par_rndust token
    Updated 2022-12-02
    select
    (block_timestamp::date) as date,
    count(tx_id) as number_of_swaps,
    sum(SWAP_TO_AMOUNT) as sum_swap_amount
    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