PREVIEW / stock_daily / 2007-08-29

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-29.parquet
  size:    176 KB
  rows:    5,468
  symbols: 3,288

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-08-29	AAPL	Stock	4.6386	4.7921	4.6264	4.7886	1166860800.0
2007-08-29	MSFT	Stock	28.13	28.61	27.82	28.59	45753700.0
2007-08-29	NVDA	Stock	0.7883	0.817	0.7867	0.816	538560000.0
2007-08-29	AMZN	Stock	3.848	3.9525	3.843	3.9525	101536000.0
2007-08-29	TLT	Stock	88.49	88.77	88.16	88.22	2686700.0
2007-08-29	CL	Stock	32.775	33.26	32.755	33.24	3168600.0
2007-08-29	A	Stock	25.0215	25.4793	24.9857	25.4793	2640682.0
2007-08-29	AABA-DELISTED	Stock	22.6	22.69	22.27	22.53	21802279.0
2007-08-29	AACC-DELISTED	Stock	10.61	11.03	10.58	10.97	130006.0
2007-08-29	AAI-DELISTED	Stock	10.09	10.47	10.09	10.44	793391.0
2007-08-29	AAIC-DELISTED	Stock	88.6	92.6	88.0	91.2	1705600.0
2007-08-29	AAME	Stock	2.8	3.06	2.8	2.85	9900.0
2007-08-29	AAON	Stock	3.9506	4.0395	3.9032	4.0336	300206.0
2007-08-29	AAP	Stock	34.48	35.32	34.45	35.32	897100.0
2007-08-29	AATI-DELISTED	Stock	9.0	9.28	8.95	9.19	905965.0
2007-08-29	AAU-DELISTED	Stock	2.22	2.22	1.91	2.14	189600.0
2007-08-29	AAUAF-DELISTED	Stock	2.22	2.22	1.91	2.14	189600.0
2007-08-29	AAV-DELISTED	Stock	11.34	11.35	11.1	11.19	600100.0
2007-08-29	AAWW-DELISTED	Stock	49.12	50.737	49.07	50.55	115049.0
2007-08-29	AAXN-DELISTED	Stock	13.41	13.68	13.37	13.6	1038068.0
2007-08-29	AB	Stock	81.05	82.52	80.15	80.97	295700.0
2007-08-29	ABAX-DELISTED	Stock	19.59	19.9	19.25	19.4	189044.0
2007-08-29	ABB-DELISTED	Stock	23.74	24.25	23.65	24.23	2069900.0
2007-08-29	ABBC-DELISTED	Stock	9.62	9.75	9.54	9.68	93834.0
2007-08-29	ABBNY-DELISTED	Stock	23.74	24.25	23.65	24.2	2106700.0
2007-08-29	ABC-DELISTED	Stock	23.78	23.8	23.28	23.61	3578400.0
2007-08-29	ABCB	Stock	19.1125	19.9489	18.9762	19.9489	25395.0
2007-08-29	ABCO-DELISTED	Stock	27.97	28.59	27.69	28.51	198243.0
2007-08-29	ABCW-DELISTED	Stock	26.59	27.23	26.46	27.19	146660.0
2007-08-29	ABD-DELISTED	Stock	22.88	23.11	22.56	22.94	293060.0
2007-08-29	ABE-DELISTED	Stock	20.8	21.56	20.41	21.33	31200.0
2007-08-29	ABEO	Stock	4300.0	4812.5	4300.0	4625.0	9.0
2007-08-29	ABFS-DELISTED	Stock	35.39	35.79	35.02	35.75	545134.0
2007-08-29	ABG	Stock	21.17	21.39	21.0	21.3	550200.0
2007-08-29	ABK-DELISTED	Stock	61.91	62.85	60.75	62.14	2514100.0
2007-08-29	ABM	Stock	22.4	23.07	22.15	22.99	191100.0
2007-08-29	ABMD-DELISTED	Stock	12.12	12.22	11.62	11.94	108358.0
2007-08-29	ABP-DELISTED	Stock	3.6	3.7	3.53	3.57	110900.0
2007-08-29	ABR	Stock	18.75	19.15	18.51	18.96	190500.0
2007-08-29	ABT	Stock	24.3978	24.7385	24.1531	24.7049	12620675.0
2007-08-29	ABTL-DELISTED	Stock	15.897	16.1	15.746	16.1	3983.0
2007-08-29	ABV-DELISTED	Stock	64.25	67.12	63.13	66.64	522100.0
2007-08-29	ABVA-DELISTED	Stock	9.95	10.03	9.85	9.97	25597.0
2007-08-29	ABX-DELISTED	Stock	31.29	31.9	31.21	31.8	3749700.0
2007-08-29	ACAD	Stock	14.09	14.18	13.8	14.17	182900.0
2007-08-29	ACAP-DELISTED	Stock	38.81	40.05	37.86	39.99	50705.0
2007-08-29	ACAS-DELISTED	Stock	39.59	40.38	39.16	40.26	1407668.0
2007-08-29	ACAT-DELISTED	Stock	16.6	17.04	16.34	16.98	87017.0
2007-08-29	ACC-DELISTED	Stock	27.02	27.53	26.82	27.4	115900.0
2007-08-29	ACCL-DELISTED	Stock	6.07	6.17	6.06	6.1	62346.0

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

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