PREVIEW / stock_daily / 2021-10-26

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-26.parquet
  size:    260 KB
  rows:    7,975
  symbols: 2,713

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-26	AAPL	Stock	149.33	150.84	149.01	149.32	60893400.0
2021-10-26	MSFT	Stock	311.0	312.4	308.6	310.11	28107300.0
2021-10-26	NVDA	Stock	23.989	25.259	23.924	24.717	485898000.0
2021-10-26	AMZN	Stock	167.4755	170.806	167.199	168.8035	53966000.0
2021-10-26	GOOGL	Stock	139.2635	140.0829	138.3045	139.3085	49235020.0
2021-10-26	META	Stock	328.26	330.21	309.6	315.81	65654000.0
2021-10-26	TSLA	Stock	341.5633	364.98	333.8133	339.4767	187245000.0
2021-10-26	TLT	Stock	144.62	145.1	143.74	145.1	13670997.0
2021-10-26	ES	Stock	86.04	86.53	85.61	86.03	1143700.0
2021-10-26	CL	Stock	75.44	76.19	75.23	76.16	5400200.0
2021-10-26	A	Stock	159.63	159.92	157.04	158.19	1016400.0
2021-10-26	AA	Stock	50.8	51.266	49.26	49.55	6153100.0
2021-10-26	AAC-DELISTED	Stock	9.85	9.85	9.81	9.84	254895.0
2021-10-26	AACG	Stock	2.46	2.46	2.34	2.34	41800.0
2021-10-26	AACIU	Stock	9.95	9.95	9.94	9.95	4200.0
2021-10-26	AAIC-DELISTED	Stock	3.83	3.89	3.82	3.88	181773.0
2021-10-26	AAIC.C-DELISTED	Stock	25.25	25.25	25.25	25.25	100.0
2021-10-26	AAL	Stock	19.34	19.82	19.24	19.39	31007900.0
2021-10-26	AAM.A-DELISTED	Stock	26.01	26.04	25.97	25.98	7616.0
2021-10-26	AAM.B-DELISTED	Stock	27.06	27.165	27.06	27.11	10240.0
2021-10-26	AAMC-DELISTED	Stock	7.5162	7.8088	7.5162	7.7676	69574.0
2021-10-26	AAME	Stock	4.02	4.2	4.0	4.08	25500.0
2021-10-26	AAMI	Stock	27.23	27.39	27.01	27.05	290000.0
2021-10-26	AAN-DELISTED	Stock	29.95	30.05	24.0	24.24	1351200.0
2021-10-26	AAOI	Stock	7.59	7.822	7.49	7.5	510000.0
2021-10-26	AAON	Stock	46.8667	47.16	46.3067	46.6733	211800.0
2021-10-26	AAP	Stock	231.16	233.53	229.17	232.56	397100.0
2021-10-26	AAQC-DELISTED	Stock	9.7522	9.77	9.75	9.77	5900.0
2021-10-26	AAT	Stock	39.45	39.81	39.21	39.41	164200.0
2021-10-26	AATC	Stock	6.99	6.99	6.75	6.8	24969.0
2021-10-26	AAU-DELISTED	Stock	0.39	0.39	0.3769	0.3854	1044092.0
2021-10-26	AAUAF-DELISTED	Stock	0.39	0.39	0.38	0.3854	1052177.0
2021-10-26	AAWW-DELISTED	Stock	83.2	83.24	81.21	81.88	207937.0
2021-10-26	AAXJ	Stock	88.9	88.9	87.9	87.94	1440543.0
2021-10-26	AB	Stock	55.6	56.17	55.02	55.53	254300.0
2021-10-26	ABB-DELISTED	Stock	33.15	33.205	32.89	32.94	1114757.0
2021-10-26	ABBNY-DELISTED	Stock	33.15	33.205	32.89	32.95	1236316.0
2021-10-26	ABBV	Stock	108.81	109.58	108.2	109.49	5047400.0
2021-10-26	ABC-DELISTED	Stock	123.04	123.68	122.0	122.96	252584.0
2021-10-26	ABCB	Stock	54.88	54.88	53.98	54.23	213700.0
2021-10-26	ABCL	Stock	16.16	16.47	15.41	15.58	2001600.0
2021-10-26	ABCM-DELISTED	Stock	22.5	22.83	22.5	22.77	22584.0
2021-10-26	ABEO	Stock	22.0	22.0	21.25	22.0	19632.0
2021-10-26	ABEV	Stock	2.68	2.71	2.66	2.7	24712700.0
2021-10-26	ABG	Stock	228.5	228.5	207.36	208.8	311000.0
2021-10-26	ABGI-DELISTED	Stock	9.77	9.77	9.74	9.77	20000.0
2021-10-26	ABM	Stock	45.49	45.49	43.83	43.88	256800.0
2021-10-26	ABMD-DELISTED	Stock	355.0	355.0	347.85	347.85	66469.0
2021-10-26	ABNB	Stock	170.4	172.0	167.9	171.14	2937900.0
2021-10-26	ABOS	Stock	14.15	15.295	14.0	15.23	80900.0

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

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