flipside

    All Contracts DAU on Blast
    sssstatisticAll Contracts DAU on Blast
    Updated 2025-05-09

    select
    to_char(BLOCK_TIMESTAMP, 'YYYY-MM-DD') as time,
    count(DISTINCT FROM_ADDRESS) AS Users,
    count(*) AS transactions
    from
    blast.core.fact_transactions fl
    where status = 'SUCCESS'
    AND BLOCK_TIMESTAMP < CURRENT_DATE
    GROUP by
    to_char(BLOCK_TIMESTAMP, 'YYYY-MM-DD')
    ORDER by time desc, Users DESC
    Last run: about 1 month ago
    TIME
    USERS
    TRANSACTIONS
    1
    		2025-04-033611402040
    2
    		2025-04-024354503201
    3
    		2025-04-014603459753
    4
    		2025-03-316302565145
    5
    		2025-03-305441547145
    6
    		2025-03-295202536720
    7
    		2025-03-285480541893
    8
    		2025-03-276069871824
    9
    		2025-03-264942596771
    10
    		2025-03-2520503613995
    11
    		2025-03-2417910649181
    12
    		2025-03-2368171008005
    13
    		2025-03-22262081042768
    14
    		2025-03-2199781001672
    15
    		2025-03-2018400442460
    16
    		2025-03-195138394941
    17
    		2025-03-184958369866
    18
    		2025-03-176608376781
    19
    		2025-03-165454409246
    20
    		2025-03-156842426368
    ...
    405
    11KB
    15s