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
22
23
24
25
26
27
28
›
⌄
⌄
SELECT
CONCAT(source_chain, ' -> ', destination_chain) AS "Bridge",
SUM(amount_in_usd) AS "total bridge Volume"
FROM
aptos.defi.ez_bridge_activity
WHERE
DATE_TRUNC('month', block_timestamp) = DATE_TRUNC('month', CURRENT_DATE)
GROUP BY
source_chain,
destination_chain
ORDER BY
"total bridge Volume" DESC
LIMIT
5;
/*
SELECT
destination_chain,
source_chain,
COUNT(DISTINCT sender) AS "wallet addresses",
COUNT(DISTINCT tx_hash) AS "Bridges",
SUM(amount_in_usd) AS "total bridge Volume"
FROM
aptos.defi.ez_bridge_activity
WHERE
DATE_TRUNC('month', block_timestamp) = DATE_TRUNC('month', CURRENT_DATE)
GROUP BY
destination_chain, source_chain;
*/
QueryRunArchived: QueryRun has been archived