0xHaM-dDaily Price Changes
Updated 2024-12-14
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
-- apt_price as (
-- SELECT
-- date(hour) as date,
-- symbol,
-- avg(price) as avg_price
-- FROM aptos.price.ez_prices_hourly
-- where symbol in ('APT')
-- )
-- ,
price as (
SELECT
date(hour) as date,
symbol,
avg(price) as avg_price
FROM aptos.price.ez_prices_hourly
where symbol in ('APT')
AND date::date = current_date() - 91
group by 1,2
UNION
select
date(hour) as date,
symbol,
avg(price) as avg_price
from ethereum.price.ez_prices_hourly
where symbol in ('WETH','WMATIC','WBTC')
and hour::date = current_date() - 91
group by 1,2
UNION
select
date(recorded_hour) as date,
symbol,
avg(price) as avg_price
from osmosis.price.ez_prices
where symbol in ('ATOM')
and date = current_date() - 91
QueryRunArchived: QueryRun has been archived