Date | TVL | Asset Type | |
|---|---|---|---|
1 | 2022-01-01 00:00:00.000 | ITS | |
2 | 2022-01-01 00:00:00.000 | non-ITS | |
3 | 2022-01-02 00:00:00.000 | 4167.162660191 | non-ITS |
4 | 2022-01-02 00:00:00.000 | ITS | |
5 | 2022-01-03 00:00:00.000 | 28361.287328139 | non-ITS |
6 | 2022-01-03 00:00:00.000 | ITS | |
7 | 2022-01-04 00:00:00.000 | 26053.675950652 | non-ITS |
8 | 2022-01-04 00:00:00.000 | ITS | |
9 | 2022-01-05 00:00:00.000 | 25959.471238892 | non-ITS |
10 | 2022-01-05 00:00:00.000 | ITS | |
11 | 2022-01-06 00:00:00.000 | ITS | |
12 | 2022-01-06 00:00:00.000 | 23595.697167635 | non-ITS |
13 | 2022-01-07 00:00:00.000 | ITS | |
14 | 2022-01-07 00:00:00.000 | 22187.838710829 | non-ITS |
15 | 2022-01-08 00:00:00.000 | 22114.305381284 | non-ITS |
16 | 2022-01-08 00:00:00.000 | ITS | |
17 | 2022-01-09 00:00:00.000 | 21739.603153758 | non-ITS |
18 | 2022-01-09 00:00:00.000 | ITS | |
19 | 2022-01-10 00:00:00.000 | ITS | |
20 | 2022-01-10 00:00:00.000 | 21812.158806145 | non-ITS |
Eman-RazAxelar TVL Over Time - editted: 2025-02-07
Updated 9 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
Last run: 9 days ago
...
2400
115KB
241s