PREVIEW / stock_daily / 2014-03-13

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-13.parquet
  size:    218 KB
  rows:    6,475
  symbols: 3,539

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
2014-03-13	AAPL	Stock	19.1943	19.2736	18.8986	18.9518	257742800.0
2014-03-13	MSFT	Stock	38.42	38.45	37.64	37.89	32169700.0
2014-03-13	NVDA	Stock	0.459	0.4608	0.4412	0.4435	385172000.0
2014-03-13	AMZN	Stock	18.831	19.1555	18.404	18.5755	136580000.0
2014-03-13	META	Stock	71.29	71.35	68.15	68.83	57091000.0
2014-03-13	TSLA	Stock	16.2527	16.2793	15.6	15.8527	93544500.0
2014-03-13	TLT	Stock	106.7	108.53	106.65	108.5	11815519.0
2014-03-13	ES	Stock	44.06	44.77	44.01	44.61	1618300.0
2014-03-13	CL	Stock	63.32	63.88	63.11	63.23	2633000.0
2014-03-13	A	Stock	40.887	41.0587	39.8927	39.9499	3241682.0
2014-03-13	AABA-DELISTED	Stock	38.02	38.42	36.81	37.23	19637421.0
2014-03-13	AACG	Stock	4.42	4.42	4.31	4.31	26800.0
2014-03-13	AAIC-DELISTED	Stock	27.12	27.4	27.05	27.24	101274.0
2014-03-13	AAL	Stock	37.9	37.99	35.75	36.74	11743600.0
2014-03-13	AAMC-DELISTED	Stock	250.0	257.3529	248.5294	252.1618	99681.0
2014-03-13	AAME	Stock	3.8	3.8	3.57	3.7	24200.0
2014-03-13	AAOI	Stock	26.95	27.22	26.0	26.2	174100.0
2014-03-13	AAON	Stock	13.0444	13.0444	12.0	12.1644	329400.0
2014-03-13	AAP	Stock	126.91	126.91	123.81	124.56	754200.0
2014-03-13	AAT	Stock	32.85	32.96	32.4	32.8	125400.0
2014-03-13	AAU-DELISTED	Stock	1.6	1.63	1.57	1.63	461573.0
2014-03-13	AAUAF-DELISTED	Stock	1.6	1.65	1.59	1.63	463742.0
2014-03-13	AAV-DELISTED	Stock	3.92	3.98	3.88	3.93	218268.0
2014-03-13	AAWW-DELISTED	Stock	32.3	32.3	31.88	31.97	168218.0
2014-03-13	AAXJ	Stock	57.46	57.57	56.36	56.59	461480.0
2014-03-13	AAXN-DELISTED	Stock	18.72	18.83	18.0	18.3	899009.0
2014-03-13	AB	Stock	24.29	24.95	24.2	24.3	473600.0
2014-03-13	ABAC-DELISTED	Stock	1.89	2.2999	1.89	2.09	196847.0
2014-03-13	ABAX-DELISTED	Stock	38.94	39.0899	37.95	38.46	188483.0
2014-03-13	ABB-DELISTED	Stock	25.37	25.45	24.7338	24.82	1209177.0
2014-03-13	ABBNY-DELISTED	Stock	25.37	25.45	24.7338	24.82	1265878.0
2014-03-13	ABBV	Stock	51.89	52.1	51.14	51.32	4839400.0
2014-03-13	ABC-DELISTED	Stock	68.01	68.21	67.55	67.8	1790935.0
2014-03-13	ABCB	Stock	23.54	23.67	22.85	23.52	95900.0
2014-03-13	ABCD-DELISTED	Stock	2.2	2.2	2.08	2.11	8392.0
2014-03-13	ABCO-DELISTED	Stock	66.36	67.82	65.88	66.68	291125.0
2014-03-13	ABE-DELISTED	Stock	12.6	12.6	12.4	12.41	9601.0
2014-03-13	ABEO	Stock	525.0	600.0	525.0	525.0	48.0
2014-03-13	ABEV	Stock	7.13	7.14	6.93	6.95	7171100.0
2014-03-13	ABFS-DELISTED	Stock	36.82	36.83	35.27	35.59	420026.0
2014-03-13	ABG	Stock	53.19	53.19	51.32	51.48	203600.0
2014-03-13	ABGB-DELISTED	Stock	23.51	23.51	22.5118	22.62	17422.0
2014-03-13	ABIL-DELISTED	Stock	9.66	9.7	9.64	9.64	10300.0
2014-03-13	ABM	Stock	28.42	28.43	27.97	28.15	174100.0
2014-03-13	ABMD-DELISTED	Stock	29.4	29.4	26.69	26.91	1343703.0
2014-03-13	ABR	Stock	6.73	6.75	6.66	6.69	66700.0
2014-03-13	ABR.A-DELISTED	Stock	24.4787	24.4787	24.27	24.35	2195.0
2014-03-13	ABR.B-DELISTED	Stock	22.7854	22.87	22.7854	22.84	700.0
2014-03-13	ABR.C-DELISTED	Stock	24.58	24.59	24.5	24.55	10791.0
2014-03-13	ABT	Stock	39.74	39.82	39.1	39.23	6964500.0

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

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