BaseTransactions

Column Descriptions

for base.transactions

41 rows

Name	Type	Description
max_fee_per_gas_hex	TEXT
blob_gas_fee_cap	NUMBER
blob_gas_used	NUMBER
nonce	NUMBER
logs_bloom	TEXT
state_root	TEXT
gas_price	NUMBER
r	TEXT
from	TEXT
to	TEXT
max_priority_fee_per_gas	NUMBER
type_code	NUMBER
s	TEXT
transactions_root	TEXT
blob_hashes	ARRAY
cumulative_gas_used	NUMBER
hash	TEXT
gas_used	NUMBER
max_priority_fee_per_gas_hex	TEXT
begin_ordinal	NUMBER
receipts_root	TEXT
block_number	NUMBER
data	TEXT
type	TEXT
status	TEXT
gas_limit	NUMBER
blob_gas_price_hex	TEXT
blob_gas_fee_cap_hex	TEXT
value_hex	TEXT
block_date	DATE
max_fee_per_gas	NUMBER
success	BOOLEAN
block_hash	TEXT
v	TEXT
status_code	NUMBER
index	NUMBER
blob_gas_price	NUMBER
block_time	TIMESTAMP_NTZ
value	NUMBER
gas_price_hex	TEXT
end_ordinal	NUMBER

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;