flipside

    where $Dust swappers swapped their tokens?
    par_rnwhere $Dust swappers swapped their tokens?
    Updated 2022-12-02
    select
    SWAP_PROGRAM,
    count(tx_id) as number_of_swaps
    FROM solana.core.fact_swaps
    JOIN solana.core.dim_labels
    ON solana.core.fact_swaps.SWAP_TO_MINT = solana.core.dim_labels.ADDRESS
    WHERE SUCCEEDED
    and (swap_from_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ' or swap_to_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ')
    GROUP BY 1
    Run a query to Download Data