date_trunc(week, block_timestamp) AS week,

CASE WHEN CONCAT( '0x' ,SUBSTRING(input_data, 163, 40)) = LOWER('0xB31f66AA3C1e785363F0875A1B74E27b85FD66c7') THEN 'WAVAX'

WHEN CONCAT( '0x' ,SUBSTRING(input_data, 163, 40)) = LOWER('0x49D5c2BdFfac6CE2BFdB6640F4F80f226bc10bAB') THEN 'WETH'

WHEN CONCAT( '0x' ,SUBSTRING(input_data, 163, 40)) = LOWER('0x50b7545627a5162F82A992c33b87aDc75187B218') THEN 'WBTC'

ELSE 'Others' END AS index_token,

COUNT(tx_hash) AS tx_count

FROM avalanche.core.fact_transactions

WHERE origin_function_signature = '0xde2ea948'

AND block_timestamp > CURRENT_DATE() - interval '3 months'

GROUP BY 1, 2

ORDER BY 1