PREVIEW / stock_daily / 2021-10-21

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-21.parquet
  size:    258 KB
  rows:    7,860
  symbols: 2,638

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-21	AAPL	Stock	148.81	149.64	147.87	149.48	61421000.0
2021-10-21	MSFT	Stock	307.17	311.02	306.36	310.76	16918100.0
2021-10-21	NVDA	Stock	22.097	22.711	22.083	22.692	187590000.0
2021-10-21	AMZN	Stock	170.7125	172.014	170.15	171.7505	37628000.0
2021-10-21	GOOGL	Stock	141.769	142.156	140.5	141.886	26292260.0
2021-10-21	META	Stock	340.28	342.31	337.8	341.88	16354400.0
2021-10-21	TSLA	Stock	285.3333	300.0	285.1667	298.0	94444500.0
2021-10-21	TLT	Stock	143.0	143.15	142.23	142.56	13660022.0
2021-10-21	ES	Stock	86.41	86.62	85.79	86.09	985400.0
2021-10-21	CL	Stock	75.43	75.6	74.83	74.89	4370500.0
2021-10-21	A	Stock	157.71	158.02	154.53	156.94	1405100.0
2021-10-21	AA	Stock	51.7	51.7	49.8	49.99	9066900.0
2021-10-21	AAC-DELISTED	Stock	9.81	9.84	9.81	9.82	502311.0
2021-10-21	AACG	Stock	2.45	2.6	2.27	2.42	133500.0
2021-10-21	AACIU	Stock	9.95	9.95	9.89	9.89	310319.0
2021-10-21	AAIC-DELISTED	Stock	3.92	3.97	3.855	3.9	171873.0
2021-10-21	AAIC.C-DELISTED	Stock	25.3213	25.3213	25.3213	25.3213	211.0
2021-10-21	AAL	Stock	19.62	20.01	19.5	19.89	29224700.0
2021-10-21	AAM.A-DELISTED	Stock	26.03	26.08	26.005	26.02	5534.0
2021-10-21	AAM.B-DELISTED	Stock	27.22	27.23	27.04	27.19	8926.0
2021-10-21	AAMC-DELISTED	Stock	7.8206	7.8206	7.3941	7.5529	43170.0
2021-10-21	AAME	Stock	4.22	4.22	4.15	4.19	8700.0
2021-10-21	AAMI	Stock	26.77	27.12	26.665	26.93	400700.0
2021-10-21	AAN-DELISTED	Stock	29.33	29.94	29.21	29.48	140500.0
2021-10-21	AAOI	Stock	7.37	7.58	7.37	7.52	234500.0
2021-10-21	AAON	Stock	46.92	47.9067	46.6533	46.8333	130800.0
2021-10-21	AAP	Stock	227.12	233.71	227.12	233.71	648300.0
2021-10-21	AAQC-DELISTED	Stock	9.72	9.75	9.72	9.72	4506.0
2021-10-21	AAT	Stock	39.42	39.44	38.92	39.12	209300.0
2021-10-21	AATC	Stock	6.99	7.0	6.9278	7.0	6458.0
2021-10-21	AAU-DELISTED	Stock	0.38	0.386	0.378	0.3823	412649.0
2021-10-21	AAUAF-DELISTED	Stock	0.38	0.386	0.378	0.3822	421179.0
2021-10-21	AAWW-DELISTED	Stock	78.3	80.36	78.09	80.34	290221.0
2021-10-21	AAXJ	Stock	88.01	88.405	87.93	88.27	604472.0
2021-10-21	AB	Stock	53.22	54.2	53.01	53.73	222900.0
2021-10-21	ABB-DELISTED	Stock	32.975	33.03	32.53	32.86	2965715.0
2021-10-21	ABBNY-DELISTED	Stock	32.975	33.03	32.53	32.86	3470245.0
2021-10-21	ABBV	Stock	108.41	108.95	107.15	108.76	4811800.0
2021-10-21	ABC-DELISTED	Stock	122.69	123.12	121.95	122.62	315880.0
2021-10-21	ABCB	Stock	53.41	53.77	52.97	53.62	370900.0
2021-10-21	ABCL	Stock	15.99	16.49	15.98	16.3	974700.0
2021-10-21	ABCM-DELISTED	Stock	22.47	22.96	22.47	22.89	16271.0
2021-10-21	ABEO	Stock	22.0	23.0	22.0	22.5	24616.0
2021-10-21	ABEV	Stock	2.67	2.68	2.57	2.63	23644300.0
2021-10-21	ABG	Stock	218.67	229.83	218.67	229.65	250000.0
2021-10-21	ABM	Stock	44.93	45.28	44.56	45.11	271500.0
2021-10-21	ABMD-DELISTED	Stock	348.85	350.56	343.745	349.64	84873.0
2021-10-21	ABNB	Stock	169.074	171.53	167.7	170.5	2889400.0
2021-10-21	ABOS	Stock	14.22	14.65	14.16	14.56	35400.0
2021-10-21	ABR	Stock	19.76	19.93	19.67	19.74	1031500.0

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

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