DATE | AVG $GUI price | AVG $APT price | |
|---|---|---|---|
1 | 2024-03-10 00:00:00.000 | 0.00002741070758 | 13.020192493 |
2 | 2024-03-28 00:00:00.000 | 0.00007741745284 | 17.64644603 |
3 | 2024-08-25 00:00:00.000 | 0.00001218541667 | 7.151666667 |
4 | 2024-09-12 00:00:00.000 | 0.00001114083333 | 6.14 |
5 | 2024-09-21 00:00:00.000 | 0.00001509958333 | 7.70875 |
6 | 2024-09-19 00:00:00.000 | 0.00001223875 | 6.52 |
7 | 2024-11-19 00:00:00.000 | 0.00003965 | 11.822083333 |
8 | 2024-11-24 00:00:00.000 | 0.00003413291667 | 12.475416667 |
9 | 2024-01-04 00:00:00.000 | 0.00001736490084 | 9.95044009 |
10 | 2024-12-15 00:00:00.000 | 0.00003544708333 | 13.399166667 |
11 | 2024-08-12 00:00:00.000 | 0.00001417041667 | 6.182916667 |
12 | 2024-11-07 00:00:00.000 | 0.00002365833333 | 9.699166667 |
13 | 2024-11-16 00:00:00.000 | 0.00004709875 | 12.247916667 |
14 | 2024-04-06 00:00:00.000 | 0.00004577460879 | 13.193082156 |
15 | 2024-06-26 00:00:00.000 | 0.00001312166667 | 6.8525 |
16 | 2024-06-08 00:00:00.000 | 0.00002291958333 | 8.33875 |
17 | 2024-02-05 00:00:00.000 | 0.000008229945809 | 8.852188306 |
18 | 2024-03-30 00:00:00.000 | 0.00007518660797 | 17.10765133 |
19 | 2024-04-13 00:00:00.000 | 0.00003190736219 | 9.628588304 |
20 | 2024-06-16 00:00:00.000 | 0.00001660375 | 7.83875 |
Kruys-Collinscompetitive-tomato copy
Updated 2024-12-28
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: 3 months ago
...
371
20KB
2s