flipside

    tired-coffee
    Pine Analyticstired-coffee
    Updated 2024-12-18
    select
    date,
    count(*) as new_wallets,
    sum(new_wallets) over (order by date) as total_wallets

    FROM (
    SELECT
    signers[0],
    date(min(block_timestamp)) as date

    FROM eclipse.core.fact_transactions
    GROUP BY 1
    )
    group by 1

    QueryRunArchived: QueryRun has been archived