Flipside TeamDASH: Full Token Supply Breakdown by rmas
    Updated 2024-11-14
    select

    utc_date
    , utc_date AS "Date"
    , total_supply AS "Total Supply - Actual"
    , total_staked_supply AS "Staked Supply"
    , total_nonstaked_supply AS "Non-staked Supply"
    , circulating_supply AS "Circulating Supply"
    , total_supply - circulating_supply as "Total Supply"
    , total_locked_supply AS "Locked Supply"
    , liquid_supply AS "Liquid Supply"
    , nonliquid_supply AS "Non-liquid Supply"

    , staked_locked_supply AS "Staked (Locked Supply)"
    , non_staked_locked_supply AS "Non-staked (Locked Supply)"

    , staked_circulating_supply AS "Staked (Circulating Supply)"
    , nonstaked_circulating_supply AS "Non-staked (Circulating Supply)"

    , perc_locked_supply
    , perc_circulating_supply

    , perc_staked_locked
    , perc_staked_circulating

    , 1 AS dummy
    from near.atlas.ez_supply
    WHERE utc_date >= '{{starting_date}}'
    ORDER BY utc_date DESC
    QueryRunArchived: QueryRun has been archived