flipside

    LST Supply Stats - core defi
    0xallyzachLST Supply Stats - core defi
    Updated 2025-03-24
    with base as (
    select * from $query('83427f24-d386-42ce-bd2c-dcb1ca76b121')
    ),
    core as (
    select * from base where token_group in ('LST_Pool')
    ),
    minted_daily as (
    select
    date(BLOCK_TIMESTAMP) as datetime,
    MINT as address,
    sum(MINT_AMOUNT / power(10, decimal)) as daily_minted
    from solana.defi.fact_token_mint_actions
    where
    MINT in (select mint_address from core)
    and succeeded = 'TRUE'
    group by date(BLOCK_TIMESTAMP), MINT
    ),
    burned_daily as (
    select
    date(BLOCK_TIMESTAMP) as datetime,
    MINT as address,
    - sum(BURN_AMOUNT / power(10, decimal)) as daily_burned
    from solana.defi.fact_token_burn_actions
    where
    MINT in (select mint_address from core)
    and succeeded = 'TRUE'
    group by date(BLOCK_TIMESTAMP), MINT
    ),
    combined as (
    select
    coalesce(m.datetime, b.datetime) as datetime,
    coalesce(m.address, b.address) as address,
    t.token,
    t.token_group,
    m.daily_minted,
    b.daily_burned
    Last run: 3 months ago
    DATETIME
    ADDRESS
    TOKEN
    DAILY_MINTED
    DAILY_BURNED
    NET_MINTED
    NET_BURNED
    DAILY_SUPPLY_CHANGE
    NET_SUPPLY
    1
    		2021-07-25 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL0000
    2
    		2021-08-01 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL116.041253294116.0412532940116.041253294116.041253294
    3
    		2021-08-02 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL77677.219033904-9.5177793.260287198-9.5177667.70903390477783.750287198
    4
    		2021-08-03 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL20413.855865653-74.08910474498207.116152851-83.59910474420339.76676090998123.517048107
    5
    		2021-08-04 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL1791.362443225-50.299998.478596076-133.7991047441741.16244322599864.679491332
    6
    		2021-08-05 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL0.861187054-303.03638148599999.33978313-436.835486229-302.17519443199562.504296901
    7
    		2021-08-06 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL-58.240299999.33978313-495.075686229-58.240299504.264096901
    8
    		2021-08-07 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL-27099999.33978313-765.075686229-27099234.264096901
    9
    		2021-08-08 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL2.004471568-0.1100001.344254698-765.1756862291.90447156899236.168568469
    10
    		2021-08-09 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL30611.121629182-135.26202130612.46588388-900.43770622930475.859609182129712.028177651
    11
    		2021-08-10 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL22408.531852117-7140.59508153020.997735997-8041.03278622915267.936772117144979.964949768
    12
    		2021-08-11 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL64227.234494014-347.89916217248.232230011-8388.93194622963879.335334014208859.300283782
    13
    		2021-08-12 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL8402.507272752-4030.611115225650.739502763-12419.5430612294371.896157752213231.196441534
    14
    		2021-08-13 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL23893.159185159-2509.64431249543.898687922-14929.18737122921383.514875159234614.711316693
    15
    		2021-08-13 00:00:00.0007dHbWXmci3dT8UFYWYZweBLXgycu7Y3iL6trKn1Y7ARjstSOL0000
    16
    		2021-08-14 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL19415.265784058-39.87109268959.16447198-14969.05846122919375.394694058253990.106010751
    17
    		2021-08-15 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL8317.56989163-2.6001277276.73436361-14971.6585612298314.96979163262305.075802381
    18
    		2021-08-16 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL26557.920410037-5525.03674303834.654773647-20496.69530122921032.883670037283337.959472418
    19
    		2021-08-17 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL10480.685768233-6803.1845314315.34054188-27299.8798012293677.501268233287015.460740651
    20
    		2021-08-18 00:00:00.000mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7SomSOL3.208820855-77.58102314318.549362735-27377.460821229-74.372199145286941.088541506
    ...
    6503
    1MB
    28s