SELECT
date_trunc('day', block_timestamp) as day,
case when day >= '2022-08-05' then 'After Velodrome Exploit' else 'Before Velodrome Exploit' end as periods,
count(DISTINCT tx_hash) as events,
count(DISTINCT origin_from_address) as voters
FROM optimism.velodrome.ez_votes
GROUP BY 1