SolanaInstruction Calls

Column Descriptions

for solana.instruction_calls

25 rows

Name	Type	Description
tx_id	TEXT
stack_height	NUMBER
compute_units_consumed	NUMBER
block_previous_block_hash	TEXT
block_parent_slot	NUMBER
block_date	DATE
executing_account	TEXT
log_messages	ARRAY
program_id	TEXT
block_slot	NUMBER
block_time	TIMESTAMP_NTZ
is_inner	BOOLEAN
account_arguments	ARRAY
fee	NUMBER
inner_instructions	TEXT
tx_success	BOOLEAN
data	TEXT
block_height	NUMBER
outer_executing_account	TEXT
outer_instruction_index	NUMBER
inner_executing_account	TEXT
tx_signer	TEXT
tx_index	NUMBER
block_hash	TEXT
inner_instruction_index	NUMBER

Sample Queries

Most Frequent Executing Account

Identifies the account that most frequently executes instructions.

SELECT
  executing_account,
  COUNT(*) AS execution_count
FROM
  solana.instruction_calls
GROUP BY
  executing_account
ORDER BY
  execution_count DESC
LIMIT
  1;

Daily Count of Successful Transactions with Inner Instructions

Counts the number of successful transactions that contain inner instructions each day.

SELECT
  block_date,
  COUNT(DISTINCT tx_id) AS successful_tx_with_inner_instructions
FROM
  solana.instruction_calls
WHERE
  tx_success = TRUE
  AND is_inner = TRUE
GROUP BY
  block_date
ORDER BY
  block_date;

Average Number of Account Arguments Per Instruction

Calculates the average number of account arguments used per instruction.

SELECT
  AVG(ARRAY_SIZE (account_arguments)) AS avg_account_arguments
FROM
  solana.instruction_calls;