par_rndust token
Updated 2022-12-02
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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