WAXActions

Column Descriptions

for wax.actions

31 rows

Name	Type	Description
elapsed	NUMBER
account	TEXT
context_free	BOOLEAN
tx_success	BOOLEAN
block_date	DATE
auth_sequence_account_name	ARRAY
code_sequence	NUMBER
auth_sequence	ARRAY
block_number	NUMBER
account_ram_deltas	ARRAY
index	NUMBER
json_return_value	VARIANT
name	TEXT
receipt_receiver	TEXT
raw_return_value	TEXT
tx_hash	TEXT
creator_action_ordinal	NUMBER
block_time	TIMESTAMP_NTZ
account_ram_deltas_account	ARRAY
raw_data	TEXT
closest_unnotified_ancestor_action_ordinal	NUMBER
json_data	VARIANT
receiver	TEXT
action_ordinal	NUMBER
action_mroot	TEXT
block_hash	TEXT
digest	TEXT
abi_sequence	NUMBER
global_sequence	NUMBER
console	TEXT
recv_sequence	NUMBER

Sample Queries

Top 10 Most Active Accounts

Identifies the top 10 accounts with the highest number of actions

SELECT
  account,
  COUNT(*) AS action_count
FROM
  wax.actions
GROUP BY
  account
ORDER BY
  action_count DESC
LIMIT
  10;

Daily Action Count for a Specific Contract

Calculates the number of actions per day for a specific contract

SELECT
  block_date,
  COUNT(*) AS daily_actions
FROM
  wax.actions
WHERE
  account = 'eosio.token'
GROUP BY
  block_date
ORDER BY
  block_date;

Find Actions with Specific JSON Data

Retrieves actions where the JSON_DATA field contains a specific key-value pair

SELECT * FROM wax.actions WHERE json_data:to = 'someaccount';