MLDZMNVoting performance vs gas price
    Updated 2022-06-18
    with tb1 as (select
    BLOCK_TIMESTAMP::date as day,
    count(distinct EVENT_INPUTS:voter) as voter_number
    from ethereum.core.fact_event_logs
    where EVENT_NAME='VoteCast'
    and CONTRACT_ADDRESS='0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
    group by 1),
    tb2 as (select
    BLOCK_TIMESTAMP::date as day,
    avg(GAS_PRICE) as gs
    from ethereum.core.fact_transactions
    where BLOCK_TIMESTAMP>='2022-05-22'
    group by 1 order by 1)

    select tb1.day as day,
    voter_number,
    gs
    from tb1 join tb2 on tb1.day=tb2.day
    Run a query to Download Data