BLOCK_TIMESTAMP::date as day,

CONCAT(Symbol_IN,' -> ',Symbol_out) as asset_pairs,

count(distinct tx_hash) as no_transfer,

count(distinct ORIGIN_FROM_ADDRESS) as no_sender,

sum(AMOUNT_IN) as total_volume,

avg(AMOUNT_IN) as avg_volume

from optimism.velodrome.ez_swaps

where BLOCK_TIMESTAMP>='2022-11-01'

and SYMBOL_IN='OP'

group by 1,2 having asset_pairs is not null

QUALIFY DENSE_RANK() OVER (partition by day ORDER BY total_volume DESC) <= 5