flipside

    Base daily TX Count 2
    h4wkBase daily TX Count 2
    Updated 2024-01-29
    -- forked from Base daily TX Count by Event @ https://flipsidecrypto.xyz/edit/queries/ad4ce380-463d-4971-be3d-8c78821cff83

    select block_timestamp::date as date,
    count(distinct tx_hash) as tx_count,
    count(distinct from_address) as address_count,
    sum(tx_count) over (order by date) as cumu_tx,
    sum(address_count) over (order by date) as cumu_address
    from base.core.fact_transactions
    where date >= '2023-07-13' and date < CURRENT_DATE
    and status = 'SUCCESS'
    group by 1


    Last run: over 1 year agoAuto-refreshes every 3 hours
    DATE
    TX_COUNT
    ADDRESS_COUNT
    CUMU_TX
    CUMU_ADDRESS
    1
    		2024-01-06 00:00:00.000330429631566541531311294143
    2
    		2023-07-24 00:00:00.00061121440875165680317
    3
    		2023-07-15 00:00:00.000770511766018213124542
    4
    		2023-09-23 00:00:00.00049487470531283067424492536
    5
    		2023-09-21 00:00:00.00047040862708272144724354461
    6
    		2023-08-25 00:00:00.00055695298096144858692468205
    7
    		2023-11-20 00:00:00.00029580851300514681408597720
    8
    		2024-01-15 00:00:00.000315417708676829621211865595
    9
    		2023-12-02 00:00:00.00029793279629548317149272066
    10
    		2023-12-05 00:00:00.00024998048515555994229441061
    11
    		2023-11-10 00:00:00.00022088845703487181848066065
    12
    		2023-11-24 00:00:00.00028420453671526355668813003
    13
    		2023-12-22 00:00:00.000335268622386016145310309573
    14
    		2023-11-28 00:00:00.00024717148272537848539037146
    15
    		2024-01-19 00:00:00.000311347730986945911612127584
    16
    		2023-09-15 00:00:00.00065245769435231333763946259
    17
    		2023-10-15 00:00:00.000460801133948400172796139486
    18
    		2023-08-16 00:00:00.0004353777554789830001511143
    19
    		2023-12-04 00:00:00.00023823253375553494429392546
    20
    		2023-12-30 00:00:00.000388986694396293153710837943
    ...
    200
    11KB
    12s