PREVIEW / stock_daily / 2021-10-12

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-12.parquet
  size:    256 KB
  rows:    7,853
  symbols: 2,647

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
2021-10-12	AAPL	Stock	143.23	143.25	141.04	141.51	73035900.0
2021-10-12	MSFT	Stock	295.34	295.44	292.35	292.88	17974100.0
2021-10-12	NVDA	Stock	20.828	21.057	20.528	20.671	162134000.0
2021-10-12	AMZN	Stock	162.85	163.3765	161.814	162.3665	36392000.0
2021-10-12	GOOGL	Stock	139.48	139.507	135.76	136.449	36332240.0
2021-10-12	META	Stock	323.03	324.38	317.37	323.77	31658700.0
2021-10-12	TSLA	Stock	266.9767	270.7733	265.5233	268.5733	66060000.0
2021-10-12	TLT	Stock	142.63	144.01	142.48	143.94	17968952.0
2021-10-12	ES	Stock	84.49	85.65	84.33	85.51	1462100.0
2021-10-12	CL	Stock	75.65	76.2	75.4	75.67	2788900.0
2021-10-12	A	Stock	151.18	151.18	146.3	147.95	1809900.0
2021-10-12	AA	Stock	47.88	49.44	47.345	47.78	6872300.0
2021-10-12	AAC-DELISTED	Stock	9.78	9.78	9.76	9.78	315494.0
2021-10-12	AACG	Stock	2.29	2.73	2.26	2.39	332500.0
2021-10-12	AACIU	Stock	9.95	9.95	9.9	9.95	1002.0
2021-10-12	AAIC-DELISTED	Stock	3.81	3.92	3.8	3.89	165302.0
2021-10-12	AAIC.C-DELISTED	Stock	25.22	25.64	25.22	25.58	3943.0
2021-10-12	AAL	Stock	20.2	20.4	20.03	20.29	18448400.0
2021-10-12	AAM.A-DELISTED	Stock	25.64	25.7	25.64	25.65	13301.0
2021-10-12	AAM.B-DELISTED	Stock	26.72	26.8	26.7	26.74	26472.0
2021-10-12	AAMC-DELISTED	Stock	7.0618	7.3529	6.8294	6.9088	76391.0
2021-10-12	AAME	Stock	4.58	4.59	4.34	4.38	13200.0
2021-10-12	AAMI	Stock	26.23	26.39	26.09	26.2	270100.0
2021-10-12	AAN-DELISTED	Stock	27.75	27.97	27.23	27.28	129000.0
2021-10-12	AAOI	Stock	6.83	6.94	6.74	6.75	292500.0
2021-10-12	AAON	Stock	45.32	45.6	44.72	44.74	115950.0
2021-10-12	AAP	Stock	213.07	213.6	210.61	212.01	521500.0
2021-10-12	AAQC-DELISTED	Stock	9.72	9.75	9.7	9.75	5666.0
2021-10-12	AAT	Stock	38.9	39.57	38.54	39.33	238600.0
2021-10-12	AATC	Stock	7.0687	7.0845	6.92	7.0	8933.0
2021-10-12	AAU-DELISTED	Stock	0.3825	0.39	0.3825	0.3875	273538.0
2021-10-12	AAUAF-DELISTED	Stock	0.3825	0.39	0.3825	0.3875	278583.0
2021-10-12	AAWW-DELISTED	Stock	80.25	80.68	77.1	78.24	420941.0
2021-10-12	AAXJ	Stock	85.21	85.5	84.76	84.77	1343749.0
2021-10-12	AB	Stock	50.0	50.29	49.43	49.52	216600.0
2021-10-12	ABB-DELISTED	Stock	33.21	33.22	32.99	33.03	1499600.0
2021-10-12	ABBNY-DELISTED	Stock	33.21	33.22	32.99	33.03	1619084.0
2021-10-12	ABBV	Stock	110.12	110.26	108.16	108.57	6305800.0
2021-10-12	ABC-DELISTED	Stock	121.84	122.04	118.69	119.79	806248.0
2021-10-12	ABCB	Stock	52.49	52.92	51.72	52.82	212500.0
2021-10-12	ABCL	Stock	14.9	15.35	14.78	15.12	1215900.0
2021-10-12	ABCM-DELISTED	Stock	20.49	20.5666	20.24	20.32	19067.0
2021-10-12	ABEO	Stock	22.75	23.5	22.25	22.5	17680.0
2021-10-12	ABEV	Stock	2.73	2.76	2.7	2.7	12420800.0
2021-10-12	ABG	Stock	211.02	213.01	209.72	212.5	111500.0
2021-10-12	ABGI-DELISTED	Stock	9.7	9.75	9.7	9.75	28302.0
2021-10-12	ABM	Stock	45.53	45.89	45.22	45.31	156100.0
2021-10-12	ABMD-DELISTED	Stock	335.66	340.16	331.71	333.83	58689.0
2021-10-12	ABNB	Stock	172.694	175.9	171.23	172.75	6028100.0
2021-10-12	ABOS	Stock	13.12	13.535	13.0	13.47	31700.0

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

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