PREVIEW / stock_daily / 2010-08-31

all stock daily files

  file:    by_date/stock_daily/2010/2010-08-31.parquet
  size:    190 KB
  rows:    5,948
  symbols: 3,484

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
2010-08-31	AAPL	Stock	8.6375	8.7343	8.5839	8.6821	420786800.0
2010-08-31	MSFT	Stock	23.6	23.73	23.32	23.47	66074600.0
2010-08-31	NVDA	Stock	0.2375	0.245	0.2325	0.2332	931488000.0
2010-08-31	AMZN	Stock	6.1425	6.295	6.125	6.2415	84512000.0
2010-08-31	TSLA	Stock	1.3107	1.3193	1.2887	1.2987	3016500.0
2010-08-31	TLT	Stock	108.22	108.65	107.62	108.56	8397291.0
2010-08-31	ES	Stock	28.51	29.08	28.3	28.97	2228600.0
2010-08-31	CL	Stock	36.885	37.415	36.85	36.92	7446600.0
2010-08-31	A	Stock	19.721	19.7425	19.1345	19.2918	7467417.0
2010-08-31	AABA-DELISTED	Stock	13.11	13.135	12.94	13.09	16454394.0
2010-08-31	AACC-DELISTED	Stock	3.84	3.86	3.74	3.83	19246.0
2010-08-31	AACG	Stock	2.9	2.95	2.9	2.9	43300.0
2010-08-31	AAI-DELISTED	Stock	4.51	4.62	4.4801	4.52	1318440.0
2010-08-31	AAIC-DELISTED	Stock	19.39	19.92	19.31	19.84	75372.0
2010-08-31	AAME	Stock	1.22	1.3	1.17	1.26	28200.0
2010-08-31	AAON	Stock	4.3279	4.4207	4.3081	4.3832	291094.0
2010-08-31	AAP	Stock	53.78	54.75	53.72	54.47	1268500.0
2010-08-31	AATI-DELISTED	Stock	3.27	3.35	3.23	3.25	80698.0
2010-08-31	AAU-DELISTED	Stock	2.09	2.24	2.09	2.22	444013.0
2010-08-31	AAUAF-DELISTED	Stock	2.09	2.24	2.09	2.22	445513.0
2010-08-31	AAV-DELISTED	Stock	5.82	6.02	5.82	5.95	395813.0
2010-08-31	AAWW-DELISTED	Stock	43.75	44.17	42.85	43.34	392228.0
2010-08-31	AAXJ	Stock	54.44	54.76	54.2	54.43	137915.0
2010-08-31	AAXN-DELISTED	Stock	3.63	3.74	3.62	3.64	320530.0
2010-08-31	AB	Stock	24.18	24.44	23.5	23.65	423400.0
2010-08-31	ABAC-DELISTED	Stock	3.91	3.91	3.73	3.85	9900.0
2010-08-31	ABAX-DELISTED	Stock	18.09	18.3	17.94	18.05	65029.0
2010-08-31	ABB-DELISTED	Stock	18.97	19.41	18.924	19.35	2609557.0
2010-08-31	ABBC-DELISTED	Stock	10.05	10.1584	9.99	10.02	52124.0
2010-08-31	ABBNY-DELISTED	Stock	18.97	19.41	18.924	19.37	2627046.0
2010-08-31	ABC-DELISTED	Stock	27.44	27.69	27.21	27.3	2521241.0
2010-08-31	ABCB	Stock	7.94	8.12	7.75	7.83	54700.0
2010-08-31	ABCD-DELISTED	Stock	2.86	2.89	2.77	2.84	25460.0
2010-08-31	ABCO-DELISTED	Stock	20.23	20.56	20.13	20.27	119378.0
2010-08-31	ABCW-DELISTED	Stock	0.62	0.63	0.62	0.63	116460.0
2010-08-31	ABD-DELISTED	Stock	5.71	5.9829	5.52	5.81	400970.0
2010-08-31	ABE-DELISTED	Stock	16.89	17.05	16.87	16.9865	7749.0
2010-08-31	ABEO	Stock	2500.0	2550.0	2450.0	2550.0	7.0
2010-08-31	ABFS-DELISTED	Stock	20.56	20.89	20.41	20.62	288964.0
2010-08-31	ABG	Stock	11.85	12.31	11.69	11.93	258300.0
2010-08-31	ABII-DELISTED	Stock	73.22	73.95	73.15	73.34	222005.0
2010-08-31	ABK-DELISTED	Stock	0.51	0.5762	0.498	0.546	12495766.0
2010-08-31	ABM	Stock	19.85	20.07	19.54	19.61	261800.0
2010-08-31	ABMD-DELISTED	Stock	9.0	9.12	8.99	9.05	150337.0
2010-08-31	ABR	Stock	4.62	4.71	4.45	4.55	51900.0
2010-08-31	ABT	Stock	23.6062	23.7261	23.5198	23.6733	14662985.0
2010-08-31	ABTL-DELISTED	Stock	4.2433	4.3985	4.1398	4.25	5641.0
2010-08-31	ABV-DELISTED	Stock	108.17	111.87	108.17	110.63	601701.0
2010-08-31	ABVT-DELISTED	Stock	51.2	51.87	50.915	51.63	123784.0
2010-08-31	ABX-DELISTED	Stock	46.64	47.5	46.6	46.82	8683420.0

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

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