LittlerDataWhen did they arrive
    Updated 2022-08-28
    with voters as(
    select
    lower(voter) as voter,
    count(proposal_id)
    from ethereum.core.ez_snapshot
    where proposal_id in ('0x276aeadbc8c68117dc677e6db275891281384e0dfe7c90d5b149389aa60eab32','QmfLwPbo5UwnyvkXo7emsSMDMFCr8UtJ76n87v9Rf7gEuH',
    '0xd2145fbd7da19d3247e7b40d45cbea71bd8b6e1a860b6f3b1630f33e9587f585','0x4099606ae52125cc0f581dd0f7b0a4af6e0cf59527ac5a6fae9ab36fa1f8caf8',
    '0x43ac378552db2eadf4ff031dd728c524cee09be64f3e9eed0e23810160860237')
    group by voter),

    dos as (
    select
    from_address,
    min(block_timestamp)::date as day
    from ethereum.core.fact_transactions
    where from_address in (select voter from voters)
    group by 1
    )

    select
    day,
    count(from_address)
    from dos
    group by 1



    -- 0xaf3a6d69c62a7ff323da5958a515c5bd4efdfbcc29ba644e845cc66dbef9958c -> dunjia.eth -> Are you a robot?
    -- 0xa9f1f8782ab83b1e3af941d12c491b2e44e70d7add4e701125c773d34e50020d -> birdspath.eth -> Are you a robot?
    -- 0x471d496bf06f7444046d9fc532b01bffe1eb5aa942f68588e7c8f55f9a47aed9 -> alwayslovedaisy.eth - > Are you a robot?
    -- 0x214d406dc0b5f29527cac5b2d4217697c910c7d368321a825e01f67d89f0eca4 -> hodlbeer.eth - >
    -- 0x276aeadbc8c68117dc677e6db275891281384e0dfe7c90d5b149389aa60eab32 -> thegurudao - > [Proposal] What option will bots prefer?
    -- QmfLwPbo5UwnyvkXo7emsSMDMFCr8UtJ76n87v9Rf7gEuH -> ens.eth -> What option will bots prefer?
    -- 0x499aec6c39586a76a374e0019896b9865e171a6e0ff1ce8907ecc736a6e944af -> arrebol.eth -> What option will bots prefer?
    --0x62bf3aa1c67d73ff85d363975d2aa4ff1f9f04cf743e2f4d35b7b3a0bb2206d4 -> 0xb777.eth -> What option will bots prefer?
    -- 0x9afb8c5524e7488f59ae73b349079b93d17c884d0255c3ace7b4d1f2a86731c1 -> wrapbitcoin.eth ->[Proposal] What option will bots prefer?
    Run a query to Download Data