kidaConnext Daily TVL (Avalanche)
Updated 2023-01-05
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
addresses as (
select '0x31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09' as address
),
avalanche_net_ins as (
select
block_timestamp::date as date,
contract_address, -- wrapper
sum(case when event_name = 'Deposit' then event_inputs:value
else -event_inputs:wad end) as net_in
from avalanche.core.fact_event_logs
where contract_address = lower('0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7')
and event_name in ('Deposit', 'Withdrawal')
and (contains(topics[1], lower('31efc4aeaa7c39e54a33fdc3c46ee2bd70ae0a09')))
group by 1,2
),
decimals as (
select
token_in as contract_address,
median(case when event_inputs:amount1In::decimal < event_inputs:amount0In::decimal then event_inputs:amount0In else event_inputs:amount1In end / amount_in) as decimals
from avalanche.sushi.ez_swaps s
join avalanche.core.fact_event_logs t
on t.event_index = s.event_index and s.tx_hash = t.tx_hash
group by 1
),
prices as (
select
date(block_timestamp) as date,
token_in as token_address,
symbol_in as symbol,
avg(amount_in_usd / amount_in) as price
from avalanche.sushi.ez_swaps
group by 1, 2, 3
Run a query to Download Data