mattkstewActive Wallets Flow 5
    Updated 2022-06-16
    with m1 as (
    SELECT
    date_trunc('day', block_timestamp) as day,
    proposer,
    count(*) as count1
    FROM flow.core.fact_transactions
    GROUP BY 1,2
    )
    , m2 as (
    SELECT
    proposer,
    avg(count1) as avg_total_transactions
    FROM m1
    GROUP BY 1
    )
    SELECT
    CASE WHEN avg_total_transactions > 75 then 'Non Real User' ELSE 'Real User' END,
    count(*)
    FROM m2
    GROUP BY 1
    Run a query to Download Data