PREVIEW / stock_daily / 2011-06-13

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-13.parquet
  size:    198 KB
  rows:    6,141
  symbols: 3,583

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-06-13	AAPL	Stock	11.6857	11.7254	11.6096	11.6643	329473200.0
2011-06-13	MSFT	Stock	23.79	24.19	23.7	24.04	47572500.0
2011-06-13	NVDA	Stock	0.428	0.4335	0.422	0.425	574760000.0
2011-06-13	AMZN	Stock	9.3405	9.4655	9.243	9.3145	77378000.0
2011-06-13	TSLA	Stock	1.8713	1.9253	1.8587	1.8953	25701000.0
2011-06-13	TLT	Stock	96.74	97.29	96.64	96.65	5540140.0
2011-06-13	ES	Stock	33.89	34.0	33.66	33.92	1015300.0
2011-06-13	CL	Stock	42.38	42.775	42.15	42.67	6105200.0
2011-06-13	A	Stock	34.5207	34.6209	33.691	33.9986	5627509.0
2011-06-13	AABA-DELISTED	Stock	15.2	15.335	15.1	15.15	14147750.0
2011-06-13	AACC-DELISTED	Stock	3.34	3.39	3.28	3.3	49057.0
2011-06-13	AACG	Stock	10.35	10.52	10.15	10.5	69700.0
2011-06-13	AAIC-DELISTED	Stock	28.82	29.19	28.11	29.03	34652.0
2011-06-13	AAME	Stock	2.04	2.05	1.97	2.04	7200.0
2011-06-13	AAON	Stock	6.1037	6.2538	5.9477	6.1847	258187.0
2011-06-13	AAP	Stock	58.33	58.92	57.93	57.97	985500.0
2011-06-13	AAT	Stock	21.26	21.46	21.14	21.29	43000.0
2011-06-13	AATI-DELISTED	Stock	6.04	6.05	6.04	6.04	254306.0
2011-06-13	AAU-DELISTED	Stock	3.12	3.18	2.9	2.99	530847.0
2011-06-13	AAUAF-DELISTED	Stock	3.12	3.18	2.9	2.99	532547.0
2011-06-13	AAV-DELISTED	Stock	7.9	7.97	7.67	7.79	507074.0
2011-06-13	AAWW-DELISTED	Stock	57.53	58.27	57.0	57.15	87853.0
2011-06-13	AAXJ	Stock	61.25	61.25	60.59	60.81	209866.0
2011-06-13	AAXN-DELISTED	Stock	4.3	4.36	4.27	4.3	434803.0
2011-06-13	AB	Stock	19.39	19.59	19.26	19.33	318100.0
2011-06-13	ABAC-DELISTED	Stock	2.1	2.17	2.02	2.04	74726.0
2011-06-13	ABAX-DELISTED	Stock	27.98	28.21	27.46	27.48	104502.0
2011-06-13	ABB-DELISTED	Stock	25.24	25.5	24.95	25.26	5926598.0
2011-06-13	ABBC-DELISTED	Stock	10.28	10.4	10.17	10.22	35570.0
2011-06-13	ABBNY-DELISTED	Stock	25.24	25.5	24.95	25.27	6027523.0
2011-06-13	ABC-DELISTED	Stock	41.13	41.2	40.74	40.78	1800215.0
2011-06-13	ABCB	Stock	8.55	8.64	8.54	8.55	26900.0
2011-06-13	ABCD-DELISTED	Stock	3.17	3.17	3.09	3.12	29286.0
2011-06-13	ABCO-DELISTED	Stock	24.0	24.19	23.74	23.91	51572.0
2011-06-13	ABCW-DELISTED	Stock	0.7	0.77	0.61	0.61	110360.0
2011-06-13	ABD-DELISTED	Stock	7.125	7.165	6.9052	7.125	180080.0
2011-06-13	ABE-DELISTED	Stock	18.51	18.59	18.41	18.52	10263.0
2011-06-13	ABEO	Stock	2600.0	2687.5	2550.0	2625.0	13.0
2011-06-13	ABFS-DELISTED	Stock	21.79	22.0	21.48	21.6	181269.0
2011-06-13	ABG	Stock	15.48	15.59	15.0	15.04	525400.0
2011-06-13	ABH-DELISTED	Stock	22.77	22.87	22.35	22.56	520286.0
2011-06-13	ABM	Stock	22.05	22.08	21.76	21.81	169200.0
2011-06-13	ABMD-DELISTED	Stock	16.56	16.62	16.3	16.31	95261.0
2011-06-13	ABR	Stock	5.23	5.23	4.05	4.18	504500.0
2011-06-13	ABT	Stock	24.585	24.7769	24.5466	24.6617	16107962.0
2011-06-13	ABTL-DELISTED	Stock	5.5925	5.6415	5.0528	5.2	103479.0
2011-06-13	ABUS	Stock	2.71	2.86	2.7	2.7	2500.0
2011-06-13	ABV-DELISTED	Stock	31.58	31.785	31.26	31.42	1317703.0
2011-06-13	ABVA-DELISTED	Stock	5.25	5.4	5.16	5.4	6995.0
2011-06-13	ABVT-DELISTED	Stock	73.78	74.17	71.59	72.7	193972.0

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

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