PREVIEW / stock_daily / 2011-06-08

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-08.parquet
  size:    199 KB
  rows:    6,153
  symbols: 3,590

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-08	AAPL	Stock	11.8493	11.9571	11.8089	11.8657	333723600.0
2011-06-08	MSFT	Stock	23.9	24.02	23.86	23.94	42205000.0
2011-06-08	NVDA	Stock	0.4492	0.452	0.4358	0.4392	569288000.0
2011-06-08	AMZN	Stock	9.3725	9.4905	9.316	9.4025	74332000.0
2011-06-08	TSLA	Stock	1.896	1.9067	1.8013	1.808	25438500.0
2011-06-08	TLT	Stock	96.26	96.84	96.17	96.79	8928072.0
2011-06-08	ES	Stock	33.99	34.33	33.88	34.16	1559900.0
2011-06-08	CL	Stock	41.98	42.21	41.805	42.105	4298400.0
2011-06-08	A	Stock	33.9914	34.3848	33.8555	34.1488	6588355.0
2011-06-08	AABA-DELISTED	Stock	15.37	15.38	15.08	15.11	21676773.0
2011-06-08	AACC-DELISTED	Stock	3.45	3.64	3.16	3.23	104433.0
2011-06-08	AACG	Stock	11.6	11.6	10.86	10.98	81100.0
2011-06-08	AAIC-DELISTED	Stock	27.93	28.342	27.86	28.02	49955.0
2011-06-08	AAME	Stock	2.0	2.04	1.96	2.0	4100.0
2011-06-08	AAON	Stock	6.3585	6.4099	6.2874	6.2894	231862.0
2011-06-08	AAP	Stock	58.35	58.67	57.87	58.4	1260000.0
2011-06-08	AAT	Stock	21.63	21.85	21.6	21.66	73300.0
2011-06-08	AATI-DELISTED	Stock	6.05	6.065	6.04	6.04	609369.0
2011-06-08	AAU-DELISTED	Stock	3.23	3.27	3.07	3.13	382942.0
2011-06-08	AAUAF-DELISTED	Stock	3.23	3.27	3.07	3.13	383542.0
2011-06-08	AAV-DELISTED	Stock	8.07	8.19	7.89	7.93	330034.0
2011-06-08	AAWW-DELISTED	Stock	57.98	58.94	57.75	58.05	235194.0
2011-06-08	AAXJ	Stock	62.39	62.43	61.82	61.97	211487.0
2011-06-08	AAXN-DELISTED	Stock	4.4	4.41	4.28	4.28	547819.0
2011-06-08	AB	Stock	19.25	19.4	19.1	19.23	413300.0
2011-06-08	ABAC-DELISTED	Stock	2.51	2.51	2.3209	2.4	32656.0
2011-06-08	ABAX-DELISTED	Stock	27.99	28.51	27.98	28.27	70244.0
2011-06-08	ABB-DELISTED	Stock	25.87	25.915	25.5106	25.58	2705413.0
2011-06-08	ABBC-DELISTED	Stock	10.6	10.76	10.53	10.56	57595.0
2011-06-08	ABBNY-DELISTED	Stock	25.87	25.915	25.5106	25.57	2709664.0
2011-06-08	ABC-DELISTED	Stock	40.76	41.02	40.599	40.97	2483001.0
2011-06-08	ABCB	Stock	8.57	8.76	8.5	8.75	87100.0
2011-06-08	ABCD-DELISTED	Stock	3.13	3.29	3.12	3.17	28117.0
2011-06-08	ABCO-DELISTED	Stock	24.77	24.82	24.28	24.43	70008.0
2011-06-08	ABCW-DELISTED	Stock	0.75	0.7501	0.73	0.74	11140.0
2011-06-08	ABD-DELISTED	Stock	7.3	7.5	7.15	7.21	152120.0
2011-06-08	ABE-DELISTED	Stock	18.83	18.83	18.66	18.6664	9807.0
2011-06-08	ABEO	Stock	2625.0	2787.5	2625.0	2750.0	10.0
2011-06-08	ABFS-DELISTED	Stock	21.4	21.77	21.27	21.55	344400.0
2011-06-08	ABG	Stock	15.48	15.49	14.96	15.29	465000.0
2011-06-08	ABH-DELISTED	Stock	23.58	23.76	23.24	23.3	216050.0
2011-06-08	ABM	Stock	22.4	23.25	21.97	22.09	445900.0
2011-06-08	ABMD-DELISTED	Stock	17.01	17.18	16.84	17.05	93465.0
2011-06-08	ABR	Stock	4.98	5.1	4.91	5.0	37800.0
2011-06-08	ABT	Stock	24.5898	24.7625	24.5418	24.7241	11992288.0
2011-06-08	ABTL-DELISTED	Stock	5.55	5.7	5.5	5.6	19965.0
2011-06-08	ABUS	Stock	2.99	3.0	2.95	2.95	1000.0
2011-06-08	ABV-DELISTED	Stock	31.71	32.13	31.5	31.99	1825882.0
2011-06-08	ABVA-DELISTED	Stock	4.96	4.96	4.85	4.85	3841.0
2011-06-08	ABVT-DELISTED	Stock	73.19	73.64	72.49	73.26	215705.0

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

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