PREVIEW / stock_daily / 2011-05-06

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-06.parquet
  size:    198 KB
  rows:    6,110
  symbols: 3,563

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
2011-05-06	AAPL	Stock	12.4889	12.5	12.3646	12.3807	280134400.0
2011-05-06	MSFT	Stock	26.07	26.22	25.75	25.87	55993000.0
2011-05-06	NVDA	Stock	0.4763	0.4875	0.4725	0.483	841080000.0
2011-05-06	AMZN	Stock	9.955	9.978	9.828	9.88	80278000.0
2011-05-06	TSLA	Stock	1.7933	1.8467	1.7747	1.808	14725500.0
2011-05-06	TLT	Stock	94.51	95.49	94.35	95.07	9460654.0
2011-05-06	ES	Stock	35.52	35.75	35.04	35.3	1383500.0
2011-05-06	CL	Stock	42.665	42.725	42.3	42.44	4097200.0
2011-05-06	A	Stock	35.7582	36.1445	35.2289	35.5722	3613271.0
2011-05-06	AABA-DELISTED	Stock	18.59	18.8	18.38	18.66	26774365.0
2011-05-06	AACC-DELISTED	Stock	5.09	5.09	4.88	5.0	19409.0
2011-05-06	AACG	Stock	7.99	8.23	7.99	8.22	8700.0
2011-05-06	AAIC-DELISTED	Stock	29.21	29.25	28.72	28.77	15167.0
2011-05-06	AAME	Stock	2.04	2.09	1.91	2.07	5600.0
2011-05-06	AAON	Stock	6.398	6.4395	6.2677	6.2775	192375.0
2011-05-06	AAP	Stock	66.12	66.6	65.02	65.05	682400.0
2011-05-06	AAT	Stock	22.02	22.04	21.59	21.72	57000.0
2011-05-06	AATI-DELISTED	Stock	4.01	4.07	3.75	3.96	218194.0
2011-05-06	AAU-DELISTED	Stock	3.96	4.14	3.83	3.98	644698.0
2011-05-06	AAUAF-DELISTED	Stock	3.96	4.14	3.83	3.98	645298.0
2011-05-06	AAV-DELISTED	Stock	7.75	8.09	7.67	7.77	649034.0
2011-05-06	AAWW-DELISTED	Stock	63.79	64.77	63.71	64.19	279548.0
2011-05-06	AAXJ	Stock	63.99	64.16	63.22	63.56	593918.0
2011-05-06	AAXN-DELISTED	Stock	4.42	4.46	4.35	4.39	225795.0
2011-05-06	AB	Stock	22.16	22.39	22.06	22.25	401300.0
2011-05-06	ABAC-DELISTED	Stock	3.22	3.25	3.04	3.07	52494.0
2011-05-06	ABAX-DELISTED	Stock	27.88	28.06	27.6	27.65	49241.0
2011-05-06	ABB-DELISTED	Stock	26.27	26.46	25.89	26.07	2358889.0
2011-05-06	ABBC-DELISTED	Stock	12.17	12.27	11.79	11.85	23656.0
2011-05-06	ABBNY-DELISTED	Stock	26.27	26.46	25.89	26.05	2362989.0
2011-05-06	ABC-DELISTED	Stock	41.31	41.85	41.3	41.4999	1860773.0
2011-05-06	ABCB	Stock	9.38	9.53	9.21	9.22	93000.0
2011-05-06	ABCD-DELISTED	Stock	3.29	3.29	3.14	3.17	44647.0
2011-05-06	ABCO-DELISTED	Stock	25.51	25.59	24.13	25.27	131952.0
2011-05-06	ABCW-DELISTED	Stock	0.8	0.8	0.65	0.68	275360.0
2011-05-06	ABD-DELISTED	Stock	9.65	9.65	9.35	9.46	276010.0
2011-05-06	ABE-DELISTED	Stock	18.86	18.93	18.799	18.82	11434.0
2011-05-06	ABEO	Stock	2625.0	2875.0	2625.0	2875.0	47.0
2011-05-06	ABFS-DELISTED	Stock	24.09	24.3	23.72	24.15	545545.0
2011-05-06	ABG	Stock	16.73	17.04	16.54	16.59	316000.0
2011-05-06	ABH-DELISTED	Stock	26.47	26.57	26.07	26.25	384092.0
2011-05-06	ABM	Stock	24.28	24.34	23.93	24.01	224000.0
2011-05-06	ABMD-DELISTED	Stock	16.83	17.15	16.71	16.94	148731.0
2011-05-06	ABR	Stock	5.15	5.22	5.08	5.12	108800.0
2011-05-06	ABT	Stock	25.3095	25.367	25.0983	25.1991	11868070.0
2011-05-06	ABTL-DELISTED	Stock	6.2	6.8	6.1	6.35	37872.0
2011-05-06	ABUS	Stock	2.85	2.94	2.73	2.89	1600.0
2011-05-06	ABV-DELISTED	Stock	32.8	32.935	32.43	32.83	3856110.0
2011-05-06	ABVA-DELISTED	Stock	6.55	6.95	6.45	6.65	21465.0
2011-05-06	ABVT-DELISTED	Stock	66.16	66.47	63.32	63.54	281414.0

> showing 50 of 6,110 rows — these rows as CSV

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