WITH fees_to_pooperscooper AS (

SELECT ft.tx_id

, ft.block_timestamp

, DATE_TRUNC('hour', ft.block_timestamp) AS date_hour

, ft.amount AS tokens_amt

, case when ft.mint = 'So11111111111111111111111111111111111111111'

then 'So11111111111111111111111111111111111111112' else ft.mint

end as token_mint

, p.symbol

, ft.amount * p.price AS fees_usd

FROM solana.core.fact_transfers ft

left JOIN solana.price.ez_prices_hourly p

ON token_mint = p.token_address

AND DATE_TRUNC('hour', ft.block_timestamp) = p.hour

WHERE tx_to IN (

'2Vi8WzFHAAVNjtAquByvdzzpw8p4MuXhkQyBxs4qSVxw'

AND ft.block_timestamp::DATE >= '2024-01-11'

, fees_to_pooperscooper AS (

SELECT tx_id

, fees_usd

FROM fees_to_pooperscooper

SUM(COALESCE(swap_to_amount_usd,0)) AS bonk_swap_amount_usd,

SUM(COALESCE(swap_to_amount,0)) AS bonk_swap_amount,

FROM solana.defi.ez_dex_swaps fs

INNER JOIN fees_to_pooperscooper btv

ON fs.tx_id = btv.tx_id

WHERE TRUE

AND fs.block_timestamp::DATE >= '2024-01-11'

AND swap_to_amount_usd > 0

AND swap_to_mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'