select block_timestamp::date as day,

swap_from_mint,

median (swap_to_amount/swap_from_amount) as price_usd

from solana.fact_swaps

where swap_to_mint in (

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

and succeeded = 1

and swap_to_amount > 0

and swap_from_amount > 0

group by day, swap_from_mint

select t1.day,

iff(mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263', 'BONK', 'Non-BONK') as type,

count (distinct (tx_id)) as txn_count,

sum (amount * price_usd) as total_amount_usd,

sum(txn_count) over (partition by type order by day asc) as cumulative_txn_count,

sum(total_amount_usd) over (partition by type order by day asc) as cumulative_total_amount_usd

from solana.core.fact_transfers a

join t1

on t1.day = a.block_timestamp::date

and t1.swap_from_mint = a.mint

where day >= '2022-12-24'

group by day, type

order by day asc