DESTINATION_CHAIN | TOTAL_VOLUME | TOTAL_TRANSACTIONS | UNIQUE_USERS | |
|---|---|---|---|---|
1 | Aptos | 186496066.547113 | 47783 | 34470 |
2 | aptos | 14444752.835704 | 4970 | 1206 |
Updated 2025-01-30
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
case when DESTINATION_CHAIN is null then 'unknown' else DESTINATION_CHAIN end as DESTINATION_CHAIN,
SUM(AMOUNT_IN_USD) AS total_volume,
COUNT(DISTINCT TX_HASH) AS total_transactions,
COUNT(DISTINCT CASE WHEN direction = 'inbound' THEN RECEIVER ELSE SENDER END) AS unique_users
FROM aptos.defi.ez_bridge_activity
WHERE direction = 'inbound'
AND block_timestamp > CURRENT_DATE - INTERVAL '{{trading_period}} days'
GROUP BY DESTINATION_CHAIN
ORDER BY total_volume DESC;
Last run: 2 months ago
2
76B
41s