PREVIEW / stock_daily / 2012-03-20

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-20.parquet
  size:    200 KB
  rows:    6,183
  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
2012-03-20	AAPL	Stock	21.4111	21.675	21.1243	21.6414	816662000.0
2012-03-20	MSFT	Stock	32.1	32.15	31.74	31.99	41566800.0
2012-03-20	NVDA	Stock	0.364	0.364	0.3568	0.36	449616000.0
2012-03-20	AMZN	Stock	9.244	9.7205	9.144	9.6165	183308000.0
2012-03-20	TSLA	Stock	2.332	2.3467	2.3047	2.3307	8505000.0
2012-03-20	TLT	Stock	110.43	110.8714	109.85	110.54	9444099.0
2012-03-20	ES	Stock	36.24	36.62	36.19	36.53	1137600.0
2012-03-20	CL	Stock	47.44	48.035	47.44	47.825	2969200.0
2012-03-20	A	Stock	32.2532	32.2961	31.8312	32.0672	2416723.0
2012-03-20	AABA-DELISTED	Stock	15.0	15.61	14.92	15.405	21981442.0
2012-03-20	AACC-DELISTED	Stock	4.58	4.735	4.58	4.7	31403.0
2012-03-20	AACG	Stock	6.34	6.36	6.3	6.35	21400.0
2012-03-20	AAIC-DELISTED	Stock	23.85	24.55	23.85	24.27	87034.0
2012-03-20	AAME	Stock	2.84	2.85	2.69	2.81	5100.0
2012-03-20	AAMRQ-DELISTED	Stock	0.484	0.488	0.456	0.4725	1500078.0
2012-03-20	AAON	Stock	6.0622	6.1156	5.8785	5.9585	132300.0
2012-03-20	AAP	Stock	88.33	89.35	88.18	88.81	1369500.0
2012-03-20	AAT	Stock	22.6	22.83	22.58	22.72	73400.0
2012-03-20	AAU-DELISTED	Stock	2.51	2.54	2.48	2.53	135139.0
2012-03-20	AAUAF-DELISTED	Stock	2.51	2.54	2.48	2.53	159530.0
2012-03-20	AAV-DELISTED	Stock	3.77	3.77	3.71	3.74	192197.0
2012-03-20	AAWW-DELISTED	Stock	48.21	49.37	47.6	48.36	316012.0
2012-03-20	AAXJ	Stock	56.71	56.79	56.43	56.7	351388.0
2012-03-20	AAXN-DELISTED	Stock	4.01	4.0794	3.98	3.98	333421.0
2012-03-20	AB	Stock	14.95	15.15	14.95	15.11	229100.0
2012-03-20	ABAC-DELISTED	Stock	1.67	1.7	1.62	1.62	2700.0
2012-03-20	ABAX-DELISTED	Stock	28.14	28.45	28.1	28.26	50263.0
2012-03-20	ABB-DELISTED	Stock	20.65	20.73	20.5	20.61	1477766.0
2012-03-20	ABBNY-DELISTED	Stock	20.65	20.73	20.5	20.61	1492466.0
2012-03-20	ABC-DELISTED	Stock	38.3	38.85	38.3	38.82	3535674.0
2012-03-20	ABCB	Stock	13.02	13.35	12.89	13.15	56600.0
2012-03-20	ABCD-DELISTED	Stock	2.84	2.84	2.74	2.77	11200.0
2012-03-20	ABCO-DELISTED	Stock	42.55	42.88	42.28	42.3	125678.0
2012-03-20	ABCW-DELISTED	Stock	0.6024	0.6526	0.5623	0.6426	113890.0
2012-03-20	ABD-DELISTED	Stock	12.85	12.91	12.64	12.83	392270.0
2012-03-20	ABE-DELISTED	Stock	19.43	19.43	18.62	19.186	12800.0
2012-03-20	ABEO	Stock	1325.0	1325.0	1175.0	1225.0	108.0
2012-03-20	ABFS-DELISTED	Stock	18.86	19.39	18.72	19.18	339997.0
2012-03-20	ABG	Stock	26.5	26.91	26.1	26.7	217300.0
2012-03-20	ABH-DELISTED	Stock	15.24	15.429	15.11	15.25	63758.0
2012-03-20	ABM	Stock	23.57	23.74	23.45	23.55	301100.0
2012-03-20	ABMD-DELISTED	Stock	22.19	22.56	22.001	22.3	231303.0
2012-03-20	ABR	Stock	5.29	5.67	5.29	5.65	82200.0
2012-03-20	ABT	Stock	28.7304	29.0519	28.7304	28.9799	14102126.0
2012-03-20	ABTL-DELISTED	Stock	5.0025	5.0025	4.7109	4.8975	29539.0
2012-03-20	ABUS	Stock	2.75	2.75	2.3	2.39	31100.0
2012-03-20	ABV-DELISTED	Stock	41.15	41.56	41.04	41.42	1713222.0
2012-03-20	ABVA-DELISTED	Stock	4.17	4.17	4.17	4.17	200.0
2012-03-20	ABVT-DELISTED	Stock	83.74	84.06	83.71	83.96	1423521.0
2012-03-20	ABX-DELISTED	Stock	43.17	43.91	42.53	43.8	8867138.0

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

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