flipside

    flow stats: txs (over time) weekly
    adriaparcerisasflow stats: txs (over time) weekly
    Updated 18 hours ago

    with txs as (
    select distinct tx_id, block_timestamp, tx_succeeded
    from flow.core.fact_transactions
    UNION
    select distinct tx_hash as tx_id, block_timestamp, tx_succeeded
    from flow.core_evm.fact_transactions
    )
    SELECT
    trunc(block_timestamp,'week') as month,
    case when tx_succeeded='true' then 'Succeeded' else 'Failed' end as type,
    count(distinct tx_id) as total_transactions
    from txs
    where month<trunc(current_date,'week')
    group by 1,2
    order by 1 asc
    Last run: about 18 hours ago
    MONTH
    TYPE
    TOTAL_TRANSACTIONS
    1
    		2020-08-17 00:00:00.000Succeeded6275
    2
    		2020-08-17 00:00:00.000Failed5078
    3
    		2020-08-24 00:00:00.000Failed725
    4
    		2020-08-24 00:00:00.000Succeeded10036
    5
    		2020-08-31 00:00:00.000Failed106
    6
    		2020-08-31 00:00:00.000Succeeded11865
    7
    		2020-09-07 00:00:00.000Failed77
    8
    		2020-09-07 00:00:00.000Succeeded13996
    9
    		2020-09-14 00:00:00.000Succeeded11274
    10
    		2020-09-14 00:00:00.000Failed111
    11
    		2020-09-21 00:00:00.000Succeeded10427
    12
    		2020-09-21 00:00:00.000Failed1508
    13
    		2020-09-28 00:00:00.000Failed2041
    14
    		2020-09-28 00:00:00.000Succeeded32039
    15
    		2020-10-05 00:00:00.000Failed944
    16
    		2020-10-05 00:00:00.000Succeeded28480
    17
    		2020-10-12 00:00:00.000Failed21503
    18
    		2020-10-12 00:00:00.000Succeeded22787
    19
    		2020-10-19 00:00:00.000Failed1911
    20
    		2020-10-19 00:00:00.000Succeeded58945
    ...
    490
    22KB
    246s