TX_DATE | TX_COUNT_PER_DAY | RUNNING_TOTAL | |
|---|---|---|---|
1 | 2024-06-25 00:00:00.000 | 270 | 270 |
2 | 2024-06-26 00:00:00.000 | 793 | 1063 |
3 | 2024-06-27 00:00:00.000 | 810 | 1873 |
4 | 2024-06-28 00:00:00.000 | 821 | 2694 |
5 | 2024-06-29 00:00:00.000 | 815 | 3509 |
6 | 2024-06-30 00:00:00.000 | 814 | 4323 |
7 | 2024-07-01 00:00:00.000 | 803 | 5126 |
8 | 2024-07-02 00:00:00.000 | 776 | 5902 |
9 | 2024-07-03 00:00:00.000 | 818 | 6720 |
10 | 2024-07-04 00:00:00.000 | 822 | 7542 |
11 | 2024-07-05 00:00:00.000 | 822 | 8364 |
12 | 2024-07-06 00:00:00.000 | 784 | 9148 |
13 | 2024-07-07 00:00:00.000 | 823 | 9971 |
14 | 2024-07-08 00:00:00.000 | 813 | 10784 |
15 | 2024-07-09 00:00:00.000 | 779 | 11563 |
16 | 2024-07-10 00:00:00.000 | 823 | 12386 |
17 | 2024-07-11 00:00:00.000 | 823 | 13209 |
18 | 2024-07-12 00:00:00.000 | 682 | 13891 |
19 | 2024-07-13 00:00:00.000 | 808 | 14699 |
20 | 2024-07-14 00:00:00.000 | 789 | 15488 |
MetaLightHM Geese Daily
Updated 2025-03-12
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
block_timestamp::date AS tx_date,
COUNT(tx_id) AS tx_count_per_day,
SUM(COUNT(tx_id)) OVER (ORDER BY block_timestamp::date) AS running_total
FROM solana.core.fact_events
WHERE succeeded
AND program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY'
AND instruction:accounts[0] = 'x44bDE1D2kxBxmPfCjQ3RUGQbF7ccBP9HhYxWvsuU1b' -- Tree Authority
AND instruction:accounts[4] = '8LWKE6EiFBRsBSeHsZHqgCFaq3qxh9o1VpD6htK6mJV5' -- Payer
GROUP BY block_timestamp::date
ORDER BY tx_date
Last run: 22 days ago
90
3KB
119s