ethereum_gas_stats AS (

WITH

top_tokens AS (

SELECT contract_address AS token_address

, symbol

, count(*) AS transfers

, sum(amount_usd) AS volume_usd

, row_number() OVER (order by transfers desc) AS _rank_transfers

, row_number() OVER (order by volume_usd desc) AS _rank_volume

FROM ethereum.core.ez_token_transfers AS tr

WHERE tr.block_timestamp >= CURRENT_DATE - interval '{{TimePeriodDays}} days'

AND tr.block_timestamp < CURRENT_DATE

AND amount_usd IS NOT NULL

AND contract_address NOT IN ( '0x8b3192f5eebd8579568a2ed41e6feb402f93f73f',

'0x24e89bdf2f65326b94e36978a7edeac63623dafa',

'0x666d875c600aa06ac1cf15641361dec3b00432ef',

'0x5b4e9a810321e168989802474f689269ec442681',

'0x3f7aff0ef20aa2e646290dfa4e67611b2220c597',

'0xd26114cd6ee289accf82350c8d8487fedb8a0c07'

)

GROUP BY 1,2

QUALIFY _rank_transfers <= 500

AND _rank_volume <= 500

),

transactions AS (

SELECT tx.tx_hash

, tx.block_timestamp

, tx.block_number

, tx.from_address

, tx.to_address

, tx.eth_value