DATE | AGGREGATOR | SRC_CHAIN | ROUTE | COUNT | VOLUME | |
|---|---|---|---|---|---|---|
1 | 2025-05-07 00:00:00.000 | lifi | arbitrum | arbitrum->bsc | 1 | 906.41 |
2 | 2025-04-14 00:00:00.000 | lifi | bsc | 191 | ||
3 | 2025-05-16 00:00:00.000 | lifi | ethereum | 242 | ||
4 | 2025-05-14 00:00:00.000 | lifi | bsc | 210 | ||
5 | 2025-01-24 00:00:00.000 | squid | bsc | bsc->polygon | 38 | 4219.16 |
6 | 2025-01-01 00:00:00.000 | lifi | polygon | 93 | ||
7 | 2025-04-15 00:00:00.000 | lifi | ethereum | 341 | ||
8 | 2025-01-19 00:00:00.000 | lifi | base | base->zksync era | 9 | 1415.62 |
9 | 2024-11-18 00:00:00.000 | lifi | ethereum | 74 | ||
10 | 2025-04-01 00:00:00.000 | lifi | ethereum | ethereum->polygon | 81 | 31096.31 |
11 | 2025-02-17 00:00:00.000 | lifi | bsc | 218 | ||
12 | 2024-12-24 00:00:00.000 | lifi | optimism | optimism->arbitrum | 49 | 1503.31 |
13 | 2025-01-19 00:00:00.000 | lifi | bsc | bsc->arbitrum | 21 | 14891.4 |
14 | 2024-11-20 00:00:00.000 | socket | avalanche | avalanche->ethereum | 8 | 9206.31 |
15 | 2025-01-09 00:00:00.000 | lifi | optimism | optimism->ethereum | 46 | 33501.24 |
16 | 2025-01-15 00:00:00.000 | lifi | base | base->arbitrum | 126 | 45866.36 |
17 | 2025-01-03 00:00:00.000 | lifi | ethereum | ethereum->arbitrum | 240 | 305264.74 |
18 | 2025-01-04 00:00:00.000 | squid | ethereum | ethereum->polygon | 40 | 15159.2 |
19 | 2025-02-14 00:00:00.000 | squid | bsc | bsc->base | 1 | 33.1 |
20 | 2025-04-26 00:00:00.000 | lifi | ethereum | ethereum->polygon | 35 | 6523.44 |
LI.FIOverview
Updated 4 days ago
99
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 MM_init AS (
SELECT tx_hash, src_chain, event_name, decoded_log, block_timestamp AS date
FROM (
SELECT tx_hash, event_name, decoded_log, block_timestamp, origin_function_signature, 'ethereum' AS src_chain FROM ethereum.core.ez_decoded_event_logs
UNION
SELECT tx_hash, event_name, decoded_log, block_timestamp, origin_function_signature, 'polygon' AS src_chain FROM polygon.core.ez_decoded_event_logs
UNION
SELECT tx_hash, event_name, decoded_log, block_timestamp, origin_function_signature, 'bsc' AS src_chain FROM bsc.core.ez_decoded_event_logs
UNION
SELECT tx_hash, event_name, decoded_log, block_timestamp, origin_function_signature, 'base' AS src_chain FROM base.core.ez_decoded_event_logs
UNION
SELECT tx_hash, event_name, decoded_log, block_timestamp, origin_function_signature, 'arbitrum' AS src_chain FROM arbitrum.core.ez_decoded_event_logs
UNION
SELECT tx_hash, event_name, decoded_log, block_timestamp, origin_function_signature, 'optimism' AS src_chain FROM optimism.core.ez_decoded_event_logs
UNION
SELECT tx_hash, event_name, decoded_log, block_timestamp, origin_function_signature, 'avalanche' AS src_chain FROM avalanche.core.ez_decoded_event_logs
UNION
SELECT tx_hash, event_name, decoded_log, block_timestamp, origin_function_signature, 'gnosis' AS src_chain FROM gnosis.core.ez_decoded_event_logs
)
WHERE origin_function_signature = '0x3ce33bff'
AND block_timestamp >= '{{from}}'
),
LiFi_Amarok_txns AS (
SELECT 'lifi' AS aggregator, a.tx_hash, a.src_chain, b.event_name, a.date
FROM MM_init a , MM_init b
WHERE a.event_name = 'XCalled' AND b.event_name = 'LiFiAmarokTransfer'
AND a.tx_hash = b.tx_hash
),
bridge_txns AS(
SELECT
CASE
WHEN event_name IN ('LiFiTransferStarted', 'LiFiAcrossTransfer', 'LiFiCBridgeTransfer', 'LiFiHopTransfer', 'LiFiAmarokTransfer') THEN 'lifi'
WHEN event_name = 'SocketBridge' THEN 'socket'
WHEN event_name = 'ContractCallWithToken' THEN 'squid'
ELSE 'other'
END AS aggregator,
Last run: 4 days ago
...
17769
1MB
344s