CHAIN | INTEGRATOR | N_TXNS | N_USERS | VOLUME | |
---|---|---|---|---|---|
1 | Arbitrum | layer3 | 1 | 1 | 19.99978 |
2 | BASE | Web3Academy | 3 | 3 | 38.692743489 |
3 | Polygon | safepal | 24 | 11 | 22390.008904681 |
4 | Polygon | rebalancer | 4 | 1 | 1251.223365786 |
5 | BASE | rebalancer | 2 | 1 | 1.704471853 |
6 | BASE | VOOI | 1 | 1 | 0.01363460954 |
7 | Polygon | transak | 5 | 1 | 3032.631860724 |
8 | Ethereum | exodusus | 1 | 1 | 29739.737908696 |
9 | Avalanche | the-standard | 1 | 1 | 2799.7956 |
10 | Arbitrum | rebalancer | 3 | 1 | 2.107637798 |
11 | Polygon | zapper | 1 | 1 | 135.470518274 |
12 | BASE | blockscout | 1 | 1 | 0 |
13 | Polygon | kucoin | 1 | 1 | 6485.527604708 |
14 | Polygon | exodusus | 6 | 5 | 3445.228612438 |
15 | Polygon | offramp | 2 | 1 | 0 |
16 | Ethereum | lifi-api | 2 | 2 | 1776.72956768 |
17 | BASE | folks-finance | 10 | 10 | 38.230985082 |
18 | Polygon | dca-app | 5 | 1 | 361.756821 |
19 | BASE | heyelsa | 3 | 3 | 1.62404487 |
20 | BASE | ionic | 1 | 1 | 3.34862 |
ali_lifiBase - Collateral Swap
Updated 2025-01-15
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
same_chain_txns as (
SELECT a.*, 'Arbitrum' as chain FROM arbitrum.core.ez_decoded_event_logs a, arbitrum.core.ez_decoded_event_logs b, arbitrum.core.ez_decoded_event_logs c
WHERE a.block_timestamp between current_date -31 AND current_date-1
AND b.block_timestamp between current_date -31 AND current_date-1
-- AND a.origin_to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
AND a.tx_hash = b.tx_hash and a.tx_hash = c.tx_hash
AND a.event_name = 'LiFiGenericSwapCompleted'
AND b.event_name = 'ReserveUsedAsCollateralEnabled' -- in ('ReserveUsedAsCollateralEnabled', 'ReserveUsedAsCollateralDisabled')
AND c.event_name = 'ReserveUsedAsCollateralDisabled' --in ('ReserveUsedAsCollateralEnabled', 'ReserveUsedAsCollateralDisabled')
UNION ALL
SELECT a.*, 'OP' as chain FROM optimism.core.ez_decoded_event_logs a,optimism.core.ez_decoded_event_logs b,optimism.core.ez_decoded_event_logs c
WHERE a.block_timestamp between current_date -31 AND current_date-1
AND b.block_timestamp between current_date -31 AND current_date-1
-- AND a.origin_to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
AND a.tx_hash = b.tx_hash and a.tx_hash = c.tx_hash
and a.event_name = 'LiFiGenericSwapCompleted'
AND b.event_name = 'ReserveUsedAsCollateralEnabled'
AND c.event_name = 'ReserveUsedAsCollateralDisabled'
UNION ALL
SELECT a.*, 'BSC' as chain FROM bsc.core.ez_decoded_event_logs a, bsc.core.ez_decoded_event_logs b , bsc.core.ez_decoded_event_logs c
WHERE a.block_timestamp between current_date -31 AND current_date-1
AND b.block_timestamp between current_date -31 AND current_date-1
-- AND a.origin_to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
AND a.tx_hash = b.tx_hash and a.tx_hash = c.tx_hash
and a.event_name = 'LiFiGenericSwapCompleted'
AND b.event_name = 'ReserveUsedAsCollateralEnabled'
AND c.event_name = 'ReserveUsedAsCollateralDisabled'
UNION ALL
SELECT a.*, 'BASE' as chain FROM base.core.ez_decoded_event_logs a, base.core.ez_decoded_event_logs b, base.core.ez_decoded_event_logs c
WHERE a.block_timestamp between current_date -31 AND current_date-1
AND b.block_timestamp between current_date -31 AND current_date-1
-- AND a.origin_to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
AND a.tx_hash = b.tx_hash and a.tx_hash = c.tx_hash
and a.event_name = 'LiFiGenericSwapCompleted'
AND b.event_name = 'ReserveUsedAsCollateralEnabled'
Last run: 27 days ago
51
2KB
249s