theericstoneNon-OP On-chain Voting (questionable)
    Updated 2022-10-06
    SELECT
    origin_from_address as address,
    count(distinct(contract_address)) as n_projects_voted,
    count(distinct(tx_hash)) as n_votes
    from optimism.core.fact_event_logs
    where block_timestamp > current_date - 90
    and lower(event_name) like any ('%vote%','%voting%')
    group by 1;
    Run a query to Download Data