MahrooUntitled Query
Updated 2022-09-08
9
1
2
3
4
5
6
7
›
⌄
SELECT trunc(block_timestamp,'day') AS date, COUNT(distinct swapper) AS users, COUNT(distinct tx_id) AS swaps, SUM(swap_to_amount) AS volume
FROM solana.core.fact_swaps
WHERE succeeded = 'True'
AND swap_to_mint = 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'
AND swap_to_amount >0
GROUP BY 1
ORDER BY 1 ASC
Run a query to Download Data