KaskoazulTop10 swap pairs daily
Updated 2022-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
SELECT
block_timestamp::date as fecha,
CASE CONCAT (swap_from_mint, '-', swap_to_mint)
WHEN 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v-EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDC-USDC'
WHEN 'So11111111111111111111111111111111111111112-EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'wrappedSOL-USDC'
WHEN 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v-So11111111111111111111111111111111111111112' THEN 'USDC-wrappedSOL'
WHEN 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v-4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R' THEN 'USDC-RAY'
WHEN '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R-EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'RAY-USDC'
WHEN 'So11111111111111111111111111111111111111112-So11111111111111111111111111111111111111112' THEN 'wrappedSOL-wrappedSOL'
WHEN 'StepAscQoEioFxxWGnh2sLBDFp9d8rvKz2Yp39iDpyT-EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'STEP-USDC'
WHEN 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB-EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' THEN 'USDT-USDC'
WHEN 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v-StepAscQoEioFxxWGnh2sLBDFp9d8rvKz2Yp39iDpyT' THEN 'USDC-STEP'
WHEN 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v-Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB' THEN 'USDC-USDT'
ELSE 'Other Pair'
END AS PAIR,
count(tx_id)
FROM
solana.swaps
WHERE fecha >= '2022-02-01'
AND succeeded = 'True'
GROUP BY 1,2
ORDER BY 3 DESC
Run a query to Download Data