Query editor
with data as (select issuer,product, description,asset_type, underlying, last_price as price, balance as units, market_capfrom query_1833027 -- Backedunion allselect 'Mountain' as issuer, '📗USDM<a href="https://etherscan.io/token/0x59d9356e565ab3a36dd77763fc0d87feaf85508c" target="_blank">🔵</a>' as product, 'Mountain Protocol USD' as description,'Bonds' as asset_type, 'T-Bills' underlying, 1.0 as price, outstanding as units, outstanding as market_capfrom query_3050717 -- Mountain Ethereumwhere period = current_dateunion allselect 'Mountain' as issuer, '📗USDM<a href="https://arbiscan.com/token/0x59D9356E565Ab3A36dD77763Fc0d87fEaf85508C" target="_blank">🟣</a>' as product, 'Mountain Protocol USD' as description,'Bonds' as asset_type, 'T-Bills' underlying, 1.0 as price, outstanding as units, outstanding as market_capfrom query_3690450 -- Mountain Arbitrumwhere period = current_dateunion allselect 'Mountain' as issuer, '📗USDM<a href="https://polygonscan.com/token/0x59D9356E565Ab3A36dD77763Fc0d87fEaf85508C" target="_blank">🟣</a>' as product, 'Mountain Protocol USD' as description,'Bonds' as asset_type, 'T-Bills' underlying, 1.0 as price, outstanding as units, outstanding as market_capfrom query_3254302 -- Mountain Polygon PoSwhere period = current_dateunion allselect 'Mountain' as issuer, '📗USDM<a href="https://basescan.org/token/0x59D9356E565Ab3A36dD77763Fc0d87fEaf85508C" target="_blank">⚪</a>' as product, 'Mountain Protocol USD' as description,'Bonds' as asset_type, 'T-Bills' underlying, 1.0 as price, outstanding as units, outstanding as market_capfrom query_3298548 -- Mountain Basewhere period = current_dateunion allselect 'Ondo' as issuer,product, description, asset_type, underlying, price, outstanding as units, market_capfrom query_7688136-- query_1980700 -- OLD Ondounion allselect issuer, '📗USDY<a href="https://etherscan.io/token/0x96f6ef951840721adbf46ac996b59e0235cb985c" target="_blank">🔵</a>' as product, 'Ondo U.S. Dollar Yield' as description, 'Bonds' as asset_type, 'T-Bills' underlying, price, outstanding as units, market_capfrom query_3053455 -- Ondo USDYwhere period = current_dateunion allselect 'Swarm' as issuer,product, description, asset_type, underlying, price, outstanding as units, market_capfrom query_2039016 -- Swarmunion allselect 'Matrixdock' as issuer, '📗STBT<a href="https://etherscan.io/token/0x530824da86689c9c17cdc2871ff29b058345b44a" target="_blank">🔵</a>' as product,'Matrixdock Short-term Treasury Bill' as description, 'Bonds' as asset_type, 'T-Bills' underlying,1.0 as price,totalSupply as units,totalSupply as market_capfrom query_2742941 -- Matrixdockwhere day = (select max(day) from query_2742941)union allselect issuer, product, description, asset_type, underlying, price, outstanding as units, market_capfrom query_2414792 -- OpenEden - Products Summaryunion allselect issuer, product, description, asset_type, underlying, price, outstanding as units, market_capfrom query_2453275 -- TradFi Securities - Products SummaryUNION ALLSELECT issuer, product, description, asset_type, underlying, price, outstanding, market_capFROM query_3990371 -- Spiko - Products SummaryUNION ALLSELECT issuer, product, description, asset_type, underlying, price, outstanding, market_capFROM query_4004969 -- Superstate - Products SummaryUNION ALLSELECT issuer, product, description, asset_type, underlying, price, outstanding, market_capFROM query_4045616 -- Janus Henderson - Products SummaryUNION ALLSELECT issuer, product, description, asset_type, underlying, price, outstanding, market_capFROM query_5369120 -- Midas - Products Summary