DAY | EVENTS | VOTERS | |
|---|---|---|---|
1 | 2024-04-04 00:00:00.000 | 612 | 552 |
2 | 2024-01-03 00:00:00.000 | 1012 | 904 |
3 | 2024-01-26 00:00:00.000 | 96 | 92 |
4 | 2024-12-15 00:00:00.000 | 301 | 273 |
5 | 2024-07-20 00:00:00.000 | 289 | 247 |
6 | 2023-10-01 00:00:00.000 | 180 | 172 |
7 | 2024-08-28 00:00:00.000 | 2358 | 1734 |
8 | 2024-04-19 00:00:00.000 | 327 | 296 |
9 | 2023-08-31 00:00:00.000 | 733 | 723 |
10 | 2024-07-11 00:00:00.000 | 712 | 618 |
11 | 2025-01-14 00:00:00.000 | 415 | 352 |
12 | 2024-12-23 00:00:00.000 | 405 | 329 |
13 | 2023-12-01 00:00:00.000 | 57 | 54 |
14 | 2023-08-29 00:00:00.000 | 915 | 911 |
15 | 2024-10-02 00:00:00.000 | 2577 | 1886 |
16 | 2024-08-14 00:00:00.000 | 2324 | 1777 |
17 | 2024-09-10 00:00:00.000 | 362 | 277 |
18 | 2023-11-15 00:00:00.000 | 1270 | 1149 |
19 | 2024-10-12 00:00:00.000 | 318 | 276 |
20 | 2023-12-11 00:00:00.000 | 90 | 82 |
jackguyAreodrome Voting 1
Updated 2025-01-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tab1 AS (
SELECT DISTINCT tx_hash
FROM base.core.fact_event_logs --
WHERE tx_hash in (
SELECT tx_hash
FROM base.core.fact_transactions
WHERE to_address LIKE '0x16613524e02ad97edfef371bc883f2f5d6c480a5'
)
AND origin_function_signature like '0x7ac09bf7'
)
SELECT
date(block_timestamp) as day,
count(DISTINCT tx_hash) as events,
count(DISTINCT from_address) as voters
FROM base.core.fact_transactions
WHERE tx_hash in (SELECT * from tab1)
GROUP BY 1
Last run: 2 months ago
...
519
18KB
469s