PREVIEW / stock_daily / 2014-08-26

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-26.parquet
  size:    222 KB
  rows:    6,646
  symbols: 3,592

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-26	AAPL	Stock	25.355	25.375	25.215	25.2225	132608000.0
2014-08-26	MSFT	Stock	45.31	45.4	44.94	45.01	14873100.0
2014-08-26	NVDA	Stock	0.479	0.4872	0.4772	0.4862	269636000.0
2014-08-26	AMZN	Stock	16.85	17.218	16.7275	17.0915	73094000.0
2014-08-26	GOOGL	Stock	29.6	29.6025	29.3725	29.406	29439060.0
2014-08-26	META	Stock	75.0	75.99	74.73	75.96	23993000.0
2014-08-26	TSLA	Stock	17.6653	17.7	17.444	17.4493	57270000.0
2014-08-26	TLT	Stock	117.94	117.99	117.21	117.35	5487657.0
2014-08-26	ES	Stock	45.38	45.64	44.91	44.95	1133400.0
2014-08-26	CL	Stock	64.9	65.11	64.71	64.79	2390400.0
2014-08-26	A	Stock	41.309	41.4163	41.1588	41.3805	1237649.0
2014-08-26	AABA-DELISTED	Stock	37.76	37.9	37.56	37.795	8461815.0
2014-08-26	AACG	Stock	4.67	4.73	4.5	4.58	20200.0
2014-08-26	AAIC-DELISTED	Stock	28.0	28.26	27.99	28.22	267302.0
2014-08-26	AAL	Stock	39.55	39.75	39.07	39.09	5732600.0
2014-08-26	AAMC-DELISTED	Stock	198.5294	207.5	198.5294	206.1765	72831.0
2014-08-26	AAME	Stock	4.13	4.15	4.12	4.12	3200.0
2014-08-26	AAOI	Stock	19.5	19.6	19.34	19.58	106700.0
2014-08-26	AAON	Stock	12.4267	12.4933	12.26	12.4467	200400.0
2014-08-26	AAP	Stock	136.13	136.68	135.72	136.06	441300.0
2014-08-26	AAT	Stock	34.82	35.05	34.7	34.88	126800.0
2014-08-26	AAU-DELISTED	Stock	1.44	1.45	1.405	1.4249	58083.0
2014-08-26	AAUAF-DELISTED	Stock	1.43	1.44	1.4	1.43	58893.0
2014-08-26	AAV-DELISTED	Stock	5.98	6.33	5.98	6.23	418949.0
2014-08-26	AAVL-DELISTED	Stock	29.98	30.9	28.18	29.25	118602.0
2014-08-26	AAWW-DELISTED	Stock	33.65	33.77	33.14	33.51	173748.0
2014-08-26	AAXJ	Stock	65.98	66.16	65.93	66.12	443909.0
2014-08-26	AAXN-DELISTED	Stock	15.99	16.0	15.47	15.67	1784842.0
2014-08-26	AB	Stock	27.24	27.55	27.02	27.42	189100.0
2014-08-26	ABAC-DELISTED	Stock	1.97	2.01	1.95	1.95	13534.0
2014-08-26	ABAX-DELISTED	Stock	45.96	47.5	45.35	47.35	126546.0
2014-08-26	ABB-DELISTED	Stock	22.93	23.01	22.91	22.96	1234143.0
2014-08-26	ABBNY-DELISTED	Stock	22.93	23.01	22.91	22.97	1271354.0
2014-08-26	ABBV	Stock	55.68	55.94	55.64	55.75	9309800.0
2014-08-26	ABC-DELISTED	Stock	76.85	76.91	76.35	76.71	514632.0
2014-08-26	ABCB	Stock	24.0	24.19	23.56	23.83	163200.0
2014-08-26	ABCD-DELISTED	Stock	1.66	1.68	1.65	1.65	26984.0
2014-08-26	ABCO-DELISTED	Stock	49.1	50.15	49.01	50.12	287324.0
2014-08-26	ABDC-DELISTED	Stock	13.37	13.7	13.3	13.599	40838.0
2014-08-26	ABE-DELISTED	Stock	14.6704	14.7	14.624	14.624	10048.0
2014-08-26	ABEO	Stock	437.5	437.5	375.0	387.5	19.0
2014-08-26	ABEV	Stock	7.3	7.31	7.18	7.24	6765900.0
2014-08-26	ABG	Stock	69.03	69.94	68.96	69.75	138300.0
2014-08-26	ABGB-DELISTED	Stock	27.93	29.0	27.93	28.72	8647.0
2014-08-26	ABM	Stock	26.25	26.5	26.14	26.5	162700.0
2014-08-26	ABMD-DELISTED	Stock	25.15	25.88	25.02	25.77	217238.0
2014-08-26	ABR	Stock	7.01	7.02	6.95	6.96	172000.0
2014-08-26	ABR.A-DELISTED	Stock	24.76	24.8	24.71	24.798	9200.0
2014-08-26	ABR.B-DELISTED	Stock	24.18	24.2	24.12	24.2	2110.0
2014-08-26	ABR.C-DELISTED	Stock	25.13	25.14	25.1299	25.1387	8150.0

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

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