MONTH | PLATFORM | TOTAL_VOLUME_USD | |
|---|---|---|---|
1 | 2025-05-01 00:00:00.000 | rainbow | 16654.054529124 |
2 | 2025-05-01 00:00:00.000 | allbridge | 0.0009260997521 |
3 | 2025-04-01 00:00:00.000 | rainbow | 419218.212425183 |
4 | 2025-04-01 00:00:00.000 | wormhole | 249.976615833 |
5 | 2025-04-01 00:00:00.000 | allbridge | 5.323277914 |
6 | 2025-03-01 00:00:00.000 | rainbow | 1281655.86305767 |
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 | 1662765.17621288 |
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 | 1199540.89399364 |
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 | 5049365.53120833 |
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 | 9095407.90914672 |
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 4 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: 4 days ago
...
126
7KB
418s