TX_DATE | RECIPIENT | TX_COUNT_PER_DAY | CUMULATIVE_TX_COUNT | |
|---|---|---|---|---|
1 | 2024-12-27 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 20 | 20 |
2 | 2024-12-28 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 42 | 62 |
3 | 2024-12-29 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 27 | 89 |
4 | 2024-12-30 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 15 | 104 |
5 | 2024-12-31 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 31 | 135 |
6 | 2025-01-01 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 5 | 140 |
7 | 2025-01-02 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 11 | 151 |
8 | 2025-01-03 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 42 | 193 |
9 | 2025-01-04 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 42 | 235 |
10 | 2025-01-05 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 12 | 247 |
11 | 2025-01-06 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 30 | 277 |
12 | 2025-01-07 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 20 | 297 |
13 | 2025-01-08 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 9 | 306 |
14 | 2025-01-09 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 14 | 320 |
15 | 2025-01-10 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 6 | 326 |
16 | 2025-01-11 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 9 | 335 |
17 | 2025-01-12 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 13 | 348 |
18 | 2025-01-13 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 16 | 364 |
19 | 2025-01-14 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 20 | 384 |
20 | 2025-01-15 00:00:00.000 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 | 27 | 411 |
MetaLightHelium Mobile - Hotspot Growth copy
Updated 8 days ago
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
›
⌄
WITH tx_data AS (
SELECT
block_timestamp::date AS tx_date,
COUNT(tx_id) AS tx_count_per_day,
instruction:accounts[12]::string AS recipient
FROM solana.core.fact_events
WHERE succeeded
AND program_id = 'hemjuPXBpNvggtaUnN1MwT3wrdhttKEfosTcc2P9Pg8'
AND instruction:accounts[0] = 'FbnCZoQzE9GrmWxG1yMsYyw4YrEJSZjyNVtF3PDCPzoi'
AND instruction:accounts[6] = 'Tgb2gsQWVc4KWxUE8RdyLEqZZCf75XrNWr5ku986F78'
AND instruction:accounts[3] = '8Rap1SUaHABCZ18yVbubn1SQVEQHvBaiwZFeDtTn7u5a'
AND block_timestamp >= CURRENT_DATE - INTERVAL '90 days'
GROUP BY block_timestamp::date, instruction:accounts[12]::string
),
cumulative AS (
SELECT
tx_date,
recipient,
tx_count_per_day,
SUM(tx_count_per_day) OVER (PARTITION BY recipient ORDER BY tx_date) AS cumulative_tx_count
FROM tx_data
)
SELECT * FROM cumulative
ORDER BY tx_date;
Last run: 8 days ago
91
7KB
5s