PREVIEW / stock_daily / 2022-01-13

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-13.parquet
  size:    261 KB
  rows:    8,021
  symbols: 2,575

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-01-13	AAPL	Stock	175.78	176.62	171.79	172.19	84505800.0
2022-01-13	MSFT	Stock	320.47	320.88	304.0	304.8	45366000.0
2022-01-13	NVDA	Stock	28.379	28.48	26.498	26.575	540171000.0
2022-01-13	AMZN	Stock	165.2505	166.2215	161.091	161.214	52188000.0
2022-01-13	GOOGL	Stock	141.54	142.85	138.409	138.587	31436600.0
2022-01-13	META	Stock	334.98	335.63	325.76	326.48	14797100.0
2022-01-13	TSLA	Stock	369.69	371.8667	342.18	343.8533	97209900.0
2022-01-13	TLT	Stock	143.39	144.42	143.03	144.28	15166030.0
2022-01-13	ES	Stock	87.75	88.29	86.78	88.07	1142800.0
2022-01-13	CL	Stock	82.81	82.84	81.97	82.54	6698400.0
2022-01-13	A	Stock	149.46	149.54	144.85	145.17	1741800.0
2022-01-13	AA	Stock	61.75	63.26	60.37	60.51	5769800.0
2022-01-13	AAC-DELISTED	Stock	9.78	9.78	9.76	9.76	30252.0
2022-01-13	AACG	Stock	1.94	2.0	1.82	1.86	290600.0
2022-01-13	AACIW-DELISTED	Stock	0.5101	0.5103	0.5101	0.5103	500.0
2022-01-13	AAIC-DELISTED	Stock	3.6	3.63	3.58	3.58	54979.0
2022-01-13	AAL	Stock	18.73	19.76	18.63	19.34	55911800.0
2022-01-13	AAM.A-DELISTED	Stock	25.41	25.715	25.399	25.62	17970.0
2022-01-13	AAM.B-DELISTED	Stock	26.39	26.8	26.22	26.77	27249.0
2022-01-13	AAME	Stock	2.84	2.97	2.7	2.72	5400.0
2022-01-13	AAMI	Stock	24.68	24.99	24.46	24.53	442900.0
2022-01-13	AAN-DELISTED	Stock	23.15	23.42	22.82	22.9	183200.0
2022-01-13	AAOI	Stock	4.42	4.42	4.19	4.2	566300.0
2022-01-13	AAON	Stock	48.7267	49.22	47.9667	48.0733	152400.0
2022-01-13	AAP	Stock	241.16	244.2	240.32	241.32	642700.0
2022-01-13	AAQC-DELISTED	Stock	9.72	9.72	9.71	9.71	201236.0
2022-01-13	AAT	Stock	38.27	39.2	38.25	38.76	199400.0
2022-01-13	AATC	Stock	6.48	6.48	6.26	6.27	8771.0
2022-01-13	AAU-DELISTED	Stock	0.3	0.3	0.295	0.2961	308492.0
2022-01-13	AAUAF-DELISTED	Stock	0.3	0.3	0.295	0.2951	312227.0
2022-01-13	AAWW-DELISTED	Stock	86.21	87.62	85.45	86.58	188887.0
2022-01-13	AAXJ	Stock	85.33	85.37	84.4	84.48	3294216.0
2022-01-13	AB	Stock	51.5	52.14	50.45	50.51	237000.0
2022-01-13	ABB-DELISTED	Stock	38.34	38.43	37.885	37.96	1386320.0
2022-01-13	ABBNY-DELISTED	Stock	38.34	38.43	37.885	37.95	1550750.0
2022-01-13	ABBV	Stock	135.0	135.12	132.9	133.52	8386400.0
2022-01-13	ABC-DELISTED	Stock	135.5	136.26	134.57	134.9	604612.0
2022-01-13	ABCB	Stock	54.2	55.62	54.19	55.14	470100.0
2022-01-13	ABCL	Stock	11.61	11.63	10.83	10.86	2120800.0
2022-01-13	ABCM-DELISTED	Stock	19.65	19.67	18.44	18.44	591800.0
2022-01-13	ABEO	Stock	7.5	7.5	6.75	6.75	173056.0
2022-01-13	ABEV	Stock	2.7	2.73	2.68	2.72	16945000.0
2022-01-13	ABG	Stock	168.0	170.84	166.21	167.37	247500.0
2022-01-13	ABGI-DELISTED	Stock	9.75	9.75	9.745	9.75	36411.0
2022-01-13	ABM	Stock	43.79	45.24	43.79	44.88	560800.0
2022-01-13	ABMD-DELISTED	Stock	316.8	316.8	304.78	306.44	240984.0
2022-01-13	ABNB	Stock	170.233	171.99	165.765	166.0	4893800.0
2022-01-13	ABOS	Stock	5.26	5.73	5.085	5.4	144500.0
2022-01-13	ABR	Stock	18.75	18.85	18.62	18.68	1244100.0
2022-01-13	ABR.D	Stock	25.16	25.17	25.12	25.16	25312.0

> showing 50 of 8,021 rows — these rows as CSV

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