flipside

    Base_ez_5 copy copy
    jackguyBase_ez_5 copy copy
    Updated 2023-09-29



    SELECT
    avg(active_days),
    median(active_days)

    FROM (
    SELECT
    from_address,
    count(DISTINCT tx_hash) as events,
    count(DISTINCT date_trunc('day', block_timestamp)) as active_days
    FROM base.core.fact_transactions
    GROUP BY 1
    )




    Run a query to Download Data