BRIDGE_PROTOCOL | FIRST_HOP_ACTION | TX_COUNT | |
|---|---|---|---|
1 | across-v3 | Idle Holding | 1736115 |
2 | across-v3 | Bridging Back | 492371 |
3 | across-v3 | DEX Swap | 11021 |
4 | stargate | Bridging Back | 70934 |
5 | stargate | Idle Holding | 15816 |
6 | stargate | DEX Swap | 161 |
merklehaggardGetting Started
Updated 10 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 time_window AS (
SELECT
CURRENT_DATE - INTERVAL '90 days' AS start_date,
CURRENT_DATE AS end_date
),
bridge_activity AS (
-- Ethereum
SELECT
'ethereum' AS origin_chain,
b.destination_chain,
b.platform AS bridge_protocol,
b.destination_chain_receiver AS recipient,
b.tx_hash,
b.block_timestamp
FROM ethereum.defi.ez_bridge_activity b
WHERE b.block_timestamp >= (SELECT start_date FROM time_window)
AND b.platform IN ('across-v3', 'stargate', 'layerzero')
UNION ALL
-- Arbitrum
SELECT
'arbitrum',
b.destination_chain,
b.platform,
b.destination_chain_receiver,
b.tx_hash,
b.block_timestamp
FROM arbitrum.defi.ez_bridge_activity b
WHERE b.block_timestamp >= (SELECT start_date FROM time_window)
AND b.platform IN ('across-v3', 'stargate', 'layerzero')
UNION ALL
Last run: 10 days ago
6
203B
55s