PREVIEW / stock_daily / 2006-10-23

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-23.parquet
  size:    152 KB
  rows:    4,551
  symbols: 2,871

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-10-23	AAPL	Stock	2.8568	2.925	2.8482	2.9093	832507200.0
2006-10-23	MSFT	Stock	28.3	28.69	28.18	28.45	48525000.0
2006-10-23	NVDA	Stock	0.5287	0.5415	0.525	0.5263	280248000.0
2006-10-23	AMZN	Stock	1.6235	1.6455	1.607	1.644	161186000.0
2006-10-23	CL	Stock	30.34	30.36	30.075	30.155	4678000.0
2006-10-23	A	Stock	25.1001	25.3362	24.7282	24.8856	2680805.0
2006-10-23	AABA-DELISTED	Stock	23.1399993896484	23.5	23.1000003814697	23.3700008392334	26301200.0
2006-10-23	AACC-DELISTED	Stock	17.36	17.45	17.1	17.18	104762.0
2006-10-23	AACQ-DELISTED	Stock	5.32	5.37	5.32	5.37	24984.0
2006-10-23	AAI-DELISTED	Stock	11.1	11.39	10.99	11.3	2933000.0
2006-10-23	AAIC-DELISTED	Stock	156.8	156.8	147.8	150.0	2827100.0
2006-10-23	AAME	Stock	2.91	2.91	2.85	2.87	1100.0
2006-10-23	AAON	Stock	3.1249	3.1631	3.0947	3.117	85809.0
2006-10-23	AAP	Stock	35.46	36.31	35.43	36.25	1112100.0
2006-10-23	AATI-DELISTED	Stock	5.43	5.6899	5.36	5.67	285457.0
2006-10-23	AAU-DELISTED	Stock	2.5	2.5299	2.46	2.49	39000.0
2006-10-23	AAUAF-DELISTED	Stock	2.5	2.5299	2.46	2.49	39000.0
2006-10-23	AAV-DELISTED	Stock	13.98	13.98	13.75	13.79	632900.0
2006-10-23	AAWW-DELISTED	Stock	47.4	47.67	46.77	46.91	89867.0
2006-10-23	AAXN-DELISTED	Stock	9.25	9.55000019073486	9.21000003814697	9.39999961853027	1090700.0
2006-10-23	AB	Stock	74.5	76.22	74.02	75.75	216000.0
2006-10-23	ABAX-DELISTED	Stock	22.09	22.09	21.31	21.57	223481.0
2006-10-23	ABB-DELISTED	Stock	14.17	14.36	14.15	14.3101	2778300.0
2006-10-23	ABBC-DELISTED	Stock	15.93	16.0	15.91	15.96	3402.0
2006-10-23	ABC-DELISTED	Stock	23.3	23.74	23.25	23.7	1237800.0
2006-10-23	ABCB	Stock	26.9033	27.234	26.806	27.234	43798.0
2006-10-23	ABCO-DELISTED	Stock	27.31	27.89	27.21	27.72	93209.0
2006-10-23	ABCW-DELISTED	Stock	29.1	29.35	28.94	29.26	18950.0
2006-10-23	ABD-DELISTED	Stock	23.7	24.25	23.53	24.24	339400.0
2006-10-23	ABE-DELISTED	Stock	15.35	15.5	15.2	15.35	47500.0
2006-10-23	ABFS-DELISTED	Stock	42.0	42.4	40.27	41.62	1943646.0
2006-10-23	ABG	Stock	22.4	23.08	22.0	22.98	635400.0
2006-10-23	ABK-DELISTED	Stock	84.7	85.32	84.5	85.26	317200.0
2006-10-23	ABM	Stock	19.57	19.75	19.55	19.74	114900.0
2006-10-23	ABMD-DELISTED	Stock	13.82	14.4	13.62	14.06	159345.0
2006-10-23	ABP-DELISTED	Stock	3.66	3.66	3.51	3.51	112300.0
2006-10-23	ABR	Stock	27.23	27.39	27.1	27.25	48800.0
2006-10-23	ABT	Stock	23.2703	23.4814	23.1456	23.4286	8812839.0
2006-10-23	ABTL-DELISTED	Stock	16.425	16.575	16.075	16.275	14046.0
2006-10-23	ABV-DELISTED	Stock	44.44	44.87	44.14	44.57	760700.0
2006-10-23	ABVA-DELISTED	Stock	17.0301	17.26	17.01	17.26	1939.0
2006-10-23	ABVT-DELISTED	Stock	59.0	63.0	56.0	60.0	382.0
2006-10-23	ABX-DELISTED	Stock	29.6	30.41	29.37	30.34	5016470.0
2006-10-23	ACAD	Stock	9.99	10.05	9.72	9.8	121000.0
2006-10-23	ACAP-DELISTED	Stock	52.3	52.42	51.73	51.73	21833.0
2006-10-23	ACAS-DELISTED	Stock	41.319	41.65	41.27	41.5	948105.0
2006-10-23	ACAT-DELISTED	Stock	16.47	16.97	16.35	16.5	65002.0
2006-10-23	ACC-DELISTED	Stock	26.72	26.93	26.6	26.93	78000.0
2006-10-23	ACCL-DELISTED	Stock	6.26	6.26	6.1	6.15	63308.0
2006-10-23	ACCO	Stock	23.7	24.25	23.53	24.24	350800.0

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

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