BLOCK_TIMESTAMP::date as DATE,

COUNT(DISTINCT TX_HASH) as TRANSFERS,

COUNT(DISTINCT SENDER) as USERS,

sum(amount) as volume,

avg(amount) as avg_volume,

sum(TRANSFERS) over (order by date) as cum_TRANSFERS,

sum(volume) over (order by date) as cum_volume

FROM axelar.defi.ez_bridge_squid

WHERE not DESTINATION_CHAIN ilike any ('arbitrum' , 'polygon' , 'avalanche', 'moonbeam',

'celo', 'fantom', 'binance' , 'ethereum' , 'terra2' , 'filecoin')

AND date BETWEEN '2024-01-01' and current_date() - 1

GROUP by 1

ORDER by 1