PREVIEW / stock_daily / 2022-09-21

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-21.parquet
  size:    252 KB
  rows:    7,887
  symbols: 2,217

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-09-21	AAPL	Stock	157.34	158.74	153.6	153.72	101696800.0
2022-09-21	MSFT	Stock	244.27	247.66	238.9	238.95	28625600.0
2022-09-21	NVDA	Stock	13.213	14.031	13.11	13.261	807679000.0
2022-09-21	AMZN	Stock	122.49	123.76	118.45	118.54	58498900.0
2022-09-21	GOOGL	Stock	101.67	102.88	99.27	99.28	31487265.0
2022-09-21	META	Stock	146.39	149.6	142.0	142.12	38338600.0
2022-09-21	TSLA	Stock	308.29	313.8	300.63	300.8	62555700.0
2022-09-21	TLT	Stock	106.7	108.04	105.97	108.03	23132922.0
2022-09-21	ES	Stock	89.2	89.84	87.82	87.83	1122500.0
2022-09-21	CL	Stock	75.58	76.32	74.89	74.9	2884500.0
2022-09-21	A	Stock	128.73	130.57	126.33	126.48	1105700.0
2022-09-21	AA	Stock	43.5	43.87	39.37	39.41	11720000.0
2022-09-21	AAC-DELISTED	Stock	9.93	9.94	9.93	9.94	380156.0
2022-09-21	AACG	Stock	1.99	2.0	1.91	1.98	21300.0
2022-09-21	AAIC-DELISTED	Stock	3.06	3.0865	3.06	3.07	26858.0
2022-09-21	AAIC.C-DELISTED	Stock	20.05	20.12	20.05	20.12	1600.0
2022-09-21	AAL	Stock	13.85	13.85	13.23	13.23	40988700.0
2022-09-21	AAM.A-DELISTED	Stock	23.61	23.9654	23.6	23.68	14037.0
2022-09-21	AAM.B-DELISTED	Stock	23.77	24.38	23.6436	23.95	12231.0
2022-09-21	AAMC-DELISTED	Stock	5.4412	5.4412	5.4412	5.4412	2424.0
2022-09-21	AAME	Stock	3.06	3.1	2.94	3.09	2200.0
2022-09-21	AAMI	Stock	16.7	16.91	16.27	16.3	123600.0
2022-09-21	AAN-DELISTED	Stock	11.61	11.99	11.49	11.5	268900.0
2022-09-21	AAOI	Stock	3.21	3.44	3.12	3.33	878700.0
2022-09-21	AAON	Stock	38.5133	39.1733	37.8667	37.9467	185850.0
2022-09-21	AAP	Stock	167.78	169.43	165.44	165.5	606100.0
2022-09-21	AAQC-DELISTED	Stock	9.81	9.82	9.81	9.82	79532.0
2022-09-21	AAT	Stock	27.28	27.47	26.6	26.61	327000.0
2022-09-21	AATC	Stock	5.05	5.11	5.04	5.05	16692.0
2022-09-21	AAU-DELISTED	Stock	0.2176	0.2275	0.2091	0.2275	302440.0
2022-09-21	AAUAF-DELISTED	Stock	0.2176	0.23	0.2091	0.23	305857.0
2022-09-21	AAWW-DELISTED	Stock	99.24	99.5	99.03	99.23	506411.0
2022-09-21	AAXJ	Stock	63.26	63.58	62.57	62.59	759100.0
2022-09-21	AB	Stock	41.68	41.87	40.78	40.78	219800.0
2022-09-21	ABB-DELISTED	Stock	26.95	27.195	26.53	26.535	1612170.0
2022-09-21	ABBNY-DELISTED	Stock	26.95	27.195	26.53	26.54	1745317.0
2022-09-21	ABBV	Stock	142.15	143.63	140.29	140.31	5076100.0
2022-09-21	ABC-DELISTED	Stock	139.93	142.26	139.11	139.11	631147.0
2022-09-21	ABCB	Stock	48.6	49.33	48.28	48.46	290800.0
2022-09-21	ABCL	Stock	10.33	10.58	10.01	10.23	1447000.0
2022-09-21	ABCM-DELISTED	Stock	15.89	15.95	15.5	15.57	292934.0
2022-09-21	ABEO	Stock	3.71	3.79	3.53	3.58	92400.0
2022-09-21	ABEV	Stock	3.0	3.02	2.94	2.95	31717000.0
2022-09-21	ABG	Stock	154.53	156.24	150.03	150.27	124500.0
2022-09-21	ABGI-DELISTED	Stock	9.91	9.92	9.91	9.92	9915.0
2022-09-21	ABM	Stock	40.54	40.99	39.83	39.83	427800.0
2022-09-21	ABMD-DELISTED	Stock	258.99	264.295	252.8	252.82	131545.0
2022-09-21	ABNB	Stock	116.37	119.33	112.36	114.01	6898700.0
2022-09-21	ABOS	Stock	4.89	4.93	4.67	4.77	29500.0
2022-09-21	ABR	Stock	14.48	14.52	14.09	14.09	1513500.0

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

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