label,

sum(amount) as usdc_volume,

sum(usdc_volume) over (partition by label order by day) as cumu_usdc_volume,

count(distinct(tx_id)) as tx_count,

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

count(distinct(tx_from)) as wallet_count,

sum(wallet_count) over (partition by label order by day) as cumu_wallet_count

from solana.core.fact_transfers a

join solana.core.dim_labels b on a.tx_to = b.address

where block_timestamp >= '2022-08-05'

and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and label_type != 'token'

and label_type != 'nft'

and label != 'solana'

group by 1,2)

select *,

when day >= '2022-09-29 00:00:00.000' then 'USDC Removed'

when day >= '2022-09-05 00:00:00.000' and day < '2022-09-29 00:00:00.000' then 'Post Announcement'

when day < '2022-09-05 00:00:00.000' then 'Pre Announcement'

end as binance_announcement

from table_1

order by 1 desc