Query editor
-- Dune query name: tokenized_stocks_backed_solana_snapshot_v1-- Description: Buccaneers-owned STATIC snapshot of Backed's Solana token-- universe + per-xStock mark price + per-deployment-- circulatingSupply. Inlined as VALUES because live HTTP_GET-- to Backed reliably times out Dune materialize.-- Circulating supply is Backed's own authoritative view of-- on-chain float (excludes their full custody/treasury/MM-- wallet set, not just the two named issuer wallets S7vYFF-- and HmMxm - trying to reconstruct that set from on-chain-- balance data alone leaves a ~3x overcount, so we trust-- Backed's figure).-- Data source: curl https://api.backed.fi/rest/tokens-- and: curl https://api.backed.fi/rest/token-statistics/last-day-- Snapshot generated: 2026-08-14-- Rows: 720 Solana deployments; 556 with price, 556 with circulating.---- TO REFRESH: run-- python3 ~/dev/tasks/xstocks/atlas_dash/scripts/refresh_backed_solana_snapshot.py---- Materialize as dune.buccaneers.result_tokenized_stocks_backed_solana_snapshot_v1-- Reference in tokenized_stocks_xstocks_solana_aum_daily_v1 (q8326152).WITH backed_snapshot (token_mint_address, symbol, underlying_ticker, backed_price_usd, backed_circulating_supply) AS (VALUES('XsxAd6okt8y1RRK6gNg7iJaqiWNiq5Md5EDf3ZrF2dm', 'SLVx', 'SLV', 58.325, 15831.90379417),('Xs3c2aZenyRQwXjki5MDxJEJ2km27ef2rWQMFWx7QKJ', 'GLXYx', 'GLXY', 20.85, 5297.41619257),('XsvHMmbDcd14DHHW16PkxPGW7ks77ehxUv1E9Zmxgj4', 'BTGOx', 'BTGO', 5.485, 21620.30112619),('XsDZMGEU8zadWFCkTtPBoPWYcUX3JHVmghnwf2Mve2q', 'ADBEx', 'ADBE', 269.855, 841.07926088),('XsybfiKkD4UmjkAGT2uR8X2sq9AWFtvGJM2KTffoALZ', 'COPXx', 'COPX', 85.43, 3725.5593701769762),('Xsz1UqWKSjB4X7zcvXV6XVL5eBA2YaRqEjXZVP6GXwZ', 'ATOx', 'ATO', 170.135, 0.02912),('Xs2yquAgsHByNzx68WJC55WHjHBvG9JsMB7CWjTLyPy', 'DFDVx', 'DFDV', 3.03, 163552.4124631444),('Xsa62P5mvPszXL1krVUnU5ar38bBSVcWAB6fmPCo5Zu', 'METAx', 'META', 594.75, 8504.533242914717),('XsGtpmjhmC8kyjVSWL4VicGu36ceq9u55PTgF8bhGv6', 'OPENx', 'OPEN', 3.665, 28641.734611552914),('XsaQGz41BEQkS9xAB44uvUtuXcdLJAXEU1dogEzWMZ8', 'STRKx', 'STRK', 66.515, 48.34639700862141),('XsGVi5eo1Dh2zUpic4qACcjuWGjNv8GCt3dm5XcX6Dn', 'JNJx', 'JNJ', 262.015, 1182.2750994972141),('XsnQnU7AdbRZYe2akqqpibDdXjkieGFfSkbkjX1Sd1X', 'MRKx', 'MRK', 134.89, 1781.5210933831545),('XsGAnis8BY5TLxEGdPY1LeeqY1DHPcUkkBQWRyQaJya', 'ENHAx', 'ENHA', 2.25, 40259.65027696),('Xsgc9YTqdAH1GzDLBGQcScCMgkKsVBn4hBmqtNRospY', 'ONDSx', 'ONDS', 9.235, 21581.3190254),('Xsbe4fwmjVQEWEPkzfyxqNdPUUK7X9dKfTJrZdDbNgx', 'TERx', 'TER', 410.5, 317.1785222201564),('Xs6B6zawENwAbWVi7w92rjazLuAr5Az59qgWKcNb45x', 'BRK.Bx', 'BRK.B', 507.59, 2880.77396937),('XsoBhf2ufR8fTyNSjqfU71DYGaE6Z3SUGAidpzriAA4', 'PLTRx', 'PLTR', 178.315, 10436.53715399),('XsLT5v4DAd1kwViPQh3SZiT5kzJfNLxzJxJN1dySZTe', 'VXUSx', 'VXUS', 87.5, 1166.5573391063253),('Xs3uhDYpQGfkeZ7rrzQgmozWQHC5uDLUa6iAN65qHM1', 'BANKCx', '3988', 0.673309, 0),('XsJb1p4Ks6VFggq68JyMz7S3kdRfkqh4wA6EMyxi4DD', 'OKLOx', 'OKLO', 46.635, 2894.800114),('XsSbcq8MZso4DLAMgtRKjzCvgozdh4sje8PLj45kxJZ', 'FSLRx', 'FSLR', 224.4625, 0.418624),('XsguBZPkM9BDmxspmWe29EmrYZBv21ENcC27Pqh7grB', 'MARAx', 'MARA', 9.205, 14960.74156325),('Xs6yCfUGbkjcvivWr4crLR7pJGxEXspsuuUMhxNEEUw', 'RCATx', 'RCAT', 10.765, 9116.60325175),('Xs31mE5EiqjSHEaiX9QDKCN6NvSGCqpJ6f1FNq2wri5', 'RIOTx', 'RIOT', 19.295, 4777.00528361),('XsJJneENiaBPqqcdK1gMsfwi9cbw111azigzRYHoctX', 'USARx', 'USAR', 18.7775, 17271.35713574),('Xs2ZEuDVSQkNnXHqfqEYKVShLHpecyKfdfpEYwiHtQE', 'APLDx', 'APLD', 30.83, 3854.71616503),('XsAiRejKuvLAdq9KtedrMSrabz7SWdzKoVK6Qgac1Ki', 'KRAQx', 'KRAQ', 9.96, 62224.59787958692),('9JMgSynsVkKrDvKCf21npkAW5oacp7XcVYHigNBvmwT7', 'bTSLA', 'TSLA', CAST(NULL AS DOUBLE), CAST(NULL AS DOUBLE)),('bG5CYb7Z48BfpZwhN6LqnyHYz8orvFwrufCjmc3RJHb', 'bGME', 'GME', CAST(NULL AS DOUBLE), CAST(NULL AS DOUBLE)),('XsAsZLF4MmsvS1sDxRMrUz7REjHfwbC9UAMXSRBqgEB', 'UBERx', 'UBER', 76.32, 2927.1274672),('Xsn3H7ACEpSF2ULxeiD6kW4jRZXpurh8ZPttyfoS56W', 'CLSKx', 'CLSK', 11.6, 10289.54153362),('XsBNz5UKYqcALjS5Xnm7HesMapyKLxkmfWPGHBek36x', 'USPXx', 'USPX', 83.075, 1216.9807087164015),('XsHtf5RpxsQ7jeJ9ivNewouZKJHbPxhPoEy6yYvULr7', 'ABTx', 'ABT', 111.67, 2343.0148038548914),('XsPHkGBbztHCCe1RMhiAs7CxVqoghmyd6zDUfrbfVWG', 'SLMTx', 'SLMT', 2.955, 0),('Xst6eFD4YT6sz9RLMysN9SyvaZWtraSdVJQGu5ZkAme', 'PPLTx', 'PPLT', 15.655, 10000.8387637),('XsfCC9VL4DamVGNgdJpfLXB3sBVa158Gbx8sh7NzmTk', 'VIDAx', 'VIDA', 2.75, 32158.03032125),