rajsSolana Swaps First Tx
    Updated 2022-07-20
    SELECT
    first_month,
    count(distinct swapper) as no_of_users
    FROM
    (
    SELECT
    swapper,
    count(*) as no_of_swaps,
    date_trunc('month', min(block_timestamp)) as first_month
    from solana.core.fact_swaps
    where swapper IN
    (
    SELECT
    purchaser
    from solana.core.fact_nft_sales
    where mint IN
    (
    SELECT
    address
    from solana.core.dim_labels
    where address_name = 'communi3: mad scientists'
    )
    )
    -- and block_timestamp < '2022-05-05'
    group by 1
    )
    group by 1
    order by 1
    Run a query to Download Data