MLDZMNVoting performance vs gas price
Updated 2022-06-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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