petertherockPolygon hard fork new user copy
    Updated 2023-02-27
    -- forked from b8872ef3-6cbb-48b3-9022-64eedf7b1c2d

    select
    date(joined_date) as date,
    case
    when joined_date::date > '2023-01-17' then 'After Hard Fork'
    else 'Before Hard Fork'
    end as
    Type,
    count(from_address) as new_user
    from
    (
    select
    from_address,
    min(block_timestamp::date) as joined_date
    from polygon.core.fact_transactions
    where
    block_timestamp::date >= '2022-12-17'
    and block_timestamp::date < '2023-02-18'
    group by 1
    )
    group by 1,2


    Run a query to Download Data