EthereumTraces

Column Descriptions

for eth.traces

30 rows

Name	Type	Description
failure_reason	TEXT
begin_ordinal	NUMBER
status_reverted	BOOLEAN
tx_status	TEXT
call_type_code	NUMBER
index	NUMBER
block_number	NUMBER
tx_success	BOOLEAN
address	TEXT
depth	NUMBER
value	NUMBER
gas_consumed	NUMBER
end_ordinal	NUMBER
input	TEXT
value_hex	TEXT
tx_status_code	NUMBER
executed_code	BOOLEAN
status_failed	BOOLEAN
tx_hash	TEXT
suicide	BOOLEAN
caller	TEXT
block_hash	TEXT
parent_index	NUMBER
block_date	DATE
state_reverted	BOOLEAN
block_time	TIMESTAMP_NTZ
call_type	TEXT
tx_index	NUMBER
return_data	TEXT
gas_limit	NUMBER

Sample Queries

ERC-20 Transfers

Daily ERC-20 transfers from 2024-11-01 to 2024-11-07

SELECT
  block_date,
  count(*) as total
FROM
  eth.traces
WHERE
  tx_success = true
  AND SUBSTR (input, 1, 10) IN ('0xa9059cbb', '0x23b872dd')
  AND block_date >= '2024-11-01'
  AND block_date <= '2024-11-07'
GROUP BY
  block_date
ORDER BY
  block_date;

Traces by Call Type and Success

Shows the counts of successful and failed traces by call type

SELECT
  call_type,
  tx_success,
  COUNT(*) AS trace_count
FROM
  eth.traces
GROUP BY
  call_type,
  tx_success
ORDER BY
  call_type,
  tx_success;

Daily Failed Trace Count

Number of failed traces per day

SELECT
  block_date,
  COUNT(*) AS failed_trace_count
FROM
  eth.traces
WHERE
  tx_success = FALSE
GROUP BY
  block_date
ORDER BY
  block_date;