PREVIEW / stock_daily / 2006-08-18

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-18.parquet
  size:    148 KB
  rows:    4,450
  symbols: 2,802

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-08-18	AAPL	Stock	2.4182	2.4429	2.4021	2.4254	536354000.0
2006-08-18	MSFT	Stock	25.05	25.8	24.98	25.79	128414800.0
2006-08-18	NVDA	Stock	0.4492	0.4583	0.4335	0.456	665898000.0
2006-08-18	AMZN	Stock	1.4545	1.4615	1.411	1.456	119972000.0
2006-08-18	CL	Stock	29.54	29.65	29.42	29.5	2446000.0
2006-08-18	A	Stock	23.083	23.083	22.475	22.7468	4099495.0
2006-08-18	AABA-DELISTED	Stock	28.8999996185303	29.9699993133545	28.7700004577637	29.7800006866455	19611300.0
2006-08-18	AACC-DELISTED	Stock	16.55	16.55	16.0	16.18	140341.0
2006-08-18	AACQ-DELISTED	Stock	5.32	5.32	5.3	5.3	23000.0
2006-08-18	AACQW-DELISTED	Stock	0.4	0.4	0.39	0.39	46000.0
2006-08-18	AAI-DELISTED	Stock	11.58	11.81	11.54	11.66	2441400.0
2006-08-18	AAIC-DELISTED	Stock	181.6	182.8	180.2	182.6	1063700.0
2006-08-18	AAME	Stock	2.7	2.71	2.61	2.66	6300.0
2006-08-18	AAON	Stock	3.1539	3.1539	2.9695	3.0578	162506.0
2006-08-18	AAP	Stock	31.1	31.24	30.29	30.51	737600.0
2006-08-18	AATI-DELISTED	Stock	9.68	9.75	9.32	9.48	83773.0
2006-08-18	AAU-DELISTED	Stock	2.62	2.66	2.5001	2.64	33000.0
2006-08-18	AAUAF-DELISTED	Stock	2.62	2.66	2.5001	2.64	33000.0
2006-08-18	AAV-DELISTED	Stock	15.98	16.03	15.88	15.96	311800.0
2006-08-18	AAWW-DELISTED	Stock	41.86	42.0	41.25	41.71	184307.0
2006-08-18	AAXN-DELISTED	Stock	7.71999979019165	7.92999982833862	7.67999982833862	7.90999984741211	1232400.0
2006-08-18	AB	Stock	69.17	69.3	68.45	69.15	130400.0
2006-08-18	ABAX-DELISTED	Stock	22.95	23.36	22.55	23.32	97144.0
2006-08-18	ABB-DELISTED	Stock	13.52	13.7	13.51	13.69	2110400.0
2006-08-18	ABBC-DELISTED	Stock	14.85	15.0	14.8	14.83	16775.0
2006-08-18	ABC-DELISTED	Stock	21.81	21.9	21.7	21.82	3001400.0
2006-08-18	ABCB	Stock	25.7264	25.7264	24.7343	25.5318	26731.0
2006-08-18	ABCO-DELISTED	Stock	25.7	25.71	24.91	25.26	130232.0
2006-08-18	ABCW-DELISTED	Stock	29.52	29.52	28.8	29.39	27730.0
2006-08-18	ABD-DELISTED	Stock	18.75	19.65	18.72	19.33	451280.0
2006-08-18	ABE-DELISTED	Stock	13.55	13.57	13.44	13.51	61700.0
2006-08-18	ABFS-DELISTED	Stock	45.25	45.5	44.54	45.05	156023.0
2006-08-18	ABG	Stock	20.62	20.62	20.25	20.4	51900.0
2006-08-18	ABK-DELISTED	Stock	85.09	85.21	84.74	84.89	722600.0
2006-08-18	ABM	Stock	17.97	18.0	17.75	17.94	75800.0
2006-08-18	ABMD-DELISTED	Stock	13.79	13.8	13.4	13.68	68592.0
2006-08-18	ABP-DELISTED	Stock	4.02	4.16	4.0	4.14	177600.0
2006-08-18	ABR	Stock	25.16	25.34	25.03	25.18	42500.0
2006-08-18	ABT	Stock	23.5726	23.5966	23.3375	23.5102	10470613.0
2006-08-18	ABTL-DELISTED	Stock	15.0	15.132	14.8	14.95	11003.0
2006-08-18	ABV-DELISTED	Stock	43.85	43.86	43.0	43.7	271000.0
2006-08-18	ABVA-DELISTED	Stock	16.95	16.95	16.54	16.65	1700.0
2006-08-18	ABX-DELISTED	Stock	31.01	31.73	30.8	31.64	3211554.0
2006-08-18	ACAD	Stock	7.41	7.65	7.24	7.58	381700.0
2006-08-18	ACAP-DELISTED	Stock	49.8	49.8	48.56	49.12	20712.0
2006-08-18	ACAS-DELISTED	Stock	38.34	38.46	38.2	38.4	807569.0
2006-08-18	ACAT-DELISTED	Stock	18.53	18.55	18.11	18.2	22343.0
2006-08-18	ACC-DELISTED	Stock	25.22	25.28	24.93	25.15	73200.0
2006-08-18	ACCL-DELISTED	Stock	6.0	6.22	6.0	6.19	35999.0
2006-08-18	ACCO	Stock	18.75	19.65	18.72	19.33	468700.0

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

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