PREVIEW / stock_daily / 2022-05-23

all stock daily files

  file:    by_date/stock_daily/2022/2022-05-23.parquet
  size:    256 KB
  rows:    7,936
  symbols: 2,371

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-05-23	AAPL	Stock	137.79	143.26	137.65	143.11	117726300.0
2022-05-23	MSFT	Stock	255.49	261.5	253.43	260.65	33175400.0
2022-05-23	NVDA	Stock	16.274	16.915	16.179	16.898	639889000.0
2022-05-23	AMZN	Stock	108.461	108.819	103.95	107.557	107798000.0
2022-05-23	GOOGL	Stock	109.5875	112.1475	108.741	111.488	37184940.0
2022-05-23	META	Stock	195.19	196.99	191.24	196.23	25059200.0
2022-05-23	TSLA	Stock	218.34	226.6533	212.6867	224.9667	88903500.0
2022-05-23	TLT	Stock	117.705	118.25	116.54	116.56	15925189.0
2022-05-23	ES	Stock	91.34	91.88	90.21	91.29	1670500.0
2022-05-23	CL	Stock	75.58	76.78	75.37	76.52	3754700.0
2022-05-23	A	Stock	126.45	126.47	123.76	125.98	2037000.0
2022-05-23	AA	Stock	62.3	63.65	59.86	63.14	6221400.0
2022-05-23	AAC-DELISTED	Stock	9.79	9.8	9.79	9.79	58990.0
2022-05-23	AACG	Stock	1.02	1.02	1.01	1.01	6300.0
2022-05-23	AACIW-DELISTED	Stock	0.2001	0.3	0.1704	0.2898	23717.0
2022-05-23	AAIC-DELISTED	Stock	3.39	3.49	3.35	3.48	86777.0
2022-05-23	AAIC.C-DELISTED	Stock	22.6	22.75	22.6	22.75	1600.0
2022-05-23	AAL	Stock	16.43	16.86	16.14	16.75	24684500.0
2022-05-23	AAM.A-DELISTED	Stock	24.12	24.14	23.94	24.14	42558.0
2022-05-23	AAM.B-DELISTED	Stock	24.75	25.25	24.68	25.0	67214.0
2022-05-23	AAMC-DELISTED	Stock	2.9055	3.05	2.8971	3.0471	11866.0
2022-05-23	AAME	Stock	2.71	2.71	2.69	2.71	3200.0
2022-05-23	AAMI	Stock	20.2	20.2	19.7	19.8	570600.0
2022-05-23	AAN-DELISTED	Stock	18.31	18.35	17.68	17.99	442500.0
2022-05-23	AAOI	Stock	2.3	2.35	2.23	2.24	114900.0
2022-05-23	AAON	Stock	34.7733	35.12	33.26	34.2067	303300.0
2022-05-23	AAP	Stock	182.07	184.71	176.78	183.24	1585500.0
2022-05-23	AAQC-DELISTED	Stock	9.76	9.76	9.74	9.76	4520.0
2022-05-23	AAT	Stock	32.17	32.41	31.47	32.26	214000.0
2022-05-23	AATC	Stock	6.01	6.0877	5.6101	5.73	12491.0
2022-05-23	AAU-DELISTED	Stock	0.27	0.2799	0.27	0.275	291983.0
2022-05-23	AAUAF-DELISTED	Stock	0.27	0.2799	0.27	0.275	296127.0
2022-05-23	AAWW-DELISTED	Stock	66.15	67.69	65.6	66.95	305558.0
2022-05-23	AAXJ	Stock	69.63	69.915	69.3	69.77	2464260.0
2022-05-23	AB	Stock	39.25	40.97	39.25	39.73	455000.0
2022-05-23	ABB-DELISTED	Stock	29.83	30.155	29.66	30.05	1774403.0
2022-05-23	ABBNY-DELISTED	Stock	29.83	30.155	29.66	30.04	1937380.0
2022-05-23	ABBV	Stock	151.65	152.0	147.19	148.03	6886400.0
2022-05-23	ABC-DELISTED	Stock	151.91	153.925	150.72	152.75	613211.0
2022-05-23	ABCB	Stock	43.7	44.21	43.06	43.61	384300.0
2022-05-23	ABCL	Stock	7.95	7.96	7.59	7.67	865200.0
2022-05-23	ABCM-DELISTED	Stock	14.73	14.95	14.67	14.9	261580.0
2022-05-23	ABEO	Stock	4.0	4.25	3.75	4.0	35248.0
2022-05-23	ABEV	Stock	2.85	2.9	2.84	2.9	25222100.0
2022-05-23	ABG	Stock	171.03	171.03	164.6	166.33	284500.0
2022-05-23	ABGI-DELISTED	Stock	9.79	9.79	9.79	9.79	6200.0
2022-05-23	ABM	Stock	46.23	46.39	45.54	45.93	461100.0
2022-05-23	ABMD-DELISTED	Stock	238.3	250.32	237.09	249.52	205771.0
2022-05-23	ABNB	Stock	113.545	115.15	110.93	113.28	6000800.0
2022-05-23	ABOS	Stock	3.51	3.62	3.41	3.45	184900.0

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

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