flipside

    flow stats: txs (over time) weekly copy
    messariflow stats: txs (over time) weekly copy
    Updated 3 days ago
    -- forked from adriaparcerisas / flow stats: txs (over time) weekly @ https://flipsidecrypto.xyz/adriaparcerisas/q/iNdF3ST8N50r/flow-stats-txs-over-time-weekly


    SELECT
    trunc(block_timestamp,'day') as day,
    case when tx_succeeded='true' then 'Succeeded' else 'Failed' end as type,
    count(*) as total_transactions
    from flow.core.fact_transactions x
    --where month<trunc(current_date,'week')
    group by 1,2
    order by 1 asc



    Last run: 3 days ago
    DAY
    TYPE
    TOTAL_TRANSACTIONS
    1
    		2020-08-18 00:00:00.000Succeeded10
    2
    		2020-08-18 00:00:00.000Failed5019
    3
    		2020-08-19 00:00:00.000Failed1
    4
    		2020-08-19 00:00:00.000Succeeded1127
    5
    		2020-08-20 00:00:00.000Failed21
    6
    		2020-08-20 00:00:00.000Succeeded1709
    7
    		2020-08-21 00:00:00.000Succeeded1342
    8
    		2020-08-21 00:00:00.000Failed16
    9
    		2020-08-22 00:00:00.000Succeeded1017
    10
    		2020-08-22 00:00:00.000Failed10
    11
    		2020-08-23 00:00:00.000Succeeded1070
    12
    		2020-08-23 00:00:00.000Failed11
    13
    		2020-08-24 00:00:00.000Failed6
    14
    		2020-08-24 00:00:00.000Succeeded1463
    15
    		2020-08-25 00:00:00.000Succeeded2638
    16
    		2020-08-25 00:00:00.000Failed8
    17
    		2020-08-26 00:00:00.000Failed205
    18
    		2020-08-26 00:00:00.000Succeeded1538
    19
    		2020-08-27 00:00:00.000Succeeded1737
    20
    		2020-08-27 00:00:00.000Failed467
    ...
    3405
    149KB
    11s