PREVIEW / stock_daily / 2021-10-22

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-22.parquet
  size:    257 KB
  rows:    7,860
  symbols: 2,628

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-22	AAPL	Stock	149.69	150.18	148.64	148.69	58883400.0
2021-10-22	MSFT	Stock	310.4	311.09	307.8	309.16	17449300.0
2021-10-22	NVDA	Stock	22.823	23.13	22.561	22.726	249384000.0
2021-10-22	AMZN	Stock	171.05	171.492	166.565	166.7775	62782000.0
2021-10-22	GOOGL	Stock	139.15	140.5828	136.056	137.5665	50588960.0
2021-10-22	META	Stock	326.35	329.63	321.11	324.61	35224500.0
2021-10-22	TSLA	Stock	298.5	303.3333	296.9867	303.2267	68642400.0
2021-10-22	TLT	Stock	143.45	144.4	143.21	144.13	13740010.0
2021-10-22	ES	Stock	86.39	86.84	86.21	86.5	931300.0
2021-10-22	CL	Stock	74.81	75.69	74.58	75.5	7665400.0
2021-10-22	A	Stock	156.95	158.71	156.9	157.97	772200.0
2021-10-22	AA	Stock	50.49	50.99	48.87	49.25	7469300.0
2021-10-22	AAC-DELISTED	Stock	9.84	9.84	9.81	9.83	320287.0
2021-10-22	AACG	Stock	2.38	2.41	2.34	2.34	36300.0
2021-10-22	AACIU	Stock	9.9	9.9	9.9	9.9	85642.0
2021-10-22	AAIC-DELISTED	Stock	3.85	3.92	3.85	3.92	124281.0
2021-10-22	AAIC.C-DELISTED	Stock	25.2723	25.29	25.2723	25.29	529.0
2021-10-22	AAL	Stock	19.72	19.76	19.03	19.15	36948200.0
2021-10-22	AAM.A-DELISTED	Stock	26.09	26.09	25.9118	25.96	15661.0
2021-10-22	AAM.B-DELISTED	Stock	27.26	27.26	27.06	27.06	7456.0
2021-10-22	AAMC-DELISTED	Stock	7.5029	7.8529	7.0941	7.5676	165407.0
2021-10-22	AAME	Stock	4.17	4.2	4.06	4.09	10800.0
2021-10-22	AAMI	Stock	27.03	27.05	26.85	26.98	356700.0
2021-10-22	AAN-DELISTED	Stock	29.64	30.44	29.23	30.3	232000.0
2021-10-22	AAOI	Stock	7.5	7.61	7.41	7.5	432100.0
2021-10-22	AAON	Stock	46.6733	47.4	46.6733	47.1467	93750.0
2021-10-22	AAP	Stock	233.85	235.32	230.85	231.97	798900.0
2021-10-22	AAQC-DELISTED	Stock	9.74	9.74	9.735	9.735	2397.0
2021-10-22	AAT	Stock	39.32	39.71	39.13	39.22	133000.0
2021-10-22	AATC	Stock	6.99	7.0	6.8893	7.0	15146.0
2021-10-22	AAU-DELISTED	Stock	0.38	0.3859	0.3665	0.3707	803585.0
2021-10-22	AAUAF-DELISTED	Stock	0.38	0.3859	0.3665	0.3707	817712.0
2021-10-22	AAWW-DELISTED	Stock	80.42	82.415	80.42	80.98	336978.0
2021-10-22	AAXJ	Stock	88.51	88.87	87.96	88.08	698128.0
2021-10-22	AB	Stock	54.15	55.28	53.92	54.94	240300.0
2021-10-22	ABB-DELISTED	Stock	32.97	33.255	32.895	33.2	1554773.0
2021-10-22	ABBNY-DELISTED	Stock	32.97	33.255	32.895	33.21	1774065.0
2021-10-22	ABBV	Stock	108.67	109.22	108.31	109.14	4614400.0
2021-10-22	ABC-DELISTED	Stock	122.94	123.67	122.7	123.37	236381.0
2021-10-22	ABCB	Stock	53.57	54.5	53.38	54.41	231200.0
2021-10-22	ABCL	Stock	16.16	16.201	15.6	15.97	839500.0
2021-10-22	ABCM-DELISTED	Stock	22.57	22.84	22.53	22.7	23326.0
2021-10-22	ABEO	Stock	22.5	22.5	21.5	21.5	26576.0
2021-10-22	ABEV	Stock	2.57	2.65	2.5	2.62	46325000.0
2021-10-22	ABG	Stock	228.86	230.97	226.01	228.03	215400.0
2021-10-22	ABM	Stock	45.14	45.25	44.48	44.52	199800.0
2021-10-22	ABMD-DELISTED	Stock	349.45	353.77	346.24	352.35	61243.0
2021-10-22	ABNB	Stock	169.3	169.44	165.16	166.64	2986000.0
2021-10-22	ABOS	Stock	14.65	14.65	13.84	14.38	40700.0
2021-10-22	ABR	Stock	19.75	19.86	19.64	19.77	602600.0

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

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