flipside

    dau base
    adriaparcerisasdau base
    Updated 2024-01-30

    WITH
    daus as (
    SELECT
    distinct from_address as users,
    trunc(block_timestamp,'week') as weeks,
    count(distinct trunc(block_timestamp,'day')) as active_days
    from base.core.fact_transactions
    group by 1,2
    having active_days>=4
    ),
    active_users as (
    SELECT
    trunc(block_timestamp,'week') as date,
    case when from_address in (select users from daus) then 'DAU'
    else 'No DAU' end as type,
    count(distinct from_address) as n_users,
    count(distinct tx_hash) as txs
    from base.core.fact_transactions
    group by 1,2
    )
    select * from active_users
    where date>=current_date-interval '{{Months}} MONTHS'
    and date <current_date
    order by 1 asc




    Last run: about 1 year agoAuto-refreshes every 6 hours
    DATE
    TYPE
    N_USERS
    TXS
    1
    		2023-10-30 00:00:00.000No DAU211048664168
    2
    		2023-10-30 00:00:00.000DAU718641488173
    3
    		2023-11-06 00:00:00.000DAU692911334828
    4
    		2023-11-06 00:00:00.000No DAU189941530409
    5
    		2023-11-13 00:00:00.000DAU663321435894
    6
    		2023-11-13 00:00:00.000No DAU171820603609
    7
    		2023-11-20 00:00:00.000No DAU171570597881
    8
    		2023-11-20 00:00:00.000DAU690961598497
    9
    		2023-11-27 00:00:00.000DAU765541340475
    10
    		2023-11-27 00:00:00.000No DAU192767551248
    11
    		2023-12-04 00:00:00.000DAU625811310442
    12
    		2023-12-04 00:00:00.000No DAU192136545493
    13
    		2023-12-11 00:00:00.000No DAU195385578185
    14
    		2023-12-11 00:00:00.000DAU568851321216
    15
    		2023-12-18 00:00:00.000No DAU216127635604
    16
    		2023-12-18 00:00:00.000DAU664871485877
    17
    		2023-12-25 00:00:00.000No DAU241900845473
    18
    		2023-12-25 00:00:00.000DAU700701666971
    19
    		2024-01-01 00:00:00.000DAU703361540797
    20
    		2024-01-01 00:00:00.000No DAU209049859069
    28
    1KB
    159s