pavlyshyn2023-04-04 11:41 AM
    select
    Date, epoch, validator, sum(amount) as amount
    from (

    select
    toDate(block_time) as Date,
    toInt64(epoch) as epoch,
    vote_account as validator,
    toInt64(lamports)/pow(10,9) as amount

    from stage_solana_optimized.rewards
    where reward_type=voting)
    group by Date, epoch, validator
    Run a query to Download Data