adambalaUnique Users on Algorand
    Updated 2022-06-28

    with
    a as (
    select
    hour,
    price as btc,
    symbol,'btc' as title
    from ethereum.token_prices_hourly
    where lower(symbol) = 'WBTC'
    and hour > '2021-12-10 00:00:00.000'
    group by 1,2,3,4),
    b as (
    select
    hour,
    price as eth,
    symbol,'eth' as title
    from ethereum.token_prices_hourly
    where lower(symbol) = 'WETH'
    and hour > '2021-12-10 00:00:00.000'
    group by 1,2,3,4)


    select btc , eth ,a.hour
    from a inner join b on a.hour=b.hour
    Run a query to Download Data