golimmAmount _ matic _ circulation(daily)
    Updated 2022-09-21
    SELECT
    date_trunc('day', b.block_timestamp) AS date,
    sum(b.AMOUNT ) AS circulation,
    sum (b.AMOUNT_USD) AS normal_usd
    FROM polygon.core.dim_labels r
    INNER JOIN polygon.core.ez_matic_transfers b ON
    r.ADDRESS = b.MATIC_TO_ADDRESS
    WHERE
    BLOCK_TIMESTAMP >= '2022-07-01'
    AND not ADDRESS_NAME LIKE '%stak%'
    and r.LABEL_TYPE = 'dex'
    GROUP BY date
    ORDER BY date
    Run a query to Download Data