Flipside Team365D Inflation % Over Time
    Updated 2024-11-26
    -- forked from 2023-07-20 11:44 AM copy @ https://flipsidecrypto.xyz/edit/queries/63b41105-d5f2-4ebd-9dfb-5641f340e0da

    WITH supply_data AS (
    SELECT
    date_trunc('day', BLOCK_TIMESTAMP) AS date,
    avg(TOTAL_SUPPLY / 1e24) AS total_supply
    FROM near.core.fact_blocks
    GROUP BY 1
    )


    select a.date, 100*(a.total_supply-b.total_supply)/a.total_supply as "365D Inflation %"
    from supply_data a
    join supply_data b
    on a.date=b.date+ interval '365 day'
    WHERE a.date >= '{{starting_date}}'


    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived