ArashhPrices
Updated 2024-12-05
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 T1 AS (
-- SELECT
-- DATE(HOUR) AS date,
-- AVG(CASE WHEN symbol = 'SEI' AND IS_NATIVE = 1 THEN price ELSE NULL END) AS SEI_PRICE,
-- AVG(CASE WHEN symbol = 'OSMO' AND IS_NATIVE = 1 THEN price ELSE NULL END) AS OSMO_PRICE,
-- AVG(CASE WHEN symbol = 'ATOM' AND IS_NATIVE = 1 THEN price ELSE NULL END) AS ATOM_PRICE,
-- AVG(CASE WHEN TOKEN_ADDRESS IN ('ibc/785AFEC6B3741100D15E7AF01374E3C4C36F24888E96479B1C33F5C71F364EF9') THEN price ELSE NULL END) AS TERRA_PRICE,
-- AVG(CASE WHEN symbol = 'AXL' AND IS_NATIVE = 1 THEN price ELSE NULL END) AS AXL_PRICE
-- FROM crosschain.price.ez_prices_hourly
-- WHERE HOUR >= (SELECT MAX(HOUR) FROM crosschain.price.ez_prices_hourly) - INTERVAL '30 days'
-- AND (symbol IN ('SEI', 'OSMO', 'ATOM', 'AXL') OR TOKEN_ADDRESS IN ('ibc/785AFEC6B3741100D15E7AF01374E3C4C36F24888E96479B1C33F5C71F364EF9'))
-- GROUP BY DATE(HOUR)
-- ),
-- T2 AS (
-- SELECT
-- DATE(HOUR) AS date,
-- AVG(PRICE) AS LAVA_PRICE
-- FROM lava.price.ez_prices_hourly
-- WHERE symbol = 'LAVA'
-- AND DATE(HOUR) > CURRENT_DATE - INTERVAL '30 days'
-- GROUP BY DATE(HOUR)
-- )
-- SELECT
-- T1.date,
-- T1.SEI_PRICE,
-- T1.OSMO_PRICE,
-- T1.ATOM_PRICE,
-- T1.TERRA_PRICE,
-- T1.AXL_PRICE,
-- T2.LAVA_PRICE
-- FROM T1
-- JOIN T2 ON T1.date = T2.date
-- ORDER BY T1.date DESC;
QueryRunArchived: QueryRun has been archived