MLDZMNfirst received
    Updated 2022-06-24
    with tb1 as (select
    *
    from solana.core.fact_transactions
    where INSTRUCTIONS[0]:parsed:info:mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    and INSTRUCTIONS[1]:programId='781wH11JGQgEoBkBzuc8uoQLtp8KxeHk1yZiS1JhFYKy'
    and SUCCEEDED='TRUE'
    ),

    tb2 as (select
    TX_TO,
    min(BLOCK_TIMESTAMP) as first_received
    from solana.core.fact_transfers
    where TX_TO in (select signers[0] from tb1)
    group by 1)

    select
    case
    when first_received<='2021-06-01' then 'Before July 2021'
    when first_received between '2021-06-01' and '2022-01-01' then 'Between July 2021 and January 2022'
    when first_received>='2022-01-01' then 'In 2022'
    end as recieved_time,
    count(distinct TX_TO) as no_users
    from tb2
    group by 1 having recieved_time is not null
    Run a query to Download Data