potmoC2 sign-ups-by-segment
    Updated 2023-04-06
    -- forked from C2 Segment totals @ https://flipsidecrypto.xyz/edit/queries/26709f60-e068-4a3b-9ffb-ff72d3d6e52a
    select count(*) as "Total cohort 2 signups"
    from (
    select
    week,
    count(*) as total
    from
    (
    select
    case
    when tokenid = 0 then 'Segment 1'
    when tokenid = 1 then 'Segment 2'
    when tokenid = 2 then 'Segment 3'
    when tokenid = 3 then 'Segment 4'
    when tokenid = 5 then 'Segment 5'
    when tokenid = 6 then 'Graduate'
    end as week
    from
    polygon.core.ez_nft_transfers
    where
    nft_address = lower('0x74539714796C0FACc5EA32fB180F7cb04c71e97f')
    and event_type = 'mint'
    and erc1155_value = 1
    and tokenid <= 6
    and tokenid != 4
    )
    group by
    1
    order by
    2 desc


    Run a query to Download Data