DATE | ATLAS_PRICE | POLIS_PRICE | SOL_PRICE | |
|---|---|---|---|---|
1 | 2022-12-16 00:00:00.000 | 0.003380012374 | 0.4104790934 | 13.554040899 |
2 | 2023-03-14 00:00:00.000 | 0.003200289215 | 0.2944082639 | 20.794117269 |
3 | 2023-03-19 00:00:00.000 | 0.003568206587 | 0.2785365879 | 21.886561985 |
4 | 2023-07-19 00:00:00.000 | 0.001552268845 | 0.1218650475 | 26.274305184 |
5 | 2023-12-20 00:00:00.000 | 0.005911351668 | 0.4872806383 | 77.167655659 |
6 | 2024-09-04 00:00:00.000 | 0.001761240417 | 0.14307875 | 129.942916667 |
7 | 2022-07-19 00:00:00.000 | 0.00836043532 | 0.5754581776 | 44.753162736 |
8 | 2022-07-20 00:00:00.000 | 0.00874327316 | 0.5996231763 | 44.627033324 |
9 | 2023-05-11 00:00:00.000 | 0.002261955719 | 0.1603235176 | 20.450590627 |
10 | 2023-05-16 00:00:00.000 | 0.002198165445 | 0.1619862376 | 20.843619058 |
11 | 2024-08-17 00:00:00.000 | 0.001636617917 | 0.11463875 | 139.73 |
12 | 2024-05-05 00:00:00.000 | 0.004255527936 | 0.2399957351 | 145.9020045 |
13 | 2024-07-12 00:00:00.000 | 0.002034334583 | 0.129304125 | 136.970833333 |
14 | 2022-07-08 00:00:00.000 | 0.006907655288 | 0.4050077632 | 38.063373465 |
15 | 2022-08-16 00:00:00.000 | 0.007635732517 | 0.5091197611 | 43.430218891 |
16 | 2023-08-24 00:00:00.000 | 0.001562202552 | 0.1219749277 | 21.469375125 |
17 | 2024-02-28 00:00:00.000 | 0.005989973509 | 0.4726705934 | 110.815927121 |
18 | 2024-04-21 00:00:00.000 | 0.005160796785 | 0.3015448774 | 150.166031969 |
19 | 2024-05-03 00:00:00.000 | 0.004167181608 | 0.2324930056 | 140.202274316 |
20 | 2024-05-21 00:00:00.000 | 0.00405532875 | 0.2372487083 | 181.093333333 |
AephiaRQ - Token Prices
Updated 2 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
hour::DATE AS DATE,
AVG(case when token_address = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx'
then price end) as atlas_price,
AVG(case when token_address = 'poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk'
then price end) as polis_price,
AVG(case when token_address = 'So11111111111111111111111111111111111111112'
then price end) as sol_price
FROM
SOLANA.price.ez_prices_hourly
WHERE
hour::DATE > '2021-09-01' --AND hour::date < current_date
GROUP BY ALL
Last run: about 2 hours agoAuto-refreshes every 6 hours
...
1369
90KB
7s