with tb1 as (select

from blast.core.ez_decoded_event_logs

where CONTRACT_ADDRESS = lower('0x0000000000E14E87e5c80A8A90817308fFF715d3')

and ORIGIN_FUNCTION_SIGNATURE in ('0x7d7c3c74','0x7d33ca3f') --fee payment

select

BLOCK_TIMESTAMP::date as day,

sum(amount) as "Volume ETH",

sum(AMOUNT_USD) as "Volume USD",

avg(AMOUNT_USD) as avg_volume

from blast.core.ez_native_transfers

where tx_hash in (select tx_hash from tb1)

and to_address = lower('0x6b86fF7863e27d1C8CCf05dF9cB03b8eFaA52125')

group by 1