MostlyData_C1 Fee per Epoch test
Updated 2025-02-11
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
›
⌄
with validators_pubkeys as (
select
column1 as pubkey
from values
('ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n')--, -- 'Chorus One'
--('{{pubkey}}')
)
,leader_fees_raw as(
select
rf.epoch_earned as epoch,
--rf.block_id,
rf.pubkey,
sum(rf.reward_amount_sol * pow(10,9)) * pow(10,-9) as block_fee
from solana.gov.fact_rewards_fee rf
inner join validators_pubkeys vpk on vpk.pubkey = rf.pubkey
where
epoch_earned = '{{epoch}}'
group by 1,2
)
select * from leader_fees_raw
--limit 100
QueryRunArchived: QueryRun has been archived