DATE | SYMBOL | USD | |
|---|---|---|---|
1 | 2024-11-01 00:00:00.000 | USDC | 14522535.7248641 |
2 | 2024-12-01 00:00:00.000 | thAPT | 1928.774715105 |
3 | 2024-10-01 00:00:00.000 | WETH | 3860370.52579254 |
4 | 2024-12-01 00:00:00.000 | APT | 1384237.47778716 |
5 | 2024-11-01 00:00:00.000 | thAPT | 2070.349767232 |
6 | 2025-01-01 00:00:00.000 | USDt | 10709284.4938042 |
7 | 2024-12-01 00:00:00.000 | USDt | 24106342.2027762 |
8 | 2024-10-01 00:00:00.000 | WBTC | 779761.418197543 |
9 | 2024-10-01 00:00:00.000 | stAPT | 5221741.48656535 |
10 | 2024-04-01 00:00:00.000 | APT | 32170.917431136 |
11 | 2024-06-01 00:00:00.000 | USDC | 29653.890506664 |
12 | 2024-11-01 00:00:00.000 | stAPT | 7376163.0964811 |
13 | 2024-12-01 00:00:00.000 | TruAPT | 4467.527388915 |
14 | 2024-10-01 00:00:00.000 | USDC | 18685738.7936582 |
15 | 2024-11-01 00:00:00.000 | TruAPT | 197.992571616 |
16 | 2024-06-01 00:00:00.000 | THL | 1321.557846459 |
17 | 2024-05-01 00:00:00.000 | USDT | 9217.790538677 |
18 | 2024-06-01 00:00:00.000 | USDT | 15056.445474644 |
19 | 2024-08-01 00:00:00.000 | THL | 122.314903666 |
20 | 2024-10-01 00:00:00.000 | thAPT | 998.154203086 |
Sbhn_NPlinear-cyan
Updated 2025-01-17
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
36
›
⌄
with price as (
SELECT hour::date as datee,
symbol,
token_address,
decimals,
avg(price) as usdprice
from aptos.price.ez_prices_hourly
group by 1,2,3,4
UNION
SELECT hour::date as datee,
'USDt' as symbol,
'0xccd1a84ccea93531d7f165b90134aa0415feb30e8757ab1632dac68c0055f5c2::coins::USDt' as token_address,
6 as decimals,
avg(price) as usdprice
from aptos.price.ez_prices_hourly
where symbol ='USDT'
group by 1,2,3,4
UNION
SELECT hour::date as datee,
'thAPT' as symbol,
'0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::ThalaAPT' as token_address,
decimals,
avg(price) as usdprice
from aptos.price.ez_prices_hourly
where symbol ='APT'
group by 1,2,3,4
UNION
SELECT hour::date as datee,
'TruAPT' as symbol,
'0xccd1a84ccea93531d7f165b90134aa0415feb30e8757ab1632dac68c0055f5c2::coins::TruAPT' as token_address,
decimals,
avg(price) as usdprice
from aptos.price.ez_prices_hourly
where symbol ='APT'
group by 1,2,3,4)
Last run: 3 months ago
79
4KB
19s