i_danBig Red: $Td x $AVAX Price
Updated 2024-12-03
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
26
27
28
29
›
⌄
With price_td AS (
SELECT
date_trunc(day, hour) AS day
, AVG(price) AS Td_price
FROM avalanche.price.ez_prices_hourly
WHERE 1=1
AND token_address = lower('0x87bbFc9DCB66Caa8ce7582A3F17B60a25cd8A248') -- $TD
GROUP BY 1
),
price_wa AS (
SELECT
date_trunc(day, hour) AS day
, AVG(price) AS avax_price
FROM avalanche.price.ez_prices_hourly
WHERE 1=1
AND token_address=lower('0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7') -- $WAVAX
GROUP BY 1
)
SELECT
w.day
, Td_price AS "$Td Price"
, avax_price AS "$AVAX price"
FROM price_td t
JOIN price_wa w ON t.day = w.day
ORDER BY 1 DESC
QueryRunArchived: QueryRun has been archived