nsa2000Table. Circulating Supply of Polygon (MATIC) as well as Price thereof: from the start till today
    Updated 2022-06-06
    with MATIC_Price as (
    select date_trunc('day', hour::date) as date,
    avg(price) as AVG_PRICE
    from ethereum.core.fact_hourly_token_prices
    where symbol = 'MATIC'
    group by 1
    ),
    matic_amount as(
    select date_trunc('day', block_timestamp::date) as date,
    sum(amount) as AMOUNT_MATIC
    from flipside_prod_db.polygon.udm_events
    where symbol = 'MATIC'
    group by 1
    )
    SELECT MATIC_Price.date, MATIC_Price.AVG_PRICE, matic_amount.AMOUNT_MATIC
    from MATIC_Price
    full join matic_amount on MATIC_Price.date=matic_amount.date

    order by 1




    Run a query to Download Data