thea[Uniswap NFT] Gas Total
    Updated 2022-12-20
    with final as (
    SELECT sales.*
    from ethereum.core.ez_nft_sales as sales
    JOIN
    (SELECT *
    from ethereum.core.fact_transactions
    where to_address = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b'
    and ORIGIN_FUNCTION_SIGNATURE = '0x24856bc3'
    and block_timestamp >= '2022-11-30'
    ) as uni
    on sales.tx_hash = uni.tx_hash
    )
    select sum(tx_fee) as gas,
    count(tx_hash) as txs,
    sum(tx_fee) / count(tx_hash) as gas_per_tx
    from (
    select distinct tx_hash, tx_fee
    from final
    ) as tmp
    Run a query to Download Data