from osmosis.core.fact_swaps

where block_timestamp::date >= CURRENT_DATE - 15)

,

label as ( select date, tx_id, trader, amount , PROJECT_NAME

from osmosis.core.dim_labels a join swap b on b.FROM_CURRENCY = a.address)

,

price as ( select date(RECORDED_AT) as date, symbol , avg(price) as avg_price

from osmosis.core.dim_prices

where date >= CURRENT_DATE - 15 and symbol in (select project_name from label)

group by 1,2)

select a.date,case when a.date <= '2022-11-07' then 'Before FTX' else 'After FTX' end as type, count(DISTINCT(tx_id)) as total_tx, count(DISTINCT(trader)) as total_user, sum(amount*avg_price) as volume,

avg(amount*avg_price) as avg_volume

from label a left outer join price b on a.date = b.date and a.project_name = b.symbol

group by 1,2