encryptedCost per voting transactions?
Updated 2022-06-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
--select * from ethereum.core.fact_event_logs where block_number = 14887882 and tx_hash = '0x783d64b2146de10f7545e1053a6fa58d2846ee78fb5dc30ed635182ac5313e9b'
with
allvote as (select block_timestamp, event_inputs:voter as voter, tx_hash from ethereum.core.fact_event_logs where contract_address ='0x5d2c31ce16924c2a71d317e5bbfd5ce387854039' and event_name='VoteCast' and tx_status='SUCCESS' order by 1 asc ),
--transaction details
txd as (select tx_hash, gas_price/pow(10,9) as gasprice, gas_used, gasprice*gas_used as gas_paid, tx_fee, gas_paid+tx_fee as total from ethereum.core.fact_transactions where tx_hash in (select tx_hash from allvote) )
select
LPAD(min(total),8,0) as "Min cost per vote transaction" ,
LPAD(max(total),8,0) as "Max cost per vote transaction" ,
LPAD(avg(total),8,0) as "Average cost per vote transaction"
from txd inner join allvote on allvote.tx_hash=txd.tx_hash
Run a query to Download Data