INFLOW | OUTFLOW | NETFLOW | |
|---|---|---|---|
1 | 362873062.390339 | 353333360.917292 | 9539701.47304726 |
Sbhn_NPburning-crimson
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
1
54B
53s