PREVIEW / stock_daily / 2023-01-17

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-17.parquet
  size:    250 KB
  rows:    7,736
  symbols: 1,928

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
2023-01-17	AAPL	Stock	134.83	137.29	134.13	135.94	63646600.0
2023-01-17	MSFT	Stock	237.97	240.91	237.09	240.35	29831300.0
2023-01-17	NVDA	Stock	16.899	17.728	16.899	17.702	511102000.0
2023-01-17	AMZN	Stock	98.68	98.89	95.73	96.05	72755000.0
2023-01-17	GOOGL	Stock	92.06	92.25	90.05	91.29	32602423.0
2023-01-17	META	Stock	136.18	136.75	134.25	135.36	21147600.0
2023-01-17	TSLA	Stock	125.7	131.7	125.02	131.49	186477000.0
2023-01-17	TLT	Stock	105.67	106.66	105.65	106.06	13911676.0
2023-01-17	ES	Stock	84.2	85.08	83.63	83.73	1480800.0
2023-01-17	CL	Stock	78.16	78.97	78.08	78.23	5615100.0
2023-01-17	A	Stock	156.68	158.11	155.03	155.4	1602200.0
2023-01-17	AA	Stock	54.61	55.49	54.06	54.86	5288200.0
2023-01-17	AAC-DELISTED	Stock	10.14	10.14	10.12	10.12	602823.0
2023-01-17	AACG	Stock	1.38	1.45	1.38	1.38	1800.0
2023-01-17	AACIW-DELISTED	Stock	0.07	0.07	0.0601	0.07	5571.0
2023-01-17	AAIC-DELISTED	Stock	3.03	3.06	3.02	3.03	38670.0
2023-01-17	AAIC.C-DELISTED	Stock	20.83	21.4	20.83	21.4	9547.0
2023-01-17	AAL	Stock	16.9	17.12	16.74	17.08	32875700.0
2023-01-17	AAM.A-DELISTED	Stock	23.9729	24.6	23.9729	24.58	14402.0
2023-01-17	AAM.B-DELISTED	Stock	24.7	24.7	24.25	24.52	9374.0
2023-01-17	AAMC-DELISTED	Stock	8.7941	8.9706	8.5412	8.7794	16021.0
2023-01-17	AAME	Stock	2.55	2.62	2.44	2.6	8200.0
2023-01-17	AAMI	Stock	21.52	21.89	21.32	21.73	162800.0
2023-01-17	AAN-DELISTED	Stock	14.43	14.43	13.86	13.86	217600.0
2023-01-17	AAOI	Stock	2.43	2.53	2.32	2.44	238900.0
2023-01-17	AAON	Stock	51.9133	52.6933	51.06	51.4	158850.0
2023-01-17	AAP	Stock	150.22	151.0	147.99	149.21	828800.0
2023-01-17	AAT	Stock	27.7	27.89	27.6	27.88	200000.0
2023-01-17	AATC	Stock	3.85	4.05	3.85	3.93	24814.0
2023-01-17	AAU-DELISTED	Stock	0.2452	0.2495	0.243	0.2455	268898.0
2023-01-17	AAUAF-DELISTED	Stock	0.2462	0.2495	0.243	0.2454	195450.0
2023-01-17	AAWW-DELISTED	Stock	101.91	101.93	101.47	101.65	306646.0
2023-01-17	AAXJ	Stock	70.39	70.44	70.1	70.32	834413.0
2023-01-17	AB	Stock	39.03	39.03	38.07	38.41	212500.0
2023-01-17	ABB-DELISTED	Stock	34.38	34.49	34.08	34.1	1724422.0
2023-01-17	ABBNY-DELISTED	Stock	34.38	34.49	34.08	34.1	1926041.0
2023-01-17	ABBV	Stock	153.8	155.1	152.58	152.83	8507000.0
2023-01-17	ABC-DELISTED	Stock	164.28	165.335	163.73	164.09	977078.0
2023-01-17	ABCB	Stock	49.36	49.36	48.64	48.96	228500.0
2023-01-17	ABCL	Stock	10.45	10.55	10.22	10.54	1050500.0
2023-01-17	ABCM-DELISTED	Stock	15.65	16.49	15.38	16.38	525696.0
2023-01-17	ABEO	Stock	2.7	2.72	2.66	2.67	204600.0
2023-01-17	ABEV	Stock	2.66	2.73	2.65	2.72	43180400.0
2023-01-17	ABG	Stock	185.35	188.81	184.19	186.19	132400.0
2023-01-17	ABGI-DELISTED	Stock	10.13	10.42	10.13	10.14	274675.0
2023-01-17	ABM	Stock	46.45	46.64	45.52	45.69	196200.0
2023-01-17	ABNB	Stock	99.915	102.735	99.1	101.27	5496200.0
2023-01-17	ABOS	Stock	6.23	6.298	5.991	6.11	73800.0
2023-01-17	ABR	Stock	14.25	14.43	14.19	14.24	1537900.0
2023-01-17	ABR.D	Stock	19.98	20.06	19.8144	19.965	33703.0

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

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