Kruys-CollinsTop Bridged Assets
Updated 2024-11-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH total_data AS (
SELECT
COUNT(*) AS total_transactions,
SUM(AMOUNT_USD) AS total_volume
FROM ethereum.defi.ez_bridge_activity
WHERE
bridge_address = lower('0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5')
)
SELECT
TOKEN_SYMBOL AS "TOKEN SYMBOL",
COUNT(*) AS "Bridge Transactions",
SUM(AMOUNT_USD) AS "Bridging Volume in USD",
(COUNT(*) / total_transactions) * 100 AS "% Share of Bridge Transactions",
(SUM(AMOUNT_USD) / total_volume) * 100 AS "% Share of Bridging Volume"
FROM ethereum.defi.ez_bridge_activity
CROSS JOIN total_data
WHERE
bridge_address = lower('0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5')
GROUP BY 1, total_transactions, total_volume
ORDER BY 2 DESC;
QueryRunArchived: QueryRun has been archived