PREVIEW / stock_daily / 2022-09-29

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-29.parquet
  size:    251 KB
  rows:    7,897
  symbols: 2,221

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-09-29	AAPL	Stock	146.1	146.72	140.68	142.48	128138200.0
2022-09-29	MSFT	Stock	238.89	239.95	234.41	237.5	27484200.0
2022-09-29	NVDA	Stock	12.448	12.5	11.946	12.22	532763000.0
2022-09-29	AMZN	Stock	115.6	116.07	113.06	114.8	58969700.0
2022-09-29	GOOGL	Stock	98.64	98.64	95.96	97.42	31047224.0
2022-09-29	META	Stock	139.36	139.84	135.2	136.41	38985400.0
2022-09-29	TSLA	Stock	282.76	283.65	265.78	268.21	77620600.0
2022-09-29	TLT	Stock	102.9	104.225	102.8	103.79	19127141.0
2022-09-29	ES	Stock	82.8	82.8	79.49	79.58	1349800.0
2022-09-29	CL	Stock	72.92	73.2	71.24	71.77	4617200.0
2022-09-29	A	Stock	122.81	124.24	122.28	122.74	1312800.0
2022-09-29	AA	Stock	37.15	37.55	34.27	35.43	13168100.0
2022-09-29	AAC-DELISTED	Stock	9.92	9.93	9.915	9.92	1762856.0
2022-09-29	AACG	Stock	1.75	1.76	1.75	1.76	3100.0
2022-09-29	AAIC-DELISTED	Stock	2.76	2.7705	2.65	2.66	73807.0
2022-09-29	AAIC.C-DELISTED	Stock	19.21	19.21	17.625	17.84	11281.0
2022-09-29	AAL	Stock	12.53	12.55	12.09	12.25	34402800.0
2022-09-29	AAM.A-DELISTED	Stock	23.46	23.85	23.1166	23.72	23568.0
2022-09-29	AAM.B-DELISTED	Stock	23.53	23.99	23.0001	23.78	29444.0
2022-09-29	AAME	Stock	2.93	2.98	2.85	2.98	2400.0
2022-09-29	AAMI	Stock	15.35	15.6	15.0	15.33	316500.0
2022-09-29	AAN-DELISTED	Stock	10.54	10.55	10.1	10.51	323400.0
2022-09-29	AAOI	Stock	2.9	2.94	2.61	2.66	376200.0
2022-09-29	AAON	Stock	36.5867	36.78	35.62	36.2267	245700.0
2022-09-29	AAP	Stock	160.86	161.54	158.73	159.66	404500.0
2022-09-29	AAQC-DELISTED	Stock	9.82	9.82	9.81	9.81	1060.0
2022-09-29	AAT	Stock	25.15	25.29	24.59	25.18	420100.0
2022-09-29	AATC	Stock	4.56	4.7299	4.5585	4.56	8756.0
2022-09-29	AAU-DELISTED	Stock	0.2147	0.22	0.21	0.2132	112880.0
2022-09-29	AAUAF-DELISTED	Stock	0.2147	0.22	0.21	0.213	158989.0
2022-09-29	AAWW-DELISTED	Stock	95.81	96.07	94.76	95.5	660321.0
2022-09-29	AAXJ	Stock	59.1	59.16	58.475	58.87	1235570.0
2022-09-29	AB	Stock	36.41	36.5	35.35	35.66	349100.0
2022-09-29	ABB-DELISTED	Stock	25.76	25.96	25.5	25.95	1927732.0
2022-09-29	ABBNY-DELISTED	Stock	25.76	25.96	25.5	25.95	2072481.0
2022-09-29	ABBV	Stock	144.85	145.25	141.83	142.72	5509400.0
2022-09-29	ABC-DELISTED	Stock	138.4	138.4	135.255	135.95	692353.0
2022-09-29	ABCB	Stock	45.13	45.13	44.47	44.92	367500.0
2022-09-29	ABCL	Stock	9.82	9.905	9.575	9.85	1913300.0
2022-09-29	ABCM-DELISTED	Stock	14.5	14.68	14.33	14.65	156766.0
2022-09-29	ABEO	Stock	3.04	3.08	2.9	2.96	73500.0
2022-09-29	ABEV	Stock	2.87	2.89	2.82	2.86	46118900.0
2022-09-29	ABG	Stock	146.73	149.0	140.7	147.0	899600.0
2022-09-29	ABM	Stock	38.55	38.65	37.97	38.57	272800.0
2022-09-29	ABMD-DELISTED	Stock	246.69	249.86	243.52	249.1	273560.0
2022-09-29	ABNB	Stock	109.19	109.475	105.17	106.66	4259500.0
2022-09-29	ABOS	Stock	8.54	10.65	8.51	10.48	10208000.0
2022-09-29	ABR	Stock	12.2	12.32	11.44	11.58	4561300.0
2022-09-29	ABR.D	Stock	19.1556	19.59	19.039	19.59	18632.0
2022-09-29	ABR.E	Stock	18.6499	19.2399	18.58	19.2	5767.0

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

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