SolanaTransactions

Column Descriptions

for solana.transactions

25 rows

Name	Type	Description
index	NUMBER
block_parent_slot	NUMBER
signer	TEXT
block_slot	NUMBER
fee	NUMBER
block_time	TIMESTAMP_NTZ
recent_block_hash	TEXT
error	TEXT
post_balances	ARRAY
block_height	NUMBER
compute_units_consumed	NUMBER
block_previous_block_hash	TEXT
required_signed_accounts	NUMBER
account_keys	ARRAY
signature	TEXT
required_unsigned_accounts	NUMBER
block_hash	TEXT
log_messages	ARRAY
signatures	ARRAY
required_signatures	NUMBER
success	BOOLEAN
id	TEXT
pre_balances	ARRAY
block_date	DATE
signers	ARRAY

Sample Queries

Average Transaction Fee Daily

Calculates the average transaction fee paid in lamports per day.

SELECT
  block_date,
  AVG(fee) AS avg_fee
FROM
  solana.transactions
GROUP BY
  block_date
ORDER BY
  block_date;

Top 10 Transactions with Highest Fees

Identifies the top 10 transactions with the highest fees paid.

SELECT
  id,
  fee
FROM
  solana.transactions
ORDER BY
  fee DESC
LIMIT
  10;

Hourly Successful Transaction Count

Calculates the number of successful transactions for each hour of a specific day.

SELECT
  DATE_TRUNC ('hour', block_time) AS transaction_hour,
  COUNT(*) AS successful_transactions
FROM
  solana.transactions
WHERE
  success = TRUE
  AND block_date = '2024-10-30'
GROUP BY
  transaction_hour
ORDER BY
  transaction_hour;