PREVIEW / stock_daily / 2014-05-19

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-19.parquet
  size:    218 KB
  rows:    6,545
  symbols: 3,550

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-19	AAPL	Stock	21.3518	21.6904	21.3332	21.5925	317755200.0
2014-05-19	MSFT	Stock	39.61	39.82	39.46	39.75	24537400.0
2014-05-19	NVDA	Stock	0.4538	0.466	0.4518	0.4635	360076000.0
2014-05-19	AMZN	Stock	14.788	14.95	14.6905	14.838	45684000.0
2014-05-19	GOOGL	Stock	26.444	26.9675	26.283	26.9415	39557700.0
2014-05-19	META	Stock	57.89	59.56	57.57	59.21	43034000.0
2014-05-19	TSLA	Stock	12.7147	13.126	12.6667	13.0727	68575500.0
2014-05-19	TLT	Stock	113.93	113.96	112.62	112.7	7403492.0
2014-05-19	ES	Stock	45.94	45.94	45.18	45.26	1331400.0
2014-05-19	CL	Stock	66.56	66.81	66.32	66.73	1832500.0
2014-05-19	A	Stock	39.2704	39.5064	39.1273	39.3205	3833456.0
2014-05-19	AABA-DELISTED	Stock	33.41	33.99	33.28	33.885	14143693.0
2014-05-19	AACG	Stock	4.65	4.75	4.59	4.59	44600.0
2014-05-19	AAIC-DELISTED	Stock	26.68	26.79	26.53	26.73	151453.0
2014-05-19	AAL	Stock	38.49	39.16	38.1	38.57	7164500.0
2014-05-19	AAMC-DELISTED	Stock	243.0147	258.2353	243.0147	253.1765	27037.0
2014-05-19	AAME	Stock	3.48	3.5	3.46	3.48	4500.0
2014-05-19	AAOI	Stock	17.99	19.6	17.99	19.28	235700.0
2014-05-19	AAON	Stock	13.3733	13.6889	13.3733	13.5467	96075.0
2014-05-19	AAP	Stock	121.48	123.47	121.31	122.8	784200.0
2014-05-19	AAT	Stock	34.3	34.33	33.89	34.26	83900.0
2014-05-19	AAU-DELISTED	Stock	1.3	1.36	1.3	1.3	35581.0
2014-05-19	AAUAF-DELISTED	Stock	1.3	1.35	1.3	1.31	36214.0
2014-05-19	AAV-DELISTED	Stock	5.75	5.83	5.69	5.76	243137.0
2014-05-19	AAWW-DELISTED	Stock	36.56	37.08	36.41	36.7	164812.0
2014-05-19	AAXJ	Stock	61.43	61.78	61.43	61.72	425012.0
2014-05-19	AAXN-DELISTED	Stock	13.2	13.66	13.111	13.525	838389.0
2014-05-19	AB	Stock	23.99	24.24	23.69	23.84	312600.0
2014-05-19	ABAC-DELISTED	Stock	2.11	2.11	2.0	2.0	39348.0
2014-05-19	ABAX-DELISTED	Stock	43.27	44.04	43.13	43.59	67182.0
2014-05-19	ABB-DELISTED	Stock	23.54	23.62	23.52	23.59	837454.0
2014-05-19	ABBNY-DELISTED	Stock	23.54	23.62	23.52	23.6	875897.0
2014-05-19	ABBV	Stock	52.84	54.21	52.71	54.11	6010500.0
2014-05-19	ABC-DELISTED	Stock	68.53	69.5	68.31	69.41	3077929.0
2014-05-19	ABCB	Stock	19.62	20.2	19.45	20.05	53400.0
2014-05-19	ABCD-DELISTED	Stock	2.35	2.35	2.3	2.3	28982.0
2014-05-19	ABCO-DELISTED	Stock	50.1	50.84	49.43	49.66	256923.0
2014-05-19	ABDC-DELISTED	Stock	15.06	15.06	14.9	14.92	31121.0
2014-05-19	ABE-DELISTED	Stock	13.9	14.03	13.9	14.02	8106.0
2014-05-19	ABEO	Stock	562.5	587.5	550.0	550.0	15.0
2014-05-19	ABEV	Stock	7.35	7.44	7.33	7.44	5060700.0
2014-05-19	ABG	Stock	62.64	63.58	62.35	63.18	221800.0
2014-05-19	ABGB-DELISTED	Stock	19.93	20.72	19.93	20.72	21909.0
2014-05-19	ABIL-DELISTED	Stock	9.7	9.85	9.6899	9.74	85828.0
2014-05-19	ABM	Stock	26.39	26.83	26.39	26.77	116600.0
2014-05-19	ABMD-DELISTED	Stock	21.35	22.1	21.23	21.95	227365.0
2014-05-19	ABR	Stock	7.02	7.07	6.98	7.07	55200.0
2014-05-19	ABR.A-DELISTED	Stock	24.56	24.6	24.48	24.51	10091.0
2014-05-19	ABR.B-DELISTED	Stock	23.49	23.76	23.49	23.7	5275.0
2014-05-19	ABR.C-DELISTED	Stock	24.82	24.82	24.78	24.797	6646.0

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

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