SocioCryptobalances
    Updated 2023-05-09


    SELECT avg(balance)/pow(10,18) as ETH_balance
    FROM
    (SELECT block_timestamp,
    origin_from_address
    FROM ethereum.core.fact_event_logs
    WHERE contract_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
    AND event_name = 'VoteCast'
    AND tx_status = 'SUCCESS'
    ) a
    LEFT JOIN ethereum.core.fact_eth_balances b
    ON date_trunc('day', a.block_timestamp) = date_trunc('day', b.block_timestamp) AND a.origin_from_address = b.user_address

    Run a query to Download Data