TX_DATE | TX_COUNT_PER_DAY | CUMULATIVE_TX_COUNT | |
|---|---|---|---|
1 | 2023-07-25 00:00:00.000 | 302 | 302 |
2 | 2023-07-26 00:00:00.000 | 327 | 629 |
3 | 2023-07-27 00:00:00.000 | 562 | 1191 |
4 | 2023-07-28 00:00:00.000 | 369 | 1560 |
5 | 2023-07-29 00:00:00.000 | 165 | 1725 |
6 | 2023-07-30 00:00:00.000 | 85 | 1810 |
7 | 2023-07-31 00:00:00.000 | 81 | 1891 |
8 | 2023-08-01 00:00:00.000 | 89 | 1980 |
9 | 2023-08-02 00:00:00.000 | 70 | 2050 |
10 | 2023-08-03 00:00:00.000 | 134 | 2184 |
11 | 2023-08-04 00:00:00.000 | 105 | 2289 |
12 | 2023-08-05 00:00:00.000 | 55 | 2344 |
13 | 2023-08-06 00:00:00.000 | 50 | 2394 |
14 | 2023-08-07 00:00:00.000 | 199 | 2593 |
15 | 2023-08-08 00:00:00.000 | 156 | 2749 |
16 | 2023-08-09 00:00:00.000 | 95 | 2844 |
17 | 2023-08-10 00:00:00.000 | 125 | 2969 |
18 | 2023-08-11 00:00:00.000 | 216 | 3185 |
19 | 2023-08-12 00:00:00.000 | 121 | 3306 |
20 | 2023-08-13 00:00:00.000 | 68 | 3374 |
MetaLightHelium Mobile - New Rewardable Subscribers
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
›
⌄
-- forked from Helium Mobile - New Rewardable Subscribers @ https://flipsidecrypto.xyz/studio/queries/6945491f-dc50-4ea8-affc-d61f14ad1d8e
-- forked from marqu / Helium New Subscribers - testing 1 @ https://flipsidecrypto.xyz/marqu/q/0F8pLW21XcpV/helium-new-subscribers---testing-1
WITH daily_tx_counts AS (
SELECT
block_timestamp::date AS tx_date,
COUNT(tx_id) AS tx_count_per_day
FROM solana.core.fact_events
WHERE succeeded
AND program_id = 'memMa1HG4odAFmUbGWfPwS1WWfK95k99F2YTkGvyxZr'
AND instruction:accounts[4] = '5S4n56zJZdqBQ5aNP6wJmqHBsHzWTnj1mvhL9N55zBgV'
AND instruction:accounts[13] = '9YgvHbCTrRCvBd6ZEMsMAFBmk2SkWkySdYPK98y34F9S'
AND instruction:accounts[17] = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
GROUP BY block_timestamp::date
)
SELECT
tx_date,
tx_count_per_day,
SUM(tx_count_per_day) OVER (
ORDER BY tx_date
) AS cumulative_tx_count
FROM daily_tx_counts
ORDER BY tx_date
LIMIT 1000000;
Last run: 8 days ago
...
610
23KB
20s