PREVIEW / stock_daily / 2014-09-18

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-18.parquet
  size:    222 KB
  rows:    6,635
  symbols: 3,586

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-18	AAPL	Stock	25.4825	25.5875	25.39	25.4475	149197600.0
2014-09-18	MSFT	Stock	46.59	46.83	46.46	46.68	35556600.0
2014-09-18	NVDA	Stock	0.4818	0.4865	0.4803	0.486	219604000.0
2014-09-18	AMZN	Stock	16.272	16.355	16.1855	16.25	51538000.0
2014-09-18	GOOGL	Stock	29.7525	29.878	29.651	29.8635	29889340.0
2014-09-18	META	Stock	76.77	77.33	76.52	77.0	23031000.0
2014-09-18	TSLA	Stock	17.5573	17.7067	17.488	17.588	55389000.0
2014-09-18	TLT	Stock	113.18	113.48	112.85	113.16	7031549.0
2014-09-18	ES	Stock	45.64	45.8	45.22	45.26	2031300.0
2014-09-18	CL	Stock	65.28	65.45	65.04	65.31	3443400.0
2014-09-18	A	Stock	42.3462	42.4893	41.7096	41.774	4008066.0
2014-09-18	AABA-DELISTED	Stock	43.08	43.32	41.42	42.0899	90193269.0
2014-09-18	AACG	Stock	4.5	4.51	4.4	4.48	8000.0
2014-09-18	AAIC-DELISTED	Stock	27.4	27.48	27.26	27.34	447456.0
2014-09-18	AAL	Stock	37.7	38.11	37.6	38.05	4553800.0
2014-09-18	AAMC-DELISTED	Stock	204.3382	207.4838	204.3382	206.7647	26425.0
2014-09-18	AAME	Stock	4.02	4.02	3.89	3.9	3700.0
2014-09-18	AAOI	Stock	18.18	18.56	18.1	18.51	153400.0
2014-09-18	AAON	Stock	12.3133	12.4733	12.2867	12.4333	168900.0
2014-09-18	AAP	Stock	134.43	134.5	133.31	133.62	511600.0
2014-09-18	AAT	Stock	33.62	33.94	33.27	33.35	176000.0
2014-09-18	AAU-DELISTED	Stock	1.59	1.59	1.48	1.48	178372.0
2014-09-18	AAUAF-DELISTED	Stock	1.57	1.57	1.46	1.48	183489.0
2014-09-18	AAV-DELISTED	Stock	5.52	5.56	5.34	5.45	675910.0
2014-09-18	AAVL-DELISTED	Stock	33.06	34.14	31.25	31.55	144621.0
2014-09-18	AAWW-DELISTED	Stock	36.01	36.34	35.77	36.04	141438.0
2014-09-18	AAXJ	Stock	64.15	64.21	63.98	64.13	600900.0
2014-09-18	AAXN-DELISTED	Stock	17.24	17.3	16.35	16.91	3081997.0
2014-09-18	AB	Stock	27.47	27.76	27.36	27.62	148700.0
2014-09-18	ABAC-DELISTED	Stock	1.95	1.95	1.85	1.93	55398.0
2014-09-18	ABAX-DELISTED	Stock	52.62	53.16	52.3033	53.145	83377.0
2014-09-18	ABB-DELISTED	Stock	23.01	23.14	22.99	23.08	1007056.0
2014-09-18	ABBNY-DELISTED	Stock	23.01	23.14	22.99	23.08	1132102.0
2014-09-18	ABBV	Stock	59.6	59.65	59.1	59.45	10980500.0
2014-09-18	ABC-DELISTED	Stock	76.81	77.23	76.7	77.14	978798.0
2014-09-18	ABCB	Stock	22.92	23.0	22.75	22.89	26300.0
2014-09-18	ABCD-DELISTED	Stock	1.49	1.49	1.455	1.455	25364.0
2014-09-18	ABCO-DELISTED	Stock	48.43	48.7	48.05	48.47	245495.0
2014-09-18	ABDC-DELISTED	Stock	13.48	13.876	13.48	13.8	39490.0
2014-09-18	ABE-DELISTED	Stock	14.349	14.42	14.349	14.4124	2251.0
2014-09-18	ABEO	Stock	337.5	337.5	300.0	325.0	95.0
2014-09-18	ABEV	Stock	6.71	6.93	6.71	6.82	27444100.0
2014-09-18	ABG	Stock	66.68	67.4	66.37	66.47	197800.0
2014-09-18	ABGB-DELISTED	Stock	28.38	28.38	26.03	27.81	10006.0
2014-09-18	ABM	Stock	27.66	27.71	27.39	27.63	229900.0
2014-09-18	ABMD-DELISTED	Stock	25.24	25.46	25.11	25.44	121163.0
2014-09-18	ABR	Stock	6.75	6.75	6.6	6.67	132500.0
2014-09-18	ABR.A-DELISTED	Stock	24.7399	24.7399	24.54	24.54	4050.0
2014-09-18	ABR.B-DELISTED	Stock	24.13	24.13	24.12	24.12	1043.0
2014-09-18	ABR.C-DELISTED	Stock	25.12	25.12	25.0401	25.12	2550.0

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

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