10Blockchaintest eth L1
    Updated 2025-02-21
    SELECT
    tx_hash,
    block_number,
    block_timestamp,
    gas_used,
    effective_gas_price,
    (gas_used * effective_gas_price) / 1e18 AS calculated_fee_eth
    FROM ethereum.core.fact_transactions
    WHERE tx_hash IN (
    '0xa0808c353f8af25ed266ba4e85486d4f9deadea342edf5ab93effbfe3223e352',
    '0x85375f9772806d9c3a7afb0ef527e93c1dcfc0de7b38b25c942a1cd602efac76'
    );

    Last run: 2 months ago
    TX_HASH
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    GAS_USED
    EFFECTIVE_GAS_PRICE
    CALCULATED_FEE_ETH
    1
    0x85375f9772806d9c3a7afb0ef527e93c1dcfc0de7b38b25c942a1cd602efac76218735442025-02-18 13:26:11.0002150731.3515395872.906796736e-13
    2
    0xa0808c353f8af25ed266ba4e85486d4f9deadea342edf5ab93effbfe3223e352218735422025-02-18 13:25:47.0001110311.3656567471.516302343e-13
    2
    283B
    3s