sinahosseinzadehUntitled Query
    Updated 2022-08-01
    with cs as (
    select
    BALANCE_DATE as date,
    sum(balance) as curculating_supply
    from flipside_prod_db.ethereum.erc20_balances
    where
    CONTRACT_ADDRESS = lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0')
    and USER_ADDRESS not in ('0x50d669f43b484166680ecc3670e4766cdb0945ce', '0xcbfe11b78c2e6cb25c6eda2c6ff46cd4755c8fca',
    '0xb316fa9fa91700d7084d377bfdc81eb9f232f5ff', '0xccb04768f3abcf1af1e749085ef67d8ec7c5fdd2','0x5e3ef299fddf15eaa0432e6e66473ace8c13d908')
    group by date
    ),
    price as (
    select
    date_trunc('day', HOUR) as date,
    avg(PRICE) as matic_average_price
    from flipside_prod_db.ethereum.token_prices_hourly
    where TOKEN_ADDRESS = lower('0x7D1AfA7B718fb893dB30A3aBc0Cfc608AaCfeBB0')
    group by date
    )
    select cs.date,
    cs.curculating_supply,
    p.matic_average_price
    from cs join price p on cs.date = p.date
    Run a query to Download Data