BlockTrackercurrent tvl
Updated 2024-12-12
999
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 prices as (
select
date_trunc('day', hour) as date,
symbol,
median(price) as usd_price
from aptos.price.ez_prices_hourly
group by 1 , 2
union all
-- thala-apt
select
date_trunc('day', hour) as date,
'thAPT' as symbol,
median(price) as usd_price
from aptos.price.ez_prices_hourly
where symbol = 'APT'
group by 1 , 2
union all
-- TrueFin
select
date_trunc('day', hour) as date,
'TruAPT' as symbol,
median(price) as usd_price
from aptos.price.ez_prices_hourly
where symbol = 'APT'
group by 1 , 2
)
,
AmnisFinance as (--amAPT supply
select
date,
'Amnis Finance (amAPT)' as token,
'amAPT' as symbol,
sum(amount) as "Amount",
sum("Amount") over (order by date) as "Supply"
QueryRunArchived: QueryRun has been archived