PREVIEW / stock_daily / 2014-04-21

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-21.parquet
  size:    218 KB
  rows:    6,559
  symbols: 3,564

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-04-21	AAPL	Stock	18.7621	19.005	18.7129	18.9704	182548800.0
2014-04-21	MSFT	Stock	40.13	40.15	39.79	39.94	22221200.0
2014-04-21	NVDA	Stock	0.4643	0.469	0.4612	0.4678	117004000.0
2014-04-21	AMZN	Stock	16.1985	16.5575	16.1155	16.5435	59988000.0
2014-04-21	GOOGL	Stock	27.2	27.2	26.7	26.9685	48504140.0
2014-04-21	META	Stock	59.46	61.24	59.15	61.24	60364000.0
2014-04-21	TSLA	Stock	13.1387	13.7467	12.9333	13.6253	78873000.0
2014-04-21	TLT	Stock	110.37	110.62	109.84	109.96	4316275.0
2014-04-21	ES	Stock	45.88	46.07	45.36	45.71	1117200.0
2014-04-21	CL	Stock	66.7	67.05	66.15	66.84	2132200.0
2014-04-21	A	Stock	39.0629	39.1989	38.8627	39.1202	1657888.0
2014-04-21	AABA-DELISTED	Stock	36.6	36.65	35.89	36.39	15271658.0
2014-04-21	AACG	Stock	4.15	4.23	4.15	4.15	29900.0
2014-04-21	AAIC-DELISTED	Stock	25.85	25.98	25.695	25.75	104838.0
2014-04-21	AAL	Stock	35.08	35.79	34.86	35.67	7189200.0
2014-04-21	AAMC-DELISTED	Stock	286.9029	295.5882	283.2382	286.6118	35707.0
2014-04-21	AAME	Stock	3.55	3.62	3.48	3.58	29000.0
2014-04-21	AAOI	Stock	23.65	24.0	23.16	23.39	107200.0
2014-04-21	AAON	Stock	11.8578	12.0444	11.7778	11.9867	222750.0
2014-04-21	AAP	Stock	120.63	121.52	119.95	121.4	476100.0
2014-04-21	AAT	Stock	33.4	33.64	33.04	33.38	91000.0
2014-04-21	AAU-DELISTED	Stock	1.37	1.39	1.34	1.3637	148002.0
2014-04-21	AAUAF-DELISTED	Stock	1.37	1.39	1.34	1.3637	148547.0
2014-04-21	AAV-DELISTED	Stock	5.75	5.86	5.67	5.71	387336.0
2014-04-21	AAWW-DELISTED	Stock	35.33	35.42	34.74	34.9	123494.0
2014-04-21	AAXJ	Stock	60.76	60.76	60.4701	60.59	406971.0
2014-04-21	AAXN-DELISTED	Stock	17.86	17.93	17.36	17.7	854295.0
2014-04-21	AB	Stock	25.31	25.69	25.31	25.63	227400.0
2014-04-21	ABAC-DELISTED	Stock	2.15	2.15	1.96	2.1	32647.0
2014-04-21	ABAX-DELISTED	Stock	39.31	39.93	38.685	39.47	82705.0
2014-04-21	ABB-DELISTED	Stock	25.99	26.02	25.83	25.9	934317.0
2014-04-21	ABBNY-DELISTED	Stock	25.99	26.02	25.83	25.91	967220.0
2014-04-21	ABBV	Stock	48.5	49.45	48.4	49.43	4445000.0
2014-04-21	ABC-DELISTED	Stock	64.21	65.15	64.21	64.8	1108854.0
2014-04-21	ABCB	Stock	22.28	22.54	22.05	22.24	31100.0
2014-04-21	ABCD-DELISTED	Stock	2.19	2.3	2.16	2.175	45305.0
2014-04-21	ABCO-DELISTED	Stock	60.46	60.6	59.79	60.4	76848.0
2014-04-21	ABE-DELISTED	Stock	13.36	13.4194	13.26	13.38	11980.0
2014-04-21	ABEO	Stock	575.0	575.0	575.0	575.0	2.0
2014-04-21	ABEV	Stock	7.8	7.85	7.71	7.8	6138300.0
2014-04-21	ABFS-DELISTED	Stock	38.05	38.74	37.77	38.4	281268.0
2014-04-21	ABG	Stock	55.04	55.27	54.56	55.0	155800.0
2014-04-21	ABGB-DELISTED	Stock	22.79	22.92	22.75	22.88	19331.0
2014-04-21	ABIL-DELISTED	Stock	9.56	9.74	9.56	9.65	46700.0
2014-04-21	ABM	Stock	27.74	27.79	27.55	27.62	75300.0
2014-04-21	ABMD-DELISTED	Stock	24.75	25.06	24.34	24.93	151611.0
2014-04-21	ABR	Stock	7.0	7.07	6.92	6.96	79800.0
2014-04-21	ABR.A-DELISTED	Stock	24.98	25.09	24.92	25.03	27516.0
2014-04-21	ABR.B-DELISTED	Stock	23.439	23.53	23.4	23.46	44627.0
2014-04-21	ABR.C-DELISTED	Stock	24.85	24.9	24.85	24.9	17330.0

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

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