MostlyData_C1 Fee per Epoch test
    Updated 2025-02-11
    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