PREVIEW / stock_daily / 2012-03-19

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-19.parquet
  size:    200 KB
  rows:    6,199
  symbols: 3,562

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-19	AAPL	Stock	21.3704	21.4918	21.0375	21.4679	901236000.0
2012-03-19	MSFT	Stock	32.54	32.61	32.15	32.2	44789200.0
2012-03-19	NVDA	Stock	0.367	0.3688	0.3642	0.366	405400000.0
2012-03-19	AMZN	Stock	9.1725	9.334	9.15	9.276	78068000.0
2012-03-19	TSLA	Stock	2.3507	2.3547	2.3027	2.332	15234000.0
2012-03-19	TLT	Stock	111.36	111.48	109.69	110.1	14011855.0
2012-03-19	ES	Stock	36.45	36.62	36.32	36.35	1075700.0
2012-03-19	CL	Stock	47.69	47.78	47.4	47.685	3946600.0
2012-03-19	A	Stock	32.5107	32.6896	32.3033	32.4464	3337445.0
2012-03-19	AABA-DELISTED	Stock	15.08	15.22	14.92	15.155	15418901.0
2012-03-19	AACC-DELISTED	Stock	4.76	4.76	4.51	4.65	48293.0
2012-03-19	AACG	Stock	6.43	6.61	6.3	6.3	4300.0
2012-03-19	AAIC-DELISTED	Stock	24.07	24.84	23.71	23.95	223696.0
2012-03-19	AAME	Stock	2.95	2.95	2.85	2.85	2800.0
2012-03-19	AAMRQ-DELISTED	Stock	0.49	0.497	0.48	0.488	1462544.0
2012-03-19	AAON	Stock	6.0119	6.317	5.9644	6.1363	200475.0
2012-03-19	AAP	Stock	87.81	88.85	87.33	88.5	1009400.0
2012-03-19	AAT	Stock	22.48	22.94	22.4	22.78	184500.0
2012-03-19	AAU-DELISTED	Stock	2.54	2.57	2.51	2.51	92111.0
2012-03-19	AAUAF-DELISTED	Stock	2.54	2.57	2.51	2.51	94311.0
2012-03-19	AAV-DELISTED	Stock	3.81	3.83	3.73	3.8	856375.0
2012-03-19	AAWW-DELISTED	Stock	47.9	49.13	47.16	48.53	311299.0
2012-03-19	AAXJ	Stock	57.23	57.84	57.23	57.63	7241343.0
2012-03-19	AAXN-DELISTED	Stock	4.05	4.09	4.02	4.05	284570.0
2012-03-19	AB	Stock	15.08	15.25	14.79	15.05	233800.0
2012-03-19	ABAC-DELISTED	Stock	1.645	1.74	1.62	1.63	5050.0
2012-03-19	ABAX-DELISTED	Stock	27.53	28.5	27.41	28.23	56538.0
2012-03-19	ABB-DELISTED	Stock	21.0	21.08	20.9223	20.98	3583854.0
2012-03-19	ABBNY-DELISTED	Stock	21.0	21.08	20.9223	20.99	3734089.0
2012-03-19	ABC-DELISTED	Stock	38.22	38.68	38.12	38.55	2626664.0
2012-03-19	ABCB	Stock	12.84	13.41	12.68	13.13	70300.0
2012-03-19	ABCD-DELISTED	Stock	2.8	2.9	2.61	2.87	13669.0
2012-03-19	ABCO-DELISTED	Stock	43.18	43.78	42.24	42.72	199131.0
2012-03-19	ABCW-DELISTED	Stock	0.5321	0.5824	0.5321	0.5522	85290.0
2012-03-19	ABD-DELISTED	Stock	12.66	13.151	12.56	13.01	656630.0
2012-03-19	ABE-DELISTED	Stock	19.48	19.52	19.3008	19.477	19705.0
2012-03-19	ABEO	Stock	1362.5	1375.0	1287.5	1325.0	37.0
2012-03-19	ABFS-DELISTED	Stock	18.94	19.29	18.82	19.02	131344.0
2012-03-19	ABG	Stock	26.54	26.77	26.11	26.71	389800.0
2012-03-19	ABH-DELISTED	Stock	15.41	15.57	15.36	15.37	104749.0
2012-03-19	ABM	Stock	23.53	23.93	23.32	23.82	252600.0
2012-03-19	ABMD-DELISTED	Stock	22.41	22.58	21.82	22.42	514957.0
2012-03-19	ABR	Stock	5.3	5.4	5.3	5.36	61300.0
2012-03-19	ABT	Stock	28.6345	29.0567	28.6345	28.8936	22666111.0
2012-03-19	ABTL-DELISTED	Stock	4.9817	5.2573	4.8204	4.9	39700.0
2012-03-19	ABUS	Stock	2.21	2.3	2.17	2.23	46000.0
2012-03-19	ABV-DELISTED	Stock	40.63	41.34	40.58	41.29	1296061.0
2012-03-19	ABVA-DELISTED	Stock	4.11	4.21	4.1	4.21	8775.0
2012-03-19	ABVT-DELISTED	Stock	84.45	84.54	83.75	83.7901	4226074.0
2012-03-19	ABX-DELISTED	Stock	44.02	44.4	43.55	43.6	7616459.0

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

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