Date | TVL | |
|---|---|---|
1 | 2025-04-23 00:00:00.000 | 297262131.47 |
Eman-RazCurrent TVL - editted: 2025-02-07
Updated 12 hours 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
Last run: about 12 hours agoAuto-refreshes every 24 hours
1
42B
919s