a.block_timestamp::date "Date",

iff(program_id = 'srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX', 'openbook', label) "Program",

case when "Date" >= '2022-11-08' then 'After FTX Collapse' else 'Before FTX Collapse' end "TimeSpan",

count(distinct a.tx_id) "TX Number",

count(distinct tx_from) "Users",

row_number() over (partition by "Date" order by "TX Number" desc) "Num"

from solana.core.fact_events a

join solana.core.fact_transfers b

on a.tx_id = b.tx_id

left join solana.core.dim_labels on program_id = address

where label_type in ('dex', 'defi')

and "Date" >= '2022-11-01'

group by 1, 2, 3

qualify "Num" <= 10

order by 1 asc