validator_name "Validator",

count (distinct(tx_id)) "TXN Number",

count (distinct(signers[0])) "User Number",

sum ((post_tx_staked_balance - pre_tx_staked_balance) / power(10, 9)) "Total Amount",

("Total Amount" / "User Number") "Amount/User"

row_number() over(partition by "Date" order by "Total Amount" desc) "Rank"

from solana.core.ez_staking_lp_actions

where succeeded = true

and event_type in ('activate', 'delegate')

and block_timestamp >= current_date - interval '1 week'

group by "Date", "Validator"

qualify "Rank" <= 10

order by "Date", "Rank" asc