DATE | PROJECT | N_CONTRIBUTOR | REWARDS_USD | REWARD_PER_CONTRIBUTOR | |
|---|---|---|---|---|---|
1 | 2024-11-01 00:00:00.000 | Nosana | 437 | 103651.65943156 | 237.189152017 |
2 | 2025-01-01 00:00:00.000 | Nosana | 599 | 59138.50113213 | 98.728716414 |
3 | 2024-10-01 00:00:00.000 | Nosana | 449 | 87725.38167188 | 195.379469202 |
4 | 2025-02-01 00:00:00.000 | Nosana | 1043 | 54223.376739702 | 51.987897162 |
5 | 2024-12-01 00:00:00.000 | Nosana | 756 | 69317.66965798 | 91.69003923 |
6 | 2025-03-01 00:00:00.000 | Nosana | 1236 | 50021.837398638 | 40.470742232 |
ArioNosana reward per contributor
Updated 2025-03-31
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
›
⌄
with tab as (
select
tx_id,
block_timestamp,
INSTRUCTION:accounts[8] as user_address
from solana.core.fact_events
where PROGRAM_ID = 'nosJhNRqr2bc9g1nfGDcXXTXvYUmxD4cVwy2pMWhrYM'
and SUCCEEDED
and substr(utils.udf_base58_to_hex(fact_events.instruction :data), 3, 16) = '434aaa847de9b625' -- finish
and block_timestamp >= '2024-10-01'
group by 1,2,3
)
select
date_trunc(month, fact_transfers.block_timestamp) as date,
'Nosana' as Project,
count(distinct user_address) as N_Contributor,
sum(amount * price) as rewards_USD,
rewards_USD / N_Contributor as reward_per_contributor
from solana.core.fact_transfers
join tab
on fact_transfers.block_timestamp = tab.block_timestamp
and fact_transfers.tx_to = tab.user_address
and fact_transfers.tx_id = tab.tx_id
join solana.price.ez_prices_hourly
on ez_prices_hourly.token_address = fact_transfers.mint
and date_trunc(hour, fact_transfers.block_timestamp) = ez_prices_hourly.hour
and ez_prices_hourly.token_address = 'nosXBVoaCTtYdLvKY6Csb4AC8JCdQKKAaWYtx2ZMoo7'
where fact_transfers.mint = 'nosXBVoaCTtYdLvKY6Csb4AC8JCdQKKAaWYtx2ZMoo7'
and fact_transfers.block_timestamp >= '2024-10-01'
group by 1,2
Last run: 17 days ago
6
421B
907s