PREVIEW / stock_daily / 2022-12-13

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-13.parquet
  size:    252 KB
  rows:    7,795
  symbols: 2,034

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-12-13	AAPL	Stock	149.5	149.97	144.24	145.47	93886200.0
2022-12-13	MSFT	Stock	261.69	263.92	253.07	256.92	42196900.0
2022-12-13	NVDA	Stock	18.531	18.79	17.711	18.072	656589000.0
2022-12-13	AMZN	Stock	95.23	96.25	90.52	92.49	100212000.0
2022-12-13	GOOGL	Stock	97.76	99.53	95.03	95.63	40593656.0
2022-12-13	META	Stock	122.13	123.3	118.64	120.15	44701100.0
2022-12-13	TSLA	Stock	174.87	175.05	156.91	160.95	175862700.0
2022-12-13	TLT	Stock	109.04	109.08	107.455	107.7	23854670.0
2022-12-13	ES	Stock	86.79	87.58	85.09	85.95	2191700.0
2022-12-13	CL	Stock	79.25	79.45	78.02	78.75	3760500.0
2022-12-13	A	Stock	159.2	160.26	156.76	157.66	1534200.0
2022-12-13	AA	Stock	48.55	48.88	45.45	46.17	4444300.0
2022-12-13	AAC-DELISTED	Stock	10.06	10.08	10.06	10.06	492380.0
2022-12-13	AACG	Stock	1.48	1.54	1.46	1.53	3300.0
2022-12-13	AAIC-DELISTED	Stock	3.04	3.04	2.97	2.98	81747.0
2022-12-13	AAIC.C-DELISTED	Stock	21.5	21.62	21.5	21.5	2046.0
2022-12-13	AAL	Stock	14.6	14.74	13.29	13.46	51620100.0
2022-12-13	AAM.A-DELISTED	Stock	23.29	23.4775	23.0	23.2561	31553.0
2022-12-13	AAM.B-DELISTED	Stock	22.91	23.14	22.7563	23.01	40489.0
2022-12-13	AAMC-DELISTED	Stock	6.6265	6.65	6.5647	6.5647	6474.0
2022-12-13	AAME	Stock	2.5	2.67	2.5	2.67	8400.0
2022-12-13	AAMI	Stock	20.11	20.21	19.56	19.69	143800.0
2022-12-13	AAN-DELISTED	Stock	12.55	12.81	11.97	12.41	665700.0
2022-12-13	AAOI	Stock	2.15	2.28	2.13	2.14	183100.0
2022-12-13	AAON	Stock	54.1533	55.3333	52.9733	53.1	328950.0
2022-12-13	AAP	Stock	148.85	149.07	144.94	145.68	1110300.0
2022-12-13	AAQC-DELISTED	Stock	10.08	10.09	10.08	10.085	26839.0
2022-12-13	AAT	Stock	27.85	27.96	27.27	27.38	368200.0
2022-12-13	AATC	Stock	5.17	5.17	5.0	5.09	3553.0
2022-12-13	AAU-DELISTED	Stock	0.2429	0.25	0.2375	0.2383	293536.0
2022-12-13	AAUAF-DELISTED	Stock	0.2429	0.25	0.2375	0.24	296079.0
2022-12-13	AAWW-DELISTED	Stock	100.96	101.0	100.55	100.7	1077287.0
2022-12-13	AAXJ	Stock	67.1	67.43	66.21	66.41	1779206.0
2022-12-13	AB	Stock	39.4	40.2	38.85	39.51	1011000.0
2022-12-13	ABB-DELISTED	Stock	32.07	32.21	31.585	31.735	1544490.0
2022-12-13	ABBNY-DELISTED	Stock	32.07	32.21	31.585	31.75	1779755.0
2022-12-13	ABBV	Stock	166.95	167.5	164.67	164.79	5050400.0
2022-12-13	ABC-DELISTED	Stock	167.92	167.92	164.23	165.1	888422.0
2022-12-13	ABCB	Stock	50.81	51.67	48.95	49.06	414800.0
2022-12-13	ABCL	Stock	10.97	11.03	10.015	10.08	2476900.0
2022-12-13	ABCM-DELISTED	Stock	15.36	15.89	15.21	15.84	3346232.0
2022-12-13	ABEO	Stock	3.13	3.25	2.95	3.0	485600.0
2022-12-13	ABEV	Stock	2.9	2.94	2.85	2.85	71171600.0
2022-12-13	ABG	Stock	185.78	186.66	174.74	175.77	275800.0
2022-12-13	ABGI-DELISTED	Stock	10.06	10.06	10.06	10.06	2300.0
2022-12-13	ABLV	Stock	10.12	10.12	10.12	10.12	5001.0
2022-12-13	ABM	Stock	46.68	47.18	45.29	45.61	669700.0
2022-12-13	ABMD-DELISTED	Stock	380.29	381.03	380.1	380.4	3441691.0
2022-12-13	ABNB	Stock	100.37	100.65	93.12	93.34	7378900.0
2022-12-13	ABOS	Stock	5.63	5.99	5.55	5.83	84100.0

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

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