SELECT date_trunc('day', block_timestamp) as date,
count(DECODED_LOG:provider) as n_stake,
sum(DECODED_LOG:value)/pow(10,18) as staked_STG,
staked_STG/n_stake as avg_stake
FROM ethereum.core.ez_decoded_event_logs
WHERE event_name = 'Deposit'
AND contract_address = '0x0e42acbd23faee03249daff896b78d7e79fbd58e'
GROUP BY date