count (distinct slot_number) as Slots_Count,

count (distinct pubkey) as Total_Validators,

sum (deposit_amount) as Deposit_Amountt,

avg (deposit_amount) as Average_Deposit_Amountt,

median (deposit_amount) as Median_Deposit_Amountt,

min (deposit_amount) as Minimum_Deposit_Amountt,

max (deposit_amount) as MaximumDeposit_Amountt

from ethereum.beacon_chain.fact_deposits where SLOT_TIMESTAMP::date< CURRENT_DATE