flipside

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