KaskoazulUNI correlation vs ETH + DEX
    Updated 2022-04-01
    WITH UNI_PRICE AS (
    select hour,
    price as UNI_PRICE
    from ethereum.token_prices_hourly
    where token_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984' -- UNI
    and hour >= '2022-01-01'
    ),

    ETH_PRICE AS (
    select hour,
    price as ETH_PRICE
    from ethereum.token_prices_hourly
    where symbol = 'ETH' -- ETH
    and hour >= '2022-01-01'
    ),

    SUSHI_PRICE AS (
    select hour,
    price as SUSHI_PRICE
    from ethereum.token_prices_hourly
    where token_address = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' -- SUSHI
    and hour >= '2022-01-01'
    ),

    RUNE_PRICE AS (
    select hour,
    price as RUNE_PRICE
    from ethereum.token_prices_hourly
    where symbol = 'RUNE' -- RUNE
    and hour >= '2022-01-01'
    ),

    FIRSTJOIN AS (
    select uni.hour,
    uni.UNI_PRICE,
    eth.ETH_PRICE
    Run a query to Download Data