PREVIEW / stock_daily / 2022-10-07

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-07.parquet
  size:    248 KB
  rows:    7,756
  symbols: 2,090

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-10-07	AAPL	Stock	142.54	143.1	139.45	140.09	85925600.0
2022-10-07	MSFT	Stock	240.9	241.32	233.17	234.24	37769600.0
2022-10-07	NVDA	Stock	12.505	12.67	12.022	12.076	672478000.0
2022-10-07	AMZN	Stock	118.0	118.17	113.88	114.56	54678000.0
2022-10-07	GOOGL	Stock	99.85	100.53	98.295	98.68	27502765.0
2022-10-07	META	Stock	136.76	138.29	132.44	133.45	33214800.0
2022-10-07	TSLA	Stock	233.94	234.57	222.02	223.07	83916800.0
2022-10-07	TLT	Stock	100.81	101.62	100.47	100.99	14814780.0
2022-10-07	ES	Stock	75.28	75.61	73.74	74.25	1714600.0
2022-10-07	CL	Stock	69.54	69.65	68.74	68.99	4316300.0
2022-10-07	A	Stock	130.45	130.93	126.96	127.44	1154700.0
2022-10-07	AA	Stock	39.04	39.355	37.88	39.01	6270400.0
2022-10-07	AAC-DELISTED	Stock	9.93	9.95	9.93	9.94	47181.0
2022-10-07	AACG	Stock	1.94	1.97	1.84	1.89	11300.0
2022-10-07	AACIW-DELISTED	Stock	0.15	0.15	0.15	0.15	199.0
2022-10-07	AAIC-DELISTED	Stock	2.79	2.8382	2.73	2.74	36139.0
2022-10-07	AAIC.C-DELISTED	Stock	19.4945	19.4945	19.4945	19.4945	1000.0
2022-10-07	AAL	Stock	12.5	12.54	11.95	12.18	37297700.0
2022-10-07	AAM.A-DELISTED	Stock	23.59	23.59	23.17	23.19	9713.0
2022-10-07	AAM.B-DELISTED	Stock	23.32	23.32	23.07	23.2	3881.0
2022-10-07	AAMC-DELISTED	Stock	4.4824	4.6147	4.2441	4.3118	12424.0
2022-10-07	AAME	Stock	2.8	2.81	2.75	2.75	5600.0
2022-10-07	AAMI	Stock	17.27	17.365	16.84	16.89	671900.0
2022-10-07	AAN-DELISTED	Stock	9.75	9.86	9.44	9.5	491800.0
2022-10-07	AAOI	Stock	2.89	2.91	2.74	2.78	262000.0
2022-10-07	AAON	Stock	36.5467	36.5467	35.2067	35.4267	191250.0
2022-10-07	AAP	Stock	163.97	164.03	160.1	161.32	582800.0
2022-10-07	AAQC-DELISTED	Stock	9.83	9.83	9.83	9.83	300.0
2022-10-07	AAT	Stock	24.78	25.02	24.69	24.92	460600.0
2022-10-07	AATC	Stock	4.5	4.5	4.45	4.45	1395.0
2022-10-07	AAU-DELISTED	Stock	0.2378	0.245	0.2313	0.2401	90005.0
2022-10-07	AAUAF-DELISTED	Stock	0.2378	0.245	0.2313	0.24	91137.0
2022-10-07	AAWW-DELISTED	Stock	97.68	98.505	97.68	98.17	363867.0
2022-10-07	AAXJ	Stock	60.21	60.3	59.33	59.39	314771.0
2022-10-07	AB	Stock	35.12	35.3	34.69	35.22	283200.0
2022-10-07	ABB-DELISTED	Stock	25.36	25.37	24.88	25.02	1390237.0
2022-10-07	ABBNY-DELISTED	Stock	25.36	25.37	24.88	25.01	1491323.0
2022-10-07	ABBV	Stock	139.01	140.05	137.55	138.76	4648800.0
2022-10-07	ABC-DELISTED	Stock	138.8	139.27	136.87	137.39	674329.0
2022-10-07	ABCB	Stock	48.74	48.94	47.79	48.37	362100.0
2022-10-07	ABCL	Stock	11.09	11.3	10.71	10.75	1378600.0
2022-10-07	ABCM-DELISTED	Stock	15.66	15.72	15.26	15.33	196560.0
2022-10-07	ABEO	Stock	3.5	4.87	3.5	4.41	4541000.0
2022-10-07	ABEV	Stock	2.96	2.96	2.89	2.89	33749800.0
2022-10-07	ABG	Stock	152.54	155.16	150.23	154.63	190000.0
2022-10-07	ABLV	Stock	9.99	9.99	9.99	9.99	299000.0
2022-10-07	ABM	Stock	41.37	41.65	40.53	40.55	428600.0
2022-10-07	ABMD-DELISTED	Stock	263.37	266.53	255.48	257.1	128938.0
2022-10-07	ABNB	Stock	108.87	109.532	107.1	108.54	3352700.0
2022-10-07	ABOS	Stock	10.07	10.215	9.81	9.82	261100.0

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

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