PREVIEW / stock_daily / 2022-06-23

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-23.parquet
  size:    255 KB
  rows:    7,915
  symbols: 2,317

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-06-23	AAPL	Stock	136.82	138.59	135.63	138.27	72433800.0
2022-06-23	MSFT	Stock	255.57	259.37	253.63	258.86	25861400.0
2022-06-23	NVDA	Stock	16.519	16.585	15.853	16.225	463680000.0
2022-06-23	AMZN	Stock	110.39	113.0	107.93	112.44	64345300.0
2022-06-23	GOOGL	Stock	112.2315	112.7425	110.5005	112.242	28361920.0
2022-06-23	META	Stock	156.27	159.75	154.25	158.75	40499200.0
2022-06-23	TSLA	Stock	237.9067	239.3167	228.6367	235.07	104202600.0
2022-06-23	TLT	Stock	113.9	115.165	113.49	114.14	20669222.0
2022-06-23	ES	Stock	80.85	82.38	80.82	82.1	1263300.0
2022-06-23	CL	Stock	78.15	79.18	78.12	78.88	3932400.0
2022-06-23	A	Stock	114.6	118.75	114.27	118.6	1801600.0
2022-06-23	AA	Stock	47.98	48.795	45.22	46.62	8209100.0
2022-06-23	AAC-DELISTED	Stock	9.82	9.83	9.82	9.83	65307.0
2022-06-23	AACG	Stock	1.03	1.04	1.03	1.03	4000.0
2022-06-23	AACIW-DELISTED	Stock	0.2	0.2	0.2	0.2	1927.0
2022-06-23	AAIC-DELISTED	Stock	3.1	3.27	3.04	3.27	86452.0
2022-06-23	AAIC.C-DELISTED	Stock	22.72	22.72	22.58	22.59	1410.0
2022-06-23	AAL	Stock	13.02	13.18	12.58	12.98	31067800.0
2022-06-23	AAM.A-DELISTED	Stock	23.98	24.2129	23.77	24.01	14037.0
2022-06-23	AAM.B-DELISTED	Stock	25.35	25.36	24.66	24.66	10125.0
2022-06-23	AAMC-DELISTED	Stock	3.3824	3.3824	3.1912	3.2382	9993.0
2022-06-23	AAME	Stock	3.09	3.09	2.83	2.94	4400.0
2022-06-23	AAMI	Stock	19.02	19.02	18.45	18.88	272000.0
2022-06-23	AAN-DELISTED	Stock	15.28	15.75	15.28	15.75	325100.0
2022-06-23	AAOI	Stock	1.96	2.06	1.9	1.975	274700.0
2022-06-23	AAON	Stock	33.9533	34.9733	33.8333	34.9333	270450.0
2022-06-23	AAP	Stock	176.34	179.04	175.13	178.63	644100.0
2022-06-23	AAQC-DELISTED	Stock	9.7698	9.8	9.76	9.8	24531.0
2022-06-23	AAT	Stock	29.28	29.73	29.07	29.59	160500.0
2022-06-23	AATC	Stock	5.29	5.44	5.29	5.39	13359.0
2022-06-23	AAU-DELISTED	Stock	0.2439	0.2563	0.2302	0.236	475202.0
2022-06-23	AAUAF-DELISTED	Stock	0.2439	0.2563	0.2302	0.2405	478805.0
2022-06-23	AAWW-DELISTED	Stock	62.52	63.55	61.4801	63.51	197296.0
2022-06-23	AAXJ	Stock	68.29	68.66	67.75	68.43	1396438.0
2022-06-23	AB	Stock	41.0	42.3	40.98	41.89	300900.0
2022-06-23	ABB-DELISTED	Stock	26.15	26.19	25.8	26.19	3195017.0
2022-06-23	ABBNY-DELISTED	Stock	26.15	26.19	25.8	26.18	3458477.0
2022-06-23	ABBV	Stock	148.72	150.8	147.54	149.45	7795000.0
2022-06-23	ABC-DELISTED	Stock	145.91	146.39	143.63	144.585	663265.0
2022-06-23	ABCB	Stock	41.08	41.23	39.77	40.3	245900.0
2022-06-23	ABCL	Stock	10.36	10.8	10.29	10.55	3078300.0
2022-06-23	ABCM-DELISTED	Stock	13.97	14.61	13.97	14.58	92739.0
2022-06-23	ABEO	Stock	4.25	4.75	4.0	4.75	102908.0
2022-06-23	ABEV	Stock	2.53	2.54	2.5	2.52	36052600.0
2022-06-23	ABG	Stock	165.66	168.28	163.33	166.36	139000.0
2022-06-23	ABM	Stock	42.39	42.62	41.74	42.03	606200.0
2022-06-23	ABMD-DELISTED	Stock	239.37	250.01	236.29	248.61	155217.0
2022-06-23	ABNB	Stock	100.0	100.8	93.02	95.72	12340800.0
2022-06-23	ABOS	Stock	3.45	3.69	3.44	3.69	224100.0
2022-06-23	ABR	Stock	12.93	13.16	12.88	13.09	2526300.0

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

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