flyingfishFactura fees in gwei
Updated 2022-09-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
⌄
/* with mints as (
SELECT tx_hash, block_number, block_timestamp, tokenid::int as token_id, tx_fee
FROM ethereum.core.ez_nft_mints
WHERE nft_address = '0x27787755137863bb7f2387ed34942543c9f24efe'
ORDER BY token_id ASC
),
tx AS (
SELECT tx_hash, gas_limit, gas_price, gas_used, tx_fee
FROM ethereum.core.fact_transactions
WHERE tx_hash IN (SELECT tx_hash FROM mints)
)
SELECT mints.tx_hash,
mints.token_id,
mints.tx_fee,
tx.gas_price
FROM mints
JOIN tx on tx.tx_hash = mints.tx_hash */
SELECT a.tx_hash, a.block_number, a.block_timestamp, a.tokenid::int as token_id, a.tx_fee, b.gas_price
FROM ethereum.core.ez_nft_mints a
LEFT JOIN ethereum.core.fact_transactions b
ON a.tx_hash = b.tx_hash
WHERE a.block_timestamp > '2022-07-14' AND nft_address = '0x27787755137863bb7f2387ed34942543c9f24efe'
ORDER BY token_id ASC
Run a query to Download Data