DATE_TRUNC('day', 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

near.defi.ez_bridge_activity

platform = 'rainbow'

and date > '2021-10-27'

GROUP BY

date

ORDER BY

date DESC;