PREVIEW / stock_daily / 2006-08-09

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-09.parquet
  size:    148 KB
  rows:    4,451
  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-09	AAPL	Stock	2.3368	2.3429	2.2643	2.2711	955838800.0
2006-08-09	MSFT	Stock	24.49	24.64	24.34	24.44	44405700.0
2006-08-09	NVDA	Stock	0.4137	0.425	0.4025	0.4055	584706000.0
2006-08-09	AMZN	Stock	1.327	1.335	1.3	1.3105	138224000.0
2006-08-09	CL	Stock	29.525	29.825	29.43	29.495	3333400.0
2006-08-09	A	Stock	19.6209	20.2146	19.4206	19.5136	2311453.0
2006-08-09	AABA-DELISTED	Stock	27.75	27.8500003814697	27.0	27.2199993133545	14736100.0
2006-08-09	AACC-DELISTED	Stock	15.7	15.79	14.86	15.4	399519.0
2006-08-09	AACQ-DELISTED	Stock	5.34	5.34	5.34	5.34	10000.0
2006-08-09	AAI-DELISTED	Stock	12.45	12.5	11.51	11.6	2589300.0
2006-08-09	AAIC-DELISTED	Stock	181.4	182.4	176.2	176.2	1157800.0
2006-08-09	AAON	Stock	3.1315	3.1644	3.067	3.0881	187566.0
2006-08-09	AAP	Stock	29.67	29.8	28.79	28.95	1869800.0
2006-08-09	AATI-DELISTED	Stock	9.01	9.19	8.67	8.81	141663.0
2006-08-09	AAU-DELISTED	Stock	2.57	2.68	2.55	2.56	70500.0
2006-08-09	AAUAF-DELISTED	Stock	2.57	2.68	2.55	2.56	70500.0
2006-08-09	AAV-DELISTED	Stock	16.4	16.53	16.25	16.2751	367200.0
2006-08-09	AAWW-DELISTED	Stock	39.22	39.22	36.76	37.13	148735.0
2006-08-09	AAXN-DELISTED	Stock	7.09999990463257	7.15000009536743	6.8600001335144	6.8899998664856	918200.0
2006-08-09	AB	Stock	65.24	66.47	65.18	65.26	171700.0
2006-08-09	ABAX-DELISTED	Stock	22.24	22.6	21.7	21.75	122758.0
2006-08-09	ABB-DELISTED	Stock	12.97	13.21	12.96	13.0	5264500.0
2006-08-09	ABBC-DELISTED	Stock	14.8	14.87	14.7	14.74	45078.0
2006-08-09	ABC-DELISTED	Stock	21.38	21.52	21.24	21.44	1950000.0
2006-08-09	ABCB	Stock	25.5707	25.7556	25.3665	25.5318	148873.0
2006-08-09	ABCO-DELISTED	Stock	24.99	25.02	24.16	24.18	268196.0
2006-08-09	ABCW-DELISTED	Stock	29.76	29.96	28.72	28.72	31390.0
2006-08-09	ABD-DELISTED	Stock	18.8	18.88	18.3	18.3	281910.0
2006-08-09	ABE-DELISTED	Stock	12.78	12.93	12.76	12.88	19500.0
2006-08-09	ABFS-DELISTED	Stock	44.88	45.24	41.82	42.29	588505.0
2006-08-09	ABG	Stock	20.4	20.66	20.0	20.05	77800.0
2006-08-09	ABK-DELISTED	Stock	83.07	83.84	82.69	82.85	1071600.0
2006-08-09	ABM	Stock	16.27	16.61	16.21	16.3	159800.0
2006-08-09	ABMD-DELISTED	Stock	13.0	13.58	12.88	13.21	206160.0
2006-08-09	ABP-DELISTED	Stock	4.03	4.15	3.94	3.95	452100.0
2006-08-09	ABR	Stock	25.2	25.25	24.55	24.63	53900.0
2006-08-09	ABT	Stock	22.9104	22.92	22.5986	22.7041	9474781.0
2006-08-09	ABTL-DELISTED	Stock	15.85	16.0	14.8	15.0	24476.0
2006-08-09	ABV-DELISTED	Stock	41.6	41.92	41.2	41.45	362800.0
2006-08-09	ABVA-DELISTED	Stock	16.4	16.513	16.14	16.35	10406.0
2006-08-09	ABX-DELISTED	Stock	32.55	33.08	32.17	32.88	3831137.0
2006-08-09	ACAD	Stock	6.05	6.05	5.5	5.56	333100.0
2006-08-09	ACAP-DELISTED	Stock	47.55	48.16	46.75	47.0	35020.0
2006-08-09	ACAS-DELISTED	Stock	36.68	37.0	36.51	36.52	1178563.0
2006-08-09	ACAT-DELISTED	Stock	17.86	18.16	17.4	17.93	122731.0
2006-08-09	ACC-DELISTED	Stock	25.46	25.56	24.9	24.93	71700.0
2006-08-09	ACCL-DELISTED	Stock	6.34	6.4	6.27	6.3	22313.0
2006-08-09	ACCO	Stock	18.8	18.88	18.3	18.3	295800.0
2006-08-09	ACCP-DELISTED	Stock	0.86	0.86	0.86	0.86	3000.0
2006-08-09	ACE-DELISTED	Stock	49.75	49.75	48.64	48.98	2491600.0

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

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