SELECT date_trunc('day', block_timestamp) as date,
action_type,
count(distinct tx_id) as n_txns,
count(distinct provider_address) as n_stakers,
sum(DEPOSIT_AMOUNT_USD) as deposited,
sum(MSOL_MINTED) as MSOL_MINTED,
sum(MSOL_BURNED) as MSOL_BURNED
FROM solana.marinade.ez_liquid_staking_actions
WHERE date_trunc('day', block_timestamp) >= '2025-01-01'
GROUP by 1,2