PREVIEW / stock_daily / 2006-10-31

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-31.parquet
  size:    154 KB
  rows:    4,600
  symbols: 2,917

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-31	AAPL	Stock	2.9089	2.9171	2.8654	2.8957	501474400.0
2006-10-31	MSFT	Stock	28.66	28.85	28.56	28.71	61861700.0
2006-10-31	NVDA	Stock	0.5582	0.5812	0.5553	0.5812	996174000.0
2006-10-31	AMZN	Stock	1.911	1.9295	1.89	1.9045	124208000.0
2006-10-31	CL	Stock	31.745	32.035	31.66	31.985	4976200.0
2006-10-31	A	Stock	25.0358	25.6152	25.0143	25.4649	3892591.0
2006-10-31	AABA-DELISTED	Stock	26.4400005340576	26.7000007629395	26.1000003814697	26.3400001525879	33492800.0
2006-10-31	AACC-DELISTED	Stock	17.8	17.91	17.54	17.81	76341.0
2006-10-31	AACQ-DELISTED	Stock	5.4	5.5	5.4	5.49	440500.0
2006-10-31	AACQU-DELISTED	Stock	6.55	6.55	6.5	6.5	4000.0
2006-10-31	AACQW-DELISTED	Stock	0.53	0.56	0.52	0.56	276700.0
2006-10-31	AAI-DELISTED	Stock	10.1	10.2	9.82	9.96	2522800.0
2006-10-31	AAIC-DELISTED	Stock	155.0	155.4	151.0	152.6	633700.0
2006-10-31	AAME	Stock	2.52	2.52	2.52	2.52	200.0
2006-10-31	AAON	Stock	3.1328	3.1565	3.0828	3.0828	78216.0
2006-10-31	AAP	Stock	35.84	36.01	34.96	35.02	1071200.0
2006-10-31	AATI-DELISTED	Stock	6.13	6.27	6.09	6.22	228082.0
2006-10-31	AAU-DELISTED	Stock	2.42	2.45	2.4	2.45	38900.0
2006-10-31	AAUAF-DELISTED	Stock	2.42	2.45	2.4	2.45	38900.0
2006-10-31	AAV-DELISTED	Stock	13.72	13.72	13.3	13.6426	859800.0
2006-10-31	AAWW-DELISTED	Stock	45.65	46.76	45.35	45.48	118080.0
2006-10-31	AAXN-DELISTED	Stock	9.63000011444092	9.69999980926514	9.25	9.3100004196167	1349700.0
2006-10-31	AB	Stock	76.92	78.66	76.9	77.7	319800.0
2006-10-31	ABAX-DELISTED	Stock	20.12	20.16	19.901	20.05	212046.0
2006-10-31	ABB-DELISTED	Stock	14.86	14.95	14.86	14.92	1543300.0
2006-10-31	ABBC-DELISTED	Stock	16.08	16.2	16.06	16.17	21891.0
2006-10-31	ABC-DELISTED	Stock	23.38	23.68	23.34	23.58	2658200.0
2006-10-31	ABCB	Stock	27.2826	27.2826	27.0006	27.1464	22413.0
2006-10-31	ABCO-DELISTED	Stock	26.38	28.04	25.83	27.61	614368.0
2006-10-31	ABCW-DELISTED	Stock	29.27	29.28	28.86	29.04	19240.0
2006-10-31	ABD-DELISTED	Stock	24.19	24.33	24.07	24.28	213220.0
2006-10-31	ABE-DELISTED	Stock	15.9	16.02	15.85	16.0	15000.0
2006-10-31	ABFS-DELISTED	Stock	41.68	42.15	40.89	41.0	745701.0
2006-10-31	ABG	Stock	24.07	24.23	23.66	24.0	659800.0
2006-10-31	ABK-DELISTED	Stock	83.62	84.07	83.35	83.48	669300.0
2006-10-31	ABM	Stock	20.0	20.0	19.74	19.86	212500.0
2006-10-31	ABMD-DELISTED	Stock	14.4	14.41	14.13	14.2	80289.0
2006-10-31	ABP-DELISTED	Stock	3.52	3.71	3.42	3.58	127400.0
2006-10-31	ABR	Stock	28.15	28.15	27.66	27.8	59900.0
2006-10-31	ABT	Stock	22.7905	22.8385	22.589	22.7953	11385160.0
2006-10-31	ABTL-DELISTED	Stock	16.901	16.952	16.346	16.75	6700.0
2006-10-31	ABV-DELISTED	Stock	43.4	43.95	43.4	43.7	793700.0
2006-10-31	ABVA-DELISTED	Stock	16.72	16.82	16.49	16.49	325.0
2006-10-31	ABVT-DELISTED	Stock	55.0	64.0	50.0	64.0	535.0
2006-10-31	ABX-DELISTED	Stock	30.03	31.0	30.0	31.0	3538200.0
2006-10-31	ACAD	Stock	9.45	9.6	9.39	9.48	95500.0
2006-10-31	ACAP-DELISTED	Stock	54.1	55.22	53.9	54.57	20738.0
2006-10-31	ACAS-DELISTED	Stock	43.06	43.46	42.9	43.21	1137008.0
2006-10-31	ACAT-DELISTED	Stock	17.87	18.03	17.65	17.9	103408.0
2006-10-31	ACC-DELISTED	Stock	26.7	26.96	26.47	26.63	123200.0

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

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