pavlyshyn2023-04-04 11:41 AM
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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