Total Bridges | Total Bridgers | token sent for bridging | total platforms involved in bridging | successful bridges | failed bridges | inbound bridges | outbound bridges | |
|---|---|---|---|---|---|---|---|---|
1 | 127103 | 43705 | 456 | 3 | 126927 | 176 | 74068 | 53035 |
datavortexBridge activities
Updated 2025-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
COUNT(DISTINCT tx_id) AS "Total Bridges",
COUNT(DISTINCT user_address) AS "Total Bridgers",
COUNT(DISTINCT mint) AS "token sent for bridging",
COUNT(DISTINCT platform) AS "total platforms involved in bridging",
COUNT(DISTINCT CASE WHEN succeeded ='True' THEN tx_id END) AS "successful bridges",
COUNT(DISTINCT CASE WHEN succeeded ='False' THEN tx_id END) AS "failed bridges",
COUNT(DISTINCT CASE WHEN direction ='inbound' THEN tx_id END) AS "inbound bridges",
COUNT(DISTINCT CASE WHEN direction ='outbound' THEN tx_id END) AS "outbound bridges",
FROM solana.defi.fact_bridge_activity
WHERE
block_timestamp > '2024-08-31'AND block_timestamp < '2024-10-01'
Last run: 2 months ago
1
45B
5s