PREVIEW / stock_daily / 2006-01-04

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-04.parquet
  size:    145 KB
  rows:    4,345
  symbols: 2,755

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
2006-01-04	AAPL	Stock	2.6832	2.7136	2.6607	2.6775	619603600.0
2006-01-04	MSFT	Stock	26.77	27.08	26.77	26.97	57975600.0
2006-01-04	NVDA	Stock	0.3209	0.3279	0.3176	0.3274	510072000.0
2006-01-04	AMZN	Stock	2.3745	2.3865	2.3345	2.3625	148818000.0
2006-01-04	CL	Stock	27.42	27.83	27.415	27.78	3951600.0
2006-01-04	A	Stock	23.9986	24.1989	23.8698	24.0272	4195817.0
2006-01-04	AABA-DELISTED	Stock	41.2200012207031	41.9000015258789	40.7700004577637	40.9700012207031	20549000.0
2006-01-04	AACC-DELISTED	Stock	22.72	22.72	22.261	22.49	113996.0
2006-01-04	AACQ-DELISTED	Stock	5.22	5.22	5.2	5.2	4000.0
2006-01-04	AACQU-DELISTED	Stock	6.15	6.15	6.15	6.15	150000.0
2006-01-04	AACQW-DELISTED	Stock	0.52	0.52	0.52	0.52	5000.0
2006-01-04	AAI-DELISTED	Stock	16.34	16.85	16.32	16.73	1336100.0
2006-01-04	AAIC-DELISTED	Stock	207.2	209.0	205.4	207.2	843300.0
2006-01-04	AAME	Stock	2.71	2.71	2.71	2.71	200.0
2006-01-04	AAON	Stock	2.3691	2.4296	2.3691	2.3888	77456.0
2006-01-04	AAP	Stock	43.9	44.71	43.65	43.83	896800.0
2006-01-04	AATI-DELISTED	Stock	13.95	14.15	13.63	13.93	196722.0
2006-01-04	AAU-DELISTED	Stock	2.3	2.38	2.3	2.37	346100.0
2006-01-04	AAUAF-DELISTED	Stock	2.3	2.38	2.3	2.37	346100.0
2006-01-04	AAV-DELISTED	Stock	19.5	19.5	19.15	19.34	153000.0
2006-01-04	AAWW-DELISTED	Stock	44.0	45.0	43.5	45.0	12800.0
2006-01-04	AAXN-DELISTED	Stock	7.09999990463257	7.32000017166138	7.01000022888184	7.30000019073486	1601000.0
2006-01-04	ABAX-DELISTED	Stock	16.82	17.99	16.75	17.75	166031.0
2006-01-04	ABB-DELISTED	Stock	10.35	10.54	10.34	10.48	2293500.0
2006-01-04	ABBC-DELISTED	Stock	13.34	13.65	13.15	13.54	49961.0
2006-01-04	ABC-DELISTED	Stock	21.0	21.24	20.82	20.97	2771000.0
2006-01-04	ABCB	Stock	19.0249	19.5501	18.9957	19.3167	11309.0
2006-01-04	ABCO-DELISTED	Stock	24.02	24.42	23.69	24.42	255832.0
2006-01-04	ABCW-DELISTED	Stock	31.14	31.44	31.02	31.23	33350.0
2006-01-04	ABD-DELISTED	Stock	24.09	24.17	23.84	24.17	451820.0
2006-01-04	ABE-DELISTED	Stock	11.9	12.18	11.85	12.18	34200.0
2006-01-04	ABFS-DELISTED	Stock	44.4	45.17	44.02	44.34	253635.0
2006-01-04	ABG	Stock	16.32	17.2	16.31	16.85	84700.0
2006-01-04	ABK-DELISTED	Stock	78.55	80.03	78.55	78.83	633700.0
2006-01-04	ABM	Stock	19.6	19.86	19.52	19.8	228000.0
2006-01-04	ABMD-DELISTED	Stock	9.42	9.73	9.24	9.68	58255.0
2006-01-04	ABP-DELISTED	Stock	5.51	5.55	5.35	5.55	301200.0
2006-01-04	ABR	Stock	26.35	26.52	26.13	26.52	70400.0
2006-01-04	ABT	Stock	18.8945	19.1824	18.7986	19.0049	16334514.0
2006-01-04	ABTL-DELISTED	Stock	24.25	24.75	24.2	24.5	25902.0
2006-01-04	ABV-DELISTED	Stock	39.1	39.79	39.1	39.5	559900.0
2006-01-04	ABVA-DELISTED	Stock	16.0	16.15	16.0	16.001	1643.0
2006-01-04	ABX-DELISTED	Stock	28.7	29.51	28.63	29.5	6473756.0
2006-01-04	ACAD	Stock	10.13	10.13	9.91	9.97	54300.0
2006-01-04	ACAP-DELISTED	Stock	45.86	47.13	45.86	46.59	67455.0
2006-01-04	ACAS-DELISTED	Stock	36.39	36.87	36.27	36.69	660229.0
2006-01-04	ACAT-DELISTED	Stock	20.7	21.58	20.38	21.3	95557.0
2006-01-04	ACC-DELISTED	Stock	24.6	24.87	24.57	24.74	82600.0
2006-01-04	ACCL-DELISTED	Stock	7.9	7.9	7.68	7.76	349287.0
2006-01-04	ACCO	Stock	24.1	24.18	23.85	24.16	452700.0

> showing 50 of 4,345 rows — these rows as CSV

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