Date_trunc('Day', Block_timestamp) AS Date,

COUNT(DISTINCT decoded_log:user) AS Total_Stakers,

COUNT(DISTINCT tx_hash) AS Transactions

avalanche.core.ez_decoded_event_logs

WHERE

tx_status = 'SUCCESS'

AND event_name = 'Submitted'

AND contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'

AND Date >= '2024-01-01'

GROUP BY 1