PREVIEW / stock_daily / 2022-06-09

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-09.parquet
  size:    256 KB
  rows:    7,923
  symbols: 2,348

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-09	AAPL	Stock	147.08	147.95	142.53	142.64	69473000.0
2022-06-09	MSFT	Stock	267.78	272.71	264.63	264.79	26439700.0
2022-06-09	NVDA	Stock	18.481	18.933	18.041	18.048	395574000.0
2022-06-09	AMZN	Stock	119.99	121.3	116.1	116.15	67029800.0
2022-06-09	GOOGL	Stock	116.3275	118.299	114.776	114.8355	25797960.0
2022-06-09	META	Stock	194.28	199.45	183.68	184.0	23501600.0
2022-06-09	TSLA	Stock	249.34	255.5467	239.3267	239.7067	96491400.0
2022-06-09	TLT	Stock	113.835	114.71	113.68	114.48	15527256.0
2022-06-09	ES	Stock	90.76	91.39	87.77	87.82	981400.0
2022-06-09	CL	Stock	78.09	78.91	76.72	76.85	6327300.0
2022-06-09	A	Stock	126.09	126.92	124.13	124.14	814400.0
2022-06-09	AA	Stock	61.46	61.7	55.56	55.56	10339700.0
2022-06-09	AAC-DELISTED	Stock	9.83	9.83	9.82	9.825	2844.0
2022-06-09	AACG	Stock	1.04	1.12	1.04	1.08	5900.0
2022-06-09	AAIC-DELISTED	Stock	3.63	3.63	3.5917	3.61	25096.0
2022-06-09	AAIC.C-DELISTED	Stock	23.6599	23.6599	23.5507	23.5507	905.0
2022-06-09	AAL	Stock	16.08	16.22	15.46	15.47	31530200.0
2022-06-09	AAM.A-DELISTED	Stock	24.69	24.81	24.5277	24.7	21584.0
2022-06-09	AAM.B-DELISTED	Stock	25.64	25.6833	25.0	25.3528	7785.0
2022-06-09	AAMC-DELISTED	Stock	4.1147	4.1147	3.8971	4.0441	8055.0
2022-06-09	AAME	Stock	3.01	3.04	3.0	3.04	2100.0
2022-06-09	AAMI	Stock	20.6	20.92	20.43	20.46	251600.0
2022-06-09	AAN-DELISTED	Stock	19.03	19.095	18.71	18.73	173000.0
2022-06-09	AAOI	Stock	2.38	2.39	2.22	2.24	199000.0
2022-06-09	AAON	Stock	36.8333	37.2	36.4933	36.76	219150.0
2022-06-09	AAP	Stock	184.86	187.94	184.17	184.66	632700.0
2022-06-09	AAT	Stock	31.89	31.89	31.11	31.17	240400.0
2022-06-09	AATC	Stock	5.83	5.8627	5.75	5.75	3225.0
2022-06-09	AAU-DELISTED	Stock	0.27	0.2789	0.2551	0.2551	146001.0
2022-06-09	AAUAF-DELISTED	Stock	0.27	0.2789	0.2545	0.2545	148969.0
2022-06-09	AAWW-DELISTED	Stock	69.84	69.84	67.41	67.49	399802.0
2022-06-09	AAXJ	Stock	71.8	71.97	70.73	70.73	1149277.0
2022-06-09	AB	Stock	42.75	43.66	42.56	42.84	228100.0
2022-06-09	ABB-DELISTED	Stock	30.45	30.6	29.94	29.94	1486746.0
2022-06-09	ABBNY-DELISTED	Stock	30.45	30.6	29.93	29.93	1617867.0
2022-06-09	ABBV	Stock	149.72	150.52	145.3	145.43	5642900.0
2022-06-09	ABC-DELISTED	Stock	145.39	146.76	143.89	143.95	588519.0
2022-06-09	ABCB	Stock	44.46	45.04	43.48	43.54	302900.0
2022-06-09	ABCL	Stock	8.48	9.1	8.39	8.39	6200700.0
2022-06-09	ABCM-DELISTED	Stock	15.04	15.04	14.75	14.8	112940.0
2022-06-09	ABEO	Stock	4.25	4.75	4.0	4.25	136624.0
2022-06-09	ABEV	Stock	2.75	2.78	2.71	2.71	29476600.0
2022-06-09	ABG	Stock	187.11	190.74	185.29	188.57	166700.0
2022-06-09	ABGI-DELISTED	Stock	9.8	9.82	9.8	9.82	47292.0
2022-06-09	ABM	Stock	46.75	47.48	43.01	43.48	1698500.0
2022-06-09	ABMD-DELISTED	Stock	261.76	264.02	256.9	257.13	86034.0
2022-06-09	ABNB	Stock	122.31	122.98	115.42	115.72	5315900.0
2022-06-09	ABOS	Stock	3.94	4.02	3.5	3.87	212100.0
2022-06-09	ABR	Stock	15.92	15.98	15.63	15.63	2159500.0
2022-06-09	ABR.D	Stock	22.3959	22.4899	21.825	22.04	17211.0

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

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