select date_trunc('day', block_timestamp) as date,

'Mint' as type,

mint_amount/1e9 as amount

from solana.defi.fact_token_mint_actions

where mint = 'BonK1YhkXEGLZzwtcvRTip3gAL9nCeQD7ppZBLXhtTs'

and block_timestamp::date >= '2024-01-01'

and succeeded = TRUE

UNION ALL

select date_trunc('day', block_timestamp) as date,

'Burn' as type,

burn_amount/1e9 as amount

from solana.defi.fact_token_burn_actions

where mint = 'BonK1YhkXEGLZzwtcvRTip3gAL9nCeQD7ppZBLXhtTs'

and block_timestamp::date >= '2024-01-01'

and succeeded = TRUE

, price as (

select hour::date as price_date,

symbol,

avg(price) as price

from solana.price.ez_prices_hourly

where token_address = 'BonK1YhkXEGLZzwtcvRTip3gAL9nCeQD7ppZBLXhtTs'

group by 1,2

select date_day,

case when date_day > '2024-06-05' then 'End of Wonderland SS1'

when date_day > '2024-04-01' then 'Wonderland SS1'

else 'Before Wonderland' end as type,

sum(zeroifnull(case when type = 'Mint' then amount end)) as "Mint Amount",

sum(zeroifnull(case when type = 'Burn' then -amount end)) as "Burn Amount",

"Mint Amount" + "Burn Amount" as net_amount,

sum("Mint Amount") over (order by date_day) as "Total Mint",