PREVIEW / stock_daily / 2014-05-15

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-15.parquet
  size:    218 KB
  rows:    6,526
  symbols: 3,533

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-05-15	AAPL	Stock	21.2393	21.3071	21.0014	21.0293	230846000.0
2014-05-15	MSFT	Stock	40.09	40.4	39.51	39.6	37793200.0
2014-05-15	NVDA	Stock	0.4515	0.454	0.4455	0.45	325896000.0
2014-05-15	AMZN	Stock	14.901	14.96	14.519	14.7595	85902000.0
2014-05-15	GOOGL	Stock	26.657	26.7	26.2655	26.456	36660880.0
2014-05-15	META	Stock	59.26	59.38	57.52	57.92	56814000.0
2014-05-15	TSLA	Stock	12.6653	12.844	12.3533	12.5727	90606000.0
2014-05-15	TLT	Stock	113.78	114.41	113.6	113.86	12627912.0
2014-05-15	ES	Stock	45.68	45.89	45.38	45.47	998900.0
2014-05-15	CL	Stock	66.74	67.09	66.31	66.41	2440500.0
2014-05-15	A	Stock	39.0558	40.1645	38.4478	38.9771	8024800.0
2014-05-15	AABA-DELISTED	Stock	34.18	34.19	33.4	33.79	18000585.0
2014-05-15	AACG	Stock	4.25	4.53	4.25	4.3	15500.0
2014-05-15	AAIC-DELISTED	Stock	26.7	26.86	26.37	26.59	166323.0
2014-05-15	AAL	Stock	38.55	38.73	37.48	38.19	10673900.0
2014-05-15	AAMC-DELISTED	Stock	241.2265	242.0412	235.2941	236.7647	63260.0
2014-05-15	AAME	Stock	3.53	3.56	3.4	3.56	2300.0
2014-05-15	AAOI	Stock	17.43	18.48	17.34	18.15	303300.0
2014-05-15	AAON	Stock	13.2489	13.3822	12.92	13.28	260100.0
2014-05-15	AAP	Stock	127.78	128.45	120.13	124.23	2247200.0
2014-05-15	AAT	Stock	34.04	34.08	33.58	33.88	133500.0
2014-05-15	AAU-DELISTED	Stock	1.33	1.344	1.272	1.298	70070.0
2014-05-15	AAUAF-DELISTED	Stock	1.33	1.344	1.272	1.298	70851.0
2014-05-15	AAV-DELISTED	Stock	5.81	5.86	5.58	5.86	777863.0
2014-05-15	AAWW-DELISTED	Stock	36.34	36.6	35.27	36.48	272607.0
2014-05-15	AAXJ	Stock	61.04	61.05	60.63	60.83	538067.0
2014-05-15	AAXN-DELISTED	Stock	12.93	13.1254	12.6186	13.055	943955.0
2014-05-15	AB	Stock	23.9	23.9	22.71	22.99	423200.0
2014-05-15	ABAC-DELISTED	Stock	2.0902	2.137	2.05	2.052	17392.0
2014-05-15	ABAX-DELISTED	Stock	43.62	43.81	43.074	43.44	94600.0
2014-05-15	ABB-DELISTED	Stock	23.63	23.68	23.48	23.58	2437702.0
2014-05-15	ABBNY-DELISTED	Stock	23.63	23.68	23.48	23.57	2665599.0
2014-05-15	ABBV	Stock	52.96	53.07	52.42	52.69	6963800.0
2014-05-15	ABC-DELISTED	Stock	66.89	67.51	66.69	67.51	1738576.0
2014-05-15	ABCB	Stock	20.16	20.19	19.77	19.89	178600.0
2014-05-15	ABCD-DELISTED	Stock	2.33	2.37	2.279	2.36	82270.0
2014-05-15	ABCO-DELISTED	Stock	48.93	50.33	48.285	50.2	353329.0
2014-05-15	ABDC-DELISTED	Stock	15.1	15.1	14.76	14.92	47400.0
2014-05-15	ABE-DELISTED	Stock	13.88	13.8852	13.76	13.84	8957.0
2014-05-15	ABEO	Stock	612.5	612.5	550.0	600.0	72.0
2014-05-15	ABEV	Stock	7.46	7.48	7.33	7.38	4587700.0
2014-05-15	ABG	Stock	62.54	62.97	61.82	62.47	403600.0
2014-05-15	ABGB-DELISTED	Stock	22.0	22.0	20.8979	21.23	37203.0
2014-05-15	ABIL-DELISTED	Stock	9.65	9.65	9.64	9.64	614.0
2014-05-15	ABM	Stock	26.39	26.44	25.88	26.26	127100.0
2014-05-15	ABMD-DELISTED	Stock	21.4	21.405	20.51	21.22	332828.0
2014-05-15	ABR	Stock	7.07	7.13	7.02	7.02	66900.0
2014-05-15	ABR.A-DELISTED	Stock	25.049	25.049	24.95	25.0	1998.0
2014-05-15	ABR.B-DELISTED	Stock	23.73	23.78	23.65	23.78	3312.0
2014-05-15	ABR.C-DELISTED	Stock	24.84	24.84	24.8	24.82	6950.0

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

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