flipside

    2016 Halving: Active Users
    dannyamah2016 Halving: Active Users
    Updated 2024-05-21
    select
    date_trunc('day', block_timestamp) as date,
    count(DISTINCT pubkey_script_address) AS "Active Users"
    from
    bitcoin.core.fact_inputs
    where
    date between ('2016-07-9'::date) and ('2016-07-9'::date + 365)
    group by 1
    order by 1
    QueryRunArchived: QueryRun has been archived