PREVIEW / stock_daily / 2014-08-05

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-05.parquet
  size:    221 KB
  rows:    6,627
  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-05	AAPL	Stock	23.84	23.92	23.59	23.78	223732000.0
2014-08-05	MSFT	Stock	43.31	43.46	42.83	43.08	26266400.0
2014-08-05	NVDA	Stock	0.44	0.448	0.4362	0.4415	298136000.0
2014-08-05	AMZN	Stock	15.665	15.7275	15.503	15.616	57042000.0
2014-08-05	GOOGL	Stock	28.969	29.01	28.5155	28.657	33026840.0
2014-08-05	META	Stock	73.2	73.59	72.18	72.69	34986000.0
2014-08-05	TSLA	Stock	15.8313	16.1993	15.7127	15.8993	80829000.0
2014-08-05	TLT	Stock	114.07	114.8	113.68	114.63	8037302.0
2014-08-05	ES	Stock	43.09	43.35	42.51	42.64	2168500.0
2014-08-05	CL	Stock	63.5	64.07	63.48	63.77	4336500.0
2014-08-05	A	Stock	39.9857	40.1359	39.4134	39.5136	2422594.0
2014-08-05	AABA-DELISTED	Stock	36.32	36.42	35.615	35.7	15359544.0
2014-08-05	AACG	Stock	4.73	4.75	4.6	4.75	1500.0
2014-08-05	AAIC-DELISTED	Stock	26.35	26.56	26.25	26.42	138909.0
2014-08-05	AAL	Stock	37.89	38.45	36.74	37.18	10423000.0
2014-08-05	AAMC-DELISTED	Stock	155.0	168.5235	155.0	168.5235	71322.0
2014-08-05	AAME	Stock	4.04	4.38	4.0	4.31	13100.0
2014-08-05	AAOI	Stock	19.16	19.41	18.85	19.16	127400.0
2014-08-05	AAON	Stock	13.26	13.5133	13.1133	13.2533	279000.0
2014-08-05	AAP	Stock	123.58	125.55	122.85	124.41	775400.0
2014-08-05	AAT	Stock	34.21	34.77	34.07	34.09	255100.0
2014-08-05	AAU-DELISTED	Stock	1.3838	1.4	1.3562	1.376	46572.0
2014-08-05	AAUAF-DELISTED	Stock	1.3775	1.39	1.3501	1.38	47878.0
2014-08-05	AAV-DELISTED	Stock	5.32	5.36	5.21	5.3	451584.0
2014-08-05	AAVL-DELISTED	Stock	24.13	24.14	22.0	22.45	134336.0
2014-08-05	AAWW-DELISTED	Stock	32.02	32.55	31.6	32.0	367976.0
2014-08-05	AAXJ	Stock	64.74	64.76	64.3	64.36	660229.0
2014-08-05	AAXN-DELISTED	Stock	11.49	11.9	11.44	11.64	957797.0
2014-08-05	AB	Stock	26.47	26.69	25.78	25.99	336900.0
2014-08-05	ABAC-DELISTED	Stock	1.93	1.9999	1.791	1.83	48715.0
2014-08-05	ABAX-DELISTED	Stock	47.08	47.68	46.45	46.64	98060.0
2014-08-05	ABB-DELISTED	Stock	22.66	22.72	22.425	22.54	1493067.0
2014-08-05	ABBNY-DELISTED	Stock	22.66	22.72	22.425	22.54	1631940.0
2014-08-05	ABBV	Stock	52.77	53.19	52.45	52.79	12783800.0
2014-08-05	ABC-DELISTED	Stock	77.27	77.78	76.84	77.05	1500931.0
2014-08-05	ABCB	Stock	21.47	21.88	21.47	21.71	58300.0
2014-08-05	ABCD-DELISTED	Stock	1.91	1.95	1.85	1.92	22351.0
2014-08-05	ABCO-DELISTED	Stock	46.61	48.02	46.42	47.81	351600.0
2014-08-05	ABDC-DELISTED	Stock	12.7	13.1	12.7	12.98	62258.0
2014-08-05	ABE-DELISTED	Stock	14.3	14.47	14.11	14.34	28400.0
2014-08-05	ABEO	Stock	325.0	337.5	300.0	337.5	44.0
2014-08-05	ABEV	Stock	6.81	6.86	6.64	6.67	29060600.0
2014-08-05	ABG	Stock	68.37	69.37	67.85	68.39	124800.0
2014-08-05	ABGB-DELISTED	Stock	26.5	26.5	25.3401	25.433	10007.0
2014-08-05	ABIL-DELISTED	Stock	9.76	9.76	9.76	9.76	200.0
2014-08-05	ABM	Stock	24.64	25.14	24.64	24.85	165100.0
2014-08-05	ABMD-DELISTED	Stock	25.26	25.52	25.07	25.41	187228.0
2014-08-05	ABR	Stock	6.95	7.01	6.92	6.99	116800.0
2014-08-05	ABR.A-DELISTED	Stock	24.9358	25.01	24.9358	25.01	1797.0
2014-08-05	ABR.B-DELISTED	Stock	24.69	24.7	24.47	24.47	8770.0

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

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