PREVIEW / stock_daily / 2014-09-08

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-08.parquet
  size:    222 KB
  rows:    6,654
  symbols: 3,596

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-09-08	AAPL	Stock	24.825	24.8275	24.5125	24.59	185426800.0
2014-09-08	MSFT	Stock	46.02	46.8	45.99	46.47	45736700.0
2014-09-08	NVDA	Stock	0.4988	0.4998	0.4928	0.4948	319288000.0
2014-09-08	AMZN	Stock	17.227	17.2905	16.952	17.117	59106000.0
2014-09-08	GOOGL	Stock	29.957	30.176	29.9012	30.0815	32024880.0
2014-09-08	META	Stock	77.26	78.17	77.01	77.89	28183000.0
2014-09-08	TSLA	Stock	18.508	18.992	18.5013	18.8073	82524000.0
2014-09-08	TLT	Stock	116.41	116.63	115.45	115.78	9331233.0
2014-09-08	ES	Stock	46.53	46.55	46.13	46.34	1679700.0
2014-09-08	CL	Stock	64.44	64.53	63.63	63.64	3739100.0
2014-09-08	A	Stock	41.2876	41.4592	41.1302	41.2375	1881428.0
2014-09-08	AABA-DELISTED	Stock	40.35	41.82	40.26	41.81	71177463.0
2014-09-08	AACG	Stock	4.61	4.66	4.6	4.65	9800.0
2014-09-08	AAIC-DELISTED	Stock	27.65	27.8	27.52	27.78	612701.0
2014-09-08	AAL	Stock	37.96	38.4	37.96	38.23	7345800.0
2014-09-08	AAMC-DELISTED	Stock	213.2353	213.5294	207.3412	209.1029	39573.0
2014-09-08	AAME	Stock	4.07	4.07	4.0	4.07	900.0
2014-09-08	AAOI	Stock	20.25	20.56	19.87	20.02	133500.0
2014-09-08	AAON	Stock	12.7133	12.7667	12.5133	12.7067	220650.0
2014-09-08	AAP	Stock	137.47	138.27	136.02	136.8	401700.0
2014-09-08	AAT	Stock	35.4	35.58	35.29	35.47	83700.0
2014-09-08	AAU-DELISTED	Stock	1.55	1.55	1.45	1.5	232520.0
2014-09-08	AAUAF-DELISTED	Stock	1.55	1.55	1.45	1.5	248025.0
2014-09-08	AAV-DELISTED	Stock	5.66	5.73	5.54	5.63	248983.0
2014-09-08	AAVL-DELISTED	Stock	31.2	31.404	29.56	29.56	44886.0
2014-09-08	AAWW-DELISTED	Stock	35.15	35.19	34.69	34.75	147893.0
2014-09-08	AAXJ	Stock	66.3	66.34	65.84	66.05	703031.0
2014-09-08	AAXN-DELISTED	Stock	18.31	18.35	17.36	17.81	3741146.0
2014-09-08	AB	Stock	26.7	27.0	26.63	26.7	194600.0
2014-09-08	ABAC-DELISTED	Stock	1.48	1.48	1.24	1.39	203896.0
2014-09-08	ABAX-DELISTED	Stock	48.11	48.87	47.84	48.8	64370.0
2014-09-08	ABB-DELISTED	Stock	23.0	23.115	22.87	22.91	1209323.0
2014-09-08	ABBNY-DELISTED	Stock	23.0	23.115	22.87	22.91	1315224.0
2014-09-08	ABBV	Stock	55.78	55.95	55.37	55.57	6568800.0
2014-09-08	ABC-DELISTED	Stock	77.93	78.5992	77.82	78.31	949360.0
2014-09-08	ABCB	Stock	22.64	22.88	22.57	22.88	70800.0
2014-09-08	ABCD-DELISTED	Stock	1.56	1.6	1.54	1.59	28733.0
2014-09-08	ABCO-DELISTED	Stock	48.09	48.14	46.02	47.55	155240.0
2014-09-08	ABDC-DELISTED	Stock	13.8	13.87	13.63	13.7	32159.0
2014-09-08	ABE-DELISTED	Stock	14.9	14.9599	14.71	14.76	20256.0
2014-09-08	ABEO	Stock	362.5	412.5	362.5	412.5	17.0
2014-09-08	ABEV	Stock	7.13	7.15	6.92	6.95	20017900.0
2014-09-08	ABG	Stock	71.81	72.09	70.49	71.4	242000.0
2014-09-08	ABGB-DELISTED	Stock	29.13	29.2199	28.94	29.07	79382.0
2014-09-08	ABIL-DELISTED	Stock	9.79	9.81	9.79	9.81	2100.0
2014-09-08	ABM	Stock	28.15	28.35	27.96	28.34	209800.0
2014-09-08	ABMD-DELISTED	Stock	24.89	25.3	24.69	25.28	81539.0
2014-09-08	ABR	Stock	6.97	6.97	6.9	6.9	24400.0
2014-09-08	ABR.A-DELISTED	Stock	24.85	24.899	24.838	24.856	1801.0
2014-09-08	ABR.B-DELISTED	Stock	24.35	24.35	24.14	24.2091	8356.0

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

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