PREVIEW / stock_daily / 2014-05-13

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-13.parquet
  size:    219 KB
  rows:    6,553
  symbols: 3,553

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-13	AAPL	Stock	21.1429	21.2336	21.0964	21.2057	159737200.0
2014-05-13	MSFT	Stock	39.92	40.5	39.85	40.42	27004800.0
2014-05-13	NVDA	Stock	0.4582	0.4658	0.4555	0.457	221104000.0
2014-05-13	AMZN	Stock	15.13	15.28	15.0375	15.232	70198000.0
2014-05-13	GOOGL	Stock	26.979	27.1995	26.895	27.077	40239260.0
2014-05-13	META	Stock	59.66	60.89	59.51	59.83	48525000.0
2014-05-13	TSLA	Stock	12.2507	12.756	12.2	12.6773	106458000.0
2014-05-13	TLT	Stock	111.44	111.75	111.33	111.75	5501018.0
2014-05-13	ES	Stock	45.27	45.64	45.16	45.34	1194200.0
2014-05-13	CL	Stock	67.21	67.39	67.0	67.26	1797000.0
2014-05-13	A	Stock	40.5079	40.7582	40.3433	40.6509	2048769.0
2014-05-13	AABA-DELISTED	Stock	34.43	34.685	34.19	34.4	11767780.0
2014-05-13	AACG	Stock	4.4	4.4	4.26	4.28	2100.0
2014-05-13	AAIC-DELISTED	Stock	26.93	27.03	26.75	26.91	217253.0
2014-05-13	AAL	Stock	38.95	39.74	38.85	39.31	8680100.0
2014-05-13	AAMC-DELISTED	Stock	242.9941	244.7059	235.3029	241.7794	41014.0
2014-05-13	AAME	Stock	3.48	3.55	3.48	3.5	5000.0
2014-05-13	AAOI	Stock	17.4	17.95	17.21	17.26	176000.0
2014-05-13	AAON	Stock	14.1689	14.1689	13.6667	13.8	290925.0
2014-05-13	AAP	Stock	125.69	125.69	123.07	123.41	816800.0
2014-05-13	AAT	Stock	34.33	34.9	34.27	34.27	263500.0
2014-05-13	AAU-DELISTED	Stock	1.35	1.3605	1.3	1.33	35036.0
2014-05-13	AAUAF-DELISTED	Stock	1.33	1.34	1.3	1.33	42060.0
2014-05-13	AAV-DELISTED	Stock	5.86	5.95	5.8	5.93	281499.0
2014-05-13	AAWW-DELISTED	Stock	36.37	37.53	36.11	37.43	230571.0
2014-05-13	AAXJ	Stock	60.61	60.88	60.54	60.76	202129.0
2014-05-13	AAXN-DELISTED	Stock	14.17	14.24	13.55	13.65	761932.0
2014-05-13	AB	Stock	23.6	24.31	23.58	24.08	434700.0
2014-05-13	ABAC-DELISTED	Stock	2.21	2.21	2.0601	2.1799	43816.0
2014-05-13	ABAX-DELISTED	Stock	42.31	44.79	42.27	44.58	241229.0
2014-05-13	ABB-DELISTED	Stock	23.7	23.72	23.55	23.585	1054658.0
2014-05-13	ABBNY-DELISTED	Stock	23.7	23.72	23.55	23.59	2612626.0
2014-05-13	ABBV	Stock	52.45	52.5	51.92	52.2	4145200.0
2014-05-13	ABC-DELISTED	Stock	66.55	67.0	66.05	66.85	2404783.0
2014-05-13	ABCB	Stock	21.01	21.05	20.82	20.85	99000.0
2014-05-13	ABCD-DELISTED	Stock	2.3499	2.4	2.2675	2.339	108863.0
2014-05-13	ABCO-DELISTED	Stock	52.64	54.19	50.17	50.39	227677.0
2014-05-13	ABDC-DELISTED	Stock	15.0	15.0	14.85	15.0	23325.0
2014-05-13	ABE-DELISTED	Stock	13.9	13.9	13.82	13.82	10619.0
2014-05-13	ABEO	Stock	562.5	650.0	562.5	625.0	51.0
2014-05-13	ABEV	Stock	7.48	7.67	7.41	7.44	15588300.0
2014-05-13	ABG	Stock	64.5	65.38	63.43	63.44	370000.0
2014-05-13	ABGB-DELISTED	Stock	22.92	22.92	22.55	22.76	34625.0
2014-05-13	ABIL-DELISTED	Stock	9.74	9.78	9.65	9.65	11847.0
2014-05-13	ABM	Stock	27.44	27.53	27.15	27.17	203300.0
2014-05-13	ABMD-DELISTED	Stock	21.93	22.03	21.5	21.53	154644.0
2014-05-13	ABR	Stock	7.1	7.16	7.08	7.13	123300.0
2014-05-13	ABR.A-DELISTED	Stock	25.16	25.161	24.98	24.9999	6053.0
2014-05-13	ABR.B-DELISTED	Stock	23.76	23.77	23.625	23.7	4525.0
2014-05-13	ABR.C-DELISTED	Stock	24.86	24.8699	24.7	24.84	15587.0

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

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