flipside

    holder vs price
    Abolfazl_771025holder vs price
    Updated 2022-07-31
    with cs as (
    select BALANCE_DATE as date,
    sum(balance) as circulating_supply,
    Count(user_address) as holders
    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,
    p.matic_average_price,
    cs.circulating_supply,
    cs.holders
    from cs join price p on cs.date = p.date
    Run a query to Download Data