with bonk_price as (

select hour,

symbol,

token_address,

price

from solana.price.ez_prices_hourly

where token_address = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

, base as (

select a.block_timestamp,

a.tx_id,

swapper as user_address,

swap_from_mint,

swap_from_amount,

c.symbol as swap_from_symbol,

swap_to_amount as bonk_amount,

swap_to_amount * price as volume_bonk_usd,

amount * 3 as fee_amount, -- Fees split into 3 addresses equally, so we just multiply by 3

amount * 3 * price as fee_amount_usd,

0.00203928 as rent_returned

from solana.defi.fact_swaps_jupiter_summary a

join bonk_price on (date_trunc('hour', a.block_timestamp) = hour)

join (select * from solana.core.fact_transfers

where tx_to = 'CbX9HYvyHBa2RuotGN8Y8hCKow6xppdrhAh6RL6i2BEf' -- Fee collected address (one of the three)

and mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

and block_timestamp >= '2024-01-12') b on (swapper = tx_from and a.tx_id = b.tx_id)

left join solana.price.ez_asset_metadata c on (swap_from_mint = c.token_address)

where swap_to_mint = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'

and a.block_timestamp >= '2024-01-12'

select count(distinct tx_id) as tx_count,

count(distinct user_address) as user_count,