PREVIEW / stock_daily / 2022-08-17

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-17.parquet
  size:    253 KB
  rows:    7,847
  symbols: 2,213

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-17	AAPL	Stock	172.77	176.15	172.57	174.55	79542000.0
2022-08-17	MSFT	Stock	289.74	293.35	289.47	291.32	18253400.0
2022-08-17	NVDA	Stock	18.523	18.688	18.145	18.335	446799000.0
2022-08-17	AMZN	Stock	142.69	143.38	140.78	142.1	48149800.0
2022-08-17	GOOGL	Stock	120.12	121.29	119.38	119.55	22846958.0
2022-08-17	META	Stock	176.76	178.14	174.17	174.85	20118100.0
2022-08-17	TSLA	Stock	303.3967	309.6567	300.0333	303.9967	68766000.0
2022-08-17	TLT	Stock	115.06	115.1	114.31	114.72	14131281.0
2022-08-17	ES	Stock	93.43	94.03	93.27	93.81	994500.0
2022-08-17	CL	Stock	82.05	82.26	81.72	82.17	2128500.0
2022-08-17	A	Stock	148.84	149.0	140.03	142.29	4110100.0
2022-08-17	AA	Stock	52.03	52.44	51.29	51.98	4020300.0
2022-08-17	AAC-DELISTED	Stock	9.89	9.89	9.87	9.88	93157.0
2022-08-17	AACG	Stock	2.1	2.48	2.1	2.4	223500.0
2022-08-17	AAIC-DELISTED	Stock	3.31	3.37	3.3	3.3	34806.0
2022-08-17	AAIC.C-DELISTED	Stock	21.3	21.34	21.0	21.1	4460.0
2022-08-17	AAL	Stock	15.23	15.29	14.78	14.96	28352800.0
2022-08-17	AAM.A-DELISTED	Stock	25.48	25.49	25.36	25.36	12907.0
2022-08-17	AAM.B-DELISTED	Stock	25.54	25.6079	25.35	25.36	7869.0
2022-08-17	AAMC-DELISTED	Stock	6.0941	6.2235	5.8941	6.0735	21423.0
2022-08-17	AAME	Stock	2.97	3.18	2.97	3.06	15700.0
2022-08-17	AAMI	Stock	20.09	20.38	19.99	20.26	214400.0
2022-08-17	AAN-DELISTED	Stock	14.73	14.87	14.5	14.6	197900.0
2022-08-17	AAOI	Stock	2.88	2.88	2.688	2.8	271200.0
2022-08-17	AAON	Stock	42.0867	42.0867	41.3333	41.9467	129150.0
2022-08-17	AAP	Stock	207.94	211.86	206.67	209.98	506600.0
2022-08-17	AAQC-DELISTED	Stock	9.82	9.825	9.81	9.82	461285.0
2022-08-17	AAT	Stock	30.26	30.29	29.74	29.84	190300.0
2022-08-17	AATC	Stock	5.23	5.4	5.1	5.13	25860.0
2022-08-17	AAU-DELISTED	Stock	0.243	0.243	0.231	0.231	90495.0
2022-08-17	AAUAF-DELISTED	Stock	0.243	0.243	0.231	0.231	92108.0
2022-08-17	AAWW-DELISTED	Stock	99.86	100.16	99.83	100.0	760096.0
2022-08-17	AAXJ	Stock	68.61	68.81	68.33	68.48	325978.0
2022-08-17	AB	Stock	44.6	44.83	43.94	44.71	136200.0
2022-08-17	ABB-DELISTED	Stock	30.05	30.19	29.86	30.03	879726.0
2022-08-17	ABBNY-DELISTED	Stock	30.05	30.19	29.86	30.03	985556.0
2022-08-17	ABBV	Stock	141.42	142.76	140.55	141.44	3605200.0
2022-08-17	ABC-DELISTED	Stock	152.0	153.35	149.43	149.65	529605.0
2022-08-17	ABCB	Stock	50.0	50.23	49.41	49.99	146200.0
2022-08-17	ABCL	Stock	12.56	13.13	12.27	13.01	2335200.0
2022-08-17	ABCM-DELISTED	Stock	15.08	15.28	15.05	15.25	144560.0
2022-08-17	ABEO	Stock	4.79	4.81	4.5	4.6	79800.0
2022-08-17	ABEV	Stock	2.93	2.99	2.92	2.98	40492600.0
2022-08-17	ABG	Stock	196.32	197.86	188.55	189.28	169100.0
2022-08-17	ABGI-DELISTED	Stock	9.86	9.86	9.86	9.86	6469.0
2022-08-17	ABM	Stock	46.85	47.41	46.61	47.01	166900.0
2022-08-17	ABMD-DELISTED	Stock	287.44	287.64	279.73	281.81	176096.0
2022-08-17	ABNB	Stock	121.63	123.27	120.64	121.87	4336200.0
2022-08-17	ABOS	Stock	5.5	5.98	5.5	5.52	36900.0
2022-08-17	ABR	Stock	15.8	15.8	15.46	15.62	1793700.0

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

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