PREVIEW / stock_daily / 2007-09-06

all stock daily files

  file:    by_date/stock_daily/2007/2007-09-06.parquet
  size:    177 KB
  rows:    5,476
  symbols: 3,300

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-09-06	AAPL	Stock	4.8414	4.9132	4.7396	4.8218	1901261600.0
2007-09-06	MSFT	Stock	28.56	29.01	28.55	28.91	45430800.0
2007-09-06	NVDA	Stock	0.8832	0.8912	0.8725	0.8762	425496000.0
2007-09-06	AMZN	Stock	4.225	4.323	4.1425	4.3105	176538000.0
2007-09-06	TLT	Stock	89.31	89.49	88.95	89.04	1768399.0
2007-09-06	CL	Stock	32.535	33.065	32.535	33.0	3003800.0
2007-09-06	A	Stock	25.7582	26.166	25.6366	26.166	2125519.0
2007-09-06	AABA-DELISTED	Stock	24.22	24.32	23.62	24.13	12393855.0
2007-09-06	AACC-DELISTED	Stock	11.0	11.09	10.75	10.89	123568.0
2007-09-06	AAI-DELISTED	Stock	10.78	10.8	10.29	10.42	1345500.0
2007-09-06	AAIC-DELISTED	Stock	92.6	94.0	90.0	92.6	978800.0
2007-09-06	AAME	Stock	2.99	3.38	2.99	3.25	4500.0
2007-09-06	AAON	Stock	4.1086	4.16	4.0494	4.0869	249581.0
2007-09-06	AAP	Stock	34.47	35.09	34.43	34.68	728200.0
2007-09-06	AATI-DELISTED	Stock	9.39	9.4	9.14	9.28	168003.0
2007-09-06	AAU-DELISTED	Stock	2.11	2.31	2.09	2.3	156900.0
2007-09-06	AAUAF-DELISTED	Stock	2.11	2.3099	2.09	2.3	156900.0
2007-09-06	AAV-DELISTED	Stock	11.67	11.73	11.5	11.51	592700.0
2007-09-06	AAWW-DELISTED	Stock	50.93	51.07	50.13	50.93	1361654.0
2007-09-06	AAXN-DELISTED	Stock	15.3	15.6	14.87	15.1201	3657964.0
2007-09-06	AB	Stock	83.1	83.21	82.01	83.04	179000.0
2007-09-06	ABAX-DELISTED	Stock	19.79	20.05	19.35	20.0	99585.0
2007-09-06	ABB-DELISTED	Stock	23.85	24.15	23.73	23.98	1874400.0
2007-09-06	ABBC-DELISTED	Stock	9.38	9.57	9.25	9.48	43907.0
2007-09-06	ABBNY-DELISTED	Stock	23.85	24.15	23.73	23.98	1925900.0
2007-09-06	ABC-DELISTED	Stock	23.82	23.84	23.28	23.5	2514000.0
2007-09-06	ABCB	Stock	19.0249	20.0754	18.8109	19.9586	43387.0
2007-09-06	ABCO-DELISTED	Stock	28.63	28.78	28.03	28.5	152776.0
2007-09-06	ABCW-DELISTED	Stock	26.58	27.07	26.47	27.07	91650.0
2007-09-06	ABD-DELISTED	Stock	22.82	23.21	22.37	22.89	286560.0
2007-09-06	ABE-DELISTED	Stock	22.15	22.34	21.875	22.05	21200.0
2007-09-06	ABEO	Stock	4875.0	4925.0	4850.0	4925.0	2.0
2007-09-06	ABFS-DELISTED	Stock	35.34	35.75	34.56	34.64	552082.0
2007-09-06	ABG	Stock	21.75	21.95	21.57	21.75	500900.0
2007-09-06	ABK-DELISTED	Stock	62.95	63.0	60.8	61.54	1888400.0
2007-09-06	ABM	Stock	22.39	22.53	21.0	21.8	575300.0
2007-09-06	ABMD-DELISTED	Stock	12.37	12.59	12.22	12.55	75164.0
2007-09-06	ABP-DELISTED	Stock	3.61	3.62	3.56	3.58	80200.0
2007-09-06	ABR	Stock	19.65	19.65	19.1	19.17	154000.0
2007-09-06	ABT	Stock	24.9256	25.4534	24.8057	25.3814	11488954.0
2007-09-06	ABTL-DELISTED	Stock	14.925	15.326	14.925	14.975	20532.0
2007-09-06	ABV-DELISTED	Stock	67.63	69.02	67.5	68.07	412300.0
2007-09-06	ABVA-DELISTED	Stock	9.9	9.91	9.85	9.85	325.0
2007-09-06	ABVT-DELISTED	Stock	76.0	80.25	70.0	75.0	27373.0
2007-09-06	ABX-DELISTED	Stock	33.87	36.46	33.81	36.2	15793800.0
2007-09-06	ACAD	Stock	15.09	15.58	15.09	15.51	202300.0
2007-09-06	ACAP-DELISTED	Stock	38.89	39.28	38.65	38.98	35579.0
2007-09-06	ACAS-DELISTED	Stock	39.82	40.37	39.6601	39.985	1470091.0
2007-09-06	ACAT-DELISTED	Stock	16.38	16.59	16.32	16.55	50934.0
2007-09-06	ACC-DELISTED	Stock	28.08	28.37	27.69	27.87	78900.0

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

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