-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstockInfo-populated.sql
74 lines (62 loc) · 52.5 KB
/
stockInfo-populated.sql
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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Nov 01, 2024 at 12:45 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `usersTest`
--
-- --------------------------------------------------------
--
-- Table structure for table `stockInfo`
--
CREATE TABLE `stockInfo` (
`Symbol` varchar(10) NOT NULL,
`Name` varchar(255) NOT NULL,
`Exchange` varchar(50) DEFAULT NULL,
`Sector` varchar(100) DEFAULT NULL,
`Industry` varchar(100) DEFAULT NULL,
`EPS` double DEFAULT NULL,
`LatestQuarter` date DEFAULT NULL,
`52WeekHigh` double DEFAULT NULL,
`52WeekLow` double DEFAULT NULL,
`AnalystTargetPrice` double DEFAULT NULL,
`TimeSeries` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `stockInfo`
--
INSERT INTO `stockInfo` (`Symbol`, `Name`, `Exchange`, `Sector`, `Industry`, `EPS`, `LatestQuarter`, `52WeekHigh`, `52WeekLow`, `AnalystTargetPrice`, `TimeSeries`) VALUES
('AAPL', 'Apple Inc.', 'NASDAQ', 'Technology', 'Consumer Electronics', 5.11, '2024-06-30', 180, 120, 165, '{\"Time Series (Daily)\":{\"2024-10-31\":{\"1. open\":\"145.00\",\"2. high\":\"146.35\",\"3. low\":\"144.65\",\"4. close\":\"145.35\",\"5. adjusted close\":\"145.35\",\"6. volume\":\"1106819\"},\"2024-10-30\":{\"1. open\":\"145.35\",\"2. high\":\"145.90\",\"3. low\":\"143.54\",\"4. close\":\"144.35\",\"5. adjusted close\":\"144.35\",\"6. volume\":\"1820773\"},\"2024-10-29\":{\"1. open\":\"144.35\",\"2. high\":\"145.66\",\"3. low\":\"143.87\",\"4. close\":\"144.99\",\"5. adjusted close\":\"144.99\",\"6. volume\":\"3490439\"},\"2024-10-28\":{\"1. open\":\"144.99\",\"2. high\":\"146.25\",\"3. low\":\"144.05\",\"4. close\":\"145.31\",\"5. adjusted close\":\"145.31\",\"6. volume\":\"1187510\"},\"2024-10-25\":{\"1. open\":\"145.31\",\"2. high\":\"145.89\",\"3. low\":\"143.15\",\"4. close\":\"144.38\",\"5. adjusted close\":\"144.38\",\"6. volume\":\"2112378\"},\"2024-10-24\":{\"1. open\":\"144.38\",\"2. high\":\"146.41\",\"3. low\":\"143.60\",\"4. close\":\"145.16\",\"5. adjusted close\":\"145.16\",\"6. volume\":\"1269745\"},\"2024-10-23\":{\"1. open\":\"145.16\",\"2. high\":\"148.35\",\"3. low\":\"144.42\",\"4. close\":\"147.48\",\"5. adjusted close\":\"147.48\",\"6. volume\":\"1620363\"},\"2024-10-22\":{\"1. open\":\"147.48\",\"2. high\":\"148.69\",\"3. low\":\"146.80\",\"4. close\":\"146.89\",\"5. adjusted close\":\"146.89\",\"6. volume\":\"3365570\"},\"2024-10-21\":{\"1. open\":\"146.89\",\"2. high\":\"147.05\",\"3. low\":\"146.74\",\"4. close\":\"146.96\",\"5. adjusted close\":\"146.96\",\"6. volume\":\"4951799\"},\"2024-10-18\":{\"1. open\":\"146.96\",\"2. high\":\"149.52\",\"3. low\":\"146.20\",\"4. close\":\"148.22\",\"5. adjusted close\":\"148.22\",\"6. volume\":\"4459560\"},\"2024-10-17\":{\"1. open\":\"148.22\",\"2. high\":\"148.28\",\"3. low\":\"147.35\",\"4. close\":\"147.57\",\"5. adjusted close\":\"147.57\",\"6. volume\":\"2545389\"},\"2024-10-16\":{\"1. open\":\"147.57\",\"2. high\":\"150.96\",\"3. low\":\"146.39\",\"4. close\":\"150.18\",\"5. adjusted close\":\"150.18\",\"6. volume\":\"3813037\"},\"2024-10-15\":{\"1. open\":\"150.18\",\"2. high\":\"151.01\",\"3. low\":\"149.76\",\"4. close\":\"149.88\",\"5. adjusted close\":\"149.88\",\"6. volume\":\"3597137\"},\"2024-10-14\":{\"1. open\":\"149.88\",\"2. high\":\"150.48\",\"3. low\":\"148.46\",\"4. close\":\"150.33\",\"5. adjusted close\":\"150.33\",\"6. volume\":\"2313963\"},\"2024-10-11\":{\"1. open\":\"150.33\",\"2. high\":\"150.63\",\"3. low\":\"148.30\",\"4. close\":\"148.33\",\"5. adjusted close\":\"148.33\",\"6. volume\":\"2128208\"},\"2024-10-10\":{\"1. open\":\"148.33\",\"2. high\":\"149.38\",\"3. low\":\"146.05\",\"4. close\":\"146.64\",\"5. adjusted close\":\"146.64\",\"6. volume\":\"2703664\"},\"2024-10-09\":{\"1. open\":\"146.64\",\"2. high\":\"147.94\",\"3. low\":\"145.85\",\"4. close\":\"147.42\",\"5. adjusted close\":\"147.42\",\"6. volume\":\"3250848\"},\"2024-10-08\":{\"1. open\":\"147.42\",\"2. high\":\"151.32\",\"3. low\":\"146.11\",\"4. close\":\"149.90\",\"5. adjusted close\":\"149.90\",\"6. volume\":\"1120820\"},\"2024-10-07\":{\"1. open\":\"149.90\",\"2. high\":\"152.94\",\"3. low\":\"148.45\",\"4. close\":\"152.60\",\"5. adjusted close\":\"152.60\",\"6. volume\":\"1235924\"},\"2024-10-04\":{\"1. open\":\"152.60\",\"2. high\":\"154.04\",\"3. low\":\"152.05\",\"4. close\":\"152.94\",\"5. adjusted close\":\"152.94\",\"6. volume\":\"3714407\"},\"2024-10-03\":{\"1. open\":\"152.94\",\"2. high\":\"156.56\",\"3. low\":\"152.83\",\"4. close\":\"155.56\",\"5. adjusted close\":\"155.56\",\"6. volume\":\"2958702\"},\"2024-10-02\":{\"1. open\":\"155.56\",\"2. high\":\"158.38\",\"3. low\":\"155.36\",\"4. close\":\"158.25\",\"5. adjusted close\":\"158.25\",\"6. volume\":\"3015553\"},\"2024-10-01\":{\"1. open\":\"158.25\",\"2. high\":\"161.37\",\"3. low\":\"157.65\",\"4. close\":\"160.81\",\"5. adjusted close\":\"160.81\",\"6. volume\":\"2670031\"},\"2024-09-30\":{\"1. open\":\"160.81\",\"2. high\":\"163.13\",\"3. low\":\"160.55\",\"4. close\":\"163.00\",\"5. adjusted close\":\"163.00\",\"6. volume\":\"3313415\"},\"2024-09-27\":{\"1. open\":\"163.00\",\"2. high\":\"164.05\",\"3. low\":\"161.73\",\"4. close\":\"163.80\",\"5. adjusted close\":\"163.80\",\"6. volume\":\"2360060\"},\"2024-09-26\":{\"1. open\":\"163.80\",\"2. high\":\"165.37\",\"3. low\":\"161.12\",\"4. close\":\"161.72\",\"5. adjusted close\":\"161.72\",\"6. volume\":\"2085720\"},\"2024-09-25\":{\"1. open\":\"161.72\",\"2. high\":\"163.42\",\"3. low\":\"161.17\",\"4. close\":\"162.80\",\"5. adjusted close\":\"162.80\",\"6. volume\":\"2694499\"},\"2024-09-24\":{\"1. open\":\"162.80\",\"2. high\":\"164.30\",\"3. low\":\"162.75\",\"4. close\":\"163.14\",\"5. adjusted close\":\"163.14\",\"6. volume\":\"2896298\"},\"2024-09-23\":{\"1. open\":\"163.14\",\"2. high\":\"164.66\",\"3. low\":\"161.79\",\"4. close\":\"162.34\",\"5. adjusted close\":\"162.34\",\"6. volume\":\"4483575\"},\"2024-09-20\":{\"1. open\":\"162.34\",\"2. high\":\"163.31\",\"3. low\":\"160.99\",\"4. close\":\"162.19\",\"5. adjusted close\":\"162.19\",\"6. volume\":\"4726989\"}}}'),
('AMZN', 'Amazon.com, Inc.', 'NASDAQ', 'Consumer Cyclical', 'Internet Retail', 42.51, '2024-06-30', 3500, 2900, 3200, '{\"Time Series (Daily)\":{\"2024-10-31\":{\"1. open\":\"3300.00\",\"2. high\":\"3332.67\",\"3. low\":\"3256.90\",\"4. close\":\"3283.83\",\"5. adjusted close\":\"3283.83\",\"6. volume\":\"3429168\"},\"2024-10-30\":{\"1. open\":\"3283.83\",\"2. high\":\"3363.31\",\"3. low\":\"3262.16\",\"4. close\":\"3344.25\",\"5. adjusted close\":\"3344.25\",\"6. volume\":\"1284948\"},\"2024-10-29\":{\"1. open\":\"3344.25\",\"2. high\":\"3365.65\",\"3. low\":\"3313.49\",\"4. close\":\"3313.82\",\"5. adjusted close\":\"3313.82\",\"6. volume\":\"1617107\"},\"2024-10-28\":{\"1. open\":\"3313.82\",\"2. high\":\"3344.64\",\"3. low\":\"3272.18\",\"4. close\":\"3300.23\",\"5. adjusted close\":\"3300.23\",\"6. volume\":\"4052535\"},\"2024-10-25\":{\"1. open\":\"3300.23\",\"2. high\":\"3314.09\",\"3. low\":\"3258.09\",\"4. close\":\"3269.21\",\"5. adjusted close\":\"3269.21\",\"6. volume\":\"4442713\"},\"2024-10-24\":{\"1. open\":\"3269.21\",\"2. high\":\"3284.58\",\"3. low\":\"3189.19\",\"4. close\":\"3211.67\",\"5. adjusted close\":\"3211.67\",\"6. volume\":\"1629837\"},\"2024-10-23\":{\"1. open\":\"3211.67\",\"2. high\":\"3220.02\",\"3. low\":\"3125.17\",\"4. close\":\"3155.14\",\"5. adjusted close\":\"3155.14\",\"6. volume\":\"2228582\"},\"2024-10-22\":{\"1. open\":\"3155.14\",\"2. high\":\"3163.66\",\"3. low\":\"3111.12\",\"4. close\":\"3137.16\",\"5. adjusted close\":\"3137.16\",\"6. volume\":\"1451246\"},\"2024-10-21\":{\"1. open\":\"3137.16\",\"2. high\":\"3193.64\",\"3. low\":\"3125.24\",\"4. close\":\"3193.00\",\"5. adjusted close\":\"3193.00\",\"6. volume\":\"4444053\"},\"2024-10-18\":{\"1. open\":\"3193.00\",\"2. high\":\"3212.80\",\"3. low\":\"3125.31\",\"4. close\":\"3147.66\",\"5. adjusted close\":\"3147.66\",\"6. volume\":\"4453676\"},\"2024-10-17\":{\"1. open\":\"3147.66\",\"2. high\":\"3204.46\",\"3. low\":\"3127.51\",\"4. close\":\"3194.56\",\"5. adjusted close\":\"3194.56\",\"6. volume\":\"4671403\"},\"2024-10-16\":{\"1. open\":\"3194.56\",\"2. high\":\"3283.59\",\"3. low\":\"3187.21\",\"4. close\":\"3254.30\",\"5. adjusted close\":\"3254.30\",\"6. volume\":\"4256736\"},\"2024-10-15\":{\"1. open\":\"3254.30\",\"2. high\":\"3278.07\",\"3. low\":\"3234.45\",\"4. close\":\"3275.45\",\"5. adjusted close\":\"3275.45\",\"6. volume\":\"3810171\"},\"2024-10-14\":{\"1. open\":\"3275.45\",\"2. high\":\"3325.73\",\"3. low\":\"3266.93\",\"4. close\":\"3308.53\",\"5. adjusted close\":\"3308.53\",\"6. volume\":\"1406304\"},\"2024-10-11\":{\"1. open\":\"3308.53\",\"2. high\":\"3327.39\",\"3. low\":\"3284.42\",\"4. close\":\"3296.62\",\"5. adjusted close\":\"3296.62\",\"6. volume\":\"2721584\"},\"2024-10-10\":{\"1. open\":\"3296.62\",\"2. high\":\"3360.96\",\"3. low\":\"3275.19\",\"4. close\":\"3358.27\",\"5. adjusted close\":\"3358.27\",\"6. volume\":\"3718868\"},\"2024-10-09\":{\"1. open\":\"3358.27\",\"2. high\":\"3388.49\",\"3. low\":\"3339.15\",\"4. close\":\"3354.24\",\"5. adjusted close\":\"3354.24\",\"6. volume\":\"4414123\"},\"2024-10-08\":{\"1. open\":\"3354.24\",\"2. high\":\"3433.67\",\"3. low\":\"3336.13\",\"4. close\":\"3419.31\",\"5. adjusted close\":\"3419.31\",\"6. volume\":\"4322193\"},\"2024-10-07\":{\"1. open\":\"3419.31\",\"2. high\":\"3464.25\",\"3. low\":\"3392.30\",\"4. close\":\"3439.14\",\"5. adjusted close\":\"3439.14\",\"6. volume\":\"1409060\"},\"2024-10-04\":{\"1. open\":\"3439.14\",\"2. high\":\"3508.45\",\"3. low\":\"3418.16\",\"4. close\":\"3497.61\",\"5. adjusted close\":\"3497.61\",\"6. volume\":\"3469235\"},\"2024-10-03\":{\"1. open\":\"3497.61\",\"2. high\":\"3585.45\",\"3. low\":\"3494.81\",\"4. close\":\"3563.71\",\"5. adjusted close\":\"3563.71\",\"6. volume\":\"4550161\"},\"2024-10-02\":{\"1. open\":\"3563.71\",\"2. high\":\"3591.56\",\"3. low\":\"3553.02\",\"4. close\":\"3577.61\",\"5. adjusted close\":\"3577.61\",\"6. volume\":\"3123679\"},\"2024-10-01\":{\"1. open\":\"3577.61\",\"2. high\":\"3623.16\",\"3. low\":\"3575.11\",\"4. close\":\"3591.20\",\"5. adjusted close\":\"3591.20\",\"6. volume\":\"2337394\"},\"2024-09-30\":{\"1. open\":\"3591.20\",\"2. high\":\"3625.32\",\"3. low\":\"3543.23\",\"4. close\":\"3559.96\",\"5. adjusted close\":\"3559.96\",\"6. volume\":\"1869736\"},\"2024-09-27\":{\"1. open\":\"3559.96\",\"2. high\":\"3606.36\",\"3. low\":\"3539.67\",\"4. close\":\"3593.07\",\"5. adjusted close\":\"3593.07\",\"6. volume\":\"1125023\"},\"2024-09-26\":{\"1. open\":\"3593.07\",\"2. high\":\"3677.98\",\"3. low\":\"3585.88\",\"4. close\":\"3644.81\",\"5. adjusted close\":\"3644.81\",\"6. volume\":\"4574760\"},\"2024-09-25\":{\"1. open\":\"3644.81\",\"2. high\":\"3667.77\",\"3. low\":\"3583.47\",\"4. close\":\"3609.82\",\"5. adjusted close\":\"3609.82\",\"6. volume\":\"1774809\"},\"2024-09-24\":{\"1. open\":\"3609.82\",\"2. high\":\"3638.34\",\"3. low\":\"3544.30\",\"4. close\":\"3556.39\",\"5. adjusted close\":\"3556.39\",\"6. volume\":\"2227695\"},\"2024-09-23\":{\"1. open\":\"3556.39\",\"2. high\":\"3601.34\",\"3. low\":\"3552.12\",\"4. close\":\"3580.22\",\"5. adjusted close\":\"3580.22\",\"6. volume\":\"3911568\"},\"2024-09-20\":{\"1. open\":\"3580.22\",\"2. high\":\"3662.12\",\"3. low\":\"3561.24\",\"4. close\":\"3647.17\",\"5. adjusted close\":\"3647.17\",\"6. volume\":\"3657199\"}}}'),
('DIS', 'The Walt Disney Company', 'NYSE', 'Communication Services', 'Entertainment', 3.4, '2024-06-30', 200, 150, 180, '{\"Time Series (Daily)\":{\"2024-10-31\":{\"1. open\":\"170.00\",\"2. high\":\"173.21\",\"3. low\":\"169.86\",\"4. close\":\"173.18\",\"5. adjusted close\":\"173.18\",\"6. volume\":\"3272156\"},\"2024-10-30\":{\"1. open\":\"173.18\",\"2. high\":\"173.66\",\"3. low\":\"172.77\",\"4. close\":\"173.15\",\"5. adjusted close\":\"173.15\",\"6. volume\":\"1924280\"},\"2024-10-29\":{\"1. open\":\"173.15\",\"2. high\":\"174.82\",\"3. low\":\"171.45\",\"4. close\":\"173.55\",\"5. adjusted close\":\"173.55\",\"6. volume\":\"1974773\"},\"2024-10-28\":{\"1. open\":\"173.55\",\"2. high\":\"177.20\",\"3. low\":\"172.79\",\"4. close\":\"175.72\",\"5. adjusted close\":\"175.72\",\"6. volume\":\"3050674\"},\"2024-10-25\":{\"1. open\":\"175.72\",\"2. high\":\"178.29\",\"3. low\":\"174.26\",\"4. close\":\"177.99\",\"5. adjusted close\":\"177.99\",\"6. volume\":\"2517147\"},\"2024-10-24\":{\"1. open\":\"177.99\",\"2. high\":\"179.80\",\"3. low\":\"176.69\",\"4. close\":\"179.49\",\"5. adjusted close\":\"179.49\",\"6. volume\":\"4016881\"},\"2024-10-23\":{\"1. open\":\"179.49\",\"2. high\":\"181.27\",\"3. low\":\"175.38\",\"4. close\":\"176.85\",\"5. adjusted close\":\"176.85\",\"6. volume\":\"4237862\"},\"2024-10-22\":{\"1. open\":\"176.85\",\"2. high\":\"176.85\",\"3. low\":\"174.51\",\"4. close\":\"175.88\",\"5. adjusted close\":\"175.88\",\"6. volume\":\"2847152\"},\"2024-10-21\":{\"1. open\":\"175.88\",\"2. high\":\"177.20\",\"3. low\":\"173.03\",\"4. close\":\"174.51\",\"5. adjusted close\":\"174.51\",\"6. volume\":\"1941836\"},\"2024-10-18\":{\"1. open\":\"174.51\",\"2. high\":\"174.91\",\"3. low\":\"172.21\",\"4. close\":\"172.45\",\"5. adjusted close\":\"172.45\",\"6. volume\":\"4721519\"},\"2024-10-17\":{\"1. open\":\"172.45\",\"2. high\":\"174.70\",\"3. low\":\"172.42\",\"4. close\":\"173.16\",\"5. adjusted close\":\"173.16\",\"6. volume\":\"1381959\"},\"2024-10-16\":{\"1. open\":\"173.16\",\"2. high\":\"173.80\",\"3. low\":\"171.47\",\"4. close\":\"172.50\",\"5. adjusted close\":\"172.50\",\"6. volume\":\"3083107\"},\"2024-10-15\":{\"1. open\":\"172.50\",\"2. high\":\"174.07\",\"3. low\":\"169.56\",\"4. close\":\"170.46\",\"5. adjusted close\":\"170.46\",\"6. volume\":\"3680622\"},\"2024-10-14\":{\"1. open\":\"170.46\",\"2. high\":\"170.60\",\"3. low\":\"168.55\",\"4. close\":\"169.11\",\"5. adjusted close\":\"169.11\",\"6. volume\":\"3136332\"},\"2024-10-11\":{\"1. open\":\"169.11\",\"2. high\":\"170.70\",\"3. low\":\"166.14\",\"4. close\":\"166.56\",\"5. adjusted close\":\"166.56\",\"6. volume\":\"4126855\"},\"2024-10-10\":{\"1. open\":\"166.56\",\"2. high\":\"167.96\",\"3. low\":\"163.36\",\"4. close\":\"164.21\",\"5. adjusted close\":\"164.21\",\"6. volume\":\"3172348\"},\"2024-10-09\":{\"1. open\":\"164.21\",\"2. high\":\"165.01\",\"3. low\":\"160.07\",\"4. close\":\"161.17\",\"5. adjusted close\":\"161.17\",\"6. volume\":\"2939694\"},\"2024-10-08\":{\"1. open\":\"161.17\",\"2. high\":\"163.14\",\"3. low\":\"159.66\",\"4. close\":\"162.59\",\"5. adjusted close\":\"162.59\",\"6. volume\":\"4287036\"},\"2024-10-07\":{\"1. open\":\"162.59\",\"2. high\":\"164.05\",\"3. low\":\"160.33\",\"4. close\":\"160.72\",\"5. adjusted close\":\"160.72\",\"6. volume\":\"3441024\"},\"2024-10-04\":{\"1. open\":\"160.72\",\"2. high\":\"160.75\",\"3. low\":\"156.74\",\"4. close\":\"158.10\",\"5. adjusted close\":\"158.10\",\"6. volume\":\"3758897\"},\"2024-10-03\":{\"1. open\":\"158.10\",\"2. high\":\"160.37\",\"3. low\":\"157.23\",\"4. close\":\"159.22\",\"5. adjusted close\":\"159.22\",\"6. volume\":\"3919314\"},\"2024-10-02\":{\"1. open\":\"159.22\",\"2. high\":\"159.71\",\"3. low\":\"157.56\",\"4. close\":\"158.30\",\"5. adjusted close\":\"158.30\",\"6. volume\":\"1809113\"},\"2024-10-01\":{\"1. open\":\"158.30\",\"2. high\":\"161.29\",\"3. low\":\"156.80\",\"4. close\":\"160.79\",\"5. adjusted close\":\"160.79\",\"6. volume\":\"4193801\"},\"2024-09-30\":{\"1. open\":\"160.79\",\"2. high\":\"161.71\",\"3. low\":\"158.95\",\"4. close\":\"159.65\",\"5. adjusted close\":\"159.65\",\"6. volume\":\"2405673\"},\"2024-09-27\":{\"1. open\":\"159.65\",\"2. high\":\"160.77\",\"3. low\":\"158.20\",\"4. close\":\"159.73\",\"5. adjusted close\":\"159.73\",\"6. volume\":\"4901487\"},\"2024-09-26\":{\"1. open\":\"159.73\",\"2. high\":\"160.13\",\"3. low\":\"158.15\",\"4. close\":\"159.86\",\"5. adjusted close\":\"159.86\",\"6. volume\":\"2148260\"},\"2024-09-25\":{\"1. open\":\"159.86\",\"2. high\":\"160.23\",\"3. low\":\"158.79\",\"4. close\":\"159.52\",\"5. adjusted close\":\"159.52\",\"6. volume\":\"1190461\"},\"2024-09-24\":{\"1. open\":\"159.52\",\"2. high\":\"160.37\",\"3. low\":\"159.09\",\"4. close\":\"159.11\",\"5. adjusted close\":\"159.11\",\"6. volume\":\"1785818\"},\"2024-09-23\":{\"1. open\":\"159.11\",\"2. high\":\"160.35\",\"3. low\":\"157.82\",\"4. close\":\"158.39\",\"5. adjusted close\":\"158.39\",\"6. volume\":\"3163733\"},\"2024-09-20\":{\"1. open\":\"158.39\",\"2. high\":\"159.50\",\"3. low\":\"157.61\",\"4. close\":\"158.23\",\"5. adjusted close\":\"158.23\",\"6. volume\":\"1189197\"}}}'),
('GOOG', 'Alphabet Inc.', 'NASDAQ', 'Communication Services', 'Internet Content & Information', 6.5, '2024-06-30', 2800, 2200, 2500, '{\"Time Series (Daily)\":{\"2024-10-31\":{\"1. open\":\"2700.00\",\"2. high\":\"2745.82\",\"3. low\":\"2684.34\",\"4. close\":\"2718.90\",\"5. adjusted close\":\"2718.90\",\"6. volume\":\"3656026\"},\"2024-10-30\":{\"1. open\":\"2718.90\",\"2. high\":\"2728.42\",\"3. low\":\"2657.51\",\"4. close\":\"2680.56\",\"5. adjusted close\":\"2680.56\",\"6. volume\":\"4050286\"},\"2024-10-29\":{\"1. open\":\"2680.56\",\"2. high\":\"2708.78\",\"3. low\":\"2672.25\",\"4. close\":\"2693.43\",\"5. adjusted close\":\"2693.43\",\"6. volume\":\"1589643\"},\"2024-10-28\":{\"1. open\":\"2693.43\",\"2. high\":\"2699.36\",\"3. low\":\"2654.25\",\"4. close\":\"2677.27\",\"5. adjusted close\":\"2677.27\",\"6. volume\":\"1327392\"},\"2024-10-25\":{\"1. open\":\"2677.27\",\"2. high\":\"2691.99\",\"3. low\":\"2629.76\",\"4. close\":\"2639.79\",\"5. adjusted close\":\"2639.79\",\"6. volume\":\"1923386\"},\"2024-10-24\":{\"1. open\":\"2639.79\",\"2. high\":\"2645.07\",\"3. low\":\"2636.36\",\"4. close\":\"2644.54\",\"5. adjusted close\":\"2644.54\",\"6. volume\":\"1493251\"},\"2024-10-23\":{\"1. open\":\"2644.54\",\"2. high\":\"2682.99\",\"3. low\":\"2628.14\",\"4. close\":\"2673.37\",\"5. adjusted close\":\"2673.37\",\"6. volume\":\"4744036\"},\"2024-10-22\":{\"1. open\":\"2673.37\",\"2. high\":\"2713.58\",\"3. low\":\"2669.63\",\"4. close\":\"2704.92\",\"5. adjusted close\":\"2704.92\",\"6. volume\":\"2669002\"},\"2024-10-21\":{\"1. open\":\"2704.92\",\"2. high\":\"2716.29\",\"3. low\":\"2691.67\",\"4. close\":\"2712.76\",\"5. adjusted close\":\"2712.76\",\"6. volume\":\"3330719\"},\"2024-10-18\":{\"1. open\":\"2712.76\",\"2. high\":\"2733.38\",\"3. low\":\"2689.21\",\"4. close\":\"2701.64\",\"5. adjusted close\":\"2701.64\",\"6. volume\":\"3307404\"},\"2024-10-17\":{\"1. open\":\"2701.64\",\"2. high\":\"2754.30\",\"3. low\":\"2689.48\",\"4. close\":\"2732.44\",\"5. adjusted close\":\"2732.44\",\"6. volume\":\"3716401\"},\"2024-10-16\":{\"1. open\":\"2732.44\",\"2. high\":\"2802.98\",\"3. low\":\"2714.95\",\"4. close\":\"2786.82\",\"5. adjusted close\":\"2786.82\",\"6. volume\":\"1912704\"},\"2024-10-15\":{\"1. open\":\"2786.82\",\"2. high\":\"2790.72\",\"3. low\":\"2731.87\",\"4. close\":\"2747.53\",\"5. adjusted close\":\"2747.53\",\"6. volume\":\"3950832\"},\"2024-10-14\":{\"1. open\":\"2747.53\",\"2. high\":\"2822.17\",\"3. low\":\"2729.40\",\"4. close\":\"2796.44\",\"5. adjusted close\":\"2796.44\",\"6. volume\":\"2070805\"},\"2024-10-11\":{\"1. open\":\"2796.44\",\"2. high\":\"2800.91\",\"3. low\":\"2766.84\",\"4. close\":\"2791.97\",\"5. adjusted close\":\"2791.97\",\"6. volume\":\"3438463\"},\"2024-10-10\":{\"1. open\":\"2791.97\",\"2. high\":\"2800.90\",\"3. low\":\"2745.81\",\"4. close\":\"2772.15\",\"5. adjusted close\":\"2772.15\",\"6. volume\":\"3971534\"},\"2024-10-09\":{\"1. open\":\"2772.15\",\"2. high\":\"2788.23\",\"3. low\":\"2732.64\",\"4. close\":\"2746.37\",\"5. adjusted close\":\"2746.37\",\"6. volume\":\"1766430\"},\"2024-10-08\":{\"1. open\":\"2746.37\",\"2. high\":\"2749.12\",\"3. low\":\"2691.00\",\"4. close\":\"2696.66\",\"5. adjusted close\":\"2696.66\",\"6. volume\":\"3588965\"},\"2024-10-07\":{\"1. open\":\"2696.66\",\"2. high\":\"2739.16\",\"3. low\":\"2683.45\",\"4. close\":\"2717.69\",\"5. adjusted close\":\"2717.69\",\"6. volume\":\"2037462\"},\"2024-10-04\":{\"1. open\":\"2717.69\",\"2. high\":\"2795.05\",\"3. low\":\"2712.80\",\"4. close\":\"2772.04\",\"5. adjusted close\":\"2772.04\",\"6. volume\":\"1291698\"},\"2024-10-03\":{\"1. open\":\"2772.04\",\"2. high\":\"2794.23\",\"3. low\":\"2744.87\",\"4. close\":\"2773.15\",\"5. adjusted close\":\"2773.15\",\"6. volume\":\"4560656\"},\"2024-10-02\":{\"1. open\":\"2773.15\",\"2. high\":\"2807.61\",\"3. low\":\"2756.51\",\"4. close\":\"2781.19\",\"5. adjusted close\":\"2781.19\",\"6. volume\":\"2537200\"},\"2024-10-01\":{\"1. open\":\"2781.19\",\"2. high\":\"2812.14\",\"3. low\":\"2773.96\",\"4. close\":\"2802.61\",\"5. adjusted close\":\"2802.61\",\"6. volume\":\"4479885\"},\"2024-09-30\":{\"1. open\":\"2802.61\",\"2. high\":\"2805.97\",\"3. low\":\"2752.30\",\"4. close\":\"2761.97\",\"5. adjusted close\":\"2761.97\",\"6. volume\":\"3221587\"},\"2024-09-27\":{\"1. open\":\"2761.97\",\"2. high\":\"2797.99\",\"3. low\":\"2755.07\",\"4. close\":\"2784.62\",\"5. adjusted close\":\"2784.62\",\"6. volume\":\"4398305\"},\"2024-09-26\":{\"1. open\":\"2784.62\",\"2. high\":\"2838.76\",\"3. low\":\"2756.77\",\"4. close\":\"2831.96\",\"5. adjusted close\":\"2831.96\",\"6. volume\":\"3314841\"},\"2024-09-25\":{\"1. open\":\"2831.96\",\"2. high\":\"2841.88\",\"3. low\":\"2818.93\",\"4. close\":\"2838.19\",\"5. adjusted close\":\"2838.19\",\"6. volume\":\"2604589\"},\"2024-09-24\":{\"1. open\":\"2838.19\",\"2. high\":\"2851.25\",\"3. low\":\"2806.50\",\"4. close\":\"2822.30\",\"5. adjusted close\":\"2822.30\",\"6. volume\":\"1884958\"},\"2024-09-23\":{\"1. open\":\"2822.30\",\"2. high\":\"2848.55\",\"3. low\":\"2774.04\",\"4. close\":\"2774.32\",\"5. adjusted close\":\"2774.32\",\"6. volume\":\"2448156\"},\"2024-09-20\":{\"1. open\":\"2774.32\",\"2. high\":\"2777.65\",\"3. low\":\"2738.09\",\"4. close\":\"2759.89\",\"5. adjusted close\":\"2759.89\",\"6. volume\":\"3028064\"}}}'),
('IBM', 'International Business Machines', 'NYSE', 'Technology', 'Computer & Office Equipment', 9.08, '2024-06-30', 237.37, 136.3, 212.63, '{\"Time Series (Daily)\":{\"2024-10-31\":{\"1. open\":\"150.00\",\"2. high\":\"154.23\",\"3. low\":\"148.77\",\"4. close\":\"152.79\",\"5. adjusted close\":\"152.79\",\"6. volume\":\"2868187\"},\"2024-10-30\":{\"1. open\":\"152.79\",\"2. high\":\"153.26\",\"3. low\":\"149.26\",\"4. close\":\"149.78\",\"5. adjusted close\":\"149.78\",\"6. volume\":\"3500312\"},\"2024-10-29\":{\"1. open\":\"149.78\",\"2. high\":\"151.17\",\"3. low\":\"146.83\",\"4. close\":\"147.73\",\"5. adjusted close\":\"147.73\",\"6. volume\":\"2633373\"},\"2024-10-28\":{\"1. open\":\"147.73\",\"2. high\":\"150.71\",\"3. low\":\"146.34\",\"4. close\":\"149.99\",\"5. adjusted close\":\"149.99\",\"6. volume\":\"1416771\"},\"2024-10-25\":{\"1. open\":\"149.99\",\"2. high\":\"150.53\",\"3. low\":\"147.32\",\"4. close\":\"148.79\",\"5. adjusted close\":\"148.79\",\"6. volume\":\"1667888\"},\"2024-10-24\":{\"1. open\":\"148.79\",\"2. high\":\"149.71\",\"3. low\":\"145.89\",\"4. close\":\"146.04\",\"5. adjusted close\":\"146.04\",\"6. volume\":\"1586924\"},\"2024-10-23\":{\"1. open\":\"146.04\",\"2. high\":\"147.10\",\"3. low\":\"145.06\",\"4. close\":\"146.81\",\"5. adjusted close\":\"146.81\",\"6. volume\":\"2316940\"},\"2024-10-22\":{\"1. open\":\"146.81\",\"2. high\":\"147.54\",\"3. low\":\"146.22\",\"4. close\":\"146.59\",\"5. adjusted close\":\"146.59\",\"6. volume\":\"4698635\"},\"2024-10-21\":{\"1. open\":\"146.59\",\"2. high\":\"148.93\",\"3. low\":\"145.65\",\"4. close\":\"147.62\",\"5. adjusted close\":\"147.62\",\"6. volume\":\"1272587\"},\"2024-10-18\":{\"1. open\":\"147.62\",\"2. high\":\"150.55\",\"3. low\":\"146.87\",\"4. close\":\"150.19\",\"5. adjusted close\":\"150.19\",\"6. volume\":\"3785636\"},\"2024-10-17\":{\"1. open\":\"150.19\",\"2. high\":\"153.16\",\"3. low\":\"149.69\",\"4. close\":\"151.75\",\"5. adjusted close\":\"151.75\",\"6. volume\":\"2822967\"},\"2024-10-16\":{\"1. open\":\"151.75\",\"2. high\":\"152.11\",\"3. low\":\"149.93\",\"4. close\":\"150.35\",\"5. adjusted close\":\"150.35\",\"6. volume\":\"4258133\"},\"2024-10-15\":{\"1. open\":\"150.35\",\"2. high\":\"150.64\",\"3. low\":\"148.28\",\"4. close\":\"149.61\",\"5. adjusted close\":\"149.61\",\"6. volume\":\"3414171\"},\"2024-10-14\":{\"1. open\":\"149.61\",\"2. high\":\"151.33\",\"3. low\":\"149.34\",\"4. close\":\"151.30\",\"5. adjusted close\":\"151.30\",\"6. volume\":\"3804930\"},\"2024-10-11\":{\"1. open\":\"151.30\",\"2. high\":\"152.62\",\"3. low\":\"147.91\",\"4. close\":\"148.82\",\"5. adjusted close\":\"148.82\",\"6. volume\":\"4987494\"},\"2024-10-10\":{\"1. open\":\"148.82\",\"2. high\":\"150.06\",\"3. low\":\"146.50\",\"4. close\":\"147.47\",\"5. adjusted close\":\"147.47\",\"6. volume\":\"4505563\"},\"2024-10-09\":{\"1. open\":\"147.47\",\"2. high\":\"151.00\",\"3. low\":\"146.85\",\"4. close\":\"149.59\",\"5. adjusted close\":\"149.59\",\"6. volume\":\"2901085\"},\"2024-10-08\":{\"1. open\":\"149.59\",\"2. high\":\"149.90\",\"3. low\":\"146.95\",\"4. close\":\"147.26\",\"5. adjusted close\":\"147.26\",\"6. volume\":\"3859477\"},\"2024-10-07\":{\"1. open\":\"147.26\",\"2. high\":\"148.57\",\"3. low\":\"146.00\",\"4. close\":\"146.51\",\"5. adjusted close\":\"146.51\",\"6. volume\":\"1945636\"},\"2024-10-04\":{\"1. open\":\"146.51\",\"2. high\":\"147.81\",\"3. low\":\"142.86\",\"4. close\":\"143.78\",\"5. adjusted close\":\"143.78\",\"6. volume\":\"3731546\"},\"2024-10-03\":{\"1. open\":\"143.78\",\"2. high\":\"144.66\",\"3. low\":\"142.57\",\"4. close\":\"142.70\",\"5. adjusted close\":\"142.70\",\"6. volume\":\"1176722\"},\"2024-10-02\":{\"1. open\":\"142.70\",\"2. high\":\"146.45\",\"3. low\":\"141.80\",\"4. close\":\"145.11\",\"5. adjusted close\":\"145.11\",\"6. volume\":\"3016933\"},\"2024-10-01\":{\"1. open\":\"145.11\",\"2. high\":\"145.89\",\"3. low\":\"142.55\",\"4. close\":\"143.09\",\"5. adjusted close\":\"143.09\",\"6. volume\":\"3442356\"},\"2024-09-30\":{\"1. open\":\"143.09\",\"2. high\":\"145.14\",\"3. low\":\"142.35\",\"4. close\":\"145.04\",\"5. adjusted close\":\"145.04\",\"6. volume\":\"2681746\"},\"2024-09-27\":{\"1. open\":\"145.04\",\"2. high\":\"145.08\",\"3. low\":\"142.03\",\"4. close\":\"142.33\",\"5. adjusted close\":\"142.33\",\"6. volume\":\"4335235\"},\"2024-09-26\":{\"1. open\":\"142.33\",\"2. high\":\"143.78\",\"3. low\":\"141.97\",\"4. close\":\"142.36\",\"5. adjusted close\":\"142.36\",\"6. volume\":\"4777961\"},\"2024-09-25\":{\"1. open\":\"142.36\",\"2. high\":\"142.52\",\"3. low\":\"138.43\",\"4. close\":\"139.73\",\"5. adjusted close\":\"139.73\",\"6. volume\":\"4868319\"},\"2024-09-24\":{\"1. open\":\"139.73\",\"2. high\":\"140.61\",\"3. low\":\"137.74\",\"4. close\":\"138.72\",\"5. adjusted close\":\"138.72\",\"6. volume\":\"1430726\"},\"2024-09-23\":{\"1. open\":\"138.72\",\"2. high\":\"139.05\",\"3. low\":\"135.08\",\"4. close\":\"136.43\",\"5. adjusted close\":\"136.43\",\"6. volume\":\"1391418\"},\"2024-09-20\":{\"1. open\":\"136.43\",\"2. high\":\"136.46\",\"3. low\":\"135.08\",\"4. close\":\"136.42\",\"5. adjusted close\":\"136.42\",\"6. volume\":\"2368560\"}}}'),
('INTC', 'Intel Corporation', 'NASDAQ', 'Technology', 'Semiconductors', 4.5, '2024-06-30', 75, 45, 65, '{\"Time Series (Daily)\":{\"2024-10-31\":{\"1. open\":\"60.00\",\"2. high\":\"61.45\",\"3. low\":\"59.77\",\"4. close\":\"60.92\",\"5. adjusted close\":\"60.92\",\"6. volume\":\"1904011\"},\"2024-10-30\":{\"1. open\":\"60.92\",\"2. high\":\"61.30\",\"3. low\":\"60.28\",\"4. close\":\"60.74\",\"5. adjusted close\":\"60.74\",\"6. volume\":\"2417737\"},\"2024-10-29\":{\"1. open\":\"60.74\",\"2. high\":\"61.26\",\"3. low\":\"59.91\",\"4. close\":\"60.36\",\"5. adjusted close\":\"60.36\",\"6. volume\":\"1993193\"},\"2024-10-28\":{\"1. open\":\"60.36\",\"2. high\":\"60.78\",\"3. low\":\"59.56\",\"4. close\":\"59.79\",\"5. adjusted close\":\"59.79\",\"6. volume\":\"1656101\"},\"2024-10-25\":{\"1. open\":\"59.79\",\"2. high\":\"60.31\",\"3. low\":\"58.41\",\"4. close\":\"58.64\",\"5. adjusted close\":\"58.64\",\"6. volume\":\"2050915\"},\"2024-10-24\":{\"1. open\":\"58.64\",\"2. high\":\"59.57\",\"3. low\":\"58.09\",\"4. close\":\"59.00\",\"5. adjusted close\":\"59.00\",\"6. volume\":\"4281005\"},\"2024-10-23\":{\"1. open\":\"59.00\",\"2. high\":\"59.31\",\"3. low\":\"58.34\",\"4. close\":\"58.44\",\"5. adjusted close\":\"58.44\",\"6. volume\":\"2852197\"},\"2024-10-22\":{\"1. open\":\"58.44\",\"2. high\":\"58.96\",\"3. low\":\"57.59\",\"4. close\":\"58.10\",\"5. adjusted close\":\"58.10\",\"6. volume\":\"2947121\"},\"2024-10-21\":{\"1. open\":\"58.10\",\"2. high\":\"58.11\",\"3. low\":\"57.25\",\"4. close\":\"57.82\",\"5. adjusted close\":\"57.82\",\"6. volume\":\"1345738\"},\"2024-10-18\":{\"1. open\":\"57.82\",\"2. high\":\"58.99\",\"3. low\":\"57.61\",\"4. close\":\"58.61\",\"5. adjusted close\":\"58.61\",\"6. volume\":\"3561844\"},\"2024-10-17\":{\"1. open\":\"58.61\",\"2. high\":\"58.92\",\"3. low\":\"57.96\",\"4. close\":\"58.36\",\"5. adjusted close\":\"58.36\",\"6. volume\":\"1795123\"},\"2024-10-16\":{\"1. open\":\"58.36\",\"2. high\":\"58.82\",\"3. low\":\"57.61\",\"4. close\":\"57.96\",\"5. adjusted close\":\"57.96\",\"6. volume\":\"2966379\"},\"2024-10-15\":{\"1. open\":\"57.96\",\"2. high\":\"58.13\",\"3. low\":\"56.44\",\"4. close\":\"56.80\",\"5. adjusted close\":\"56.80\",\"6. volume\":\"4342389\"},\"2024-10-14\":{\"1. open\":\"56.80\",\"2. high\":\"57.10\",\"3. low\":\"55.29\",\"4. close\":\"55.77\",\"5. adjusted close\":\"55.77\",\"6. volume\":\"1456694\"},\"2024-10-11\":{\"1. open\":\"55.77\",\"2. high\":\"56.29\",\"3. low\":\"55.45\",\"4. close\":\"56.12\",\"5. adjusted close\":\"56.12\",\"6. volume\":\"4888447\"},\"2024-10-10\":{\"1. open\":\"56.12\",\"2. high\":\"56.51\",\"3. low\":\"55.62\",\"4. close\":\"55.82\",\"5. adjusted close\":\"55.82\",\"6. volume\":\"2529255\"},\"2024-10-09\":{\"1. open\":\"55.82\",\"2. high\":\"55.96\",\"3. low\":\"55.17\",\"4. close\":\"55.57\",\"5. adjusted close\":\"55.57\",\"6. volume\":\"1668500\"},\"2024-10-08\":{\"1. open\":\"55.57\",\"2. high\":\"55.76\",\"3. low\":\"54.30\",\"4. close\":\"54.54\",\"5. adjusted close\":\"54.54\",\"6. volume\":\"1816941\"},\"2024-10-07\":{\"1. open\":\"54.54\",\"2. high\":\"54.63\",\"3. low\":\"53.36\",\"4. close\":\"53.73\",\"5. adjusted close\":\"53.73\",\"6. volume\":\"3017100\"},\"2024-10-04\":{\"1. open\":\"53.73\",\"2. high\":\"53.83\",\"3. low\":\"52.85\",\"4. close\":\"53.04\",\"5. adjusted close\":\"53.04\",\"6. volume\":\"3622473\"},\"2024-10-03\":{\"1. open\":\"53.04\",\"2. high\":\"53.36\",\"3. low\":\"52.19\",\"4. close\":\"52.67\",\"5. adjusted close\":\"52.67\",\"6. volume\":\"2824852\"},\"2024-10-02\":{\"1. open\":\"52.67\",\"2. high\":\"53.10\",\"3. low\":\"51.78\",\"4. close\":\"52.05\",\"5. adjusted close\":\"52.05\",\"6. volume\":\"3180269\"},\"2024-10-01\":{\"1. open\":\"52.05\",\"2. high\":\"52.75\",\"3. low\":\"51.83\",\"4. close\":\"52.53\",\"5. adjusted close\":\"52.53\",\"6. volume\":\"1832022\"},\"2024-09-30\":{\"1. open\":\"52.53\",\"2. high\":\"53.37\",\"3. low\":\"52.17\",\"4. close\":\"53.09\",\"5. adjusted close\":\"53.09\",\"6. volume\":\"2951266\"},\"2024-09-27\":{\"1. open\":\"53.09\",\"2. high\":\"53.97\",\"3. low\":\"52.96\",\"4. close\":\"53.62\",\"5. adjusted close\":\"53.62\",\"6. volume\":\"3549676\"},\"2024-09-26\":{\"1. open\":\"53.62\",\"2. high\":\"53.97\",\"3. low\":\"53.20\",\"4. close\":\"53.26\",\"5. adjusted close\":\"53.26\",\"6. volume\":\"2398553\"},\"2024-09-25\":{\"1. open\":\"53.26\",\"2. high\":\"53.49\",\"3. low\":\"52.60\",\"4. close\":\"52.79\",\"5. adjusted close\":\"52.79\",\"6. volume\":\"2413464\"},\"2024-09-24\":{\"1. open\":\"52.79\",\"2. high\":\"52.85\",\"3. low\":\"52.21\",\"4. close\":\"52.29\",\"5. adjusted close\":\"52.29\",\"6. volume\":\"1224336\"},\"2024-09-23\":{\"1. open\":\"52.29\",\"2. high\":\"52.57\",\"3. low\":\"52.26\",\"4. close\":\"52.57\",\"5. adjusted close\":\"52.57\",\"6. volume\":\"4385364\"},\"2024-09-20\":{\"1. open\":\"52.57\",\"2. high\":\"53.34\",\"3. low\":\"52.43\",\"4. close\":\"52.92\",\"5. adjusted close\":\"52.92\",\"6. volume\":\"3744833\"}}}'),
('MSFT', 'Microsoft Corporation', 'NASDAQ', 'Technology', 'Software—Infrastructure', 8.05, '2024-06-30', 350, 250, 330, '{\"Time Series (Daily)\":{\"2024-10-31\":{\"1. open\":\"320.00\",\"2. high\":\"322.34\",\"3. low\":\"314.24\",\"4. close\":\"316.61\",\"5. adjusted close\":\"316.61\",\"6. volume\":\"1659685\"},\"2024-10-30\":{\"1. open\":\"316.61\",\"2. high\":\"318.57\",\"3. low\":\"314.93\",\"4. close\":\"315.66\",\"5. adjusted close\":\"315.66\",\"6. volume\":\"4887506\"},\"2024-10-29\":{\"1. open\":\"315.66\",\"2. high\":\"317.37\",\"3. low\":\"313.99\",\"4. close\":\"316.23\",\"5. adjusted close\":\"316.23\",\"6. volume\":\"2603521\"},\"2024-10-28\":{\"1. open\":\"316.23\",\"2. high\":\"318.32\",\"3. low\":\"313.51\",\"4. close\":\"315.31\",\"5. adjusted close\":\"315.31\",\"6. volume\":\"4535032\"},\"2024-10-25\":{\"1. open\":\"315.31\",\"2. high\":\"318.12\",\"3. low\":\"312.63\",\"4. close\":\"312.85\",\"5. adjusted close\":\"312.85\",\"6. volume\":\"1070404\"},\"2024-10-24\":{\"1. open\":\"312.85\",\"2. high\":\"314.66\",\"3. low\":\"307.03\",\"4. close\":\"309.10\",\"5. adjusted close\":\"309.10\",\"6. volume\":\"1758226\"},\"2024-10-23\":{\"1. open\":\"309.10\",\"2. high\":\"312.28\",\"3. low\":\"307.00\",\"4. close\":\"309.56\",\"5. adjusted close\":\"309.56\",\"6. volume\":\"1037490\"},\"2024-10-22\":{\"1. open\":\"309.56\",\"2. high\":\"313.22\",\"3. low\":\"306.99\",\"4. close\":\"310.27\",\"5. adjusted close\":\"310.27\",\"6. volume\":\"2933394\"},\"2024-10-21\":{\"1. open\":\"310.27\",\"2. high\":\"310.49\",\"3. low\":\"307.48\",\"4. close\":\"308.59\",\"5. adjusted close\":\"308.59\",\"6. volume\":\"2814971\"},\"2024-10-18\":{\"1. open\":\"308.59\",\"2. high\":\"309.17\",\"3. low\":\"307.39\",\"4. close\":\"309.11\",\"5. adjusted close\":\"309.11\",\"6. volume\":\"2198182\"},\"2024-10-17\":{\"1. open\":\"309.11\",\"2. high\":\"310.44\",\"3. low\":\"303.90\",\"4. close\":\"305.34\",\"5. adjusted close\":\"305.34\",\"6. volume\":\"1215431\"},\"2024-10-16\":{\"1. open\":\"305.34\",\"2. high\":\"310.56\",\"3. low\":\"303.14\",\"4. close\":\"308.00\",\"5. adjusted close\":\"308.00\",\"6. volume\":\"2310653\"},\"2024-10-15\":{\"1. open\":\"308.00\",\"2. high\":\"310.87\",\"3. low\":\"307.63\",\"4. close\":\"310.22\",\"5. adjusted close\":\"310.22\",\"6. volume\":\"4791628\"},\"2024-10-14\":{\"1. open\":\"310.22\",\"2. high\":\"316.68\",\"3. low\":\"309.75\",\"4. close\":\"316.30\",\"5. adjusted close\":\"316.30\",\"6. volume\":\"2694962\"},\"2024-10-11\":{\"1. open\":\"316.30\",\"2. high\":\"321.63\",\"3. low\":\"314.91\",\"4. close\":\"320.44\",\"5. adjusted close\":\"320.44\",\"6. volume\":\"2569759\"},\"2024-10-10\":{\"1. open\":\"320.44\",\"2. high\":\"325.32\",\"3. low\":\"318.97\",\"4. close\":\"324.64\",\"5. adjusted close\":\"324.64\",\"6. volume\":\"3585986\"},\"2024-10-09\":{\"1. open\":\"324.64\",\"2. high\":\"328.68\",\"3. low\":\"323.41\",\"4. close\":\"326.75\",\"5. adjusted close\":\"326.75\",\"6. volume\":\"4546040\"},\"2024-10-08\":{\"1. open\":\"326.75\",\"2. high\":\"328.94\",\"3. low\":\"320.80\",\"4. close\":\"323.22\",\"5. adjusted close\":\"323.22\",\"6. volume\":\"1852780\"},\"2024-10-07\":{\"1. open\":\"323.22\",\"2. high\":\"325.94\",\"3. low\":\"318.04\",\"4. close\":\"320.86\",\"5. adjusted close\":\"320.86\",\"6. volume\":\"1205407\"},\"2024-10-04\":{\"1. open\":\"320.86\",\"2. high\":\"323.68\",\"3. low\":\"313.39\",\"4. close\":\"315.47\",\"5. adjusted close\":\"315.47\",\"6. volume\":\"4791033\"},\"2024-10-03\":{\"1. open\":\"315.47\",\"2. high\":\"321.26\",\"3. low\":\"313.55\",\"4. close\":\"319.03\",\"5. adjusted close\":\"319.03\",\"6. volume\":\"4902294\"},\"2024-10-02\":{\"1. open\":\"319.03\",\"2. high\":\"321.23\",\"3. low\":\"312.04\",\"4. close\":\"314.91\",\"5. adjusted close\":\"314.91\",\"6. volume\":\"4469739\"},\"2024-10-01\":{\"1. open\":\"314.91\",\"2. high\":\"319.61\",\"3. low\":\"312.64\",\"4. close\":\"318.34\",\"5. adjusted close\":\"318.34\",\"6. volume\":\"2144860\"},\"2024-09-30\":{\"1. open\":\"318.34\",\"2. high\":\"320.73\",\"3. low\":\"315.13\",\"4. close\":\"317.70\",\"5. adjusted close\":\"317.70\",\"6. volume\":\"4809319\"},\"2024-09-27\":{\"1. open\":\"317.70\",\"2. high\":\"321.58\",\"3. low\":\"317.19\",\"4. close\":\"321.48\",\"5. adjusted close\":\"321.48\",\"6. volume\":\"1288200\"},\"2024-09-26\":{\"1. open\":\"321.48\",\"2. high\":\"327.15\",\"3. low\":\"319.33\",\"4. close\":\"326.46\",\"5. adjusted close\":\"326.46\",\"6. volume\":\"1493486\"},\"2024-09-25\":{\"1. open\":\"326.46\",\"2. high\":\"327.18\",\"3. low\":\"322.72\",\"4. close\":\"324.34\",\"5. adjusted close\":\"324.34\",\"6. volume\":\"2645187\"},\"2024-09-24\":{\"1. open\":\"324.34\",\"2. high\":\"326.19\",\"3. low\":\"316.41\",\"4. close\":\"319.51\",\"5. adjusted close\":\"319.51\",\"6. volume\":\"2395069\"},\"2024-09-23\":{\"1. open\":\"319.51\",\"2. high\":\"328.22\",\"3. low\":\"316.95\",\"4. close\":\"325.36\",\"5. adjusted close\":\"325.36\",\"6. volume\":\"4702261\"},\"2024-09-20\":{\"1. open\":\"325.36\",\"2. high\":\"326.76\",\"3. low\":\"317.05\",\"4. close\":\"319.93\",\"5. adjusted close\":\"319.93\",\"6. volume\":\"2946893\"}}}'),
('NVDA', 'NVIDIA Corporation', 'NASDAQ', 'Technology', 'Semiconductors', 9, '2024-06-30', 300, 150, 250, '{\"Time Series (Daily)\":{\"2024-10-31\":{\"1. open\":\"200.00\",\"2. high\":\"200.94\",\"3. low\":\"197.50\",\"4. close\":\"197.70\",\"5. adjusted close\":\"197.70\",\"6. volume\":\"4868767\"},\"2024-10-30\":{\"1. open\":\"197.70\",\"2. high\":\"200.36\",\"3. low\":\"197.25\",\"4. close\":\"199.80\",\"5. adjusted close\":\"199.80\",\"6. volume\":\"4256110\"},\"2024-10-29\":{\"1. open\":\"199.80\",\"2. high\":\"201.50\",\"3. low\":\"197.88\",\"4. close\":\"198.06\",\"5. adjusted close\":\"198.06\",\"6. volume\":\"1180638\"},\"2024-10-28\":{\"1. open\":\"198.06\",\"2. high\":\"199.83\",\"3. low\":\"196.85\",\"4. close\":\"199.09\",\"5. adjusted close\":\"199.09\",\"6. volume\":\"3026040\"},\"2024-10-25\":{\"1. open\":\"199.09\",\"2. high\":\"199.43\",\"3. low\":\"195.87\",\"4. close\":\"196.68\",\"5. adjusted close\":\"196.68\",\"6. volume\":\"1314908\"},\"2024-10-24\":{\"1. open\":\"196.68\",\"2. high\":\"198.39\",\"3. low\":\"195.01\",\"4. close\":\"195.83\",\"5. adjusted close\":\"195.83\",\"6. volume\":\"4321927\"},\"2024-10-23\":{\"1. open\":\"195.83\",\"2. high\":\"198.81\",\"3. low\":\"194.20\",\"4. close\":\"198.18\",\"5. adjusted close\":\"198.18\",\"6. volume\":\"1310892\"},\"2024-10-22\":{\"1. open\":\"198.18\",\"2. high\":\"200.45\",\"3. low\":\"197.07\",\"4. close\":\"199.49\",\"5. adjusted close\":\"199.49\",\"6. volume\":\"4355498\"},\"2024-10-21\":{\"1. open\":\"199.49\",\"2. high\":\"202.49\",\"3. low\":\"199.07\",\"4. close\":\"201.66\",\"5. adjusted close\":\"201.66\",\"6. volume\":\"4960858\"},\"2024-10-18\":{\"1. open\":\"201.66\",\"2. high\":\"206.92\",\"3. low\":\"201.16\",\"4. close\":\"204.93\",\"5. adjusted close\":\"204.93\",\"6. volume\":\"1742958\"},\"2024-10-17\":{\"1. open\":\"204.93\",\"2. high\":\"205.85\",\"3. low\":\"202.01\",\"4. close\":\"203.56\",\"5. adjusted close\":\"203.56\",\"6. volume\":\"1635783\"},\"2024-10-16\":{\"1. open\":\"203.56\",\"2. high\":\"204.25\",\"3. low\":\"199.65\",\"4. close\":\"201.42\",\"5. adjusted close\":\"201.42\",\"6. volume\":\"3876663\"},\"2024-10-15\":{\"1. open\":\"201.42\",\"2. high\":\"204.01\",\"3. low\":\"199.95\",\"4. close\":\"202.97\",\"5. adjusted close\":\"202.97\",\"6. volume\":\"2979849\"},\"2024-10-14\":{\"1. open\":\"202.97\",\"2. high\":\"207.13\",\"3. low\":\"202.22\",\"4. close\":\"205.67\",\"5. adjusted close\":\"205.67\",\"6. volume\":\"4480210\"},\"2024-10-11\":{\"1. open\":\"205.67\",\"2. high\":\"206.88\",\"3. low\":\"202.45\",\"4. close\":\"203.16\",\"5. adjusted close\":\"203.16\",\"6. volume\":\"1131263\"},\"2024-10-10\":{\"1. open\":\"203.16\",\"2. high\":\"205.30\",\"3. low\":\"201.41\",\"4. close\":\"204.54\",\"5. adjusted close\":\"204.54\",\"6. volume\":\"3246066\"},\"2024-10-09\":{\"1. open\":\"204.54\",\"2. high\":\"206.14\",\"3. low\":\"201.68\",\"4. close\":\"202.21\",\"5. adjusted close\":\"202.21\",\"6. volume\":\"3994895\"},\"2024-10-08\":{\"1. open\":\"202.21\",\"2. high\":\"207.13\",\"3. low\":\"201.16\",\"4. close\":\"205.69\",\"5. adjusted close\":\"205.69\",\"6. volume\":\"4663451\"},\"2024-10-07\":{\"1. open\":\"205.69\",\"2. high\":\"208.43\",\"3. low\":\"205.61\",\"4. close\":\"206.82\",\"5. adjusted close\":\"206.82\",\"6. volume\":\"3749276\"},\"2024-10-04\":{\"1. open\":\"206.82\",\"2. high\":\"207.69\",\"3. low\":\"204.76\",\"4. close\":\"206.47\",\"5. adjusted close\":\"206.47\",\"6. volume\":\"1067826\"},\"2024-10-03\":{\"1. open\":\"206.47\",\"2. high\":\"210.41\",\"3. low\":\"204.86\",\"4. close\":\"209.03\",\"5. adjusted close\":\"209.03\",\"6. volume\":\"4222761\"},\"2024-10-02\":{\"1. open\":\"209.03\",\"2. high\":\"210.93\",\"3. low\":\"207.00\",\"4. close\":\"208.99\",\"5. adjusted close\":\"208.99\",\"6. volume\":\"1142885\"},\"2024-10-01\":{\"1. open\":\"208.99\",\"2. high\":\"213.95\",\"3. low\":\"207.23\",\"4. close\":\"212.29\",\"5. adjusted close\":\"212.29\",\"6. volume\":\"1570459\"},\"2024-09-30\":{\"1. open\":\"212.29\",\"2. high\":\"213.73\",\"3. low\":\"209.14\",\"4. close\":\"211.23\",\"5. adjusted close\":\"211.23\",\"6. volume\":\"2709873\"},\"2024-09-27\":{\"1. open\":\"211.23\",\"2. high\":\"215.08\",\"3. low\":\"210.91\",\"4. close\":\"214.69\",\"5. adjusted close\":\"214.69\",\"6. volume\":\"1931724\"},\"2024-09-26\":{\"1. open\":\"214.69\",\"2. high\":\"216.60\",\"3. low\":\"210.97\",\"4. close\":\"212.07\",\"5. adjusted close\":\"212.07\",\"6. volume\":\"3592057\"},\"2024-09-25\":{\"1. open\":\"212.07\",\"2. high\":\"212.90\",\"3. low\":\"209.59\",\"4. close\":\"209.63\",\"5. adjusted close\":\"209.63\",\"6. volume\":\"3374175\"},\"2024-09-24\":{\"1. open\":\"209.63\",\"2. high\":\"211.48\",\"3. low\":\"207.95\",\"4. close\":\"210.99\",\"5. adjusted close\":\"210.99\",\"6. volume\":\"2360033\"},\"2024-09-23\":{\"1. open\":\"210.99\",\"2. high\":\"215.04\",\"3. low\":\"209.51\",\"4. close\":\"213.44\",\"5. adjusted close\":\"213.44\",\"6. volume\":\"3548037\"},\"2024-09-20\":{\"1. open\":\"213.44\",\"2. high\":\"216.63\",\"3. low\":\"213.40\",\"4. close\":\"214.59\",\"5. adjusted close\":\"214.59\",\"6. volume\":\"1083116\"}}}'),
('T', 'AT&T Inc.', 'NYSE', 'Telecom', 'Telecom Services', 2.1, '2024-06-30', 35, 25, 30, '{\"Time Series (Daily)\":{\"2024-10-31\":{\"1. open\":\"28.00\",\"2. high\":\"28.20\",\"3. low\":\"27.72\",\"4. close\":\"28.15\",\"5. adjusted close\":\"28.15\",\"6. volume\":\"3902478\"},\"2024-10-30\":{\"1. open\":\"28.15\",\"2. high\":\"28.61\",\"3. low\":\"28.10\",\"4. close\":\"28.50\",\"5. adjusted close\":\"28.50\",\"6. volume\":\"2431648\"},\"2024-10-29\":{\"1. open\":\"28.50\",\"2. high\":\"28.50\",\"3. low\":\"28.31\",\"4. close\":\"28.32\",\"5. adjusted close\":\"28.32\",\"6. volume\":\"2352714\"},\"2024-10-28\":{\"1. open\":\"28.32\",\"2. high\":\"28.67\",\"3. low\":\"28.11\",\"4. close\":\"28.55\",\"5. adjusted close\":\"28.55\",\"6. volume\":\"2735947\"},\"2024-10-25\":{\"1. open\":\"28.55\",\"2. high\":\"28.74\",\"3. low\":\"28.55\",\"4. close\":\"28.69\",\"5. adjusted close\":\"28.69\",\"6. volume\":\"1540702\"},\"2024-10-24\":{\"1. open\":\"28.69\",\"2. high\":\"28.83\",\"3. low\":\"28.18\",\"4. close\":\"28.37\",\"5. adjusted close\":\"28.37\",\"6. volume\":\"4970223\"},\"2024-10-23\":{\"1. open\":\"28.37\",\"2. high\":\"29.09\",\"3. low\":\"28.29\",\"4. close\":\"28.85\",\"5. adjusted close\":\"28.85\",\"6. volume\":\"4286599\"},\"2024-10-22\":{\"1. open\":\"28.85\",\"2. high\":\"28.96\",\"3. low\":\"28.66\",\"4. close\":\"28.67\",\"5. adjusted close\":\"28.67\",\"6. volume\":\"2424561\"},\"2024-10-21\":{\"1. open\":\"28.67\",\"2. high\":\"29.19\",\"3. low\":\"28.46\",\"4. close\":\"29.10\",\"5. adjusted close\":\"29.10\",\"6. volume\":\"4176660\"},\"2024-10-18\":{\"1. open\":\"29.10\",\"2. high\":\"29.32\",\"3. low\":\"28.51\",\"4. close\":\"28.74\",\"5. adjusted close\":\"28.74\",\"6. volume\":\"3866620\"},\"2024-10-17\":{\"1. open\":\"28.74\",\"2. high\":\"28.74\",\"3. low\":\"28.40\",\"4. close\":\"28.63\",\"5. adjusted close\":\"28.63\",\"6. volume\":\"1836681\"},\"2024-10-16\":{\"1. open\":\"28.63\",\"2. high\":\"29.23\",\"3. low\":\"28.52\",\"4. close\":\"29.03\",\"5. adjusted close\":\"29.03\",\"6. volume\":\"4924620\"},\"2024-10-15\":{\"1. open\":\"29.03\",\"2. high\":\"29.47\",\"3. low\":\"28.99\",\"4. close\":\"29.18\",\"5. adjusted close\":\"29.18\",\"6. volume\":\"2458153\"},\"2024-10-14\":{\"1. open\":\"29.18\",\"2. high\":\"29.19\",\"3. low\":\"28.82\",\"4. close\":\"29.11\",\"5. adjusted close\":\"29.11\",\"6. volume\":\"2245953\"},\"2024-10-11\":{\"1. open\":\"29.11\",\"2. high\":\"29.19\",\"3. low\":\"28.50\",\"4. close\":\"28.74\",\"5. adjusted close\":\"28.74\",\"6. volume\":\"3526474\"},\"2024-10-10\":{\"1. open\":\"28.74\",\"2. high\":\"28.99\",\"3. low\":\"28.62\",\"4. close\":\"28.89\",\"5. adjusted close\":\"28.89\",\"6. volume\":\"3865452\"},\"2024-10-09\":{\"1. open\":\"28.89\",\"2. high\":\"29.14\",\"3. low\":\"28.14\",\"4. close\":\"28.36\",\"5. adjusted close\":\"28.36\",\"6. volume\":\"2645013\"},\"2024-10-08\":{\"1. open\":\"28.36\",\"2. high\":\"28.71\",\"3. low\":\"28.20\",\"4. close\":\"28.69\",\"5. adjusted close\":\"28.69\",\"6. volume\":\"1999429\"},\"2024-10-07\":{\"1. open\":\"28.69\",\"2. high\":\"28.84\",\"3. low\":\"28.46\",\"4. close\":\"28.57\",\"5. adjusted close\":\"28.57\",\"6. volume\":\"3617254\"},\"2024-10-04\":{\"1. open\":\"28.57\",\"2. high\":\"29.15\",\"3. low\":\"28.40\",\"4. close\":\"29.01\",\"5. adjusted close\":\"29.01\",\"6. volume\":\"1452744\"},\"2024-10-03\":{\"1. open\":\"29.01\",\"2. high\":\"29.15\",\"3. low\":\"28.76\",\"4. close\":\"28.80\",\"5. adjusted close\":\"28.80\",\"6. volume\":\"2543593\"},\"2024-10-02\":{\"1. open\":\"28.80\",\"2. high\":\"29.09\",\"3. low\":\"28.50\",\"4. close\":\"28.53\",\"5. adjusted close\":\"28.53\",\"6. volume\":\"3985295\"},\"2024-10-01\":{\"1. open\":\"28.53\",\"2. high\":\"28.63\",\"3. low\":\"28.31\",\"4. close\":\"28.48\",\"5. adjusted close\":\"28.48\",\"6. volume\":\"3951021\"},\"2024-09-30\":{\"1. open\":\"28.48\",\"2. high\":\"28.75\",\"3. low\":\"28.45\",\"4. close\":\"28.48\",\"5. adjusted close\":\"28.48\",\"6. volume\":\"3549144\"},\"2024-09-27\":{\"1. open\":\"28.48\",\"2. high\":\"28.96\",\"3. low\":\"28.31\",\"4. close\":\"28.82\",\"5. adjusted close\":\"28.82\",\"6. volume\":\"3748909\"},\"2024-09-26\":{\"1. open\":\"28.82\",\"2. high\":\"29.30\",\"3. low\":\"28.67\",\"4. close\":\"29.13\",\"5. adjusted close\":\"29.13\",\"6. volume\":\"3945665\"},\"2024-09-25\":{\"1. open\":\"29.13\",\"2. high\":\"29.20\",\"3. low\":\"28.31\",\"4. close\":\"28.57\",\"5. adjusted close\":\"28.57\",\"6. volume\":\"1546641\"},\"2024-09-24\":{\"1. open\":\"28.57\",\"2. high\":\"28.82\",\"3. low\":\"28.35\",\"4. close\":\"28.44\",\"5. adjusted close\":\"28.44\",\"6. volume\":\"3092719\"},\"2024-09-23\":{\"1. open\":\"28.44\",\"2. high\":\"28.47\",\"3. low\":\"28.25\",\"4. close\":\"28.29\",\"5. adjusted close\":\"28.29\",\"6. volume\":\"2003728\"},\"2024-09-20\":{\"1. open\":\"28.29\",\"2. high\":\"28.46\",\"3. low\":\"28.26\",\"4. close\":\"28.31\",\"5. adjusted close\":\"28.31\",\"6. volume\":\"3640740\"}}}');
INSERT INTO `stockInfo` (`Symbol`, `Name`, `Exchange`, `Sector`, `Industry`, `EPS`, `LatestQuarter`, `52WeekHigh`, `52WeekLow`, `AnalystTargetPrice`, `TimeSeries`) VALUES
('TSLA', 'Tesla, Inc.', 'NASDAQ', 'Consumer Cyclical', 'Auto Manufacturers', 3.56, '2024-06-30', 1200, 650, 900, '{\"Time Series (Daily)\":{\"2024-10-31\":{\"1. open\":\"800.00\",\"2. high\":\"800.48\",\"3. low\":\"784.08\",\"4. close\":\"792.00\",\"5. adjusted close\":\"792.00\",\"6. volume\":\"3472215\"},\"2024-10-30\":{\"1. open\":\"792.00\",\"2. high\":\"798.34\",\"3. low\":\"787.49\",\"4. close\":\"790.02\",\"5. adjusted close\":\"790.02\",\"6. volume\":\"3181474\"},\"2024-10-29\":{\"1. open\":\"790.02\",\"2. high\":\"797.60\",\"3. low\":\"780.80\",\"4. close\":\"782.44\",\"5. adjusted close\":\"782.44\",\"6. volume\":\"1246072\"},\"2024-10-28\":{\"1. open\":\"782.44\",\"2. high\":\"789.17\",\"3. low\":\"768.88\",\"4. close\":\"776.57\",\"5. adjusted close\":\"776.57\",\"6. volume\":\"2892263\"},\"2024-10-25\":{\"1. open\":\"776.57\",\"2. high\":\"796.70\",\"3. low\":\"771.60\",\"4. close\":\"791.32\",\"5. adjusted close\":\"791.32\",\"6. volume\":\"3825356\"},\"2024-10-24\":{\"1. open\":\"791.32\",\"2. high\":\"793.30\",\"3. low\":\"786.58\",\"4. close\":\"789.90\",\"5. adjusted close\":\"789.90\",\"6. volume\":\"1217504\"},\"2024-10-23\":{\"1. open\":\"789.90\",\"2. high\":\"798.68\",\"3. low\":\"787.77\",\"4. close\":\"791.48\",\"5. adjusted close\":\"791.48\",\"6. volume\":\"4367739\"},\"2024-10-22\":{\"1. open\":\"791.48\",\"2. high\":\"799.32\",\"3. low\":\"781.06\",\"4. close\":\"783.57\",\"5. adjusted close\":\"783.57\",\"6. volume\":\"3068048\"},\"2024-10-21\":{\"1. open\":\"783.57\",\"2. high\":\"788.11\",\"3. low\":\"775.29\",\"4. close\":\"780.36\",\"5. adjusted close\":\"780.36\",\"6. volume\":\"4570218\"},\"2024-10-18\":{\"1. open\":\"780.36\",\"2. high\":\"781.06\",\"3. low\":\"760.57\",\"4. close\":\"766.39\",\"5. adjusted close\":\"766.39\",\"6. volume\":\"4222214\"},\"2024-10-17\":{\"1. open\":\"766.39\",\"2. high\":\"777.07\",\"3. low\":\"760.72\",\"4. close\":\"772.67\",\"5. adjusted close\":\"772.67\",\"6. volume\":\"4356820\"},\"2024-10-16\":{\"1. open\":\"772.67\",\"2. high\":\"777.54\",\"3. low\":\"761.12\",\"4. close\":\"766.10\",\"5. adjusted close\":\"766.10\",\"6. volume\":\"3402945\"},\"2024-10-15\":{\"1. open\":\"766.10\",\"2. high\":\"781.33\",\"3. low\":\"760.35\",\"4. close\":\"777.21\",\"5. adjusted close\":\"777.21\",\"6. volume\":\"3587483\"},\"2024-10-14\":{\"1. open\":\"777.21\",\"2. high\":\"798.24\",\"3. low\":\"773.79\",\"4. close\":\"791.20\",\"5. adjusted close\":\"791.20\",\"6. volume\":\"3060255\"},\"2024-10-11\":{\"1. open\":\"791.20\",\"2. high\":\"798.08\",\"3. low\":\"771.52\",\"4. close\":\"777.43\",\"5. adjusted close\":\"777.43\",\"6. volume\":\"4847043\"},\"2024-10-10\":{\"1. open\":\"777.43\",\"2. high\":\"786.32\",\"3. low\":\"772.38\",\"4. close\":\"782.17\",\"5. adjusted close\":\"782.17\",\"6. volume\":\"4621633\"},\"2024-10-09\":{\"1. open\":\"782.17\",\"2. high\":\"789.36\",\"3. low\":\"777.95\",\"4. close\":\"782.40\",\"5. adjusted close\":\"782.40\",\"6. volume\":\"3265915\"},\"2024-10-08\":{\"1. open\":\"782.40\",\"2. high\":\"789.91\",\"3. low\":\"773.56\",\"4. close\":\"774.18\",\"5. adjusted close\":\"774.18\",\"6. volume\":\"4996816\"},\"2024-10-07\":{\"1. open\":\"774.18\",\"2. high\":\"780.08\",\"3. low\":\"771.70\",\"4. close\":\"778.83\",\"5. adjusted close\":\"778.83\",\"6. volume\":\"4313469\"},\"2024-10-04\":{\"1. open\":\"778.83\",\"2. high\":\"783.04\",\"3. low\":\"769.13\",\"4. close\":\"772.68\",\"5. adjusted close\":\"772.68\",\"6. volume\":\"1986184\"},\"2024-10-03\":{\"1. open\":\"772.68\",\"2. high\":\"776.70\",\"3. low\":\"767.43\",\"4. close\":\"773.99\",\"5. adjusted close\":\"773.99\",\"6. volume\":\"3238124\"},\"2024-10-02\":{\"1. open\":\"773.99\",\"2. high\":\"781.36\",\"3. low\":\"769.35\",\"4. close\":\"779.49\",\"5. adjusted close\":\"779.49\",\"6. volume\":\"3041297\"},\"2024-10-01\":{\"1. open\":\"779.49\",\"2. high\":\"786.66\",\"3. low\":\"771.87\",\"4. close\":\"776.22\",\"5. adjusted close\":\"776.22\",\"6. volume\":\"3178789\"},\"2024-09-30\":{\"1. open\":\"776.22\",\"2. high\":\"789.86\",\"3. low\":\"772.26\",\"4. close\":\"784.29\",\"5. adjusted close\":\"784.29\",\"6. volume\":\"1005376\"},\"2024-09-27\":{\"1. open\":\"784.29\",\"2. high\":\"791.90\",\"3. low\":\"768.64\",\"4. close\":\"770.80\",\"5. adjusted close\":\"770.80\",\"6. volume\":\"1920855\"},\"2024-09-26\":{\"1. open\":\"770.80\",\"2. high\":\"785.03\",\"3. low\":\"765.71\",\"4. close\":\"781.05\",\"5. adjusted close\":\"781.05\",\"6. volume\":\"1976388\"},\"2024-09-25\":{\"1. open\":\"781.05\",\"2. high\":\"790.76\",\"3. low\":\"780.35\",\"4. close\":\"784.33\",\"5. adjusted close\":\"784.33\",\"6. volume\":\"4928054\"},\"2024-09-24\":{\"1. open\":\"784.33\",\"2. high\":\"791.08\",\"3. low\":\"781.59\",\"4. close\":\"781.98\",\"5. adjusted close\":\"781.98\",\"6. volume\":\"2734705\"},\"2024-09-23\":{\"1. open\":\"781.98\",\"2. high\":\"787.38\",\"3. low\":\"763.77\",\"4. close\":\"768.61\",\"5. adjusted close\":\"768.61\",\"6. volume\":\"4970779\"},\"2024-09-20\":{\"1. open\":\"768.61\",\"2. high\":\"770.38\",\"3. low\":\"765.84\",\"4. close\":\"768.53\",\"5. adjusted close\":\"768.53\",\"6. volume\":\"2506061\"}}}');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `stockInfo`
--
ALTER TABLE `stockInfo`
ADD PRIMARY KEY (`Symbol`);
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;