Date | TVL | Asset Type | |
|---|---|---|---|
1 | 2025-04-04 00:00:00.000 | 733491546.99 | ITS |
2 | 2025-04-04 00:00:00.000 | 192233770.66 | non-ITS |
Eman-RazCurrent TVL By Asset Type - editted: 2025-02-07
Updated 8 days ago
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 table1 as (with Added_previous_tokens as (
with overview as (with chain_data as (
--------------------------------------------------------arbitrum--------------------------------------------------------
select block_timestamp, amount, contract_address, symbol, 'Arbitrum' as native_chain, case
when contract_address in (
lower('0xc24A365A870821EB83Fd216c9596eDD89479d8d7') --g3
)
then 'ITS'
else 'non-ITS' end as asset_type
from arbitrum.core.ez_token_transfers
where to_address in (
lower('0xe432150cce91c13a887f7D836923d5597adD8E31'), --lqdr, deus, vela, gdx, arb, arx, zyb
lower('0xe4d475614359D25847252d2c55B867A58A14f281') --g3
)
and contract_address in (
lower('0xDE5ed76E7c05eC5e4572CfC88d1ACEA165109E44'),
lower('0x816E21c33fa5F8440EBcDF6e01D39314541BEA72'),
lower('0x912CE59144191C1204E64559FE8253a0e49E6548'),
lower('0x2F27118E3D2332aFb7d165140Cf1bB127eA6975d'),
lower('0x088cd8f5eF3652623c22D48b1605DCfE860Cd704'),
lower('0x82aF49447D8a07e3bd95BD0d56f35241523fBab1'),
lower('0xc24A365A870821EB83Fd216c9596eDD89479d8d7'),
lower('0xD5954c3084a1cCd70B4dA011E67760B8e78aeE84')
)
union all
select block_timestamp, -amount as amount, contract_address, symbol, 'Arbitrum' as native_chain, case
when contract_address in (
lower('0xc24A365A870821EB83Fd216c9596eDD89479d8d7') --g3
)
then 'ITS'
else 'non-ITS' end as asset_type
from arbitrum.core.ez_token_transfers
Last run: 8 days ago
2
99B
205s