0xHaM-dNative Token 30 Day Return Percent
Updated 2023-01-09
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 atomPriceTb as (
SELECT
RECORDED_HOUR::date as p_date,
symbol as symbol0,
avg(price) as price_old
FROM osmosis.core.ez_prices
WHERE symbol ilike ANY ('ATOM')
AND RECORDED_HOUR::date BETWEEN CURRENT_DATE - 31 AND CURRENT_DATE - 29
GROUP by 1,2
ORDER by 1
)
, osmoPriceTb as (
SELECT
RECORDED_HOUR::date as p_date,
symbol as symbol0,
avg(price) as price_old
FROM osmosis.core.ez_prices
WHERE symbol ilike ANY ('OSMO')
AND RECORDED_HOUR::date BETWEEN CURRENT_DATE - 31 AND CURRENT_DATE - 29
GROUP by 1,2
ORDER by 1
)
, solPriceTb as (
SELECT
RECORDED_HOUR::date as p_date,
symbol as symbol0,
avg(CLOSE) as price_old
from solana.core.fact_token_prices_hourly
where SYMBOL = 'SOL'
and IMPUTED = FALSE
AND RECORDED_HOUR::date BETWEEN CURRENT_DATE - 31 AND CURRENT_DATE - 29
GROUP by 1,2
ORDER by 1
)
, nearPriceTb as (
SELECT
Run a query to Download Data