PREVIEW / stock_daily / 2006-10-26

all stock daily files

  file:    by_date/stock_daily/2006/2006-10-26.parquet
  size:    152 KB
  rows:    4,564
  symbols: 2,887

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-26	AAPL	Stock	2.925	2.95	2.8975	2.9354	432756800.0
2006-10-26	MSFT	Stock	28.33	28.41	28.04	28.35	69964200.0
2006-10-26	NVDA	Stock	0.548	0.5658	0.548	0.564	366690000.0
2006-10-26	AMZN	Stock	1.8625	1.9245	1.859	1.915	341466000.0
2006-10-26	CL	Stock	31.4	31.495	31.005	31.39	6323200.0
2006-10-26	A	Stock	25.1216	25.3791	24.9642	25.3362	1299441.0
2006-10-26	AABA-DELISTED	Stock	24.7000007629395	25.3299999237061	24.3600006103516	25.2800006866455	38435800.0
2006-10-26	AACC-DELISTED	Stock	17.07	17.68	16.87	17.59	83890.0
2006-10-26	AACQ-DELISTED	Stock	5.33	5.37	5.33	5.345	56000.0
2006-10-26	AACQU-DELISTED	Stock	6.12	6.15	6.12	6.12	48500.0
2006-10-26	AACQW-DELISTED	Stock	0.44	0.45	0.41	0.42	309000.0
2006-10-26	AAI-DELISTED	Stock	10.51	10.97	10.4	10.88	3000700.0
2006-10-26	AAIC-DELISTED	Stock	156.0	158.0	153.2	158.0	823900.0
2006-10-26	AAON	Stock	3.1605	3.1737	3.1091	3.1671	109350.0
2006-10-26	AAP	Stock	35.35	36.51	35.16	36.4	1365500.0
2006-10-26	AATI-DELISTED	Stock	5.74	5.85	5.4	5.8	645292.0
2006-10-26	AAU-DELISTED	Stock	2.44	2.46	2.41	2.42	19700.0
2006-10-26	AAUAF-DELISTED	Stock	2.44	2.46	2.41	2.42	19700.0
2006-10-26	AAV-DELISTED	Stock	14.27	14.56	14.27	14.5	849300.0
2006-10-26	AAWW-DELISTED	Stock	47.0	47.0	46.52	46.52	79565.0
2006-10-26	AAXN-DELISTED	Stock	9.5	9.71000003814697	9.43000030517578	9.60999965667725	1409100.0
2006-10-26	AB	Stock	75.88	78.0	75.61	77.05	422200.0
2006-10-26	ABAX-DELISTED	Stock	20.36	21.21	19.75	20.75	961682.0
2006-10-26	ABB-DELISTED	Stock	14.85	14.94	14.7	14.85	4360200.0
2006-10-26	ABBC-DELISTED	Stock	16.0	16.2	15.9	16.2	18339.0
2006-10-26	ABC-DELISTED	Stock	23.25	23.43	23.18	23.23	1781200.0
2006-10-26	ABCB	Stock	27.234	27.234	27.0006	27.234	33209.0
2006-10-26	ABCO-DELISTED	Stock	27.55	28.05	27.43	28.03	153519.0
2006-10-26	ABCW-DELISTED	Stock	29.29	29.59	29.11	29.58	32670.0
2006-10-26	ABD-DELISTED	Stock	24.36	24.68	24.11	24.65	177400.0
2006-10-26	ABE-DELISTED	Stock	15.58	15.84	15.5	15.84	32500.0
2006-10-26	ABFS-DELISTED	Stock	40.89	41.49	40.69	41.08	480473.0
2006-10-26	ABG	Stock	24.15	24.59	24.1	24.38	393500.0
2006-10-26	ABK-DELISTED	Stock	83.24	85.3	83.24	84.94	1099900.0
2006-10-26	ABM	Stock	19.8	19.9	19.67	19.9	133700.0
2006-10-26	ABMD-DELISTED	Stock	13.99	14.54	13.88	14.5	86005.0
2006-10-26	ABP-DELISTED	Stock	3.83	3.95	3.8	3.86	250600.0
2006-10-26	ABR	Stock	28.0	28.0	27.69	27.88	64400.0
2006-10-26	ABT	Stock	23.1647	23.1647	22.7905	22.9776	9140684.0
2006-10-26	ABTL-DELISTED	Stock	16.5	16.85	15.85	16.85	15969.0
2006-10-26	ABV-DELISTED	Stock	43.85	43.99	43.21	43.36	728400.0
2006-10-26	ABVA-DELISTED	Stock	17.1	17.1	17.1	17.1	306.0
2006-10-26	ABX-DELISTED	Stock	30.87	30.92	30.35	30.51	3234000.0
2006-10-26	ACAD	Stock	9.38	9.72	9.3	9.67	158600.0
2006-10-26	ACAP-DELISTED	Stock	52.42	54.39	52.08	54.2	31904.0
2006-10-26	ACAS-DELISTED	Stock	42.26	42.88	42.11	42.79	940855.0
2006-10-26	ACAT-DELISTED	Stock	17.31	18.05	17.26	17.97	150296.0
2006-10-26	ACC-DELISTED	Stock	26.52	26.7	26.45	26.52	78254.0
2006-10-26	ACCL-DELISTED	Stock	6.08	6.29	6.08	6.29	63848.0
2006-10-26	ACCO	Stock	24.35	24.67	24.1	24.66	192200.0

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

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