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

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

sum (-1 * (post_tx_staked_balance - pre_tx_staked_balance) / pow (10, 9)) "Total Amount",

("Transaction Number" / "Stakers Number") "Tx per User",

("Total Amount" / "Stakers Number") "Amount per User",

avg (-1 * (post_tx_staked_balance - pre_tx_staked_balance) / pow (10, 9)) "Amount (AVG)"

from solana.core.ez_staking_lp_actions

where 1 = 1

and node_pubkey != ''

and succeeded = 'TRUE'

and block_timestamp::date >= current_date - interval '1 week'

and event_type in ('undelegate','withdraw')

group by "Validator"

order by "Total Amount" desc

limit 20