Weekly Mint and Burn copy

0xHaM-dWeekly Mint and Burn copy

Updated 2025-02-19

with priceTb as (

select

hour,

price,

from solana.price.ez_prices_hourly

where token_address = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

and hour = trunc(current_date(), 'hour')

)

mintEvent as (

select

trunc(block_timestamp,'d') as date,

sum(MSOL_MINTED) as total_mint,

sum(total_mint) over (order by date asc) as total_minted

from solana.marinade.ez_liquid_staking_actions

where action_type in ('depositStakeAccount','deposit')

group by 1

order by 1 desc

)

burnEvent as (

select

trunc(block_timestamp,'d') as date,

sum(MSOL_BURNED*-1) as total_burnt,

sum(total_burnt) over (order by date asc) as total_burned

from solana.marinade.ez_liquid_staking_actions

where action_type in ('orderUnstake')

group by 1

order by 1 desc

)

, final as (

select

COALESCE(me.date,be.date) as week,

total_mint,

total_burnt,

total_minted + total_burned as total_supply,

Last run: about 1 month ago

429B

flipside