BNB Smart ChainTransactions

Column Descriptions

for bsc.transactions

41 rows

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

Sample Queries

Active Users

Active users on 2024-10-01

SELECT
  date_trunc ('minute', block_time) AS minute,
  count(distinct "from") AS user
FROM
  bsc.transactions
WHERE
  block_date = '2024-10-01'
GROUP BY
  minute
ORDER BY
  minute ASC;

Top Contracts

Top 10 contracts by transactions on 2024-10-01

SELECT
  "to" AS contract,
  count(*) AS transactions
FROM
  bsc.transactions
WHERE
  block_date = '2024-10-01'
GROUP BY
  contract
ORDER BY
  transactions DESC
LIMIT
  10;

Average Gas Used by Transaction Type

Calculates the average gas used for each transaction type, helping analyze resource consumption by different transaction types

SELECT
  type,
  AVG(gas_used) AS avg_gas_used
FROM
  bsc.transactions
GROUP BY
  type
ORDER BY
  avg_gas_used DESC;