PREVIEW / stock_daily / 2007-10-04

all stock daily files

  file:    by_date/stock_daily/2007/2007-10-04.parquet
  size:    177 KB
  rows:    5,495
  symbols: 3,323

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
2007-10-04	AAPL	Stock	5.6429	5.6457	5.4821	5.58	656958400.0
2007-10-04	MSFT	Stock	29.56	29.77	29.44	29.71	37868000.0
2007-10-04	NVDA	Stock	0.8945	0.9048	0.8688	0.8995	378976000.0
2007-10-04	AMZN	Stock	4.6275	4.6285	4.5725	4.613	66366000.0
2007-10-04	TLT	Stock	89.01	89.32	88.91	89.24	1128700.0
2007-10-04	CL	Stock	35.69	36.25	35.69	35.86	4172200.0
2007-10-04	A	Stock	26.3734	26.7024	26.3662	26.6094	2786074.0
2007-10-04	AABA-DELISTED	Stock	27.18	27.29	26.9	27.17	19203687.0
2007-10-04	AACC-DELISTED	Stock	12.0	12.0	11.69	11.82	146780.0
2007-10-04	AAI-DELISTED	Stock	10.24	10.4	10.01	10.11	1981200.0
2007-10-04	AAIC-DELISTED	Stock	94.4	96.2	93.2	95.4	1027200.0
2007-10-04	AAME	Stock	2.61	2.62	2.57	2.59	3700.0
2007-10-04	AAON	Stock	3.9842	4.0711	3.9664	4.0632	205537.0
2007-10-04	AAP	Stock	33.82	34.25	33.48	33.78	816100.0
2007-10-04	AATI-DELISTED	Stock	11.36	11.97	11.36	11.7	991984.0
2007-10-04	AAU-DELISTED	Stock	2.46	2.6	2.46	2.58	81100.0
2007-10-04	AAUAF-DELISTED	Stock	2.46	2.6	2.46	2.58	81100.0
2007-10-04	AAV-DELISTED	Stock	12.0	12.13	11.95	12.08	556085.0
2007-10-04	AAWW-DELISTED	Stock	52.78	53.0	51.77	52.22	146162.0
2007-10-04	AAXN-DELISTED	Stock	16.63	18.12	16.4	18.05	5825864.0
2007-10-04	AB	Stock	91.18	91.52	90.46	91.43	177900.0
2007-10-04	ABAX-DELISTED	Stock	24.54	24.79	23.91	24.29	500272.0
2007-10-04	ABB-DELISTED	Stock	26.7	26.94	26.45	26.89	3135000.0
2007-10-04	ABBC-DELISTED	Stock	9.77	9.81	9.77	9.78	70722.0
2007-10-04	ABBNY-DELISTED	Stock	26.7	26.94	26.45	26.89	3135000.0
2007-10-04	ABC-DELISTED	Stock	22.42	22.64	22.24	22.3	1615400.0
2007-10-04	ABCB	Stock	17.527	18.0425	17.527	17.8285	25909.0
2007-10-04	ABCO-DELISTED	Stock	30.88	31.06	30.66	30.77	143622.0
2007-10-04	ABCW-DELISTED	Stock	27.44	27.64	27.35	27.4	21270.0
2007-10-04	ABD-DELISTED	Stock	23.5	24.0	23.37	23.84	260400.0
2007-10-04	ABE-DELISTED	Stock	23.85	24.23	23.75	24.21	9700.0
2007-10-04	ABEO	Stock	5250.0	5312.5	5187.5	5250.0	15.0
2007-10-04	ABFS-DELISTED	Stock	33.14	33.76	32.83	33.0	166715.0
2007-10-04	ABG	Stock	20.53	20.58	19.75	20.21	512400.0
2007-10-04	ABK-DELISTED	Stock	65.55	68.72	65.55	67.85	2596100.0
2007-10-04	ABM	Stock	20.35	20.35	19.85	20.13	239500.0
2007-10-04	ABMD-DELISTED	Stock	13.1	13.57	12.99	13.07	290404.0
2007-10-04	ABP-DELISTED	Stock	4.04	4.2	3.92	4.1	155500.0
2007-10-04	ABR	Stock	20.85	20.94	20.46	20.53	200000.0
2007-10-04	ABT	Stock	26.7441	27.1855	26.5713	26.6481	5623176.0
2007-10-04	ABTL-DELISTED	Stock	17.354	17.354	16.9	16.95	9071.0
2007-10-04	ABV-DELISTED	Stock	78.33	78.5	76.88	77.62	624300.0
2007-10-04	ABX-DELISTED	Stock	39.4	40.61	39.23	40.51	9416048.0
2007-10-04	ACAD	Stock	15.24	15.24	14.92	14.93	140200.0
2007-10-04	ACAP-DELISTED	Stock	40.72	41.07	40.29	41.07	27092.0
2007-10-04	ACAS-DELISTED	Stock	43.95	44.25	43.73	44.17	1243791.0
2007-10-04	ACAT-DELISTED	Stock	17.0	17.4599	16.81	17.25	54910.0
2007-10-04	ACC-DELISTED	Stock	28.77	28.92	28.58	28.82	1083027.0
2007-10-04	ACCL-DELISTED	Stock	7.58	7.63	7.28	7.46	61016.0
2007-10-04	ACCO	Stock	23.5	24.0	23.37	23.84	260400.0

> showing 50 of 5,495 rows — these rows as CSV

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