adambalaUnique Users on Algorand
Updated 2022-06-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
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