DATE | AVG $GUI price | AVG $APT price | |
|---|---|---|---|
1 | 2025-01-30 00:00:00.000 | 0.00001167541667 | 7.68625 |
2 | 2025-02-11 00:00:00.000 | 0.00001038083333 | 6.125 |
3 | 2024-01-09 00:00:00.000 | 0.00001251029133 | 8.403484131 |
4 | 2024-02-09 00:00:00.000 | 0.000008004444332 | 8.938154665 |
5 | 2024-02-10 00:00:00.000 | 0.000007138685236 | 9.118506501 |
6 | 2024-02-20 00:00:00.000 | 0.000009651772347 | 9.791314002 |
7 | 2024-04-27 00:00:00.000 | 0.00002852773077 | 8.845282691 |
8 | 2024-07-16 00:00:00.000 | 0.00001581 | 6.947083333 |
9 | 2024-07-04 00:00:00.000 | 0.00001080625 | 6.309583333 |
10 | 2024-08-22 00:00:00.000 | 0.00001205833333 | 6.37125 |
11 | 2024-09-20 00:00:00.000 | 0.00001384791667 | 7.0875 |
12 | 2024-10-21 00:00:00.000 | 0.00002680458333 | 10.040833333 |
13 | 2024-12-11 00:00:00.000 | 0.00002891416667 | 12.0175 |
14 | 2024-11-21 00:00:00.000 | 0.00003819333333 | 11.81375 |
15 | 2024-02-05 00:00:00.000 | 0.000008229945809 | 8.852188306 |
16 | 2024-03-30 00:00:00.000 | 0.00007518660797 | 17.10765133 |
17 | 2024-04-13 00:00:00.000 | 0.00003190736219 | 9.628588304 |
18 | 2024-06-16 00:00:00.000 | 0.00001660375 | 7.83875 |
19 | 2024-08-10 00:00:00.000 | 0.00001306541667 | 5.96375 |
20 | 2024-09-09 00:00:00.000 | 0.00001044833333 | 6.151666667 |
Kruys-Collinscompetitive-tomato copy
Updated 2025-03-23
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
30
31
32
33
34
35
›
⌄
-- forked from competitive-tomato @ https://flipsidecrypto.xyz/studio/queries/3b7ab992-0e17-4d3e-b060-2a238d4882fc
WITH GUI AS (
SELECT
date_trunc('day', hour) as date,
symbol,
AVG(price) as AVG_GUI_price
FROM
aptos.price.ez_prices_hourly
WHERE
TOKEN_ADDRESS ILIKE '0xe4ccb6d39136469f376242c31b34d10515c8eaaa38092f804db8e08a8f53c5b2::assets_v1::EchoCoin002'
GROUP BY 1, 2
),
APT AS
(
SELECT
date_trunc('day', hour) as date,
symbol,
TOKEN_ADDRESS,
AVG(price) as AVG_APT_price
FROM
aptos.price.ez_prices_hourly
WHERE
symbol = 'APT'
GROUP BY 1, 2,3
)
select
g.date,
g.AVG_GUI_price as "AVG $GUI price",
a.AVG_APT_price as "AVG $APT price"
from GUI g JOIN APT a ON g.date = a.date
Last run: about 1 month ago
...
456
25KB
2s