select 'NEAR' as chain,

date_trunc(day,block_timestamp) as date,

case when date >= '2022-11-07' then 'After Collapse'

else 'Before Collapse' end as timespan,

case when token_in in ('DAI','USDC','USDT','USN','cUSD','nUSDO') then 'Swap From Stablecoins'

when token_out in ('DAI','USDC','USDT','USN','cUSD','nUSDO') then 'Swap To Stablecoins'

else null end as swap_type,

count (distinct tx_hash) as TX_Count,

count (distinct trader) as Users_Count,

sum (case when token_in in ('DAI','USDC','USDT','USN','cUSD','nUSDO') then amount_in

when token_out in ('DAI','USDC','USDT','USN','cUSD','nUSDO') then amount_out end) as Swap_Volume,

avg (case when token_in in ('DAI','USDC','USDT','USN','cUSD','nUSDO') then amount_in

when token_out in ('DAI','USDC','USDT','USN','cUSD','nUSDO') then amount_out end) as Average_Swap_Volume

from near.core.ez_dex_swaps

where block_timestamp >= current_date - 30

and swap_type is not null

group by 1,2,3,4

union ALL

select 'FLOW' as chain,

date_trunc(day,block_timestamp) as date,

case when date >= '2022-11-07' then 'After Collapse'

else 'Before Collapse' end as timespan,

case when token_in_contract in ('A.231cc0dbbcffc4b7.ceBUSD','A.3c5959b568896393.FUSD','A.cfdd90d4a00f7b5b.TeleportedTetherToken','A.b19436aae4d94622.FiatToken') then 'Swap From Stablecoins'

when token_out_contract in ('A.231cc0dbbcffc4b7.ceBUSD','A.3c5959b568896393.FUSD','A.cfdd90d4a00f7b5b.TeleportedTetherToken','A.b19436aae4d94622.FiatToken') then 'Swap To Stablecoins'

else null end as swap_type,

count (distinct tx_id) as TX_Count,

count (distinct trader) as Users_Count,

sum (case when token_in_contract in ('A.231cc0dbbcffc4b7.ceBUSD','A.3c5959b568896393.FUSD','A.cfdd90d4a00f7b5b.TeleportedTetherToken','A.b19436aae4d94622.FiatToken') then token_in_amount

when token_out_contract in ('A.231cc0dbbcffc4b7.ceBUSD','A.3c5959b568896393.FUSD','A.cfdd90d4a00f7b5b.TeleportedTetherToken','A.b19436aae4d94622.FiatToken') then token_out_amount end) as Swap_Volume,

avg (case when token_in_contract in ('A.231cc0dbbcffc4b7.ceBUSD','A.3c5959b568896393.FUSD','A.cfdd90d4a00f7b5b.TeleportedTetherToken','A.b19436aae4d94622.FiatToken') then token_in_amount

when token_out_contract in ('A.231cc0dbbcffc4b7.ceBUSD','A.3c5959b568896393.FUSD','A.cfdd90d4a00f7b5b.TeleportedTetherToken','A.b19436aae4d94622.FiatToken') then token_out_amount end) as Average_Swap_Volume

from flow.core.ez_swaps

where block_timestamp >= current_date - 30