PREVIEW / stock_daily / 2022-08-05

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-05.parquet
  size:    252 KB
  rows:    7,845
  symbols: 2,229

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-08-05	AAPL	Stock	163.21	165.85	163.0	165.35	56697000.0
2022-08-05	MSFT	Stock	279.15	283.65	278.68	282.91	16774600.0
2022-08-05	NVDA	Stock	18.81	19.229	18.666	18.989	386068000.0
2022-08-05	AMZN	Stock	140.1	142.86	139.6	140.8	50686900.0
2022-08-05	GOOGL	Stock	116.23	118.1056	116.0	117.47	19159520.0
2022-08-05	META	Stock	166.99	171.61	165.8	167.11	25832700.0
2022-08-05	TSLA	Stock	302.67	304.6067	285.5433	288.17	113172900.0
2022-08-05	TLT	Stock	117.07	117.11	115.89	116.47	19492287.0
2022-08-05	ES	Stock	90.67	91.09	88.73	90.38	1555500.0
2022-08-05	CL	Stock	80.7	80.7	79.69	80.43	2408200.0
2022-08-05	A	Stock	132.27	133.84	131.75	133.61	675800.0
2022-08-05	AA	Stock	47.49	51.35	47.45	49.52	5074800.0
2022-08-05	AAC-DELISTED	Stock	9.88	9.89	9.87	9.88	80993.0
2022-08-05	AACG	Stock	1.81	1.94	1.6	1.85	123500.0
2022-08-05	AAIC-DELISTED	Stock	3.08	3.1388	3.08	3.1307	5371.0
2022-08-05	AAIC.C-DELISTED	Stock	20.75	20.8	20.75	20.78	950.0
2022-08-05	AAL	Stock	14.62	14.98	14.61	14.74	19503800.0
2022-08-05	AAM.A-DELISTED	Stock	25.31	25.45	25.1932	25.43	5766.0
2022-08-05	AAM.B-DELISTED	Stock	26.29	26.48	26.1	26.24	3725.0
2022-08-05	AAMC-DELISTED	Stock	5.2059	7.3452	5.1529	6.43	531206.0
2022-08-05	AAME	Stock	2.9	3.05	2.82	2.95	3200.0
2022-08-05	AAMI	Stock	18.52	18.85	18.5	18.84	107700.0
2022-08-05	AAN-DELISTED	Stock	13.23	13.49	13.15	13.32	217900.0
2022-08-05	AAOI	Stock	1.93	1.95	1.81	1.86	255300.0
2022-08-05	AAON	Stock	41.4733	41.48	40.6133	41.0933	153600.0
2022-08-05	AAP	Stock	190.0	193.54	189.82	193.42	367700.0
2022-08-05	AAQC-DELISTED	Stock	9.82	9.82	9.82	9.82	200.0
2022-08-05	AAT	Stock	28.77	29.35	28.72	29.28	328800.0
2022-08-05	AATC	Stock	4.95	5.0579	4.8371	5.04	2555.0
2022-08-05	AAU-DELISTED	Stock	0.24	0.2468	0.2309	0.2411	95497.0
2022-08-05	AAUAF-DELISTED	Stock	0.24	0.2468	0.2309	0.2411	109013.0
2022-08-05	AAWW-DELISTED	Stock	99.61	99.84	99.3	99.61	3210551.0
2022-08-05	AAXJ	Stock	67.87	68.26	67.76	68.16	521347.0
2022-08-05	AB	Stock	44.9	44.9	43.69	43.98	231100.0
2022-08-05	ABB-DELISTED	Stock	29.44	29.715	29.345	29.69	1035902.0
2022-08-05	ABBNY-DELISTED	Stock	29.44	29.715	29.345	29.69	1148587.0
2022-08-05	ABBV	Stock	139.05	139.91	137.95	138.04	5371100.0
2022-08-05	ABC-DELISTED	Stock	138.78	141.32	138.78	141.25	655686.0
2022-08-05	ABCB	Stock	46.82	47.6	43.9	47.27	255000.0
2022-08-05	ABCL	Stock	11.12	11.655	10.87	11.32	1661000.0
2022-08-05	ABCM-DELISTED	Stock	15.09	15.17	14.86	15.01	175795.0
2022-08-05	ABEO	Stock	4.2	4.42	4.1	4.2	487900.0
2022-08-05	ABEV	Stock	2.77	2.82	2.76	2.76	43798000.0
2022-08-05	ABG	Stock	175.63	182.06	175.63	179.22	90500.0
2022-08-05	ABM	Stock	44.23	44.76	44.07	44.47	219700.0
2022-08-05	ABMD-DELISTED	Stock	287.69	293.0	284.85	291.36	111616.0
2022-08-05	ABNB	Stock	115.52	118.87	114.82	117.11	6495000.0
2022-08-05	ABOS	Stock	5.125	5.438	5.01	5.22	36500.0
2022-08-05	ABR	Stock	15.56	15.77	15.5	15.64	1577900.0
2022-08-05	ABR.D	Stock	21.25	21.25	20.715	21.0083	12907.0

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

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