sakineh5021-nIQRzBThe Meme's game (price)
    Updated 2022-03-22
    with shib as ( select cast(hour as date) as date_swap , avg(price) as shiba
    from ethereum.token_prices_hourly
    where token_address = '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'
    group by 1
    ) ,
    kish as ( SELECT cast(hour as date) as date_swap , avg(price) as KIshu
    from ethereum.token_prices_hourly
    where token_address = '0xa2b4c0af19cc16a6cfacce81f192b024d625817d'
    group by 1
    ) ,

    Elo as ( SELECT cast(hour as date) as date_swap , avg(price) as Elon
    from ethereum.token_prices_hourly
    where token_address = '0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3'
    group by 1
    ) ,

    Hog as ( SELECT cast(hour as date) as date_swap , avg(price) as Hoge
    from ethereum.token_prices_hourly
    where token_address = '0xfad45e47083e4607302aa43c65fb3106f1cd7607'
    group by 1
    ) ,

    Woof as ( SELECT cast(hour as date) as date_swap , avg(price) as Woofy
    from ethereum.token_prices_hourly
    where token_address = '0xd0660cd418a64a1d44e9214ad8e459324d8157f1'
    group by 1
    )

    SELECT S.date_swap as swa_date , Shiba ,Woofy, Hoge , Elon , kishu
    from Shib S
    left outer join hog H on S.date_swap = H.date_swap
    left outer join woof W on S.date_swap = W.date_swap
    left outer join Elo E on S.date_swap = E.date_swap
    left outer join kish K on S.date_swap = K.date_swap
    Run a query to Download Data