\n CSCE 5320 · Homework 7 · Arranging tables\n

One stock table, rearranged

\n 30 U.S. large-cap stocks × 6 years\n (2020–2025), crawled from Yahoo Finance.\n Every view uses the same rows and the same marks;\n only the arrangement changes — order,\n alignment and axis shape.\n

\n \n

loading…

\n\n \n \n\n","us_stocks_hw7.csv","Ticker,Company,Sector,Year,Close_USD,Return_Pct,Volatility_Pct,Max_Drawdown_Pct,Volume_M_Shares,Dollar_Volume_B\nAAPL,Apple Inc.,Technology,2020,132.69,82.31,46.68,31.43,39863.86,3688.33\nAAPL,Apple Inc.,Technology,2021,177.57,34.65,25.09,18.6,22812.21,3210.34\nAAPL,Apple Inc.,Technology,2022,129.93,-26.4,35.63,30.35,22065.5,3410.54\nAAPL,Apple Inc.,Technology,2023,192.53,49.01,20.28,14.93,14805.89,2530.18\nAAPL,Apple Inc.,Technology,2024,250.42,30.71,22.6,15.35,14390.91,2945.41\nAAPL,Apple Inc.,Technology,2025,271.86,9.05,32.21,31.07,13543.94,3099.07\nABBV,AbbVie Inc.,Healthcare,2020,107.15,27.72,35.04,34.04,2390.71,213.04\nABBV,AbbVie Inc.,Healthcare,2021,135.4,32.43,20.26,11.91,1718.55,193.48\nABBV,AbbVie Inc.,Healthcare,2022,161.61,24.01,22.49,21.92,1623.06,240.78\nABBV,AbbVie Inc.,Healthcare,2023,154.97,-0.23,19.72,19.64,1375.88,203.16\nABBV,AbbVie Inc.,Healthcare,2024,177.7,18.86,24.26,19.07,1401.51,247.39\nABBV,AbbVie Inc.,Healthcare,2025,228.49,33.08,25.95,20.74,1570.49,316.71\nAVGO,Broadcom Inc.,Technology,2020,43.78,44.88,52.21,48.3,6180.34,187.53\nAVGO,Broadcom Inc.,Technology,2021,66.54,56.48,28.47,14.02,4750.42,236.28\nAVGO,Broadcom Inc.,Technology,2022,55.91,-13.27,37.26,34.84,5977.99,323.98\nAVGO,Broadcom Inc.,Technology,2023,111.62,104.18,31.65,11.93,6644.2,540.7\nAVGO,Broadcom Inc.,Technology,2024,231.84,110.49,52.56,25.25,7670.38,1200.52\nAVGO,Broadcom Inc.,Technology,2025,346.1,50.63,53.14,40.04,6680.08,1807.17\nBAC,Bank of America Corporation,Financials,2020,30.31,-11.63,58.44,48.95,17215.85,440.19\nBAC,Bank of America Corporation,Financials,2021,44.49,49.61,25.5,14.65,12206.34,488.48\nBAC,Bank of America Corporation,Financials,2022,33.12,-23.82,32.36,38.67,11684.14,440.04\nBAC,Bank of America Corporation,Financials,2023,33.67,4.83,26.84,29.97,12068.28,358.86\nBAC,Bank of America Corporation,Financials,2024,43.95,33.85,22.57,16.95,9539.75,372.28\nBAC,Bank of America Corporation,Financials,2025,55.0,28.04,27.07,27.51,9947.63,461.07\nBRK.B,Berkshire Hathaway Inc.,Financials,2020,231.87,2.37,34.95,29.57,1583.03,316.62\nBRK.B,Berkshire Hathaway Inc.,Financials,2021,299.0,28.95,15.4,6.79,1147.47,310.92\nBRK.B,Berkshire Hathaway Inc.,Financials,2022,308.9,3.31,22.51,26.58,1116.17,340.85\nBRK.B,Berkshire Hathaway Inc.,Financials,2023,356.66,15.46,13.64,10.46,837.93,279.58\nBRK.B,Berkshire Hathaway Inc.,Financials,2024,453.28,27.09,14.53,7.58,925.07,396.69\nBRK.B,Berkshire Hathaway Inc.,Financials,2025,502.65,10.89,18.78,14.95,1190.77,589.33\nCAT,Caterpillar Inc.,Industrials,2020,182.02,26.97,45.26,38.55,981.06,131.28\nCAT,Caterpillar Inc.,Industrials,2021,206.74,15.95,25.47,22.4,846.71,178.88\nCAT,Caterpillar Inc.,Industrials,2022,239.56,18.6,33.51,30.09,823.83,169.1\nCAT,Caterpillar Inc.,Industrials,2023,295.67,25.95,28.49,21.8,764.75,188.99\nCAT,Caterpillar Inc.,Industrials,2024,362.76,24.66,25.99,15.83,636.97,221.28\nCAT,Caterpillar Inc.,Industrials,2025,572.87,60.3,31.78,32.8,689.48,288.26\nCOP,ConocoPhillips,Energy,2020,39.99,-36.04,73.09,65.66,2416.75,95.57\nCOP,ConocoPhillips,Energy,2021,72.18,86.6,35.6,18.69,2289.02,133.15\nCOP,ConocoPhillips,Energy,2022,118.0,71.69,43.03,32.98,1962.48,201.98\nCOP,ConocoPhillips,Energy,2023,116.07,1.98,28.73,23.94,1447.86,159.83\nCOP,ConocoPhillips,Energy,2024,99.17,-12.17,22.59,27.28,1546.25,172.73\nCOP,ConocoPhillips,Energy,2025,93.61,-2.34,34.06,22.09,1895.63,177.3\nCOST,Costco Wholesale Corporation,Consumer Staples,2020,376.78,32.67,28.9,13.65,697.04,225.76\nCOST,Costco Wholesale Corporation,Consumer Staples,2021,567.7,51.82,18.86,17.92,564.71,233.55\nCOST,Costco Wholesale Corporation,Consumer Staples,2022,456.5,-19.05,31.74,31.4,623.97,316.09\nCOST,Costco Wholesale Corporation,Consumer Staples,2023,660.08,49.0,18.98,9.99,466.18,250.94\nCOST,Costco Wholesale Corporation,Consumer Staples,2024,916.27,39.62,18.95,10.27,489.45,402.34\nCOST,Costco Wholesale Corporation,Consumer Staples,2025,862.34,-5.39,21.68,20.74,582.75,554.88\nCVX,Chevron Corporation,Energy,2020,84.45,-25.95,61.79,54.83,2833.82,241.76\nCVX,Chevron Corporation,Energy,2021,117.35,46.24,24.51,13.36,2641.56,275.15\nCVX,Chevron Corporation,Energy,2022,179.49,58.46,32.92,24.95,2881.17,451.94\nCVX,Chevron Corporation,Energy,2023,149.16,-13.63,23.23,22.26,2161.94,343.93\nCVX,Chevron Corporation,Energy,2024,144.84,1.29,19.27,15.33,1966.21,300.12\nCVX,Chevron Corporation,Energy,2025,152.41,10.1,24.5,20.64,2193.01,330.31\nDE,Deere & Company,Industrials,2020,269.05,57.96,45.73,37.42,442.58,80.46\nDE,Deere & Company,Industrials,2021,342.89,28.86,29.73,16.7,432.17,150.92\nDE,Deere & Company,Industrials,2022,428.76,26.59,35.57,33.81,440.82,164.89\nDE,Deere & Company,Industrials,2023,399.87,-5.48,27.2,21.06,403.75,158.89\nDE,Deere & Company,Industrials,2024,423.7,7.56,23.47,16.38,359.03,140.2\nDE,Deere & Company,Industrials,2025,465.57,11.39,27.55,18.62,344.33,164.83\nGE,GE Aerospace,Industrials,2020,53.83,-2.73,63.31,58.24,4972.9,196.97\nGE,GE Aerospace,Industrials,2021,58.86,9.69,32.46,21.43,3409.33,216.72\nGE,GE Aerospace,Industrials,2022,52.2,-10.92,35.18,40.66,2614.37,130.67\nGE,GE Aerospace,Industrials,2023,101.86,95.71,24.09,9.39,1788.44,142.93\nGE,GE Aerospace,Industrials,2024,166.79,64.83,30.5,17.65,1534.36,234.35\nGE,GE Aerospace,Industrials,2025,308.03,85.73,30.44,21.36,1334.99,322.69\nHON,Honeywell International Inc.,Industrials,2020,210.25,22.97,45.22,43.01,889.44,140.85\nHON,Honeywell International Inc.,Industrials,2021,206.11,-0.29,19.02,14.31,691.05,148.57\nHON,Honeywell International Inc.,Industrials,2022,211.83,4.9,25.02,22.71,797.14,152.4\nHON,Honeywell International Inc.,Industrials,2023,207.29,0.02,18.36,17.41,705.74,136.46\nHON,Honeywell International Inc.,Industrials,2024,223.29,10.02,18.02,10.66,813.69,167.89\nHON,Honeywell International Inc.,Industrials,2025,204.6,-6.37,24.72,18.84,1026.98,216.6\nJNJ,Johnson & Johnson,Healthcare,2020,157.38,10.82,30.19,27.37,2034.81,292.81\nJNJ,Johnson & Johnson,Healthcare,2021,171.07,11.44,14.51,12.03,1798.57,296.55\nJNJ,Johnson & Johnson,Healthcare,2022,176.65,5.97,17.36,12.74,1823.53,314.26\nJNJ,Johnson & Johnson,Healthcare,2023,156.74,-8.58,16.51,17.43,2799.68,458.03\nJNJ,Johnson & Johnson,Healthcare,2024,144.62,-4.81,15.09,13.68,1805.62,279.94\nJNJ,Johnson & Johnson,Healthcare,2025,206.95,47.48,19.61,12.73,2208.71,374.72\nJPM,JPMorgan Chase & Co.,Financials,2020,127.07,-5.53,54.21,43.63,4865.18,500.21\nJPM,JPMorgan Chase & Co.,Financials,2021,158.35,27.75,21.34,11.19,3252.21,502.16\nJPM,JPMorgan Chase & Co.,Financials,2022,134.1,-12.64,29.83,37.93,3433.04,442.78\nJPM,JPMorgan Chase & Co.,Financials,2023,170.1,30.63,20.72,13.49,2686.51,382.5\nJPM,JPMorgan Chase & Co.,Financials,2024,239.71,44.29,23.32,10.13,2272.97,464.09\nJPM,JPMorgan Chase & Co.,Financials,2025,322.22,37.27,24.96,24.42,2339.75,644.44\nKO,The Coca-Cola Company,Consumer Staples,2020,54.84,2.47,34.85,36.99,4301.17,211.41\nKO,The Coca-Cola Company,Consumer Staples,2021,59.21,11.37,15.26,12.2,3990.52,214.47\nKO,The Coca-Cola Company,Consumer Staples,2022,63.61,10.61,19.76,16.66,4021.9,247.48\nKO,The Coca-Cola Company,Consumer Staples,2023,58.93,-4.43,13.51,17.27,3438.31,204.74\nKO,The Coca-Cola Company,Consumer Staples,2024,62.26,8.88,12.79,14.86,3521.07,225.32\nKO,The Coca-Cola Company,Consumer Staples,2025,69.91,15.6,17.47,9.82,4169.78,288.55\nLLY,Eli Lilly and Company,Healthcare,2020,168.84,31.04,41.8,22.49,996.18,146.68\nLLY,Eli Lilly and Company,Healthcare,2021,276.22,66.08,31.23,18.74,847.66,187.16\nLLY,Eli Lilly and Company,Healthcare,2022,365.84,34.26,27.14,14.68,726.82,223.23\nLLY,Eli Lilly and Company,Healthcare,2023,582.92,60.91,28.28,14.82,766.19,356.35\nLLY,Eli Lilly and Company,Healthcare,2024,772.0,33.3,30.16,24.13,809.24,651.85\nLLY,Eli Lilly and Company,Healthcare,2025,1074.68,40.25,40.71,32.57,992.46,807.12\nMA,Mastercard Incorporated,Financials,2020,356.94,20.19,48.65,41.0,1188.82,354.96\nMA,Mastercard Incorporated,Financials,2021,359.32,1.16,28.52,22.4,1023.85,362.35\nMA,Mastercard Incorporated,Financials,2022,347.73,-2.66,32.33,28.25,856.33,293.94\nMA,Mastercard Incorporated,Financials,2023,426.51,23.4,17.19,12.59,658.91,252.82\nMA,Mastercard Incorporated,Financials,2024,526.57,24.17,15.89,11.83,621.61,294.43\nMA,Mastercard Incorporated,Financials,2025,570.88,9.04,22.82,16.73,689.39,382.81\nMPC,Marathon Petroleum Corporation,Energy,2020,41.36,-27.38,84.72,72.88,2191.49,77.97\nMPC,Marathon Petroleum Corporation,Energy,2021,63.99,61.0,32.0,20.61,1590.16,92.22\nMPC,Marathon Petroleum Corporation,Energy,2022,116.39,86.62,36.23,30.22,1401.58,127.78\nMPC,Marathon Petroleum Corporation,Energy,2023,148.36,30.46,30.41,22.54,896.44,117.66\nMPC,Marathon Petroleum Corporation,Energy,2024,139.5,-4.06,29.78,38.99,669.65,113.11\nMPC,Marathon Petroleum Corporation,Energy,2025,162.63,19.17,34.74,25.1,599.7,97.33\nMRK,\"Merck & Co., Inc.\",Healthcare,2020,78.05,-7.2,31.85,27.26,2722.39,208.72\nMRK,\"Merck & Co., Inc.\",Healthcare,2021,76.64,1.75,23.63,20.17,3250.68,247.36\nMRK,\"Merck & Co., Inc.\",Healthcare,2022,110.95,49.42,19.88,10.76,2657.95,236.57\nMRK,\"Merck & Co., Inc.\",Healthcare,2023,109.02,1.01,18.83,14.23,1918.63,207.16\nMRK,\"Merck & Co., Inc.\",Healthcare,2024,99.48,-6.26,21.37,27.08,2353.41,274.75\nMRK,\"Merck & Co., Inc.\",Healthcare,2025,105.26,9.79,30.41,26.64,3657.56,318.28\nMSFT,Microsoft Corporation,Technology,2020,222.42,42.53,43.99,28.04,9527.88,1785.75\nMSFT,Microsoft Corporation,Technology,2021,336.32,52.48,21.02,8.77,6555.28,1792.88\nMSFT,Microsoft Corporation,Technology,2022,239.82,-28.02,35.32,35.88,7836.05,2118.76\nMSFT,Microsoft Corporation,Technology,2023,376.04,58.19,24.96,12.99,6919.27,2152.55\nMSFT,Microsoft Corporation,Technology,2024,421.5,12.93,20.07,15.49,5187.83,2173.66\nMSFT,Microsoft Corporation,Technology,2025,483.62,15.58,24.03,20.56,5548.36,2556.8\nMU,\"Micron Technology, Inc.\",Technology,2020,75.18,39.79,58.08,42.54,5740.74,292.21\nMU,\"Micron Technology, Inc.\",Technology,2021,93.15,24.21,39.77,30.46,4950.01,400.4\nMU,\"Micron Technology, Inc.\",Technology,2022,49.98,-45.93,47.43,49.63,4850.05,326.94\nMU,\"Micron Technology, Inc.\",Technology,2023,85.34,71.93,35.81,17.81,3805.62,251.26\nMU,\"Micron Technology, Inc.\",Technology,2024,84.16,-0.96,51.71,44.97,5527.15,593.95\nMU,\"Micron Technology, Inc.\",Technology,2025,285.41,240.24,62.68,40.75,5979.34,842.35\nNVDA,NVIDIA Corporation,Technology,2020,13.06,122.3,58.12,37.55,121656.38,1166.04\nNVDA,NVIDIA Corporation,Technology,2021,29.41,125.48,44.68,24.38,90608.82,1836.77\nNVDA,NVIDIA Corporation,Technology,2022,14.61,-50.26,63.16,62.7,136333.97,2516.02\nNVDA,NVIDIA Corporation,Technology,2023,49.52,239.02,46.77,18.29,118389.37,4320.42\nNVDA,NVIDIA Corporation,Technology,2024,134.29,171.25,52.06,27.05,95051.65,9539.72\nNVDA,NVIDIA Corporation,Technology,2025,186.5,38.92,49.82,36.88,55187.74,8126.17\nPG,The Procter & Gamble Company,Consumer Staples,2020,139.14,14.15,32.36,23.16,2024.19,252.05\nPG,The Procter & Gamble Company,Consumer Staples,2021,163.58,20.52,14.43,12.32,1953.73,270.9\nPG,The Procter & Gamble Company,Consumer Staples,2022,151.56,-5.05,22.05,23.77,1838.65,271.46\nPG,The Procter & Gamble Company,Consumer Staples,2023,146.54,-0.86,14.9,10.72,1573.2,233.27\nPG,The Procter & Gamble Company,Consumer Staples,2024,167.65,17.25,15.0,8.88,1687.05,278.37\nPG,The Procter & Gamble Company,Consumer Staples,2025,143.31,-12.26,19.01,19.93,2063.82,325.82\nPM,Philip Morris International Inc.,Consumer Staples,2020,82.79,3.69,39.59,31.89,1368.64,105.48\nPM,Philip Morris International Inc.,Consumer Staples,2021,95.0,20.78,17.47,18.0,1128.61,105.35\nPM,Philip Morris International Inc.,Consumer Staples,2022,101.21,12.31,25.04,22.78,1362.8,133.98\nPM,Philip Morris International Inc.,Consumer Staples,2023,94.08,-1.85,16.48,13.56,1081.53,103.5\nPM,Philip Morris International Inc.,Consumer Staples,2024,120.35,34.34,19.77,8.81,1340.96,144.85\nPM,Philip Morris International Inc.,Consumer Staples,2025,160.4,37.99,26.44,20.64,1533.31,243.38\nRTX,RTX Corporation,Industrials,2020,71.51,-21.95,57.5,51.98,2623.05,172.64\nRTX,RTX Corporation,Industrials,2021,86.06,23.27,22.92,13.44,1464.11,119.0\nRTX,RTX Corporation,Industrials,2022,100.92,20.01,25.98,21.92,1318.4,123.64\nRTX,RTX Corporation,Industrials,2023,84.14,-14.44,24.07,32.84,1695.33,146.82\nRTX,RTX Corporation,Industrials,2024,115.72,40.76,17.58,9.55,1608.26,168.52\nRTX,RTX Corporation,Industrials,2025,183.4,61.44,27.41,16.15,1243.39,181.5\nUNH,UnitedHealth Group Incorporated,Healthcare,2020,350.68,21.25,48.32,35.9,1019.47,297.8\nUNH,UnitedHealth Group Incorporated,Healthcare,2021,502.14,45.2,19.06,11.15,746.32,298.52\nUNH,UnitedHealth Group Incorporated,Healthcare,2022,530.18,6.94,24.35,16.91,777.7,394.43\nUNH,UnitedHealth Group Incorporated,Healthcare,2023,526.47,0.8,21.18,14.9,818.24,406.13\nUNH,UnitedHealth Group Incorporated,Healthcare,2024,505.86,-2.41,27.44,22.05,1034.33,543.84\nUNH,UnitedHealth Group Incorporated,Healthcare,2025,330.11,-33.14,49.61,60.06,2883.34,983.58\nV,Visa Inc.,Financials,2020,218.73,17.12,42.64,36.36,2462.07,466.13\nV,Visa Inc.,Financials,2021,216.71,-0.31,24.24,23.98,2201.29,482.3\nV,Visa Inc.,Financials,2022,207.76,-3.4,30.77,24.14,1884.57,390.82\nV,Visa Inc.,Financials,2023,260.35,26.31,15.53,7.78,1492.81,349.04\nV,Visa Inc.,Financials,2024,316.04,22.32,16.93,12.45,1740.46,485.98\nV,Visa Inc.,Financials,2025,350.71,11.76,22.57,15.01,1598.89,547.86\nVLO,Valero Energy Corporation,Energy,2020,56.57,-35.69,78.97,65.94,1262.2,70.59\nVLO,Valero Energy Corporation,Energy,2021,75.11,40.25,37.51,27.64,979.21,70.05\nVLO,Valero Energy Corporation,Energy,2022,126.86,74.95,44.95,31.94,1143.41,125.87\nVLO,Valero Energy Corporation,Energy,2023,130.0,5.86,32.84,29.93,978.21,124.16\nVLO,Valero Energy Corporation,Energy,2024,122.59,-2.96,29.16,33.96,737.46,107.49\nVLO,Valero Energy Corporation,Energy,2025,162.79,36.97,37.65,26.79,767.05,109.11\nWMT,Walmart Inc.,Consumer Staples,2020,48.05,23.32,31.16,13.14,6877.48,295.85\nWMT,Walmart Inc.,Consumer Staples,2021,48.23,1.97,16.81,14.39,6294.27,295.81\nWMT,Walmart Inc.,Consumer Staples,2022,47.26,-0.46,27.09,25.74,5999.98,274.44\nWMT,Walmart Inc.,Consumer Staples,2023,52.55,12.88,15.83,10.81,4735.43,240.96\nWMT,Walmart Inc.,Consumer Staples,2024,90.35,73.99,17.51,5.8,4281.44,298.47\nWMT,Walmart Inc.,Consumer Staples,2025,111.41,24.49,24.97,21.93,4669.4,460.16\nXOM,Exxon Mobil Corporation,Energy,2020,41.22,-36.21,52.84,55.0,7289.29,312.86\nXOM,Exxon Mobil Corporation,Energy,2021,61.19,57.58,29.4,17.22,6044.7,347.33\nXOM,Exxon Mobil Corporation,Energy,2022,110.3,87.41,35.15,20.51,6356.14,568.69\nXOM,Exxon Mobil Corporation,Energy,2023,99.98,-6.26,25.06,17.68,4370.03,472.53\nXOM,Exxon Mobil Corporation,Energy,2024,107.57,11.26,19.25,15.15,4106.6,463.6\nXOM,Exxon Mobil Corporation,Energy,2025,120.34,15.98,23.55,16.05,4013.68,445.23\n","slug","Assignment7","description","ownerType","ownerId","projectId","visibility","public","isTemplate","headCommitId","0186b8a7765c479487e72ec77eb59674","startCommitId","7dc8b4c7740a4991b8c4a8e8699a0aed","forkedFrom","forkedFromVisibility",1793404747000,1793407571000,"publishedAt","isPublished","draftStatus","published","lifecycleStatus","active","trashedAt","purgeAfter","pwaInstallEnabled","legacyVizIframeCompatEnabled","userId","account","appOrigin","https://vizhub.com","googleAnalyticsId","G-5BVJNTEF9V"]

Assignment7

Comments