TX_DATE | TX_COUNT_PER_DAY | RECIPIENT | |
|---|---|---|---|
1 | 2024-11-19 00:00:00.000 | 45 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
2 | 2024-06-27 00:00:00.000 | 28 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
3 | 2024-02-01 00:00:00.000 | 107 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
4 | 2025-02-28 00:00:00.000 | 80 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
5 | 2024-05-13 00:00:00.000 | 66 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
6 | 2024-10-15 00:00:00.000 | 54 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
7 | 2024-02-17 00:00:00.000 | 79 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
8 | 2023-10-26 00:00:00.000 | 1 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
9 | 2025-01-07 00:00:00.000 | 20 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
10 | 2024-10-28 00:00:00.000 | 35 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
11 | 2024-03-30 00:00:00.000 | 67 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
12 | 2024-07-11 00:00:00.000 | 101 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
13 | 2024-01-13 00:00:00.000 | 138 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
14 | 2024-11-27 00:00:00.000 | 18 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
15 | 2024-12-07 00:00:00.000 | 20 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
16 | 2024-02-28 00:00:00.000 | 72 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
17 | 2024-05-09 00:00:00.000 | 65 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
18 | 2023-10-04 00:00:00.000 | 1 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
19 | 2024-01-17 00:00:00.000 | 139 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
20 | 2024-10-25 00:00:00.000 | 40 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
MetaLightHelium Mobile - Hotspot Growth
Updated 2025-03-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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'
GROUP BY block_timestamp::date, instruction:accounts[12]::string
Last run: 20 days ago
...
517
39KB
86s