PapasotCopy of Price correlations (UNI & AAVE)
    Updated 2022-03-30
    WITH UNI AS (
    select
    hour,
    price as uni_price
    from ethereum.token_prices_hourly
    where
    symbol = 'UNI' AND
    hour > '2020-09-15' AND
    token_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984'
    --symbol = 'ETH' OR
    --symbol = 'AAVE'
    order by 1
    ),

    SUSHI AS (
    select
    hour,
    price as sushi_price
    from ethereum.token_prices_hourly
    where
    symbol = 'SUSHI' AND
    hour > '2020-09-15'
    --symbol = 'ETH' OR
    --symbol = 'AAVE'
    order by 1
    )

    select
    CORR (uni_price,sushi_price)
    from UNI a
    left join SUSHI b on b.hour = a.hour;
    --left join algorand.asset b on b.asset_id = a.swap_to_asset_id
    Run a query to Download Data