TX_DATE | TX_COUNT_PER_DAY | RECIPIENT | |
|---|---|---|---|
1 | 2023-12-21 00:00:00.000 | 96 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
2 | 2024-02-23 00:00:00.000 | 67 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
3 | 2024-08-21 00:00:00.000 | 154 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
4 | 2024-01-30 00:00:00.000 | 132 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
5 | 2024-05-28 00:00:00.000 | 17 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
6 | 2023-10-02 00:00:00.000 | 3 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
7 | 2023-12-14 00:00:00.000 | 21 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
8 | 2024-06-25 00:00:00.000 | 28 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
9 | 2025-01-05 00:00:00.000 | 12 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
10 | 2024-07-26 00:00:00.000 | 29 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
11 | 2024-10-23 00:00:00.000 | 32 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
12 | 2025-02-01 00:00:00.000 | 36 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
13 | 2024-11-21 00:00:00.000 | 25 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
14 | 2024-08-29 00:00:00.000 | 67 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
15 | 2024-06-27 00:00:00.000 | 28 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
16 | 2024-05-13 00:00:00.000 | 66 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
17 | 2024-02-17 00:00:00.000 | 79 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
18 | 2025-02-28 00:00:00.000 | 80 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
19 | 2024-10-15 00:00:00.000 | 54 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
20 | 2023-10-26 00:00:00.000 | 1 | GHYFhNyiqSPxu3q2a5ENs42iV1zRCfcjCiE7TmzNxni3 |
MetaLightHelium Mobile - Hotspot Growth
Updated 10 days ago
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: 10 days ago
...
544
41KB
18s