SELECT

trunc(block_timestamp::date,'day') AS date,

validator_Type,

count(TX_ID) as total_txs ,

sum (AMOUNT) as total_amounts ,

avg(AMOUNT) as avg_amounts

FROM

flow.core.ez_staking_actions t1 LEFT JOIN flow.core.dim_validator_labels t2

on t1.node_id = t2.node_id

WHERE

ACTION IN ('RewardTokensWithdrawn','DelegatorRewardTokensWithdrawn')

AND

TX_SUCCEEDED = 'true'

validator_Type IS NOT NULL

GROUP by 1,2

ORDER BY 2 DESC

SELECT

trunc(date,'week') AS date,

validator_Type ,

sum (total_amounts) as total_rewards

tbl

GROUP by 1,2

ORDER by 3 DESC