PREVIEW / stock_daily / 2014-07-25

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-25.parquet
  size:    220 KB
  rows:    6,600
  symbols: 3,573

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-07-25	AAPL	Stock	24.2125	24.46	24.16	24.4175	173876000.0
2014-07-25	MSFT	Stock	44.3	44.66	44.3	44.5	26737700.0
2014-07-25	NVDA	Stock	0.4512	0.4522	0.444	0.4448	266132000.0
2014-07-25	AMZN	Stock	15.865	16.2435	15.738	16.2005	356930000.0
2014-07-25	GOOGL	Stock	29.9625	30.05	29.7875	29.904	27238220.0
2014-07-25	META	Stock	74.99	75.67	74.66	75.19	45917000.0
2014-07-25	TSLA	Stock	14.848	15.1313	14.7833	14.9047	46306500.0
2014-07-25	TLT	Stock	115.34	115.68	115.16	115.67	7043382.0
2014-07-25	ES	Stock	45.43	45.59	45.21	45.34	1323100.0
2014-07-25	CL	Stock	68.1	68.17	67.53	67.59	1594300.0
2014-07-25	A	Stock	40.4292	40.5866	40.3076	40.4363	2404001.0
2014-07-25	AABA-DELISTED	Stock	36.0	36.33	35.75	36.12	19117028.0
2014-07-25	AACG	Stock	4.88	4.98	4.84	4.84	33200.0
2014-07-25	AAIC-DELISTED	Stock	26.47	26.571	26.3	26.46	170363.0
2014-07-25	AAL	Stock	42.25	42.68	41.34	41.68	10986700.0
2014-07-25	AAMC-DELISTED	Stock	204.4118	205.8882	202.9412	205.4559	15684.0
2014-07-25	AAME	Stock	3.94	4.03	3.94	3.99	3200.0
2014-07-25	AAOI	Stock	21.06	21.06	19.53	20.42	409200.0
2014-07-25	AAON	Stock	13.6667	13.8667	13.3533	13.4667	232950.0
2014-07-25	AAP	Stock	126.13	126.91	124.96	125.55	353400.0
2014-07-25	AAT	Stock	35.3	35.59	35.24	35.45	233500.0
2014-07-25	AAU-DELISTED	Stock	1.33	1.37	1.33	1.36	137209.0
2014-07-25	AAUAF-DELISTED	Stock	1.33	1.37	1.33	1.36	137757.0
2014-07-25	AAV-DELISTED	Stock	5.49	5.52	5.41	5.47	297242.0
2014-07-25	AAWW-DELISTED	Stock	35.71	36.03	34.89	34.99	122093.0
2014-07-25	AAXJ	Stock	64.99	64.99	64.73	64.89	523430.0
2014-07-25	AAXN-DELISTED	Stock	11.35	11.75	11.3	11.5	835542.0
2014-07-25	AB	Stock	27.33	27.47	26.83	26.95	124300.0
2014-07-25	ABAC-DELISTED	Stock	2.01	2.01	1.85	2.0	32552.0
2014-07-25	ABAX-DELISTED	Stock	46.0	46.98	45.0	45.87	671004.0
2014-07-25	ABB-DELISTED	Stock	23.93	23.95	23.78	23.84	1202200.0
2014-07-25	ABBNY-DELISTED	Stock	23.93	23.95	23.78	23.84	1325353.0
2014-07-25	ABBV	Stock	54.4	54.49	53.03	53.18	11680900.0
2014-07-25	ABC-DELISTED	Stock	76.41	77.06	76.21	76.79	1808026.0
2014-07-25	ABCB	Stock	21.45	21.45	21.03	21.18	70100.0
2014-07-25	ABCD-DELISTED	Stock	1.98	1.98	1.8	1.88	19370.0
2014-07-25	ABCO-DELISTED	Stock	51.2	51.85	50.79	51.74	145264.0
2014-07-25	ABDC-DELISTED	Stock	13.6	13.99	13.6	13.78	54736.0
2014-07-25	ABE-DELISTED	Stock	14.67	14.78	14.67	14.77	5352.0
2014-07-25	ABEO	Stock	362.5	375.0	362.5	375.0	13.0
2014-07-25	ABEV	Stock	7.45	7.5	7.4	7.43	16706700.0
2014-07-25	ABG	Stock	71.48	71.79	70.36	70.66	324900.0
2014-07-25	ABGB-DELISTED	Stock	26.57	26.802	26.5	26.75	2637.0
2014-07-25	ABM	Stock	25.24	25.44	25.12	25.15	163100.0
2014-07-25	ABMD-DELISTED	Stock	25.96	26.31	25.86	26.3	238932.0
2014-07-25	ABR	Stock	7.25	7.25	7.18	7.19	51200.0
2014-07-25	ABR.A-DELISTED	Stock	25.1	25.1	24.98	25.03	4378.0
2014-07-25	ABR.B-DELISTED	Stock	24.67	24.67	24.5399	24.55	3406.0
2014-07-25	ABR.C-DELISTED	Stock	25.4	25.4	25.3801	25.3801	3250.0
2014-07-25	ABRN-DELISTED	Stock	25.3	25.3	25.1899	25.29	7000.0

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

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