PREVIEW / stock_daily / 2022-07-06

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-06.parquet
  size:    254 KB
  rows:    7,922
  symbols: 2,308

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2022-07-06	AAPL	Stock	141.35	144.12	141.08	142.92	74064300.0
2022-07-06	MSFT	Stock	263.75	267.99	262.4	266.21	23824400.0
2022-07-06	NVDA	Stock	15.01	15.319	14.789	15.13	529066000.0
2022-07-06	AMZN	Stock	113.21	115.48	112.01	114.33	66958900.0
2022-07-06	GOOGL	Stock	113.302	115.5895	111.476	114.572	37431380.0
2022-07-06	META	Stock	168.2	171.59	165.46	169.77	23085900.0
2022-07-06	TSLA	Stock	230.78	234.5633	227.1867	231.7333	71853600.0
2022-07-06	TLT	Stock	117.39	117.54	114.77	114.77	20205365.0
2022-07-06	ES	Stock	83.78	84.96	83.05	84.15	1448500.0
2022-07-06	CL	Stock	81.4	81.97	80.95	81.02	4797900.0
2022-07-06	A	Stock	120.8	122.34	120.56	121.18	1642300.0
2022-07-06	AA	Stock	41.89	43.12	40.65	42.63	8640700.0
2022-07-06	AAC-DELISTED	Stock	9.82	9.845	9.82	9.84	53972.0
2022-07-06	AACG	Stock	1.06	1.11	1.06	1.1	6300.0
2022-07-06	AACIU	Stock	9.96	9.96	9.96	9.96	300.0
2022-07-06	AACIW-DELISTED	Stock	0.19	0.195	0.1869	0.19	17500.0
2022-07-06	AAIC-DELISTED	Stock	3.2003	3.2003	3.1109	3.12	22548.0
2022-07-06	AAIC.C-DELISTED	Stock	21.52	21.8499	20.43	20.86	14547.0
2022-07-06	AAL	Stock	13.75	14.09	13.64	13.89	30792600.0
2022-07-06	AAM.A-DELISTED	Stock	24.27	24.2986	23.85	23.85	11188.0
2022-07-06	AAM.B-DELISTED	Stock	25.0	25.08	24.5726	24.5726	7033.0
2022-07-06	AAMC-DELISTED	Stock	2.9779	3.1294	2.9735	3.1294	6361.0
2022-07-06	AAME	Stock	2.47	2.75	2.47	2.73	25200.0
2022-07-06	AAMI	Stock	18.1	18.16	17.73	17.85	288600.0
2022-07-06	AAN-DELISTED	Stock	15.2	15.44	14.43	14.6	375200.0
2022-07-06	AAOI	Stock	1.52	1.58	1.5	1.53	224400.0
2022-07-06	AAON	Stock	38.0067	38.1733	37.0267	37.2933	282450.0
2022-07-06	AAP	Stock	182.45	183.75	179.02	181.77	735800.0
2022-07-06	AAQC-DELISTED	Stock	9.77	9.77	9.76	9.77	15919.0
2022-07-06	AAT	Stock	30.35	30.67	29.82	29.9	255900.0
2022-07-06	AATC	Stock	5.36	5.39	5.338	5.338	2855.0
2022-07-06	AAU-DELISTED	Stock	0.2151	0.2277	0.2151	0.2276	171587.0
2022-07-06	AAUAF-DELISTED	Stock	0.2151	0.2277	0.2151	0.2188	173993.0
2022-07-06	AAWW-DELISTED	Stock	61.37	61.96	58.78	59.05	283495.0
2022-07-06	AAXJ	Stock	67.96	68.09	67.34	67.86	1289969.0
2022-07-06	AB	Stock	41.71	42.11	40.68	41.15	254400.0
2022-07-06	ABB-DELISTED	Stock	26.14	26.475	26.005	26.355	1897944.0
2022-07-06	ABBNY-DELISTED	Stock	26.14	26.475	26.005	26.37	2062088.0
2022-07-06	ABBV	Stock	154.61	154.99	151.69	152.53	5113600.0
2022-07-06	ABC-DELISTED	Stock	140.29	141.73	139.54	139.84	1160131.0
2022-07-06	ABCB	Stock	40.94	41.56	40.56	41.19	479400.0
2022-07-06	ABCL	Stock	10.37	10.84	10.31	10.58	1870000.0
2022-07-06	ABCM-DELISTED	Stock	15.03	15.15	14.91	15.1	96354.0
2022-07-06	ABEO	Stock	3.97	4.18	3.75	3.8	192600.0
2022-07-06	ABEV	Stock	2.59	2.61	2.55	2.59	36028100.0
2022-07-06	ABG	Stock	176.58	178.45	166.87	169.4	193900.0
2022-07-06	ABGI-DELISTED	Stock	9.8	9.8	9.8	9.8	6570.0
2022-07-06	ABM	Stock	42.22	42.63	41.59	42.2	307400.0
2022-07-06	ABMD-DELISTED	Stock	258.3	258.49	251.66	253.18	147441.0
2022-07-06	ABNB	Stock	95.29	96.17	91.8	92.88	5703000.0

> showing 50 of 7,922 rows — these rows as CSV

> unlock the full archive -- $79 one-time