kumbayaa2024-04-07 01:57 AM
    Updated 2024-04-07
    SELECT
    date_trunc('day',block_timestamp) AS date,
    tx_hash,
    to_address,
    tx_fee,
    status
    FROM ethereum.core.fact_transactions
    WHERE status = 'FAIL'
    --GROUP BY 1 2,
    ORDER BY 1 DESC
    LIMIT 100
    QueryRunArchived: QueryRun has been archived