PREVIEW / stock_daily / 2014-05-21

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-21.parquet
  size:    218 KB
  rows:    6,525
  symbols: 3,532

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-05-21	AAPL	Stock	21.5654	21.6679	21.5021	21.6539	196859600.0
2014-05-21	MSFT	Stock	39.8	40.35	39.74	40.35	22398700.0
2014-05-21	NVDA	Stock	0.4578	0.4618	0.4532	0.456	216712000.0
2014-05-21	AMZN	Stock	15.1105	15.298	15.076	15.2505	68176000.0
2014-05-21	GOOGL	Stock	27.145	27.4875	27.1055	27.485	31297080.0
2014-05-21	META	Stock	58.56	60.5	58.25	60.49	58992000.0
2014-05-21	TSLA	Stock	13.0787	13.3247	12.986	13.2967	79281000.0
2014-05-21	TLT	Stock	112.22	112.4	111.87	112.26	8225046.0
2014-05-21	ES	Stock	45.31	45.42	44.99	45.27	1341700.0
2014-05-21	CL	Stock	66.69	66.85	66.46	66.81	1706400.0
2014-05-21	A	Stock	39.0415	39.4421	38.9413	39.3348	1541015.0
2014-05-21	AABA-DELISTED	Stock	34.0	34.39	33.89	34.35	12550897.0
2014-05-21	AAIC-DELISTED	Stock	26.81	26.9	26.7501	26.88	127080.0
2014-05-21	AAL	Stock	38.28	38.85	38.05	38.32	6564100.0
2014-05-21	AAMC-DELISTED	Stock	259.1176	264.7059	257.3382	263.5441	47464.0
2014-05-21	AAME	Stock	3.5	3.57	3.33	3.48	6500.0
2014-05-21	AAOI	Stock	18.11	19.655	17.81	18.35	117700.0
2014-05-21	AAON	Stock	13.1778	13.48	13.0711	13.3822	274725.0
2014-05-21	AAP	Stock	122.11	123.02	120.71	122.58	924900.0
2014-05-21	AAT	Stock	34.16	34.16	33.48	33.66	117300.0
2014-05-21	AAU-DELISTED	Stock	1.34	1.36	1.32	1.33	100943.0
2014-05-21	AAUAF-DELISTED	Stock	1.34	1.36	1.32	1.33	101744.0
2014-05-21	AAV-DELISTED	Stock	5.7	5.79	5.675	5.75	347746.0
2014-05-21	AAWW-DELISTED	Stock	36.7	37.356	36.02	36.07	150400.0
2014-05-21	AAXJ	Stock	61.71	61.78	61.58	61.76	1123550.0
2014-05-21	AAXN-DELISTED	Stock	12.91	13.09	12.82	13.06	536253.0
2014-05-21	AB	Stock	23.5	24.0	23.4	23.87	189300.0
2014-05-21	ABAC-DELISTED	Stock	2.1	2.16	2.05	2.1201	49596.0
2014-05-21	ABAX-DELISTED	Stock	42.6	42.64	41.655	41.79	92830.0
2014-05-21	ABB-DELISTED	Stock	23.53	23.678	23.49	23.63	1422862.0
2014-05-21	ABBNY-DELISTED	Stock	23.53	23.678	23.49	23.62	1484297.0
2014-05-21	ABBV	Stock	53.5	53.84	53.1	53.27	4088000.0
2014-05-21	ABC-DELISTED	Stock	69.79	70.81	69.79	70.7	2165993.0
2014-05-21	ABCB	Stock	20.07	20.54	20.07	20.36	181300.0
2014-05-21	ABCD-DELISTED	Stock	2.2604	2.35	2.2604	2.3	6745.0
2014-05-21	ABCO-DELISTED	Stock	47.42	49.64	47.24	48.43	365931.0
2014-05-21	ABDC-DELISTED	Stock	14.91	15.0175	14.8	14.89	2972.0
2014-05-21	ABE-DELISTED	Stock	14.0	14.0799	13.97	14.0799	8505.0
2014-05-21	ABEO	Stock	562.5	587.5	537.5	587.5	14.0
2014-05-21	ABEV	Stock	7.34	7.45	7.32	7.41	5314400.0
2014-05-21	ABG	Stock	63.46	64.18	62.94	63.92	205400.0
2014-05-21	ABGB-DELISTED	Stock	20.12	20.41	20.11	20.3	16365.0
2014-05-21	ABIL-DELISTED	Stock	9.73	9.78	9.73	9.75	3501.0
2014-05-21	ABM	Stock	26.34	26.43	25.98	26.21	163700.0
2014-05-21	ABMD-DELISTED	Stock	21.09	21.26	20.81	20.88	214464.0
2014-05-21	ABR	Stock	7.08	7.13	7.0	7.04	57000.0
2014-05-21	ABR.A-DELISTED	Stock	24.72	24.72	24.03	24.22	66775.0
2014-05-21	ABR.B-DELISTED	Stock	23.79	23.85	23.71	23.75	18354.0
2014-05-21	ABR.C-DELISTED	Stock	24.84	24.85	24.8299	24.85	7361.0
2014-05-21	ABRN-DELISTED	Stock	24.85	24.9	24.82	24.88	22000.0

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

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