PREVIEW / stock_daily / 2022-06-28

all stock daily files

  file:    by_date/stock_daily/2022/2022-06-28.parquet
  size:    254 KB
  rows:    7,918
  symbols: 2,330

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-28	AAPL	Stock	142.13	143.42	137.32	137.44	67083400.0
2022-06-28	MSFT	Stock	263.98	266.91	256.32	256.48	27295500.0
2022-06-28	NVDA	Stock	16.9	17.202	15.945	15.982	461149000.0
2022-06-28	AMZN	Stock	113.5	114.85	107.04	107.4	74942900.0
2022-06-28	GOOGL	Stock	115.8025	117.3095	111.848	112.0075	35880960.0
2022-06-28	META	Stock	169.9	171.3	160.61	160.68	27744500.0
2022-06-28	TSLA	Stock	244.4833	249.97	232.3433	232.6633	90391200.0
2022-06-28	TLT	Stock	111.29	112.18	110.87	112.12	13708196.0
2022-06-28	ES	Stock	84.46	85.4	83.35	83.42	2258600.0
2022-06-28	CL	Stock	80.0	80.37	78.77	78.88	3193800.0
2022-06-28	A	Stock	120.45	121.24	116.72	117.06	1426100.0
2022-06-28	AA	Stock	50.12	51.1	48.868	49.25	5221300.0
2022-06-28	AAC-DELISTED	Stock	9.83	9.85	9.83	9.84	132655.0
2022-06-28	AACG	Stock	1.19	1.19	1.08	1.12	6800.0
2022-06-28	AACIW-DELISTED	Stock	0.16	0.2798	0.16	0.18	77400.0
2022-06-28	AAIC-DELISTED	Stock	3.27	3.35	3.22	3.23	87823.0
2022-06-28	AAIC.C-DELISTED	Stock	22.31	22.515	22.31	22.31	2640.0
2022-06-28	AAL	Stock	13.8	14.48	13.47	13.5	36500500.0
2022-06-28	AAM.A-DELISTED	Stock	24.06	24.1	23.85	23.91	19028.0
2022-06-28	AAM.B-DELISTED	Stock	24.975	25.0979	24.86	25.0979	1442.0
2022-06-28	AAMC-DELISTED	Stock	3.2412	3.2529	3.1004	3.1618	14032.0
2022-06-28	AAME	Stock	2.85	2.85	2.7	2.7	2000.0
2022-06-28	AAMI	Stock	19.46	19.76	18.74	18.82	377700.0
2022-06-28	AAN-DELISTED	Stock	16.2	16.41	15.31	15.34	166700.0
2022-06-28	AAOI	Stock	1.77	1.887	1.722	1.75	179600.0
2022-06-28	AAON	Stock	35.9533	36.2467	34.7933	34.8667	186600.0
2022-06-28	AAP	Stock	184.72	186.23	177.93	178.75	673000.0
2022-06-28	AAQC-DELISTED	Stock	9.8	9.8	9.775	9.8	39102.0
2022-06-28	AAT	Stock	30.63	30.9	29.98	30.02	134200.0
2022-06-28	AATC	Stock	5.3304	5.4399	5.3077	5.4	4861.0
2022-06-28	AAU-DELISTED	Stock	0.2301	0.255	0.2301	0.235	446875.0
2022-06-28	AAUAF-DELISTED	Stock	0.2301	0.255	0.2301	0.235	449636.0
2022-06-28	AAWW-DELISTED	Stock	65.52	66.51	64.54	64.73	368830.0
2022-06-28	AAXJ	Stock	70.55	70.89	69.62	69.62	1104449.0
2022-06-28	AB	Stock	43.24	43.41	42.41	42.79	187600.0
2022-06-28	ABB-DELISTED	Stock	27.21	27.47	26.86	26.87	1843035.0
2022-06-28	ABBNY-DELISTED	Stock	27.21	27.47	26.86	26.87	1989378.0
2022-06-28	ABBV	Stock	153.17	155.12	151.39	152.49	5735700.0
2022-06-28	ABC-DELISTED	Stock	148.9	150.0	143.15	143.23	1148031.0
2022-06-28	ABCB	Stock	41.61	42.01	40.64	40.84	284900.0
2022-06-28	ABCL	Stock	10.22	10.485	9.97	10.26	2120800.0
2022-06-28	ABCM-DELISTED	Stock	14.85	14.91	14.56	14.56	44492.0
2022-06-28	ABEO	Stock	4.5	5.0	4.5	4.5	112620.0
2022-06-28	ABEV	Stock	2.6	2.62	2.5	2.51	31646800.0
2022-06-28	ABG	Stock	179.59	182.6	174.09	175.04	158800.0
2022-06-28	ABGI-DELISTED	Stock	9.8	9.8	9.795	9.8	20073.0
2022-06-28	ABM	Stock	43.55	44.54	42.93	42.99	685800.0
2022-06-28	ABMD-DELISTED	Stock	254.66	258.21	248.54	249.14	87075.0
2022-06-28	ABNB	Stock	103.34	105.45	97.09	97.53	7744100.0
2022-06-28	ABOS	Stock	4.09	4.46	3.96	4.39	158400.0

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

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