flipside

    Polygon - failed and successful transactions ratio
    KARTODPolygon - failed and successful transactions ratio
    Updated 2023-09-16
    select
    date_trunc('day', BLOCK_TIMESTAMP) as hour,
    STATUS,
    count(distinct TX_HASH) tx_count
    from polygon.core.fact_transactions
    where BLOCK_TIMESTAMP >= DATE_TRUNC('day',CURRENT_DATE()) - interval '90 days'
    group by 1, 2

    Run a query to Download Data