zakkisyedLil Noun #3 Voting tx_hash & their gas
    Updated 2022-06-18
    --voting txns & gas used

    select T1.TX_HASH, T2.gas_used, T2.gas_price, T2.gas_limit, T2.tx_fee, T2.cumulative_gas_used, T2.block_timestamp

    from

    (

    select *
    from ethereum.core.fact_event_logs
    where contract_address = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
    and event_name = 'VoteCast'
    ) as T1

    INNER JOIN ethereum.core.fact_transactions as T2
    ON T1.TX_HASH=T2.TX_HASH



    --NFT_ADDRESS = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'

    Run a query to Download Data