flipside

    2024-04-05 07:28 PM
    AnalyticSages2024-04-05 07:28 PM
    Updated 2024-04-05
    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 ASC
    LIMIT 1000
    QueryRunArchived: QueryRun has been archived