mucrypto2023, Year-to-Date change in price of WBTC and WETH (%) 2024-01-02 06:10 AM
    Updated 2024-01-02
    with wbtc as (
    select
    hour,
    price as wbtc_price
    from ethereum.price.ez_hourly_token_prices
    where symbol in ('WBTC')
    order by 1 desc),

    wbtc_first as (
    select
    hour as first_hour,
    wbtc_price as first_wbtc_price
    from wbtc
    where first_hour >= '2023-01-01'
    order by 1
    limit 1),

    wbtc_latest as (
    select
    hour as latest_hour,
    wbtc_price as latest_wbtc_price
    from wbtc
    where latest_hour >= '2023-12-31'
    order by 1 desc
    limit 1),

    wbtc_a as
    (select
    (latest_wbtc_price - first_wbtc_price) / first_wbtc_price * 100 as latest_wbtc_c
    from wbtc_first
    inner join wbtc_latest),

    weth as (
    select
    hour,
    price as weth_price
    QueryRunArchived: QueryRun has been archived