m3jiBridge Overview
Updated 2025-05-25Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
SELECT
TRUNC(block_timestamp, 'week') AS weekly,
CASE
WHEN block_timestamp >= '2024-01-01' AND block_timestamp < '2024-04-01' THEN 'Q1-2024'
WHEN block_timestamp >= '2024-04-01' AND block_timestamp < '2024-07-01' THEN 'Q2-2024'
WHEN block_timestamp >= '2024-07-01' AND block_timestamp < '2024-10-01' THEN 'Q3-2024'
WHEN block_timestamp >= '2024-10-01' AND block_timestamp < '2025-01-01' THEN 'Q4-2024'
END AS quarter,
source_chain,
destination_chain,
symbol,
direction,
-- SUM(CASE WHEN direction = 'inbound' THEN amount_usd ELSE 0 END) AS total_inflow_usd,
-- SUM(CASE WHEN direction = 'outbound' THEN amount_usd ELSE 0 END) AS total_outflow_usd
SUM(amount_usd) AS bridge_volume
FROM
near.defi.ez_bridge_activity
WHERE
block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
AND amount_usd IS NOT NULL
GROUP BY
weekly, quarter, source_chain, destination_chain, symbol, direction
ORDER BY
quarter, bridge_volume DESC;
QueryRunArchived: QueryRun has been archived