t as (

select t.chain

from ((values

('assetmantle'),

('juno'),

('kujira'),

('comdex'),

('umee'),

('axelarnet'),

('stargaze'),

('agoric'),

('terra2'),

('osmosis'),

('crescent'),

('evmos'),

) as t(chain)

select * from (

block_timestamp::date as day,

'New Chains' as type,

count(distinct tx_hash) transactions,

count(distinct sender) active_users,

sum(amount) as volume_usd,

avg(amount) as average_volume_usd,

sum(transactions) over (order by day) as cumulative_transactions,

sum(volume_usd) over (order by day) as cumulative_volume_usd

from axelar.core.ez_squid

where destination_chain in (select chain from t)

and block_timestamp >= '2023-02-23'

group by 1

union all