--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'