DATE | N_CONTRIBUTOR | |
|---|---|---|
1 | 2024-10-01 00:00:00.000 | 92009 |
2 | 2024-11-01 00:00:00.000 | 111881 |
3 | 2024-12-01 00:00:00.000 | 112260 |
4 | 2025-01-01 00:00:00.000 | 98960 |
5 | 2025-02-01 00:00:00.000 | 64658 |
6 | 2025-03-01 00:00:00.000 | 17422 |
ArioHelium Contributors
Updated 4 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
27
28
29
30
31
32
33
34
35
36
›
-- with dist_tx as (
-- select
-- tx_id
-- from
-- solana.core.fact_events
-- where
-- program_id = '1azyuavdMyvsivtNxPoz6SucD18eDHeXzFCUPq5XU7w'
-- and SUCCEEDED
-- and block_timestamp > '2024-10-01'
-- and substr(utils.udf_base58_to_hex(fact_events.instruction :data), 3, 16) = 'a030b8390569e947' -- distributeCompressionRewardsV0
-- )
-- select
-- date_trunc(month, block_timestamp) as date,
-- count(distinct tx_to) as N_Contributor,
-- lag(N_Contributor, 1, N_Contributor) over(order by date) as lag_1,
-- round((N_Contributor - lag_1) / lag_1 * 100, 2) as Growth
-- from
-- solana.core.fact_transfers
-- -- join dist_tx using(tx_id, block_id)
-- where
-- tx_id in (select tx_id from dist_tx)
-- and mint in (
-- 'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns',
-- 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6'
-- )
-- and block_timestamp > '2024-10-01'
-- group by
-- 1
Last run: 4 days ago
6
207B
944s