date_trunc('day',block_timestamp) as dt1,

count(distinct swapper) as swap_orca,

sum(swap_orca) over(order by dt1 asc) as rate_orca

from solana.fact_swaps

where block_timestamp>='2022-01-01'

and swap_program='orca'

group by 1),

t2 as (select

date_trunc('day',block_timestamp) as dt2,

count(distinct FROM_ADDRESS) as swap_uni,

sum(swap_uni) over(order by dt2 asc) as rate_uni

from flipside_prod_db.ethereum.dex_swaps

where block_timestamp>='2022-01-01'

and PLATFORM= 'uniswap-v2'

group by 1),

t3 as (select

date_trunc('day',block_timestamp) as dt3,

count(distinct SWAPPER) as swap_tiny,

sum(swap_tiny) over(order by dt3 asc) as rate_tiny

from flipside_prod_db.algorand.swaps

where BLOCK_TIMESTAMP>='2022-01-01'

and SWAP_PROGRAM= 'tinyman'

group by 1)

select t1.dt1 as dt,

swap_orca,

swap_uni,

swap_tiny,

rate_orca,

rate_uni,

from t1