EOSActions

Column Descriptions

for eos.actions

31 rows

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

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
  eos.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
  eos.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 eos.actions WHERE json_data:to = 'someaccount';