crypto_gosttroubled-yellow
Updated 2024-10-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE(block_timestamp) AS Swap_Date,
COUNT(DISTINCT tx_id) AS BNsoln_Swap,
COUNT(DISTINCT SWAPPER) AS bnsoln_Swapper,
SUM(SWAP_From_AMOUNT_usd) AS Swap_BNsol_Amount
FROM
solana.defi.ez_dex_swaps
WHERE
SWAP_from_MINT = 'BNso1VUJnh4zcfpZa6986Ea66P6TCp59hvtNJ8b1X85'
OR SWAP_to_MINT = 'BNso1VUJnh4zcfpZa6986Ea66P6TCp59hvtNJ8b1X85'
GROUP BY
Swap_Date
ORDER BY
Swap_BNsol_Amount DESC;
QueryRunArchived: QueryRun has been archived