greyswanNFT-SWAPPERS volumes
    Updated 2023-03-07
    with
    unique_NFT_users as (
    select distinct
    date_trunc('month', block_timestamp) as NFT_month,
    seller as seller_purchaser
    from
    solana.core.fact_nft_sales
    where
    block_timestamp >= '2022-03-01'
    and block_timestamp <= '2023-02-28'
    UNION
    select distinct
    date_trunc('month', block_timestamp) as NFT_month,
    purchaser
    from
    solana.core.fact_nft_sales
    where
    block_timestamp >= '2022-03-01'
    and block_timestamp <= '2023-02-28'
    ),
    swaps_by_NFTs as (
    select
    tx_id,
    swapper,
    date_trunc('month', block_timestamp) as swap_month,
    swap_from_mint,
    swap_to_mint,
    swap_program,
    swap_from_amount,
    swap_to_amount
    from
    unique_NFT_users
    left join solana.core.fact_swaps on seller_purchaser = swapper
    and NFT_month = date_trunc('month', block_timestamp)
    where
    succeeded = 'true'
    Run a query to Download Data