TOKEN_TYPE | NET_VOLUME | |
|---|---|---|
1 | VT-savUSD | 225840.913670568 |
2 | YT-savUSD | 130365.40590173 |
Ali3NVT vs YT savUSD (Stablejack v2 savUSD Market)
Updated 2 hours ago
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
›
⌄
⌄
/*select *
from avalanche.core.ez_decoded_event_logs
where tx_hash = '0xe702e35d6c495dd1b4135a7c70004a441d7ed7397b2f7dd8deb21630d9bab3ff'
order by event_index*/
with mintt as (
select case when contract_address = '0x1326a1b025bc099197654fe027a6b2361fe4899c' then 'YT-savUSD'
when contract_address = '0xd46765985fb0e8ad889fd5ee3db62722c4ecf58f' then 'VT-savUSD' end as token_type,
count (distinct tx_hash) as Transactions,
count (distinct origin_from_address) as Users,
sum (decoded_log:value/1e18) as Volume,
avg (decoded_log:value/1e18) as avg_volume,
from avalanche.core.ez_decoded_event_logs
where origin_to_address = '0xdb8b3bd77b7a28c2835c9e8e3c15f7adbc2cd267'
and tx_succeeded
and event_name = 'Transfer'
and origin_function_signature = '0x0587bcf3'
and contract_address in ('0x1326a1b025bc099197654fe027a6b2361fe4899c','0xd46765985fb0e8ad889fd5ee3db62722c4ecf58f')
and decoded_log:from = '0x0000000000000000000000000000000000000000'
and decoded_log:to = origin_from_address
--and tx_hash = '0x30c85d2c927c2cd07e12c230f34b39b109df434c69a9494b6a7d0bd72522d3a1' --MINT
group by 1),
redeemt as (
select case when contract_address = '0x1326a1b025bc099197654fe027a6b2361fe4899c' then 'YT-savUSD'
when contract_address = '0xd46765985fb0e8ad889fd5ee3db62722c4ecf58f' then 'VT-savUSD' end as token_type,
count (distinct tx_hash) as Transactions,
count (distinct origin_from_address) as Users,
sum (decoded_log:value/1e18) as Volume,
avg (decoded_log:value/1e18) as avg_volume,
from avalanche.core.ez_decoded_event_logs
where origin_to_address = '0xdb8b3bd77b7a28c2835c9e8e3c15f7adbc2cd267'
and tx_succeeded
and event_name = 'Transfer'
and origin_function_signature = '0xfa7f0c4e'
and contract_address in ('0x1326a1b025bc099197654fe027a6b2361fe4899c','0xd46765985fb0e8ad889fd5ee3db62722c4ecf58f')
Last run: about 2 hours agoAuto-refreshes every 24 hours
2
62B
305s