HOUR | NEW_BUYERS | TOTAL_BUYERS | |
|---|---|---|---|
1 | 2025-02-21 17:00:00.000 | 18 | 17054 |
2 | 2025-01-08 23:00:00.000 | 8 | 9935 |
3 | 2025-02-18 09:00:00.000 | 4 | 16135 |
4 | 2024-12-17 14:00:00.000 | 6 | 3294 |
5 | 2025-02-26 08:00:00.000 | 8 | 18317 |
6 | 2025-02-25 09:00:00.000 | 13 | 18184 |
7 | 2025-01-16 08:00:00.000 | 3 | 11317 |
8 | 2025-01-22 23:00:00.000 | 8 | 12695 |
9 | 2025-01-31 16:00:00.000 | 18 | 14173 |
10 | 2025-02-22 06:00:00.000 | 10 | 17169 |
11 | 2024-12-26 10:00:00.000 | 14 | 6184 |
12 | 2025-01-04 08:00:00.000 | 9 | 8698 |
13 | 2024-12-30 20:00:00.000 | 14 | 7759 |
14 | 2025-02-25 14:00:00.000 | 7 | 18238 |
15 | 2025-02-28 21:00:00.000 | 6 | 18878 |
16 | 2025-01-17 09:00:00.000 | 10 | 11497 |
17 | 2025-01-07 21:00:00.000 | 11 | 9624 |
18 | 2025-01-19 06:00:00.000 | 7 | 11754 |
19 | 2025-01-25 15:00:00.000 | 8 | 13271 |
20 | 2025-01-23 21:00:00.000 | 8 | 12927 |
Pine AnalyticsScope 3
Updated 2025-04-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
hour,
count(*) as new_buyers,
sum(new_buyers) over (order by hour) as total_buyers
FROM (
SELECT
signers[0] as wallet,
min(date_trunc('hour', block_timestamp)) as hour
from eclipse.core.fact_transactions
--where tx_id like '4TwEfdwK9WNwHWybfLeoZmeMZQPWDRBb4ZqRNzofk58XiRjxRN4GoWiCSzTvH8xLUyJGRF4Yp6n3w6Y3CLpnrpQb'
WHERE ((log_messages[0] LIKE 'Program Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic invoke [1]' and log_messages[1] LIKE 'Program log: Instruction: FillOrder')
OR (log_messages[2] LIKE 'Program Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic invoke [1]' and log_messages[3] LIKE 'Program log: Instruction: FillOrder'))
and block_timestamp > '2024-12-05 14:00:00.000'
AND SUCCEEDED
GROUP BY 1
)
GROUP BY 1
Last run: 20 days ago
...
2236
79KB
231s