PREVIEW / stock_daily / 2014-07-24

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-24.parquet
  size:    221 KB
  rows:    6,589
  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-07-24	AAPL	Stock	24.26	24.33	24.105	24.2575	182916000.0
2014-07-24	MSFT	Stock	44.93	45.0	44.32	44.4	30725300.0
2014-07-24	NVDA	Stock	0.4545	0.4558	0.4495	0.4528	254576000.0
2014-07-24	AMZN	Stock	17.999	18.2425	17.926	17.9305	141774000.0
2014-07-24	GOOGL	Stock	30.2765	30.4455	30.05	30.1505	27119480.0
2014-07-24	META	Stock	75.96	76.74	74.51	74.98	124168000.0
2014-07-24	TSLA	Stock	14.8833	15.0067	14.72	14.9027	48682500.0
2014-07-24	TLT	Stock	114.52	114.58	114.25	114.32	6608996.0
2014-07-24	ES	Stock	45.38	45.55	45.19	45.49	657800.0
2014-07-24	CL	Stock	68.33	68.34	67.99	68.11	1917300.0
2014-07-24	A	Stock	41.2017	41.3019	40.5651	40.6581	3543091.0
2014-07-24	AABA-DELISTED	Stock	35.08	36.55	35.04	36.16	43534334.0
2014-07-24	AACG	Stock	4.6	5.22	4.6	4.9	240100.0
2014-07-24	AAIC-DELISTED	Stock	26.79	26.8	26.5	26.5	268419.0
2014-07-24	AAL	Stock	42.5	43.95	41.7	42.16	18015200.0
2014-07-24	AAMC-DELISTED	Stock	201.7824	210.6824	197.4527	210.6735	27989.0
2014-07-24	AAME	Stock	3.93	4.07	3.93	4.04	10400.0
2014-07-24	AAOI	Stock	21.52	21.95	21.18	21.3	140700.0
2014-07-24	AAON	Stock	14.1533	14.2267	13.7533	13.7867	139500.0
2014-07-24	AAP	Stock	124.9	127.73	124.2	126.63	1366200.0
2014-07-24	AAT	Stock	35.71	35.71	35.45	35.53	135200.0
2014-07-24	AAU-DELISTED	Stock	1.42	1.42	1.27	1.291	433243.0
2014-07-24	AAUAF-DELISTED	Stock	1.42	1.42	1.27	1.31	434603.0
2014-07-24	AAV-DELISTED	Stock	5.59	5.66	5.49	5.5	262068.0
2014-07-24	AAWW-DELISTED	Stock	36.06	36.07	35.65	35.82	284723.0
2014-07-24	AAXJ	Stock	65.11	65.23	65.01	65.14	565715.0
2014-07-24	AAXN-DELISTED	Stock	11.24	11.6	11.24	11.445	707110.0
2014-07-24	AB	Stock	27.51	28.0	27.4	27.49	198600.0
2014-07-24	ABAC-DELISTED	Stock	2.0	2.0	1.96	2.0	15107.0
2014-07-24	ABAX-DELISTED	Stock	42.15	43.34	41.763	42.08	246983.0
2014-07-24	ABB-DELISTED	Stock	24.13	24.15	23.96	24.01	2143670.0
2014-07-24	ABBNY-DELISTED	Stock	24.13	24.15	23.96	24.01	2228999.0
2014-07-24	ABBV	Stock	54.22	54.56	53.97	54.08	11712800.0
2014-07-24	ABC-DELISTED	Stock	77.05	79.13	75.62	76.37	4233902.0
2014-07-24	ABCB	Stock	21.29	21.53	21.02	21.06	48400.0
2014-07-24	ABCD-DELISTED	Stock	1.93	2.0	1.85	1.9	9480.0
2014-07-24	ABCO-DELISTED	Stock	50.34	51.92	50.34	51.75	292033.0
2014-07-24	ABDC-DELISTED	Stock	13.91	13.91	13.6101	13.79	36692.0
2014-07-24	ABE-DELISTED	Stock	14.76	14.85	14.75	14.78	17450.0
2014-07-24	ABEO	Stock	375.0	375.0	350.0	375.0	86.0
2014-07-24	ABEV	Stock	7.45	7.52	7.4	7.51	10438400.0
2014-07-24	ABG	Stock	70.69	72.11	70.2	71.86	560000.0
2014-07-24	ABGB-DELISTED	Stock	26.12	26.12	25.8	25.92	10845.0
2014-07-24	ABM	Stock	25.63	25.81	25.38	25.48	129700.0
2014-07-24	ABMD-DELISTED	Stock	25.8	26.3099	25.59	26.27	209514.0
2014-07-24	ABR	Stock	7.25	7.25	7.22	7.24	94200.0
2014-07-24	ABR.A-DELISTED	Stock	25.03	25.03	24.9	25.02	6283.0
2014-07-24	ABR.B-DELISTED	Stock	24.43	24.68	24.43	24.68	1100.0
2014-07-24	ABR.C-DELISTED	Stock	25.4	25.4	25.39	25.39	1910.0
2014-07-24	ABRN-DELISTED	Stock	25.2	25.25	25.1799	25.211	5090.0

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

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