thea[Uniswap NFT] Gas Total
Updated 2022-12-20Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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