PapasotOHMv2 holders and price
    Updated 2022-05-07
    with OHM_price as

    (SELECT
    date_trunc('day',hour) as block_day,
    avg(price) as ohm_price
    from ethereum.token_prices_hourly
    WHERE
    symbol = 'OHM' AND
    token_address = '0x64aa3364f17a4d01c6f1751fd97c2bd3d7e7f1d5' AND
    block_day > '2021-09-01'
    group by block_day
    )
    select balance_date,
    count(user_address) as Holders,
    avg(ohm_price) as OHM_price_USD
    --CORR (OHM_price_USD,Holders)
    from ethereum.erc20_balances
    left join OHM_price a on block_day = balance_date
    where symbol = 'OHM'
    AND contract_address = '0x64aa3364f17a4d01c6f1751fd97c2bd3d7e7f1d5'
    group by balance_date
    order by balance_date



    -- 0x64aa3364f17a4d01c6f1751fd97c2bd3d7e7f1d5
    -- 0x64aa3364f17a4d01c6f1751fd97c2bd3d7e7f1d5
    Run a query to Download Data