octavionotpunkgas-fee-computation-0x
Updated 2024-03-15
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from gas-fee-computation-1inch @ https://flipsidecrypto.xyz/edit/queries/e9ac7a06-6104-4c01-adf8-5f05cf4386ea
-- forked from gas-fee-computation-jumper @ https://flipsidecrypto.xyz/edit/queries/c586f40b-26c0-4ec9-b3e9-1f6fc40d371d
with
chain_tx as (
SELECT
gas_price_paid as gas_price,
gas_limit,
gas_used,
tx_fee,
tx_hash, block_timestamp,
'arbitrum' as chain
FROM
arbitrum.core.fact_transactions
UNION
ALL
SELECT
gas_price,
gas_limit,
gas_used,
tx_fee,
tx_hash, block_timestamp,
'optimism' as chain
FROM
optimism.core.fact_transactions
UNION
ALL
SELECT
gas_price,
gas_limit,
gas_used,
tx_fee,
tx_hash, block_timestamp,
'bnb' as chain
QueryRunArchived: QueryRun has been archived