datavortexBridge from aptos
Updated 2024-12-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH bridges_from_aptos AS (
SELECT
CONCAT('Aptos -> ', destination_chain) AS "Bridge From Aptos Route",
COUNT(DISTINCT tx_hash) AS "Bridges From Aptos Count"
FROM
aptos.defi.ez_bridge_activity
WHERE
DATE_TRUNC('month', block_timestamp) = DATE_TRUNC('month', CURRENT_DATE)
AND source_chain = 'Aptos'
GROUP BY
destination_chain
)
SELECT
"Bridge From Aptos Route",
"Bridges From Aptos Count"
FROM
bridges_from_aptos
ORDER BY
"Bridges From Aptos Count" DESC
LIMIT 5;
QueryRunArchived: QueryRun has been archived