'Ref Finance' as platform,

count(distinct(tx_hash)) as swap_count,

count(distinct(trader)) as swapper_count

from near.core.ez_dex_swaps

where platform = 'v2.ref-finance.near'

and block_timestamp >= current_date - 90

group by 1

select date_trunc('day', block_timestamp) as day,

'Orca Finance' as platform,

count(distinct(tx_id)) as swap_count,

count(distinct(swapper)) as swapper_count

from solana.core.fact_swaps

where swap_program = 'orca'

and block_timestamp >= current_date - 90

group by 1)

select platform,

avg(swap_count) as avg_tx,

avg(swapper_count) as avg_swapper,

row_number () over (order by avg_tx desc) as count

from table_1

group by 1