MasiCurrent Supply
    Updated 2025-04-28
    with tb0 as ( select trunc(hour,'day') as daily,
    token_address,
    symbol,
    avg(price) as avg_price
    from solana.price.ez_prices_hourly
    where symbol = 'MSOL'
    and daily = current_date
    group by 1,2,3)
    ,
    tb1 as ( select trunc(block_timestamp,'day') as day,
    tx_id,
    provider_address,
    MSOL_MINTED,
    MSOL_MINTED*avg_price as msol_usd
    from solana.marinade.ez_liquid_staking_actions a , tb0
    where action_type in ('depositStakeAccount','deposit') )
    ,
    tb2 as (select trunc(block_timestamp,'day') as day,
    tx_id,
    provider_address,
    MSOL_BURNED,
    MSOL_BURNED*avg_price as msol_burn_usd
    from solana.marinade.ez_liquid_staking_actions a , tb0
    where action_type in ('orderUnstake') )
    ,
    tb3 as ( select trunc(day,'week') as weekly,
    count(DISTINCT provider_address) as stakers,
    count(DISTINCT tx_id) as stake_tx,
    sum(MSOL_MINTED) as stake_amount,
    avg(MSOL_MINTED) as avg_stake_amount_usd,
    sum(msol_usd) as stake_amount_usd
    from tb1
    group by 1)
    ,
    tb4 as ( select trunc(day,'week') as weekly,
    count(DISTINCT provider_address) as unstakers,
    Last run: 2 months ago
    WEEK
    Minter
    Burner
    Mint transaction
    Burn transaction
    Mint Amount (mSOL)
    Burn Amount (MSOL)
    Mint Amount (USD)
    Burn Amount (USD)
    AVG Mint Amount (mSOL)
    AVG Burn Amount (mSOL)
    Cumulative Mint Amount (mSOL)
    Cumulative Mint Amount (USD)
    Cumulative Burn Amount (MSOL)
    Cumulative Burn Amount (USD)
    Total Minted (mSOL)
    Total Minted (USD)
    1
    2025-04-28 00:00:00.0005747604128164.533105342-112109.7103430341566932.89645455-21516036.603924413.7914410569342.47586191933001922.22700256333711544.37358-29227905.244745-5609404191.463433774016.98225754724307352.910142
    1
    241B
    4s