PREVIEW / stock_daily / 2014-05-09

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-09.parquet
  size:    218 KB
  rows:    6,520
  symbols: 3,536

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-09	AAPL	Stock	20.8764	20.9375	20.7261	20.9121	291597600.0
2014-05-09	MSFT	Stock	39.54	39.85	39.37	39.54	29647600.0
2014-05-09	NVDA	Stock	0.4485	0.4528	0.4428	0.4512	539532000.0
2014-05-09	AMZN	Stock	14.5285	14.684	14.219	14.612	81260000.0
2014-05-09	GOOGL	Stock	25.9325	26.3675	25.714	26.331	45228940.0
2014-05-09	META	Stock	56.85	57.65	56.38	57.24	52584000.0
2014-05-09	TSLA	Stock	11.9907	12.2267	11.8147	12.1507	127428000.0
2014-05-09	TLT	Stock	111.53	111.81	110.98	111.24	6000569.0
2014-05-09	ES	Stock	46.42	46.6	45.7	45.77	1263000.0
2014-05-09	CL	Stock	67.02	67.73	67.02	67.65	2418100.0
2014-05-09	A	Stock	39.5279	39.7926	39.206	39.6209	1800484.0
2014-05-09	AABA-DELISTED	Stock	34.02	34.1	33.4149	33.76	19372849.0
2014-05-09	AACG	Stock	4.34	4.68	4.34	4.39	29200.0
2014-05-09	AAIC-DELISTED	Stock	26.0	26.35	25.992	26.34	208159.0
2014-05-09	AAL	Stock	37.96	38.7	37.91	38.26	9704400.0
2014-05-09	AAMC-DELISTED	Stock	232.3529	232.3529	215.0	218.2353	131430.0
2014-05-09	AAME	Stock	3.5	3.67	3.5	3.5	4800.0
2014-05-09	AAOI	Stock	18.03	18.88	15.52	17.57	1153800.0
2014-05-09	AAON	Stock	13.3378	13.7733	13.16	13.6667	255600.0
2014-05-09	AAP	Stock	122.43	124.87	122.16	124.56	842000.0
2014-05-09	AAT	Stock	34.5	34.7	34.42	34.56	165800.0
2014-05-09	AAU-DELISTED	Stock	1.3	1.32	1.28	1.3	53289.0
2014-05-09	AAUAF-DELISTED	Stock	1.3	1.31	1.28	1.31	54731.0
2014-05-09	AAV-DELISTED	Stock	6.08	6.1	5.72	5.93	796630.0
2014-05-09	AAWW-DELISTED	Stock	35.57	36.22	35.45	35.9	154217.0
2014-05-09	AAXJ	Stock	59.49	59.72	59.42	59.58	110136.0
2014-05-09	AAXN-DELISTED	Stock	13.12	13.39	13.03	13.27	1135573.0
2014-05-09	AB	Stock	23.47	23.47	22.75	23.29	482300.0
2014-05-09	ABAC-DELISTED	Stock	2.1	2.14	2.06	2.119	11400.0
2014-05-09	ABAX-DELISTED	Stock	39.73	40.75	39.56	40.69	55678.0
2014-05-09	ABB-DELISTED	Stock	23.25	23.33	23.115	23.27	2144096.0
2014-05-09	ABBNY-DELISTED	Stock	23.25	23.33	23.115	23.26	2290548.0
2014-05-09	ABBV	Stock	52.07	52.35	51.08	52.26	5012500.0
2014-05-09	ABC-DELISTED	Stock	64.52	65.75	64.02	65.57	2527937.0
2014-05-09	ABCB	Stock	20.04	20.71	20.04	20.62	102600.0
2014-05-09	ABCD-DELISTED	Stock	2.18	2.24	2.1501	2.2	10290.0
2014-05-09	ABCO-DELISTED	Stock	50.23	51.96	46.552	50.28	756882.0
2014-05-09	ABDC-DELISTED	Stock	15.0	15.3	14.83	15.05	204513.0
2014-05-09	ABE-DELISTED	Stock	13.76	13.76	13.68	13.72	5780.0
2014-05-09	ABEO	Stock	550.0	550.0	525.0	550.0	1.0
2014-05-09	ABEV	Stock	7.31	7.43	7.25	7.39	7678800.0
2014-05-09	ABG	Stock	61.53	63.03	61.22	62.85	314100.0
2014-05-09	ABGB-DELISTED	Stock	22.19	22.58	22.156	22.58	4341.0
2014-05-09	ABM	Stock	26.37	26.86	26.37	26.79	184300.0
2014-05-09	ABMD-DELISTED	Stock	20.76	21.75	20.51	21.59	311462.0
2014-05-09	ABR	Stock	7.02	7.09	7.01	7.06	41300.0
2014-05-09	ABR.A-DELISTED	Stock	25.4199	25.4199	25.25	25.36	3938.0
2014-05-09	ABR.B-DELISTED	Stock	24.13	24.13	23.88	24.069	9095.0
2014-05-09	ABR.C-DELISTED	Stock	25.33	25.34	25.3	25.3299	7000.0
2014-05-09	ABT	Stock	38.68	39.02	38.61	38.99	4409000.0

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

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