flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
What is the swap volume for each token on each DEX program?
gigiokoba
What is the swap volume for each token on each DEX program?
Updated 2024-07-02
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
SWAP_PROGRAM
,
SWAP_FROM_MINT
,
SUM
(
SWAP_FROM_AMOUNT
)
AS
Swap_Volume
FROM
solana
.
defi
.
fact_swaps
WHERE
SUCCEEDED
=
TRUE
AND
BLOCK_TIMESTAMP
BETWEEN
'2024-05-01'
AND
'2024-05-31'
GROUP
BY
SWAP_PROGRAM
,
SWAP_FROM_MINT
ORDER
BY
Swap_Volume
DESC
;
Results
QueryRunArchived: QueryRun has been archived