Total_bridges | Users | Total volume | Swap fees | |
|---|---|---|---|---|
1 | 162 | 98 | 49996.090053119 | 145.701471143 |
Hessishxdefi-pol- weekly bridges vol tot
Updated 13 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 crossx as (SELECT BLOCK_TIMESTAMP::date as time_a,
TX_HASH as tx_a,
ORIGIN_FROM_ADDRESS as swapper_a,
symbol as from_token,
case when AMOUNT_USD is null then 0 else AMOUNT_USD end as amount_a,
case when BLOCK_TIMESTAMP::date < '2024-11-22' then amount_a*0.003 else amount_a*0.006 end as fee,
'Socket' as gateway
from polygon.core.ez_token_transfers
where BLOCK_TIMESTAMP::date >= '2023-01-01' and tx_hash not in (SELECT DISTINCT tx_hash from polygon.defi.ez_dex_swaps) and
ORIGIN_TO_ADDRESS in ('0xa2a42b7203b2dc0199b81039c6c4e1ef900e82a4','0xd2667072a2a30e8c21fa276b474fd047ab5ff0f7')
and FROM_ADDRESS in ('0xa2a42b7203b2dc0199b81039c6c4e1ef900e82a4','0xd2667072a2a30e8c21fa276b474fd047ab5ff0f7')
and TO_ADDRESS = '0x3a23f943181408eac424116af7b7790c94cb97a5'
and ORIGIN_from_ADDRESS not in ('0x1e2c53ba467f6c4aa9325a7767a401b1999b2bf7',
'0x90ab3b8deeaa6a3cfa3c6622f140ce56e62f47e3',
'0x36e7556a3c68876387ad02196b7e125e73939115',
'0xf91e863dcc42a81536695b2e6497797935ee5b95')
union
SELECT BLOCK_TIMESTAMP::date as time_a,
TX_HASH as tx_a,
ORIGIN_FROM_ADDRESS as swapper_a,
'MATIC' as from_token,
case when AMOUNT_USD is null then 0 else AMOUNT_USD end as amount_a,
case when BLOCK_TIMESTAMP::date < '2024-11-22' then amount_a*0.003 else amount_a*0.006 end as fee,
'Socket' as gateway
from polygon.core.ez_native_transfers
where BLOCK_TIMESTAMP::date >= '2023-01-01' and tx_hash not in (SELECT DISTINCT tx_hash from polygon.defi.ez_dex_swaps) and
ORIGIN_TO_ADDRESS in ('0xa2a42b7203b2dc0199b81039c6c4e1ef900e82a4','0xd2667072a2a30e8c21fa276b474fd047ab5ff0f7')
and FROM_ADDRESS in ('0xa2a42b7203b2dc0199b81039c6c4e1ef900e82a4','0xd2667072a2a30e8c21fa276b474fd047ab5ff0f7')
and TO_ADDRESS = '0x3a23f943181408eac424116af7b7790c94cb97a5'
and ORIGIN_from_ADDRESS not in ('0x1e2c53ba467f6c4aa9325a7767a401b1999b2bf7',
'0x90ab3b8deeaa6a3cfa3c6622f140ce56e62f47e3',
Last run: about 13 hours agoAuto-refreshes every 24 hours
1
40B
68s