zyroqperiod 3
    Updated 2024-12-09
    SELECT
    DATE_TRUNC('{{granularity }}', BLOCK_TIMESTAMP) AS date,
    COUNT(DISTINCT TX_HASH) AS bridge_tx,
    SUM(AMOUNT_USD) AS total_value_tf,
    COUNT(DISTINCT CASE
    WHEN direction = 'inbound' THEN destination_address
    ELSE source_address
    END) AS users,
    SUM(bridge_tx) OVER (ORDER BY date) AS cumulative_bridge_tx,
    SUM(total_value_tf) OVER (ORDER BY date) AS cumulative_total_value_tf,
    SUM(users) OVER (ORDER BY date) AS cumulative_users -- Cumulative unique users
    FROM
    near.defi.ez_bridge_activity
    WHERE
    platform = 'rainbow'
    AND BLOCK_TIMESTAMP > CURRENT_DATE - INTERVAL '{{trading_period}} days'
    GROUP BY
    date
    ORDER BY
    date DESC;


    QueryRunArchived: QueryRun has been archived