PREVIEW / stock_daily / 2011-02-07

all stock daily files

  file:    by_date/stock_daily/2011/2011-02-07.parquet
  size:    197 KB
  rows:    6,087
  symbols: 3,558

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-02-07	AAPL	Stock	12.4246	12.6161	12.4157	12.5671	485021600.0
2011-02-07	MSFT	Stock	27.8	28.34	27.79	28.2	68980900.0
2011-02-07	NVDA	Stock	0.633	0.6358	0.6128	0.615	934236000.0
2011-02-07	AMZN	Stock	8.8075	8.8775	8.7385	8.8215	105094000.0
2011-02-07	TSLA	Stock	1.5507	1.5507	1.5253	1.538	13426500.0
2011-02-07	TLT	Stock	88.7	89.3	88.57	89.27	8554880.0
2011-02-07	ES	Stock	33.73	34.01	33.63	33.81	1991100.0
2011-02-07	CL	Stock	38.215	38.225	37.9	38.14	9052800.0
2011-02-07	A	Stock	31.0801	31.9528	31.0229	31.7883	6388720.0
2011-02-07	AABA-DELISTED	Stock	16.83	17.0	16.77	16.81	15482809.0
2011-02-07	AACC-DELISTED	Stock	6.07	6.24	6.07	6.24	9274.0
2011-02-07	AACG	Stock	4.19	4.19	3.93	4.16	5400.0
2011-02-07	AAI-DELISTED	Stock	7.36	7.41	7.36	7.4	1786813.0
2011-02-07	AAIC-DELISTED	Stock	25.33	25.699	25.33	25.59	16314.0
2011-02-07	AAME	Stock	2.2	2.22	2.2	2.22	1000.0
2011-02-07	AAON	Stock	5.3175	5.3669	5.2958	5.3491	239962.0
2011-02-07	AAP	Stock	64.26	65.03	64.26	64.5	954700.0
2011-02-07	AAT	Stock	21.07	21.2	20.95	21.16	454900.0
2011-02-07	AATI-DELISTED	Stock	4.08	4.19	4.04	4.11	145964.0
2011-02-07	AAU-DELISTED	Stock	3.91	3.91	3.82	3.85	245899.0
2011-02-07	AAUAF-DELISTED	Stock	3.92	3.92	3.83	3.84	247167.0
2011-02-07	AAV-DELISTED	Stock	7.71	7.73	7.56	7.57	250961.0
2011-02-07	AAWW-DELISTED	Stock	53.82	55.04	53.59	54.11	107266.0
2011-02-07	AAXJ	Stock	62.38	62.77	62.29	62.64	536122.0
2011-02-07	AAXN-DELISTED	Stock	4.11	4.17	4.06	4.13	346431.0
2011-02-07	AB	Stock	21.25	21.82	21.25	21.58	707600.0
2011-02-07	ABAC-DELISTED	Stock	4.5	4.63	4.48	4.5	68749.0
2011-02-07	ABAX-DELISTED	Stock	25.64	26.09	25.56	25.68	84819.0
2011-02-07	ABB-DELISTED	Stock	23.31	23.65	23.27	23.62	2749513.0
2011-02-07	ABBC-DELISTED	Stock	12.48	12.86	12.41	12.63	126155.0
2011-02-07	ABBNY-DELISTED	Stock	23.31	23.65	23.27	23.65	2906457.0
2011-02-07	ABC-DELISTED	Stock	36.79	37.08	36.42	36.49	2513243.0
2011-02-07	ABCB	Stock	10.05	10.24	9.98	10.0	56800.0
2011-02-07	ABCD-DELISTED	Stock	3.2	3.29	3.2	3.28	17415.0
2011-02-07	ABCO-DELISTED	Stock	24.5	24.76	24.47	24.67	96828.0
2011-02-07	ABCW-DELISTED	Stock	1.69	1.74	1.56	1.58	190560.0
2011-02-07	ABD-DELISTED	Stock	8.525	8.675	8.465	8.505	230840.0
2011-02-07	ABE-DELISTED	Stock	18.66	18.75	18.431	18.5801	17051.0
2011-02-07	ABFS-DELISTED	Stock	24.03	24.38	23.895	24.09	188659.0
2011-02-07	ABG	Stock	18.78	19.72	18.66	19.48	167000.0
2011-02-07	ABH-DELISTED	Stock	27.28	29.07	27.266	28.275	954874.0
2011-02-07	ABM	Stock	25.96	26.68	25.77	26.64	195600.0
2011-02-07	ABMD-DELISTED	Stock	12.82	13.99	12.82	13.37	516027.0
2011-02-07	ABR	Stock	6.0	6.4	6.0	6.27	70700.0
2011-02-07	ABT	Stock	22.1476	22.1476	21.7973	21.9221	23649854.0
2011-02-07	ABTL-DELISTED	Stock	5.3025	5.3025	4.6208	5.05	23136.0
2011-02-07	ABUS	Stock	5.31	5.36	4.5	5.14	75600.0
2011-02-07	ABV-DELISTED	Stock	26.44	26.65	26.27	26.58	3052333.0
2011-02-07	ABVA-DELISTED	Stock	4.68	4.99	4.61	4.89	5588.0
2011-02-07	ABVT-DELISTED	Stock	61.94	62.83	61.44	62.16	40409.0

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

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