datavortexActivr bridgers
Updated 2025-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH daily_bridgers AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(DISTINCT origin_from_address) AS bridgers
FROM (
SELECT
origin_from_address,
block_timestamp
FROM polygon.defi.ez_bridge_activity
WHERE block_timestamp BETWEEN '{{start_date}}' AND '{{end_date}}'
GROUP BY origin_from_address, block_timestamp
) AS daily_activity
GROUP BY day
)
SELECT
day,
bridgers,
SUM(bridgers) OVER (ORDER BY day) AS cumulative_bridgers
FROM daily_bridgers
ORDER BY day;