MONTH | SOURCE_CHAIN | TOTAL_VOLUME_USD | |
|---|---|---|---|
1 | 2025-05-01 00:00:00.000 | aurora | 735600.987117971 |
2 | 2025-05-01 00:00:00.000 | celo | 2.746538983 |
3 | 2025-05-01 00:00:00.000 | solana | 0.01624758391 |
4 | 2025-04-01 00:00:00.000 | aurora | 280777.786971391 |
5 | 2025-04-01 00:00:00.000 | ethereum | 123565.420173959 |
6 | 2025-04-01 00:00:00.000 | solana | 200.0303183 |
7 | 2025-04-01 00:00:00.000 | celo | 5.818619271 |
8 | 2025-04-01 00:00:00.000 | binance smart chain | 0.01047655076 |
9 | 2025-03-01 00:00:00.000 | ethereum | 908285.778811016 |
10 | 2025-03-01 00:00:00.000 | aurora | 361172.955952249 |
11 | 2025-03-01 00:00:00.000 | solana | 1039.557850601 |
12 | 2025-03-01 00:00:00.000 | celo | 2.953829124 |
13 | 2025-03-01 00:00:00.000 | binance smart chain | 0.02499550182 |
14 | 2025-02-01 00:00:00.000 | ethereum | 862578.244804128 |
15 | 2025-02-01 00:00:00.000 | aurora | 790342.673067529 |
16 | 2025-02-01 00:00:00.000 | solana | 6448.131277591 |
17 | 2025-02-01 00:00:00.000 | celo | 3.38251603 |
18 | 2025-02-01 00:00:00.000 | binance smart chain | 0.2809717647 |
19 | 2025-02-01 00:00:00.000 | harmony | 0.0079825 |
20 | 2025-01-01 00:00:00.000 | aurora | 920169.719907135 |
adriaparcerisasnear bridge 5
Updated 9 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
trunc(block_timestamp,'month') as month,
source_chain,
--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,source_chain having source_chain is not null
ORDER BY
month desc, TOTAL_VOLUME_USD DESC
Last run: 9 days ago
...
361
19KB
250s