MostlyData_Rewards data by epoch C1
    Updated 2025-01-28
    -- forked from JitoMEV data by epoch @ https://flipsidecrypto.xyz/studio/queries/82973245-7881-4a00-a7b3-bd85278668aa

    /*
    This query decode MEV payment via Jito client following the schema described here

    https://jito-foundation.gitbook.io/mev/mev-payment-and-distribution/tip-distribution-program

    tracking the tip distribution program that is responsible for collecting and distributing MEV
    */
    with jito_tip_dist_program as(
    /*
    Tracking initializeTipDistributionAccount.
    See https://solscan.io/tx/64sBnPEsqNGZuqv7AT8GDxWHnNb5L4hSMRZnrdrX1XQJxS9FS9SpgnuApLTFheEXWNnzYQfyVzc7jn4XAGwLWAJr
    */
    select
    distinct ep.epoch,
    'Chorus One' as validator,
    instruction['parsed']['info']['newAccount'] as TipDistributionAccount

    from solana.core.fact_events_inner ei
    inner join solana.gov.dim_epoch ep on (ep.start_block <= ei.block_id and ei.block_id <= ep.end_block)

    where
    signers[0] = 'ChorusmmK7i1AxXeiTtQgQZhQNiXYU84ULeaYF1EH15n'
    and instruction_program_id = '4R3gSG8BpU4t19KYj8CfnbtRpnT8gtk4dvTHxVRwc2r7'
    and event_type = 'createAccount'
    and (
    (
    '{{n_days}}' = 0
    and block_timestamp >= cast('{{start_date}}' as timestamp)
    and block_timestamp <= cast('{{end_date}}' as timestamp)
    )
    or
    (
    '{{n_days}}' != 0
    Last run: 3 months ago
    EPOCH
    VALIDATOR
    ACTIVE_STAKE
    STAKING_REWARDS
    GROSSAPY
    NETAPY
    TOTAL_JITO_TIPS
    JITOPAYMENT2LEADER
    JITOPAYMENT2DELEGATORS
    COMMISSION
    1
    721Chorus One1052753.4186546387.4349374547.2536858896.716375823156.90000738678.44897361378.45103377350
    2
    723Chorus One1000811.80965845367.1943678587.2315303646.695861448180.88938825590.44366404790.44572420850
    3
    726Chorus One986294.846971904360.6773244827.2077331516.673826992137.90323679168.95058831568.95264847650
    4
    728Chorus One891798.245283731326.411920057.2141641666.679781635324.503763446162.250851643162.25291180350
    5
    720Chorus One1052651.31871972387.2007476097.2500044416.712967075115.29756307857.64775145957.64981161950
    6
    725Chorus One986001.693981714361.1549898217.2194245646.684652374148.83278257374.41536120674.41742136750
    7
    724Chorus One985565.906731571360.676183947.2130412966.678741941167.35693712183.6774384883.67949864150
    8
    729Chorus One892106.330971098327.9354923617.245334256.708642824503.157196447251.577568143251.57962830450
    9
    730Chorus One813866.571569614303.7806603037.356877686.811923777228.0593744250228.0593744250
    10
    727Chorus One987677.563054448361.9679634737.2233984326.688331881183.3238548491.6608973491.662957550
    11
    719Chorus One1052286.54742872386.6986653027.2431133066.706586394111.52397314455.76095649255.76301665250
    12
    722Chorus One1053150.32782853387.6016482117.2540721726.716733493129.08397956664.54095970364.54301986350
    12
    1KB
    257s