PREVIEW / stock_daily / 2022-09-19

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-19.parquet
  size:    251 KB
  rows:    7,889
  symbols: 2,224

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-19	AAPL	Stock	149.31	154.56	149.1	154.48	81474200.0
2022-09-19	MSFT	Stock	242.47	245.14	240.85	244.52	26826900.0
2022-09-19	NVDA	Stock	13.012	13.463	13.01	13.382	569685000.0
2022-09-19	AMZN	Stock	122.16	124.71	121.8	124.66	47279700.0
2022-09-19	GOOGL	Stock	101.75	103.33	101.55	103.07	23036811.0
2022-09-19	META	Stock	145.24	148.58	145.1	148.02	22169500.0
2022-09-19	TSLA	Stock	300.09	309.84	297.8	309.07	60231200.0
2022-09-19	TLT	Stock	106.96	107.82	106.8	107.32	11084426.0
2022-09-19	ES	Stock	88.51	89.58	88.07	89.53	1240300.0
2022-09-19	CL	Stock	75.48	76.08	75.44	76.01	3646200.0
2022-09-19	A	Stock	128.79	130.79	128.36	130.72	1059600.0
2022-09-19	AA	Stock	41.25	45.12	41.093	44.63	6567000.0
2022-09-19	AAC-DELISTED	Stock	9.93	9.94	9.92	9.93	2518406.0
2022-09-19	AACG	Stock	1.85	1.87	1.8	1.82	7300.0
2022-09-19	AACIW-DELISTED	Stock	0.18	0.18	0.1257	0.15	3831.0
2022-09-19	AAIC-DELISTED	Stock	3.07	3.13	3.07	3.115	39439.0
2022-09-19	AAIC.C-DELISTED	Stock	20.8	20.8	19.9	20.12	29889.0
2022-09-19	AAL	Stock	13.6	14.3	13.6	14.21	25403200.0
2022-09-19	AAM.A-DELISTED	Stock	23.92	24.1108	23.55	24.1108	27966.0
2022-09-19	AAM.B-DELISTED	Stock	23.71	24.0576	23.69	23.71	13677.0
2022-09-19	AAMC-DELISTED	Stock	5.3382	5.4618	5.3103	5.3382	11659.0
2022-09-19	AAME	Stock	3.04	3.07	3.04	3.04	1400.0
2022-09-19	AAMI	Stock	16.51	17.355	16.485	17.35	269600.0
2022-09-19	AAN-DELISTED	Stock	12.07	12.36	11.86	12.16	507200.0
2022-09-19	AAOI	Stock	3.57	3.68	3.38	3.66	5167100.0
2022-09-19	AAON	Stock	37.96	38.96	37.5	38.8867	178050.0
2022-09-19	AAP	Stock	167.44	169.68	165.01	168.18	993000.0
2022-09-19	AAQC-DELISTED	Stock	9.8	9.82	9.8	9.81	5301.0
2022-09-19	AAT	Stock	27.21	27.36	26.89	27.21	576000.0
2022-09-19	AATC	Stock	5.17	5.17	5.05	5.08	3179.0
2022-09-19	AAU-DELISTED	Stock	0.2115	0.2201	0.2101	0.22	145152.0
2022-09-19	AAUAF-DELISTED	Stock	0.2115	0.2201	0.2101	0.22	147205.0
2022-09-19	AAWW-DELISTED	Stock	99.51	99.9	98.8	99.2	554081.0
2022-09-19	AAXJ	Stock	63.53	64.16	63.53	64.12	837124.0
2022-09-19	AB	Stock	41.53	42.38	41.51	42.27	117800.0
2022-09-19	ABB-DELISTED	Stock	26.64	27.415	26.61	27.39	1801732.0
2022-09-19	ABBNY-DELISTED	Stock	26.64	27.415	26.61	27.39	1959560.0
2022-09-19	ABBV	Stock	143.64	143.86	141.43	142.66	5042500.0
2022-09-19	ABC-DELISTED	Stock	139.53	140.7	139.0575	140.37	1085452.0
2022-09-19	ABCB	Stock	47.42	48.88	47.42	48.67	665500.0
2022-09-19	ABCL	Stock	10.21	10.44	9.8	10.42	2101000.0
2022-09-19	ABCM-DELISTED	Stock	16.8	16.95	16.56	16.74	144426.0
2022-09-19	ABEO	Stock	3.9	3.95	3.77	3.86	71200.0
2022-09-19	ABEV	Stock	2.84	2.97	2.83	2.96	17857700.0
2022-09-19	ABG	Stock	155.94	160.68	155.94	158.79	126400.0
2022-09-19	ABGI-DELISTED	Stock	9.89	9.89	9.89	9.89	1000.0
2022-09-19	ABLV	Stock	9.95	9.96	9.95	9.95	39901.0
2022-09-19	ABM	Stock	39.65	41.06	39.62	40.82	302600.0
2022-09-19	ABMD-DELISTED	Stock	256.24	258.73	249.74	257.87	226554.0
2022-09-19	ABNB	Stock	116.87	119.78	116.47	118.78	4715400.0

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

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