DATE | AVAX | TVL | |
|---|---|---|---|
1 | 2024-02-12 00:00:00.000 | 288846.850994173 | 8952593.94908741 |
2 | 2024-02-13 00:00:00.000 | -69133.728289017 | 8883460.22079839 |
3 | 2024-02-14 00:00:00.000 | -152613.950681559 | 8730846.27011683 |
4 | 2024-02-15 00:00:00.000 | -7683.73867152 | 8723162.53144531 |
5 | 2024-02-16 00:00:00.000 | -3328.820253716 | 8719833.71119159 |
6 | 2024-02-10 00:00:00.000 | 267483.502662418 | 8695081.296697 |
7 | 2024-02-11 00:00:00.000 | -31334.198603763 | 8663747.09809323 |
8 | 2024-02-17 00:00:00.000 | -109830.054099419 | 8610003.65709217 |
9 | 2024-02-18 00:00:00.000 | -38660.316475645 | 8571343.34061653 |
10 | 2024-02-19 00:00:00.000 | -163.960113515 | 8571179.38050301 |
11 | 2024-02-08 00:00:00.000 | 98032.018394079 | 8481166.50411859 |
12 | 2024-02-09 00:00:00.000 | -53568.710084014 | 8427597.79403458 |
13 | 2024-02-07 00:00:00.000 | 269980.358791853 | 8383134.48572451 |
14 | 2024-02-06 00:00:00.000 | 138085.908927287 | 8113154.12693266 |
15 | 2024-02-05 00:00:00.000 | 91373.929063477 | 7975068.21800537 |
16 | 2024-02-03 00:00:00.000 | 79546.503966315 | 7886988.47040295 |
17 | 2024-02-04 00:00:00.000 | -3294.181461054 | 7883694.2889419 |
18 | 2024-02-02 00:00:00.000 | 389691.972647384 | 7807441.96643664 |
19 | 2024-02-01 00:00:00.000 | 32742.303024281 | 7417749.99378925 |
20 | 2024-01-31 00:00:00.000 | 160884.916215024 | 7385007.69076497 |
ArioGogopool
Updated 2024-02-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
›
⌄
-- forked from Sbhn_NP / 2023-08-27 11:49 PM @ https://flipsidecrypto.xyz/Sbhn_NP/q/6RZ1XJ6ukWsn/2023-08-27-11-49-pm
--reference : cloudr3n
with price as (
select hour::date as datee,
symbol,
avg(price) as usdprice
from avalanche.price.ez_hourly_token_prices
where symbol = 'WAVAX'
group by 1,2
),
base as (
SELECT
block_timestamp,
iff(event_name='Deposit','Deposit','Withdraw') as type,
case when event_name='Deposit' then decoded_log:assets::integer*pow(10,-18)
when event_name='Withdraw' then decoded_log:assets::integer*(-1)*pow(10,-18)
else 0
end as amount,
case when event_name='Deposit' then decoded_log:shares::integer*pow(10,-18)
when event_name='Withdraw' then decoded_log:shares::integer*(-1)*pow(10,-18)
else 0 end as shares,
contract_address
FROM
avalanche.core.ez_decoded_event_logs
WHERE
contract_address=lower('0xA25EaF2906FA1a3a13EdAc9B9657108Af7B703e3')
)
select
date_trunc('day',block_timestamp) as date,
sum(amount*usdprice) as avax,
Last run: about 1 year ago
...
290
16KB
10s