MONTH | PLATFORM | TOTAL_VOLUME_USD | |
|---|---|---|---|
1 | 2025-05-01 00:00:00.000 | rainbow | 735600.987117971 |
2 | 2025-05-01 00:00:00.000 | allbridge | 2.762786567 |
3 | 2025-04-01 00:00:00.000 | rainbow | 404293.21684535 |
4 | 2025-04-01 00:00:00.000 | wormhole | 249.976615833 |
5 | 2025-04-01 00:00:00.000 | allbridge | 5.873098289 |
6 | 2025-03-01 00:00:00.000 | rainbow | 1269458.72962331 |
7 | 2025-03-01 00:00:00.000 | wormhole | 1039.539960751 |
8 | 2025-03-01 00:00:00.000 | allbridge | 3.001854434 |
9 | 2025-02-01 00:00:00.000 | rainbow | 1652920.91787166 |
10 | 2025-02-01 00:00:00.000 | wormhole | 6448.02493075 |
11 | 2025-02-01 00:00:00.000 | allbridge | 3.777817135 |
12 | 2025-01-01 00:00:00.000 | rainbow | 1194381.19038646 |
13 | 2025-01-01 00:00:00.000 | wormhole | 560.289104301 |
14 | 2025-01-01 00:00:00.000 | allbridge | 48.106426448 |
15 | 2024-12-01 00:00:00.000 | rainbow | 5048894.80866457 |
16 | 2024-12-01 00:00:00.000 | wormhole | 2749.134078342 |
17 | 2024-12-01 00:00:00.000 | allbridge | 152.143813074 |
18 | 2024-11-01 00:00:00.000 | rainbow | 9083560.77607122 |
19 | 2024-11-01 00:00:00.000 | wormhole | 414744.733865486 |
20 | 2024-11-01 00:00:00.000 | allbridge | 577.25285645 |
adriaparcerisasnear bridge 10
Updated 8 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
trunc(block_timestamp,'month') as month,
platform,
--direction,
sum(amount_usd) AS TOTAL_VOLUME_USD
FROM
near.defi.ez_bridge_activity
WHERE
RECEIPT_SUCCEEDED = TRUE
AND AMOUNT_USD IS NOT NULL --and (source_chain = 'near' or destination_chain='near')
and direction='inbound'
GROUP BY
month,platform having platform is not null
ORDER BY
month desc, TOTAL_VOLUME_USD DESC
Last run: 8 days ago
...
126
7KB
253s