flipside

    daily new users entering flow
    arctic-night-foxdaily new users entering flow
    Updated 2022-07-20
    with base as (
    SELECT
    payer,
    min(block_timestamp::date) as first_tx_date
    from flow.core.fact_transactions
    group by 1)

    SELECT
    date_trunc('day', first_tx_date) as daily,
    COUNT(payer)
    FROM
    base

    GROUP BY daily
    ORDER BY daily
    Run a query to Download Data