hessTotal and average New Traders
Updated 2024-09-10
999
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with price as ( select hour::date as date,
symbol,
avg(price) as avg_price
from flow.price.ez_prices_hourly
where symbol is not null
and symbol not in ('FLOW','CEWBTC')
group by 1,2
UNION
select hour::date as date,
symbol,
avg(price) as avg_price
from ethereum.price.ez_prices_hourly
where symbol = 'ETH'
group by 1,2
UNION
select hour::date as date,
'CEWBTC' as symbol,
avg(price) as avg_price
from ethereum.price.ez_prices_hourly
where symbol = 'WBTC'
group by 1,2
UNION
select hour::date as date,
symbol,
avg(price) as avg_price
from polygon.price.ez_prices_hourly
where symbol = 'MATIC'
group by 1,2
UNION
Select TO_TIMESTAMP(value[0]::string) as date,
'BLT' as symbol,
value[1] as avg_price
from (
SELECT livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/blocto-token/market_chart?vs_currency=usd&days=365&interval=daily&precision=3') as resp
)
QueryRunArchived: QueryRun has been archived