AGGREGATOR | TX_COUNT | VOLUME | |
---|---|---|---|
1 | Socket | 15260 | 13902717.0719936 |
2 | Li.Fi | 97347 | 40935521.576147 |
LI.FIRabbyWallet: Li.Fi <> Socket
Updated 2025-04-28Copy Reference Fork
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
›
⌄
-- forked from Layer3: Li.Fi <> Socket @ https://flipsidecrypto.xyz/studio/queries/a011b10d-88fe-4eaf-adf9-da2d5c45cf78
-- forked from Li.Fi <> Socket Market Share @ https://flipsidecrypto.xyz/studio/queries/4cb05d25-2f61-41eb-a4cb-bf0f5825dc1b
WITH chains AS (
SELECT
*
FROM
(
VALUES
('Ethereum', '1', 'ETH'),
('Arbitrum', '42161', 'ETH'),
('BNB Smart chain', '56', 'BNB'),
('Avalanche_C', '43114', 'AVAX'),
('Optimism ', '10', 'ETH'),
('Polygon', '137', 'MATIC'),
('BASE', '8453','ETH'),
('Gnosis', '100', 'XDAI'),
('zkSync Mainnet', '324', 'ETH'),
('Solana', '1151111081099710','SOL'),
('Fantom Opera', '250','FTM'),
('Polygon zkEVM', '1101','ETH'),
('Linea', '59144', 'ETH'),
('Aurora','1313161554','AURORA')
) AS a (chain, dest_chain_id,currency)
)
,
polygon_chain_data as (
SELECT
'polygon' as src_chain ,
'Li.Fi' as aggregator,
block_timestamp,
tx_hash,
origin_from_address,
decoded_log:bridgeData:destinationChainId AS dest_chain_id,
Last run: 2 months ago
2
67B
290s