ArioNEAR-TVL Change Over Time
Updated 2024-11-19
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 dailyTVL as (
select
DATE,
TVL_USD
from external.defillama.fact_chain_tvl
where CHAIN = 'Near'
),
today_TVL as (
select
TVL_USD as TVL_USD_Today
from dailyTVL
--where date = current_date
ORDER by date desc
limit 1
),
CHange_1D as (
select
(TVL_USD_Today - TVL_USD) / TVL_USD * 100 as "1D Change %"
from dailyTVL, today_TVL
where date = (current_date - interval '1 day')
),
CHange_7D as (
select
(TVL_USD_Today - TVL_USD) / TVL_USD * 100 as "7D Change %"
from dailyTVL, today_TVL
where date = (current_date - interval '6 days')
),
CHange_30D as (
select
(TVL_USD_Today - TVL_USD) / TVL_USD * 100 as "30D Change %"
from dailyTVL, today_TVL
where date = (current_date - interval '29 days')
),
CHange_90D as (
select
(TVL_USD_Today - TVL_USD) / TVL_USD * 100 as "90D Change %"
QueryRunArchived: QueryRun has been archived