sum(amount/pow(10, decimal)) as usd_volume,

sum(usd_volume) over (order by day) as cumu_usd_volume,

avg(usd_volume) over (order by day rows between 6 preceding and current row) as ma_usd_volume,

count(distinct(tx_id)) as tx_count,

sum(tx_count) over (order by day) as cumu_tx_count,

count(distinct(sender)) as wallet_count,

tx_count/wallet_count as avg_tx,

sum(wallet_count) over (order by day) as cumu_wallet_count,

usd_volume/tx_count as avg_usd_vol

from axelar.core.fact_transfers

where tx_succeeded = 'TRUE'

and amount/pow(10, decimal) < 999999

and block_timestamp >= '2022-11-01'

group by 1)

select *,

when day >= '2022-11-07 00:00:00.000' then 'Collapse of FTX & Alameda'

else 'Before Collapsing'

end as event

from table_1

order by 1 desc