Query editor
-- xStock DEX volume on Solana, monthly, June 2025 through June 2026-- Universe: Backed xStocks Solana canonical mints (issuer list, api.backed.fi 2026-06-23).-- 165 tokens. Ready to run on Dune (DuneSQL / Trino).WITH params AS (SELECTDATE '2025-06-01' AS start_date, -- xStocks launched 30 Jun 2025DATE '2026-06-30' AS end_date),xstocks_solana AS (SELECT mint, symbolFROM (VALUES('AAPLx', 'XsbEhLAtcf6HdfpFZ5xEMdqW8nfAvcsP5bdudRLJzJp'),('ABBVx', 'XswbinNKyPmzTa5CskMbCPvMW6G5CMnZXZEeQSSQoie'),('ABTx', 'XsHtf5RpxsQ7jeJ9ivNewouZKJHbPxhPoEy6yYvULr7'),('ACNx', 'Xs5UJzmCRQ8DWZjskExdSQDnbE6iLkRu2jjrRAB1JSU'),('ADBEx', 'XsDZMGEU8zadWFCkTtPBoPWYcUX3JHVmghnwf2Mve2q'),('AMATx', 'XsQZdaWUAGC4R3fgD2N1fupKvJfJq6YM51ccnsLUWFA'),('AMBRx', 'XsaQTCgebC2KPbf27KUhdv5JFvHhQ4GDAPURwrEhAzb'),('AMDx', 'XsXcJ6GZ9kVnjqGsjBnktRcuwMBmvKWh8S93RefZ1rF'),('AMZNx', 'Xs3eBt7uRfJX8QUs4suhyU8p2M6DoUDrJyWBa8LLZsg'),('ANETx', 'XsrsM2RgtYxXqxmy4iWgxQJUkkHG1U5wzi74sVNUW8m'),('APLDx', 'Xs2ZEuDVSQkNnXHqfqEYKVShLHpecyKfdfpEYwiHtQE'),('APPx', 'XsPdAVBi8Zc1xvv53k4JcMrQaEDTgkGqKYeh7AYgPHV'),('ASMLx', 'XshuHQ6o6SVpUNawvnnTMxsZ4tacZsNgVCLorv7TkFq'),('ASTSx', 'XsR4LAtaBgTKTRUhiijY1ba13nx4bepeEcag2Pr4dZ1'),('AVGOx', 'XsgSaSvNSqLTtFuyWPBhK9196Xb9Bbdyjj4fH3cPJGo'),('AZNx', 'Xs3ZFkPYT2BN7qBMqf1j1bfTeTm1rFzEFSsQ1z3wAKU'),('BACx', 'XswsQk4duEQmCbGzfqUUWYmi7pV7xpJ9eEmLHXCaEQP'),('BITXx', 'XsraCsjDB8cYn672MZSxCzZBhrodEPXD7pWd5EiRUhm'),('BMNRx', 'XsrBCwaH8c46xiqXBChzobgufRKxQxAWUWbndgBNzFn'),('BRK.Bx', 'Xs6B6zawENwAbWVi7w92rjazLuAr5Az59qgWKcNb45x'),('BTBTx', 'XsPLBFy59Q3hY59KLAJur8QyvziMF4xUxGTxXqXE7cT'),('BTGOx', 'XsvHMmbDcd14DHHW16PkxPGW7ks77ehxUv1E9Zmxgj4'),('CEGx', 'Xssu2cDLdZXZYrq17frTVrb3meumRCAzEf7pXyxoWVN'),('CLSKx', 'Xsn3H7ACEpSF2ULxeiD6kW4jRZXpurh8ZPttyfoS56W'),('CMCSAx', 'XsvKCaNsxg2GN8jjUmq71qukMJr7Q1c5R2Mk9P8kcS8'),('COINx', 'Xs7ZdzSHLU9ftNJsii5fCeJhoRWSC32SQGzGQtePxNu'),('COPXx', 'XsybfiKkD4UmjkAGT2uR8X2sq9AWFtvGJM2KTffoALZ'),('CORZx', 'XsBGEXxbBcuu8Nrokj14G8v4ezT3JYWWLneTzXK8t6Z'),('CRCLx', 'XsueG8BtpquVJX9LVLLEGuViXUungE6WmK5YZ3p3bd1'),('CRMx', 'XsczbcQ3zfcgAEt9qHQES8pxKAVG5rujPSHQEXi4kaN'),('CRWDx', 'Xs7xXqkcK7K8urEqGg52SECi79dRp2cEKKuYjUePYDw'),('CSCOx', 'Xsr3pdLQyXvDJBFgpR5nexCEZwXvigb8wbPYp4YoNFf'),('CVXx', 'XsNNMt7WTNA2sV3jrb1NNfNgapxRF5i4i6GcnTRRHts'),('DAXx', 'XsKbKZ6e1BtERDn2cF11WkpVwvzSWCrf83AMafgnMQT'),('DELLx', 'Xsu7Tc5J2fVUE4H5vYAiSr34cvLJeCsYPMjAYnayQn6'),('DFDVx', 'Xs2yquAgsHByNzx68WJC55WHjHBvG9JsMB7CWjTLyPy'),('DHRx', 'Xseo8tgCZfkHxWS9xbFYeKFyMSbWEvZGFV1Gh53GtCV'),('ENHAx', 'XsGAnis8BY5TLxEGdPY1LeeqY1DHPcUkkBQWRyQaJya'),('ETNx', 'Xs8S5L4HkJpeBWF1J4oyUX6rVwGHmG7GZ7PiChPt7nY'),('EWGx', 'XsM51PKxDNQBZR65VRxRjNqcMWUBoYwHeVn2FR6WXi9'),('EWQx', 'Xs1neEMHNaDDSHqE9nvDGkmuX73ZASKcLtQqwmVAQde'),('EWUx', 'XsbWCMXPzLdZMLpPtiiWE7M99fySmsnK5eFCWGWfDQ8'),('EWYx', 'XswenHXJtDWYMh89uRYx2tZcABxwXSn7j3jidDPS1Yo'),('FAAAx', 'Xs8rb8QG9mEuQ41g2cUzuJLZt3xEPQFhvgb9s4obXSn'),('FEZx', 'XsbZDdYJKxEBQASz4KBj23NRgymXw2NK6mbNQ6PYhC7'),('FGDLx', 'XspurdrAqbRJMQfAUEfh88QxE3XbSWxQGu3GneJR6e3'),('FLBLx', 'XsCZJYnCmjs5cYZDMLVxVzvMy5AK2oqsWpobS6SYno8'),('FLQMx', 'XsZdwvwEAn7KH8bCCo8AkxJmSm4MbaRxcDeh9Gt2VTF'),