PREVIEW / stock_daily / 2012-03-21

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-21.parquet
  size:    199 KB
  rows:    6,150
  symbols: 3,531

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-21	AAPL	Stock	21.5264	21.7732	21.4789	21.5179	644042000.0
2012-03-21	MSFT	Stock	31.96	32.15	31.82	31.91	37928600.0
2012-03-21	NVDA	Stock	0.36	0.3648	0.356	0.3615	467840000.0
2012-03-21	AMZN	Stock	9.625	9.714	9.563	9.5865	84288000.0
2012-03-21	TSLA	Stock	2.3293	2.3533	2.3067	2.3433	9108000.0
2012-03-21	TLT	Stock	110.86	111.89	110.81	111.79	10242229.0
2012-03-21	ES	Stock	36.49	36.61	36.21	36.37	872000.0
2012-03-21	CL	Stock	47.755	48.2	47.755	48.085	3887800.0
2012-03-21	A	Stock	32.1102	32.2747	31.7597	31.9886	2198495.0
2012-03-21	AABA-DELISTED	Stock	15.42	15.61	15.17	15.515	25012969.0
2012-03-21	AACC-DELISTED	Stock	4.765	4.77	4.67	4.73	18200.0
2012-03-21	AACG	Stock	6.31	6.31	6.3	6.31	4600.0
2012-03-21	AAIC-DELISTED	Stock	24.4	25.19	24.36	24.59	350867.0
2012-03-21	AAME	Stock	2.77	2.9	2.72	2.89	3100.0
2012-03-21	AAMRQ-DELISTED	Stock	0.4725	0.4845	0.467	0.4799	1159261.0
2012-03-21	AAON	Stock	5.9911	6.24	5.9881	6.0919	147488.0
2012-03-21	AAP	Stock	89.29	89.65	88.9	89.11	528200.0
2012-03-21	AAT	Stock	22.79	22.88	22.62	22.76	70300.0
2012-03-21	AAU-DELISTED	Stock	2.57	2.64	2.53	2.64	121671.0
2012-03-21	AAUAF-DELISTED	Stock	2.53	2.64	2.53	2.64	122471.0
2012-03-21	AAV-DELISTED	Stock	3.72	3.75	3.71	3.75	182204.0
2012-03-21	AAWW-DELISTED	Stock	48.31	50.35	47.89	49.5	615325.0
2012-03-21	AAXJ	Stock	56.77	56.93	56.55	56.83	171552.0
2012-03-21	AAXN-DELISTED	Stock	4.07	4.25	4.03	4.19	1030228.0
2012-03-21	AB	Stock	15.21	15.48	15.12	15.23	195400.0
2012-03-21	ABAC-DELISTED	Stock	1.6899	1.69	1.63	1.63	5900.0
2012-03-21	ABAX-DELISTED	Stock	28.36	28.54	28.13	28.36	96197.0
2012-03-21	ABB-DELISTED	Stock	20.6	20.64	20.39	20.46	1239163.0
2012-03-21	ABBNY-DELISTED	Stock	20.6	20.64	20.39	20.45	1239463.0
2012-03-21	ABC-DELISTED	Stock	38.69	38.7899	38.52	38.57	2496340.0
2012-03-21	ABCB	Stock	13.24	13.29	13.11	13.2	32700.0
2012-03-21	ABCD-DELISTED	Stock	2.83	2.925	2.71	2.76	8329.0
2012-03-21	ABCO-DELISTED	Stock	42.51	43.58	42.04	42.76	108668.0
2012-03-21	ABCW-DELISTED	Stock	0.6526	0.753	0.6125	0.6727	47930.0
2012-03-21	ABD-DELISTED	Stock	12.84	12.84	12.64	12.64	437310.0
2012-03-21	ABE-DELISTED	Stock	19.07	19.55	19.07	19.42	51310.0
2012-03-21	ABEO	Stock	1262.5	1262.5	1062.5	1262.5	161.0
2012-03-21	ABFS-DELISTED	Stock	19.3	19.5	19.13	19.42	426778.0
2012-03-21	ABG	Stock	26.81	27.15	26.69	26.81	257800.0
2012-03-21	ABH-DELISTED	Stock	15.29	15.2992	15.02	15.15	84695.0
2012-03-21	ABM	Stock	23.61	23.67	23.38	23.39	229400.0
2012-03-21	ABMD-DELISTED	Stock	22.34	23.19	22.29	23.1	777010.0
2012-03-21	ABR	Stock	5.59	5.67	5.57	5.57	69700.0
2012-03-21	ABT	Stock	28.908	29.0375	28.7928	28.9751	13667153.0
2012-03-21	ABTL-DELISTED	Stock	5.0857	5.0883	4.9	4.9	26647.0
2012-03-21	ABUS	Stock	2.35	2.4	2.3	2.36	20500.0
2012-03-21	ABV-DELISTED	Stock	41.6	41.84	41.38	41.72	2100320.0
2012-03-21	ABVA-DELISTED	Stock	4.16	4.16	4.1	4.1	4792.0
2012-03-21	ABVT-DELISTED	Stock	84.07	84.22	83.29	83.32	1253932.0
2012-03-21	ABX-DELISTED	Stock	44.23	44.23	43.5	43.63	7816629.0

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

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