date_trunc('day', block_timestamp) as date,

CASE WHEN block_timestamp >= '2022-11-06' THEN 'After FTX Crash' ELSE 'Before FTX Crash' END AS crashtime,

sum(amount_usd) as usd_volume,

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

count(distinct(tx_hash)) as tx_count,

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

count(distinct(origin_from_address)) as wallet_count,

sum(wallet_count) over (order by date) as cumu_wallets,

usd_volume/tx_count as avg_vol_per_tx,

tx_count/wallet_count as avg_tx_per_wallet

from ethereum.core.ez_token_transfers

where to_address = '0xd54f502e184b6b739d7d27a6410a67dc462d69c8'

and block_timestamp >= current_date - 90

group by 1,2