PREVIEW / stock_daily / 2011-03-02

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-02.parquet
  size:    198 KB
  rows:    6,078
  symbols: 3,541

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-03-02	AAPL	Stock	12.4986	12.6554	12.4429	12.5757	602590800.0
2011-03-02	MSFT	Stock	26.11	26.37	26.04	26.08	48658200.0
2011-03-02	NVDA	Stock	0.5405	0.5508	0.5062	0.5188	1718140000.0
2011-03-02	AMZN	Stock	8.4545	8.665	8.4175	8.601	103714000.0
2011-03-02	TSLA	Stock	1.588	1.6187	1.582	1.6013	9949500.0
2011-03-02	TLT	Stock	91.84	91.99	90.94	90.95	8529267.0
2011-03-02	ES	Stock	33.74	34.15	33.74	34.0	1545800.0
2011-03-02	CL	Stock	38.915	38.92	38.575	38.65	5767000.0
2011-03-02	A	Stock	29.02	29.7353	28.8698	29.6567	4721465.0
2011-03-02	AABA-DELISTED	Stock	16.65	16.85	16.6	16.61	23735977.0
2011-03-02	AACC-DELISTED	Stock	5.65	5.73	5.65	5.69	10554.0
2011-03-02	AACG	Stock	8.0	8.0	7.6	7.83	48700.0
2011-03-02	AAI-DELISTED	Stock	7.29	7.38	7.28	7.3	3989860.0
2011-03-02	AAIC-DELISTED	Stock	26.95	26.99	26.63	26.71	52411.0
2011-03-02	AAME	Stock	2.09	2.09	2.09	2.09	100.0
2011-03-02	AAON	Stock	6.0543	6.1926	6.0247	6.084	273375.0
2011-03-02	AAP	Stock	62.57	63.48	61.99	63.02	971600.0
2011-03-02	AAT	Stock	21.48	21.52	21.03	21.17	170400.0
2011-03-02	AATI-DELISTED	Stock	4.21	4.27	4.18	4.21	170446.0
2011-03-02	AAU-DELISTED	Stock	4.27	4.3	4.08	4.11	262049.0
2011-03-02	AAUAF-DELISTED	Stock	4.27	4.3	4.08	4.11	263049.0
2011-03-02	AAV-DELISTED	Stock	7.97	8.1	7.8	8.09	1623334.0
2011-03-02	AAWW-DELISTED	Stock	67.17	68.72	66.609	67.85	224718.0
2011-03-02	AAXJ	Stock	60.28	60.67	60.15	60.5	368705.0
2011-03-02	AAXN-DELISTED	Stock	3.69	3.9	3.6899	3.88	598649.0
2011-03-02	AB	Stock	22.49	22.81	22.45	22.53	490200.0
2011-03-02	ABAC-DELISTED	Stock	4.86	4.88	4.78	4.84	56183.0
2011-03-02	ABAX-DELISTED	Stock	26.23	27.05	26.07	26.85	127424.0
2011-03-02	ABB-DELISTED	Stock	24.24	24.415	24.2	24.28	2471907.0
2011-03-02	ABBC-DELISTED	Stock	12.28	12.44	12.11	12.25	96925.0
2011-03-02	ABBNY-DELISTED	Stock	24.24	24.415	24.2	24.27	2483818.0
2011-03-02	ABC-DELISTED	Stock	37.34	37.6	37.1	37.17	2327793.0
2011-03-02	ABCB	Stock	9.98	10.03	9.88	9.98	41700.0
2011-03-02	ABCD-DELISTED	Stock	3.47	3.67	3.46	3.66	20715.0
2011-03-02	ABCO-DELISTED	Stock	24.92	25.11	24.49	24.81	84606.0
2011-03-02	ABCW-DELISTED	Stock	1.0	1.1	1.0	1.04	126970.0
2011-03-02	ABD-DELISTED	Stock	8.38	8.64	8.38	8.61	168580.0
2011-03-02	ABE-DELISTED	Stock	17.56	17.87	17.56	17.76	18165.0
2011-03-02	ABEO	Stock	2562.5	2725.0	2562.5	2725.0	12.0
2011-03-02	ABFS-DELISTED	Stock	23.39	23.86	23.24	23.61	122547.0
2011-03-02	ABG	Stock	18.14	18.56	17.97	18.53	228900.0
2011-03-02	ABH-DELISTED	Stock	27.2	27.8	27.2	27.68	868082.0
2011-03-02	ABM	Stock	25.76	26.09	25.52	26.05	198200.0
2011-03-02	ABMD-DELISTED	Stock	12.68	13.19	12.664	13.15	108094.0
2011-03-02	ABR	Stock	6.94	7.5	6.56	6.67	291100.0
2011-03-02	ABT	Stock	22.6658	22.8769	22.637	22.8769	15155481.0
2011-03-02	ABTL-DELISTED	Stock	5.6019	5.7037	5.4491	5.5	58757.0
2011-03-02	ABUS	Stock	4.91	4.91	4.71	4.81	15500.0
2011-03-02	ABV-DELISTED	Stock	27.38	28.5	27.38	28.49	5088015.0
2011-03-02	ABVA-DELISTED	Stock	4.63	4.69	4.62	4.667	15860.0

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

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