date_trunc('day',block_timestamp) as date,

count(DISTINCT tx_id) as swaps,

count(DISTINCT trader) as swappers

from flow.core.ez_swaps

where block_timestamp >= '2022-12-24'

group by 1,2

UNION ALL

select 'Solana' as blockchain,

date_trunc('day',block_timestamp) as date,

count(DISTINCT tx_id) as swaps,

count(DISTINCT swapper) as swappers

from solana.core.fact_swaps

where block_timestamp >= '2022-12-24'

and succeeded =TRUE

group by 1,2

UNION ALL

select 'Osmosis' as blockchain,

date_trunc('day',block_timestamp) as date,

count(DISTINCT tx_id) as swaps,

count(DISTINCT trader) as swappers

from osmosis.core.fact_swaps

where block_timestamp >= '2022-12-24'

and tx_succeeded = TRUE

group by 1,2