PREVIEW / stock_daily / 2011-06-07

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-07.parquet
  size:    198 KB
  rows:    6,113
  symbols: 3,561

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-07	AAPL	Stock	12.0775	12.0793	11.8536	11.8586	529785200.0
2011-06-07	MSFT	Stock	24.09	24.17	23.9	24.06	41112600.0
2011-06-07	NVDA	Stock	0.4552	0.4578	0.4495	0.4515	433956000.0
2011-06-07	AMZN	Stock	9.286	9.5315	9.276	9.3775	97330000.0
2011-06-07	TSLA	Stock	1.9293	1.9593	1.884	1.8913	18331500.0
2011-06-07	TLT	Stock	95.23	96.06	95.12	96.04	7407540.0
2011-06-07	ES	Stock	34.03	34.26	33.88	34.02	1391800.0
2011-06-07	CL	Stock	42.185	42.33	41.945	41.945	4422600.0
2011-06-07	A	Stock	33.9843	34.3705	33.7268	34.1202	5771503.0
2011-06-07	AABA-DELISTED	Stock	15.56	15.65	15.32	15.45	16303908.0
2011-06-07	AACC-DELISTED	Stock	3.62	3.7	3.44	3.44	36018.0
2011-06-07	AACG	Stock	11.63	11.78	11.54	11.57	45600.0
2011-06-07	AAIC-DELISTED	Stock	27.8	28.19	27.44	28.06	38566.0
2011-06-07	AAME	Stock	1.9	2.04	1.88	2.04	7100.0
2011-06-07	AAON	Stock	6.3783	6.5027	6.3565	6.4217	333619.0
2011-06-07	AAP	Stock	58.68	59.13	57.55	58.43	1555500.0
2011-06-07	AAT	Stock	21.84	21.93	21.7	21.7	87700.0
2011-06-07	AATI-DELISTED	Stock	6.04	6.08	6.03	6.07	1248965.0
2011-06-07	AAU-DELISTED	Stock	3.23	3.35	3.17	3.25	302650.0
2011-06-07	AAUAF-DELISTED	Stock	3.23	3.35	3.17	3.27	304250.0
2011-06-07	AAV-DELISTED	Stock	8.27	8.32	8.12	8.13	288595.0
2011-06-07	AAWW-DELISTED	Stock	59.29	59.29	58.36	58.37	165778.0
2011-06-07	AAXJ	Stock	62.92	63.006	62.6	62.61	230549.0
2011-06-07	AAXN-DELISTED	Stock	4.49	4.49	4.41	4.41	193234.0
2011-06-07	AB	Stock	19.4	19.55	19.31	19.35	626400.0
2011-06-07	ABAC-DELISTED	Stock	2.57	2.59	2.33	2.38	26695.0
2011-06-07	ABAX-DELISTED	Stock	28.26	28.51	28.0	28.21	62892.0
2011-06-07	ABB-DELISTED	Stock	26.34	26.37	26.09	26.11	2039407.0
2011-06-07	ABBC-DELISTED	Stock	10.6	10.88	10.56	10.67	30189.0
2011-06-07	ABBNY-DELISTED	Stock	26.34	26.37	26.09	26.11	2039407.0
2011-06-07	ABC-DELISTED	Stock	40.64	41.03	40.24	40.92	2617652.0
2011-06-07	ABCB	Stock	8.73	8.78	8.61	8.63	165000.0
2011-06-07	ABCD-DELISTED	Stock	3.09	3.21	3.09	3.15	54940.0
2011-06-07	ABCO-DELISTED	Stock	25.23	25.25	24.89	24.89	40652.0
2011-06-07	ABCW-DELISTED	Stock	0.75	0.77	0.735	0.74	7650.0
2011-06-07	ABD-DELISTED	Stock	7.56	7.57	7.37	7.37	136980.0
2011-06-07	ABE-DELISTED	Stock	18.78	18.9	18.78	18.83	10230.0
2011-06-07	ABEO	Stock	2650.0	2800.0	2625.0	2787.5	7.0
2011-06-07	ABFS-DELISTED	Stock	21.56	21.76	21.3	21.52	283906.0
2011-06-07	ABG	Stock	15.41	16.04	15.41	15.53	370600.0
2011-06-07	ABH-DELISTED	Stock	23.9	24.01	23.32	23.58	177581.0
2011-06-07	ABM	Stock	22.38	22.53	22.26	22.41	280100.0
2011-06-07	ABMD-DELISTED	Stock	17.0	17.23	16.75	17.13	178408.0
2011-06-07	ABR	Stock	5.08	5.12	4.95	5.0	33400.0
2011-06-07	ABT	Stock	24.6137	24.8392	24.537	24.6521	14986870.0
2011-06-07	ABTL-DELISTED	Stock	5.75	5.85	5.55	5.6	18557.0
2011-06-07	ABUS	Stock	3.18	3.19	2.85	2.98	5000.0
2011-06-07	ABV-DELISTED	Stock	31.5	31.98	31.5	31.62	1403757.0
2011-06-07	ABVA-DELISTED	Stock	4.94	4.98	4.94	4.94	4740.0
2011-06-07	ABVT-DELISTED	Stock	72.9	76.51	72.7	73.51	1117116.0

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

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