m3jiBridge Overview
    Updated 2025-05-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