PREVIEW / stock_daily / 2006-09-12

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-12.parquet
  size:    150 KB
  rows:    4,488
  symbols: 2,834

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-12	AAPL	Stock	2.6004	2.6232	2.5518	2.5939	1684687200.0
2006-09-12	MSFT	Stock	25.9	25.98	25.72	25.93	52248800.0
2006-09-12	NVDA	Stock	0.4667	0.4842	0.4655	0.4812	498432000.0
2006-09-12	AMZN	Stock	1.5435	1.597	1.5265	1.586	130548000.0
2006-09-12	CL	Stock	31.05	31.245	30.97	31.15	4765000.0
2006-09-12	A	Stock	22.2318	22.6395	22.1817	22.5322	4209098.0
2006-09-12	AABA-DELISTED	Stock	28.5499992370605	29.2199993133545	28.4599990844727	29.0900001525879	10005000.0
2006-09-12	AACC-DELISTED	Stock	14.42	14.61	14.42	14.51	238271.0
2006-09-12	AACQ-DELISTED	Stock	5.35	5.35	5.35	5.35	5000.0
2006-09-12	AACQU-DELISTED	Stock	6.12	6.12	6.07	6.08	21500.0
2006-09-12	AACQW-DELISTED	Stock	0.39	0.39	0.38	0.38	74833.0
2006-09-12	AAI-DELISTED	Stock	9.42	10.04	9.4	9.91	3046800.0
2006-09-12	AAIC-DELISTED	Stock	163.0	172.4	163.0	169.6	1731900.0
2006-09-12	AAON	Stock	2.9445	3.1315	2.93	3.117	142762.0
2006-09-12	AAP	Stock	31.47	33.01	31.34	32.93	3524500.0
2006-09-12	AATI-DELISTED	Stock	8.07	8.37	8.07	8.17	166790.0
2006-09-12	AAU-DELISTED	Stock	2.46	2.46	2.35	2.36	29400.0
2006-09-12	AAUAF-DELISTED	Stock	2.46	2.46	2.35	2.36	29400.0
2006-09-12	AAV-DELISTED	Stock	14.01	14.3	13.98	14.1068	501100.0
2006-09-12	AAWW-DELISTED	Stock	42.75	43.76	42.75	43.48	120414.0
2006-09-12	AAXN-DELISTED	Stock	7.63000011444092	7.67000007629395	7.51000022888184	7.63000011444092	464000.0
2006-09-12	AB	Stock	66.73	67.45	66.73	67.31	154800.0
2006-09-12	ABAX-DELISTED	Stock	22.56	23.25	22.516	23.0	109951.0
2006-09-12	ABB-DELISTED	Stock	13.19	13.43	13.15	13.4	2189700.0
2006-09-12	ABBC-DELISTED	Stock	15.03	15.2	15.01	15.15	4848.0
2006-09-12	ABC-DELISTED	Stock	22.56	22.84	22.54	22.82	1184600.0
2006-09-12	ABCB	Stock	25.0261	26.0668	25.0261	26.0376	27245.0
2006-09-12	ABCO-DELISTED	Stock	24.97	25.52	24.84	25.41	99436.0
2006-09-12	ABCW-DELISTED	Stock	28.74	29.53	28.69	29.41	31450.0
2006-09-12	ABD-DELISTED	Stock	20.56	20.9	20.48	20.65	328000.0
2006-09-12	ABE-DELISTED	Stock	13.45	13.79	13.41	13.73	34600.0
2006-09-12	ABFS-DELISTED	Stock	44.38	46.84	44.38	46.49	600512.0
2006-09-12	ABG	Stock	20.22	20.86	20.22	20.76	66000.0
2006-09-12	ABK-DELISTED	Stock	84.6	85.33	84.6	84.84	670200.0
2006-09-12	ABM	Stock	18.5	18.78	18.33	18.76	318600.0
2006-09-12	ABMD-DELISTED	Stock	14.59	14.84	14.47	14.8	87724.0
2006-09-12	ABP-DELISTED	Stock	3.95	4.0	3.65	3.79	230300.0
2006-09-12	ABR	Stock	25.2	25.67	25.2	25.54	61500.0
2006-09-12	ABT	Stock	23.2703	23.4478	23.1408	23.4142	13065444.0
2006-09-12	ABTL-DELISTED	Stock	16.475	16.475	15.726	16.475	67217.0
2006-09-12	ABV-DELISTED	Stock	43.87	44.42	43.82	44.32	209400.0
2006-09-12	ABVA-DELISTED	Stock	16.57	16.9	16.55	16.9	2103.0
2006-09-12	ABVT-DELISTED	Stock	48.0	48.0	48.0	48.0	200.0
2006-09-12	ABX-DELISTED	Stock	29.77	30.09	29.04	29.36	5256900.0
2006-09-12	ACAD	Stock	8.02	8.38	7.92	8.33	204400.0
2006-09-12	ACAP-DELISTED	Stock	47.17	47.85	46.95	47.61	32369.0
2006-09-12	ACAS-DELISTED	Stock	37.46	37.99	37.32	37.94	603045.0
2006-09-12	ACAT-DELISTED	Stock	15.9	16.78	15.75	16.78	94855.0
2006-09-12	ACC-DELISTED	Stock	24.58	24.72	24.15	24.69	244800.0
2006-09-12	ACCL-DELISTED	Stock	5.4	5.58	5.3	5.49	44190.0

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

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