PREVIEW / stock_daily / 2006-09-18

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-18.parquet
  size:    150 KB
  rows:    4,500
  symbols: 2,840

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-09-18	AAPL	Stock	2.6357	2.6736	2.6179	2.6389	705278000.0
2006-09-18	MSFT	Stock	26.74	27.04	26.67	26.79	49135000.0
2006-09-18	NVDA	Stock	0.494	0.5122	0.4925	0.5113	793896000.0
2006-09-18	AMZN	Stock	1.6225	1.6335	1.594	1.604	102462000.0
2006-09-18	CL	Stock	31.175	31.175	30.885	30.96	2189200.0
2006-09-18	A	Stock	22.1245	22.3963	22.0243	22.3033	3412378.0
2006-09-18	AABA-DELISTED	Stock	29.3700008392334	29.3899993896484	28.5799999237061	29.0	15685000.0
2006-09-18	AACC-DELISTED	Stock	14.82	15.17	14.82	15.04	108414.0
2006-09-18	AAI-DELISTED	Stock	9.61	9.91	9.61	9.84	1872800.0
2006-09-18	AAIC-DELISTED	Stock	174.6	174.8	166.0	168.6	869900.0
2006-09-18	AAME	Stock	2.63	2.75	2.63	2.7	700.0
2006-09-18	AAON	Stock	2.9722	3.0446	2.9577	3.0038	186047.0
2006-09-18	AAP	Stock	32.48	32.52	31.9	31.99	1050400.0
2006-09-18	AATI-DELISTED	Stock	8.33	8.59	7.99	8.1	244372.0
2006-09-18	AAU-DELISTED	Stock	2.39	2.45	2.38	2.4	28600.0
2006-09-18	AAUAF-DELISTED	Stock	2.39	2.45	2.38	2.4	28600.0
2006-09-18	AAV-DELISTED	Stock	14.4	14.4	14.1	14.2	430400.0
2006-09-18	AAWW-DELISTED	Stock	43.71	43.97	43.64	43.76	23952.0
2006-09-18	AAXN-DELISTED	Stock	7.5	7.55000019073486	7.42000007629395	7.46999979019165	775100.0
2006-09-18	AB	Stock	71.0	71.0	68.81	69.12	405700.0
2006-09-18	ABAX-DELISTED	Stock	22.46	23.24	22.38	23.05	82082.0
2006-09-18	ABB-DELISTED	Stock	13.23	13.49	13.23	13.46	2155500.0
2006-09-18	ABBC-DELISTED	Stock	15.2	15.3	15.13	15.13	6147.0
2006-09-18	ABC-DELISTED	Stock	23.06	23.24	22.94	23.14	2372000.0
2006-09-18	ABCB	Stock	26.1252	26.3586	25.882	26.0765	11618.0
2006-09-18	ABCO-DELISTED	Stock	25.33	25.53	25.02	25.21	96694.0
2006-09-18	ABCW-DELISTED	Stock	28.6	29.21	28.6	29.19	31770.0
2006-09-18	ABD-DELISTED	Stock	20.23	20.85	20.18	20.33	277000.0
2006-09-18	ABE-DELISTED	Stock	14.0	14.22	13.95	14.1	57200.0
2006-09-18	ABFS-DELISTED	Stock	43.5	44.74	43.33	43.61	539234.0
2006-09-18	ABG	Stock	20.12	20.13	19.18	19.25	730000.0
2006-09-18	ABK-DELISTED	Stock	84.0	84.05	83.2	83.37	777100.0
2006-09-18	ABM	Stock	18.75	18.91	18.61	18.8	242100.0
2006-09-18	ABMD-DELISTED	Stock	14.91	15.22	14.77	15.15	145746.0
2006-09-18	ABP-DELISTED	Stock	3.65	3.66	3.53	3.65	194800.0
2006-09-18	ABR	Stock	25.7	25.93	25.7	25.8	34100.0
2006-09-18	ABT	Stock	23.6062	23.6349	23.4142	23.4526	9202168.0
2006-09-18	ABTL-DELISTED	Stock	16.096	16.195	15.752	15.85	12147.0
2006-09-18	ABV-DELISTED	Stock	45.15	46.0	45.15	45.71	306400.0
2006-09-18	ABVA-DELISTED	Stock	16.4	16.75	16.4	16.75	2994.0
2006-09-18	ABX-DELISTED	Stock	29.26	30.01	29.09	29.99	5377065.0
2006-09-18	ACAD	Stock	8.51	8.77	8.38	8.44	201000.0
2006-09-18	ACAP-DELISTED	Stock	50.07	51.5	50.04	51.42	36540.0
2006-09-18	ACAS-DELISTED	Stock	38.75	38.77	38.39	38.4095	794028.0
2006-09-18	ACAT-DELISTED	Stock	16.24	16.79	16.24	16.78	82406.0
2006-09-18	ACC-DELISTED	Stock	25.65	25.65	25.23	25.41	181500.0
2006-09-18	ACCL-DELISTED	Stock	5.51	5.53	5.45	5.48	37328.0
2006-09-18	ACCO	Stock	20.23	20.85	20.18	20.33	284700.0
2006-09-18	ACCP-DELISTED	Stock	0.78	0.88	0.75	0.88	25147.0
2006-09-18	ACE-DELISTED	Stock	55.55	55.55	54.86	54.97	644900.0

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

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