PREVIEW / stock_daily / 2014-08-01

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-01.parquet
  size:    220 KB
  rows:    6,609
  symbols: 3,559

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-08-01	AAPL	Stock	23.725	24.155	23.7025	24.0325	194044000.0
2014-08-01	MSFT	Stock	43.21	43.25	42.6	42.86	31170300.0
2014-08-01	NVDA	Stock	0.4375	0.4448	0.436	0.4422	219884000.0
2014-08-01	AMZN	Stock	15.6845	15.7915	15.2295	15.353	148830000.0
2014-08-01	GOOGL	Stock	28.9278	29.1715	28.515	28.68	44275800.0
2014-08-01	META	Stock	72.22	73.22	71.55	72.36	43535000.0
2014-08-01	TSLA	Stock	15.0727	15.8333	15.0667	15.5513	178437000.0
2014-08-01	TLT	Stock	113.58	114.87	113.19	114.56	14951150.0
2014-08-01	ES	Stock	43.82	44.85	43.42	43.79	2512000.0
2014-08-01	CL	Stock	63.06	64.67	62.89	63.95	5261900.0
2014-08-01	A	Stock	39.8927	40.3433	39.7496	40.1073	2238757.0
2014-08-01	AABA-DELISTED	Stock	35.65	36.08	35.31	35.62	13860217.0
2014-08-01	AACG	Stock	4.74	4.83	4.47	4.48	41700.0
2014-08-01	AAIC-DELISTED	Stock	26.08	26.2	26.0	26.2	305585.0
2014-08-01	AAL	Stock	38.75	39.53	38.43	39.43	8975900.0
2014-08-01	AAMC-DELISTED	Stock	179.4118	179.4118	147.0735	170.5882	85170.0
2014-08-01	AAME	Stock	4.09	4.09	3.92	4.08	15200.0
2014-08-01	AAOI	Stock	17.98	18.25	17.848	18.12	209000.0
2014-08-01	AAON	Stock	13.1133	13.28	12.8533	13.1	211500.0
2014-08-01	AAP	Stock	121.32	122.63	119.71	121.06	934500.0
2014-08-01	AAT	Stock	34.36	34.49	34.05	34.19	155900.0
2014-08-01	AAU-DELISTED	Stock	1.4	1.4322	1.37	1.3975	61162.0
2014-08-01	AAUAF-DELISTED	Stock	1.4	1.4297	1.37	1.3951	61600.0
2014-08-01	AAV-DELISTED	Stock	5.34	5.36	5.23	5.31	543749.0
2014-08-01	AAVL-DELISTED	Stock	26.95	27.15	25.0	25.17	455504.0
2014-08-01	AAWW-DELISTED	Stock	34.25	34.47	31.09	32.04	802276.0
2014-08-01	AAXJ	Stock	64.47	64.99	64.42	64.85	297648.0
2014-08-01	AAXN-DELISTED	Stock	12.01	12.0799	11.3701	11.52	1187941.0
2014-08-01	AB	Stock	26.38	26.46	25.57	25.86	310300.0
2014-08-01	ABAC-DELISTED	Stock	2.02	2.02	1.98	1.99	28600.0
2014-08-01	ABAX-DELISTED	Stock	47.53	47.85	46.72	47.06	214131.0
2014-08-01	ABB-DELISTED	Stock	22.89	23.0374	22.73	22.835	1283789.0
2014-08-01	ABBNY-DELISTED	Stock	22.89	23.0374	22.73	22.83	1340726.0
2014-08-01	ABBV	Stock	52.03	52.64	51.75	52.48	11593200.0
2014-08-01	ABC-DELISTED	Stock	76.96	77.83	76.73	77.33	1479067.0
2014-08-01	ABCB	Stock	21.92	22.08	21.48	21.64	111700.0
2014-08-01	ABCD-DELISTED	Stock	1.98	1.9899	1.93	1.93	1300.0
2014-08-01	ABCO-DELISTED	Stock	51.79	51.79	47.1	47.66	572998.0
2014-08-01	ABDC-DELISTED	Stock	13.0	13.08	10.6	12.89	120689.0
2014-08-01	ABE-DELISTED	Stock	14.2	14.48	14.2	14.3	8882.0
2014-08-01	ABEO	Stock	312.5	350.0	312.5	325.0	27.0
2014-08-01	ABEV	Stock	6.89	6.95	6.83	6.9	14012600.0
2014-08-01	ABG	Stock	67.66	68.56	67.66	68.05	256000.0
2014-08-01	ABGB-DELISTED	Stock	26.36	26.65	26.0	26.171	5830.0
2014-08-01	ABIL-DELISTED	Stock	9.81	9.81	9.81	9.81	100.0
2014-08-01	ABM	Stock	24.53	24.72	24.32	24.57	197300.0
2014-08-01	ABMD-DELISTED	Stock	25.59	25.87	25.34	25.69	222194.0
2014-08-01	ABR	Stock	7.11	7.11	7.0	7.02	102900.0
2014-08-01	ABR.A-DELISTED	Stock	25.08	25.08	24.82	24.9999	16000.0
2014-08-01	ABR.B-DELISTED	Stock	24.51	24.64	24.47	24.64	2446.0

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

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