PREVIEW / stock_daily / 2006-01-09

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-09.parquet
  size:    145 KB
  rows:    4,330
  symbols: 2,744

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-09	AAPL	Stock	2.7404	2.7571	2.705	2.7161	675040800.0
2006-01-09	MSFT	Stock	26.93	27.07	26.76	26.86	55625000.0
2006-01-09	NVDA	Stock	0.3402	0.3517	0.3394	0.3498	560484000.0
2006-01-09	AMZN	Stock	2.3275	2.355	2.32	2.354	178862000.0
2006-01-09	CL	Stock	27.34	27.81	27.31	27.735	3398600.0
2006-01-09	A	Stock	24.7854	24.8927	24.6209	24.7139	4082859.0
2006-01-09	AABA-DELISTED	Stock	43.0999984741211	43.6599998474121	42.8199996948242	43.4199981689453	16266900.0
2006-01-09	AACC-DELISTED	Stock	22.48	23.5	22.381	23.12	175695.0
2006-01-09	AACQ-DELISTED	Stock	5.21	5.21	5.21	5.21	29000.0
2006-01-09	AAI-DELISTED	Stock	16.53	16.72	16.3	16.46	1174900.0
2006-01-09	AAIC-DELISTED	Stock	213.4	220.0	212.6	215.6	1391200.0
2006-01-09	AAME	Stock	2.66	2.69	2.66	2.67	1400.0
2006-01-09	AAON	Stock	2.344	2.4362	2.344	2.4296	69862.0
2006-01-09	AAP	Stock	43.9	44.74	43.9	44.56	609700.0
2006-01-09	AATI-DELISTED	Stock	13.77	13.77	13.48	13.5	146694.0
2006-01-09	AAU-DELISTED	Stock	2.58	2.98	2.58	2.68	338400.0
2006-01-09	AAUAF-DELISTED	Stock	2.58	2.98	2.58	2.68	338400.0
2006-01-09	AAV-DELISTED	Stock	18.6	18.64	18.16	18.32	283100.0
2006-01-09	AAWW-DELISTED	Stock	44.0	45.0	42.0	44.0	12500.0
2006-01-09	AAXN-DELISTED	Stock	7.75	8.38000011444092	7.59999990463257	8.19999980926514	4903300.0
2006-01-09	ABAX-DELISTED	Stock	17.85	17.9	17.71	17.74	97790.0
2006-01-09	ABB-DELISTED	Stock	10.88	10.95	10.83	10.93	2326200.0
2006-01-09	ABBC-DELISTED	Stock	13.65	13.65	13.42	13.49	1914.0
2006-01-09	ABC-DELISTED	Stock	20.43	20.54	20.16	20.5	2479400.0
2006-01-09	ABCB	Stock	19.4626	19.9489	19.3167	19.8711	8636.0
2006-01-09	ABCO-DELISTED	Stock	23.33	23.59	23.28	23.57	228004.0
2006-01-09	ABCW-DELISTED	Stock	31.36	31.54	31.21	31.47	38350.0
2006-01-09	ABD-DELISTED	Stock	24.24	24.92	24.24	24.73	364300.0
2006-01-09	ABE-DELISTED	Stock	12.6	12.93	12.6	12.85	60500.0
2006-01-09	ABFS-DELISTED	Stock	44.55	45.88	44.55	45.42	298171.0
2006-01-09	ABG	Stock	16.67	16.86	16.35	16.56	30900.0
2006-01-09	ABK-DELISTED	Stock	79.25	79.54	78.78	79.33	412000.0
2006-01-09	ABM	Stock	20.06	20.36	20.02	20.2	132900.0
2006-01-09	ABMD-DELISTED	Stock	9.59	10.16	9.59	10.12	132119.0
2006-01-09	ABP-DELISTED	Stock	5.95	5.96	5.45	5.54	1004500.0
2006-01-09	ABR	Stock	26.56	27.14	26.56	27.07	40100.0
2006-01-09	ABT	Stock	20.3915	20.5114	19.9981	20.3483	23626303.0
2006-01-09	ABTL-DELISTED	Stock	25.17	25.63	25.17	25.48	16989.0
2006-01-09	ABV-DELISTED	Stock	41.1	41.28	40.66	40.94	409300.0
2006-01-09	ABVA-DELISTED	Stock	16.2	16.43	16.12	16.12	1905.0
2006-01-09	ABX-DELISTED	Stock	29.7	30.46	29.46	29.94	5442800.0
2006-01-09	ACAD	Stock	10.5	10.85	10.48	10.69	123200.0
2006-01-09	ACAP-DELISTED	Stock	48.01	48.71	47.25	48.44	76448.0
2006-01-09	ACAS-DELISTED	Stock	35.84	36.09	35.79	35.96	1817714.0
2006-01-09	ACAT-DELISTED	Stock	22.38	22.89	22.18	22.68	103062.0
2006-01-09	ACC-DELISTED	Stock	25.35	25.55	25.1	25.24	82400.0
2006-01-09	ACCL-DELISTED	Stock	7.8	7.81	7.66	7.78	86482.0
2006-01-09	ACCO	Stock	24.24	24.92	24.24	24.73	367100.0
2006-01-09	ACE-DELISTED	Stock	56.09	56.26	55.7	55.94	623900.0
2006-01-09	ACF-DELISTED	Stock	26.0	26.71	26.0	26.68	1937100.0

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

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