from polygon.transactions

where to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'),

contract as (select contract_address, tx_id

from polygon.udm_events

where event_name = 'Approval' and event_type = 'event'

and contract_address in ('0xa5f1ea7df861952863df2e8d1312f7305dabf215', '0x8634666ba15ada4bbc83b9dbf285f73d9e46e4c2', '0xfd12ec7ea4b381a79c78fe8b2248b4c559011ffb',

'0xe7e16f2da731265778f87cb8d7850e31b84b7b86', '0x0a0bf65248805efa926c39bf51b6dd94e3d1a7af', '0x82bbf7be0eb9a6024b7a641ba179e00812bdae53', '0xbccaa7acb552a2c7eb27c7eb77c2cc99580735b9',

'0x58530e43b89234fe08fd20ed06ef536233b6dd69', '0x76c52b2c4b2d2666663ce3318a5f35f912bd25c3', '0x36a8377e2bb3ec7d6b0f1675e243e542eb6a4764')

and tx_id in (select tx_id from raw)),

overall as (select tx_id, sum(amount_usd) as Volume_USD_all

from polygon.udm_events

where amount_usd is not null and symbol = 'WETH' and tx_id in (select tx_id from contract)

group by 1),

price_7 as (select tx_id, sum(amount_usd) as Volume_USD_7

from polygon.udm_events

where amount_usd is not null and symbol = 'WETH' and tx_id in (select tx_id from contract)

and block_timestamp >= CURRENT_DATE - 7

group by 1),

price_30 as (select tx_id, sum(amount_usd) as Volume_USD_30

from polygon.udm_events

where amount_usd is not null and symbol = 'WETH' and tx_id in (select tx_id from contract)

and block_timestamp >= CURRENT_DATE - 30

group by 1),

price_1 as (select tx_id, sum(amount_usd) as Volume_USD_1

from polygon.udm_events

where amount_usd is not null and symbol = 'WETH' and tx_id in (select tx_id from contract)

and block_timestamp >= CURRENT_DATE - 1

group by 1)

select a.contract_address, case