PREVIEW / stock_daily / 2023-01-06

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-06.parquet
  size:    249 KB
  rows:    7,756
  symbols: 1,961

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-06	AAPL	Stock	126.01	130.29	124.89	129.62	87754700.0
2023-01-06	MSFT	Stock	223.0	225.76	219.35	224.93	43613600.0
2023-01-06	NVDA	Stock	14.474	15.01	14.034	14.859	405044000.0
2023-01-06	AMZN	Stock	83.03	86.4	81.43	86.08	83303400.0
2023-01-06	GOOGL	Stock	86.79	87.69	84.86	87.34	41381495.0
2023-01-06	META	Stock	128.97	130.33	126.04	130.02	27584500.0
2023-01-06	TSLA	Stock	103.0	114.39	101.81	113.06	220911100.0
2023-01-06	TLT	Stock	102.7	105.3	102.64	105.18	27473733.0
2023-01-06	ES	Stock	84.93	86.26	84.39	85.8	912400.0
2023-01-06	CL	Stock	79.4	80.46	79.17	79.98	2274500.0
2023-01-06	A	Stock	154.36	154.64	143.01	147.67	2445000.0
2023-01-06	AA	Stock	46.52	47.74	45.68	46.36	4645200.0
2023-01-06	AAC-DELISTED	Stock	10.12	10.12	10.11	10.11	89706.0
2023-01-06	AACG	Stock	1.36	1.44	1.35	1.41	1300.0
2023-01-06	AACIU	Stock	10.15	10.15	10.13	10.13	1619.0
2023-01-06	AACIW-DELISTED	Stock	0.035	0.035	0.0349	0.0349	200.0
2023-01-06	AAIC-DELISTED	Stock	2.96	2.97	2.95	2.96	183822.0
2023-01-06	AAIC.C-DELISTED	Stock	21.52	21.52	21.29	21.29	2764.0
2023-01-06	AAL	Stock	14.01	14.25	13.92	14.18	29546400.0
2023-01-06	AAM.A-DELISTED	Stock	23.3	23.94	23.3	23.73	16325.0
2023-01-06	AAM.B-DELISTED	Stock	23.21	23.896	23.21	23.8	6961.0
2023-01-06	AAMC-DELISTED	Stock	6.9118	8.0882	6.9118	7.5118	61839.0
2023-01-06	AAME	Stock	2.43	2.53	2.43	2.44	1300.0
2023-01-06	AAMI	Stock	20.4	21.0	20.28	20.95	232400.0
2023-01-06	AAN-DELISTED	Stock	12.85	13.11	12.67	13.05	237400.0
2023-01-06	AAOI	Stock	1.9	1.909	1.83	1.86	159900.0
2023-01-06	AAON	Stock	47.5133	49.5533	47.4533	49.46	310500.0
2023-01-06	AAP	Stock	153.67	155.74	153.33	154.02	718200.0
2023-01-06	AAT	Stock	26.64	27.07	26.58	27.04	174200.0
2023-01-06	AATC	Stock	3.63	3.75	3.63	3.74	44083.0
2023-01-06	AAU-DELISTED	Stock	0.27	0.28	0.2599	0.262	228381.0
2023-01-06	AAUAF-DELISTED	Stock	0.27	0.28	0.2599	0.262	233918.0
2023-01-06	AAWW-DELISTED	Stock	101.5	101.59	101.28	101.28	201930.0
2023-01-06	AAXJ	Stock	67.91	68.78	67.43	68.77	702150.0
2023-01-06	AB	Stock	35.5	37.26	35.37	36.96	348900.0
2023-01-06	ABB-DELISTED	Stock	31.77	32.59	31.66	32.51	1333082.0
2023-01-06	ABBNY-DELISTED	Stock	31.77	32.59	31.66	32.51	1487784.0
2023-01-06	ABBV	Stock	164.84	168.11	164.12	166.55	5099100.0
2023-01-06	ABC-DELISTED	Stock	164.63	166.46	163.85	165.68	787566.0
2023-01-06	ABCB	Stock	46.6	47.67	46.27	47.47	233200.0
2023-01-06	ABCL	Stock	9.7	9.7	9.41	9.51	1673800.0
2023-01-06	ABCM-DELISTED	Stock	16.95	16.95	15.7	15.905	719454.0
2023-01-06	ABEO	Stock	3.11	3.15	2.99	3.1	188700.0
2023-01-06	ABEV	Stock	2.67	2.72	2.65	2.71	13126500.0
2023-01-06	ABG	Stock	182.85	185.22	181.19	184.23	170700.0
2023-01-06	ABGI-DELISTED	Stock	10.11	10.11	10.1	10.11	33923.0
2023-01-06	ABLV	Stock	10.22	10.22	10.16	10.16	7091.0
2023-01-06	ABM	Stock	46.01	46.61	45.88	46.21	302700.0
2023-01-06	ABNB	Stock	88.52	88.74	85.71	88.52	4348400.0
2023-01-06	ABOS	Stock	5.72	5.8	5.19	5.24	90000.0

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

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