PREVIEW / stock_daily / 2012-01-11

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-11.parquet
  size:    198 KB
  rows:    6,183
  symbols: 3,582

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
2012-01-11	AAPL	Stock	15.0957	15.1018	14.9754	15.0911	215084800.0
2012-01-11	MSFT	Stock	27.43	27.98	27.37	27.72	65582400.0
2012-01-11	NVDA	Stock	0.3588	0.362	0.3533	0.3548	484272000.0
2012-01-11	AMZN	Stock	8.982	9.0385	8.9095	8.945	62054000.0
2012-01-11	TSLA	Stock	1.8413	1.892	1.82	1.882	10084500.0
2012-01-11	TLT	Stock	119.04	120.06	118.98	119.86	8634406.0
2012-01-11	ES	Stock	34.39	34.56	34.19	34.24	1121400.0
2012-01-11	CL	Stock	44.685	44.695	44.075	44.255	5438000.0
2012-01-11	A	Stock	27.8112	28.1116	27.5608	27.8398	3932574.0
2012-01-11	AABA-DELISTED	Stock	15.59	15.62	15.45	15.53	9712928.0
2012-01-11	AACC-DELISTED	Stock	4.18	4.25	4.13	4.2	5100.0
2012-01-11	AACG	Stock	7.54	7.6	7.54	7.6	2300.0
2012-01-11	AAIC-DELISTED	Stock	20.57	21.65	20.44	21.06	59639.0
2012-01-11	AAME	Stock	2.0	2.03	2.0	2.02	600.0
2012-01-11	AAMRQ-DELISTED	Stock	0.365	0.37	0.3235	0.358	10094044.0
2012-01-11	AAON	Stock	5.9704	5.9911	5.9022	5.9259	267638.0
2012-01-11	AAP	Stock	71.6	72.49	71.6	72.02	551000.0
2012-01-11	AAT	Stock	20.18	20.74	20.07	20.73	54800.0
2012-01-11	AAU-DELISTED	Stock	2.64	2.86	2.61	2.86	343000.0
2012-01-11	AAUAF-DELISTED	Stock	2.64	2.86	2.61	2.86	344000.0
2012-01-11	AAV-DELISTED	Stock	4.23	4.23	3.94	4.05	457091.0
2012-01-11	AAWW-DELISTED	Stock	41.3	41.99	41.09	41.55	191383.0
2012-01-11	AAXJ	Stock	51.49	51.69	51.35	51.56	279976.0
2012-01-11	AAXN-DELISTED	Stock	5.17	5.1996	5.08	5.15	271419.0
2012-01-11	AB	Stock	15.02	15.23	14.62	14.71	326000.0
2012-01-11	ABAC-DELISTED	Stock	1.4	1.6	1.4	1.56	17779.0
2012-01-11	ABAX-DELISTED	Stock	28.18	28.68	28.11	28.5	120499.0
2012-01-11	ABB-DELISTED	Stock	19.71	19.9	19.67	19.86	1542295.0
2012-01-11	ABBNY-DELISTED	Stock	19.71	19.9	19.67	19.86	1552415.0
2012-01-11	ABC-DELISTED	Stock	38.89	38.92	38.4501	38.62	1123970.0
2012-01-11	ABCB	Stock	10.59	10.67	10.51	10.67	19700.0
2012-01-11	ABCD-DELISTED	Stock	3.15	3.22	3.102	3.19	12150.0
2012-01-11	ABCO-DELISTED	Stock	37.24	37.45	37.0	37.23	133178.0
2012-01-11	ABCW-DELISTED	Stock	0.3414	0.3665	0.3414	0.3615	87190.0
2012-01-11	ABD-DELISTED	Stock	9.32	9.43	9.3	9.4	127300.0
2012-01-11	ABE-DELISTED	Stock	17.98	18.18	17.98	18.063	4864.0
2012-01-11	ABEO	Stock	1612.5	1725.0	1612.5	1725.0	3.0
2012-01-11	ABFS-DELISTED	Stock	20.83	21.11	20.75	21.09	222714.0
2012-01-11	ABG	Stock	22.49	22.62	22.3	22.55	107700.0
2012-01-11	ABH-DELISTED	Stock	15.17	15.366	15.16	15.19	154267.0
2012-01-11	ABM	Stock	20.71	20.94	20.55	20.84	203500.0
2012-01-11	ABMD-DELISTED	Stock	18.08	18.37	18.08	18.23	104927.0
2012-01-11	ABR	Stock	3.77	3.98	3.74	3.93	60800.0
2012-01-11	ABT	Stock	26.7009	26.7057	26.4658	26.5905	13866194.0
2012-01-11	ABTL-DELISTED	Stock	3.8512	3.9135	3.7493	3.8	1674.0
2012-01-11	ABUS	Stock	1.7	1.75	1.65	1.75	15100.0
2012-01-11	ABV-DELISTED	Stock	35.43	35.67	35.42	35.6	1379605.0
2012-01-11	ABVA-DELISTED	Stock	3.33	3.48	3.33	3.47	700.0
2012-01-11	ABVT-DELISTED	Stock	67.2	67.37	65.2	65.73	150337.0
2012-01-11	ABX-DELISTED	Stock	48.43	48.95	47.96	48.78	4160637.0

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

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