flipside

    Daily number of FLOW unique users
    DrsimonDaily number of FLOW unique users
    Updated 2022-07-19
    SELECT date_trunc('day', Block_timestamp) as FLOW_date,
    count(DISTINCT TX_ID) as FLOW_unique_user
    FROM flow.core.fact_transactions
    WHERE FLOW_date between '2022-06-01' and '2022-07-01'
    group by FLOW_date
    Run a query to Download Data