hbd19942022 - calls
Updated 2024-11-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
WITH block_groups AS (
SELECT
BLOCK_ID,
BLOCK_ID - ROW_NUMBER() OVER (ORDER BY BLOCK_ID) AS group_id
FROM (SELECT DISTINCT BLOCK_ID FROM near.core.fact_actions_events_function_call WHERE BLOCK_TIMESTAMP >= '2021-12-31' and BLOCK_TIMESTAMP < '2023-01-01')),
grouped_calls AS (
SELECT
MIN(t.BLOCK_ID) AS start_block,
MAX(t.BLOCK_ID) AS end_block,
COUNT(DISTINCT FACT_ACTIONS_EVENTS_FUNCTION_CALL_ID) AS call_count
FROM near.core.fact_actions_events_function_call t
JOIN block_groups bg ON t.BLOCK_ID = bg.BLOCK_ID
WHERE t.BLOCK_TIMESTAMP >= '2021-12-31' and t.BLOCK_TIMESTAMP < '2023-01-01'
GROUP BY bg.group_id
HAVING COUNT(DISTINCT t.BLOCK_ID) = 10
),
ranked_results AS (
SELECT
start_block,
end_block,
call_count,
RANK() OVER (ORDER BY call_count DESC) AS rank
FROM grouped_calls
)
SELECT
start_block,
end_block,
call_count
FROM ranked_results
WHERE rank <= 10;
--SELECT * FROM near.core.ez_token_transfers ORDER BY 2 LIMIT 1
QueryRunArchived: QueryRun has been archived