PREVIEW / stock_daily / 2016-09-13

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-13.parquet
  size:    219 KB
  rows:    6,557
  symbols: 3,230

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
2016-09-13	AAPL	Stock	26.8775	27.1975	26.81	26.9875	248704800.0
2016-09-13	MSFT	Stock	56.5	56.65	56.05	56.53	30130200.0
2016-09-13	NVDA	Stock	1.515	1.5325	1.4882	1.4968	471768000.0
2016-09-13	AMZN	Stock	38.4385	38.4945	37.9525	38.0505	62344000.0
2016-09-13	GOOGL	Stock	39.7005	39.7895	39.2165	39.436	36180880.0
2016-09-13	META	Stock	128.03	128.35	126.66	127.21	18016200.0
2016-09-13	TSLA	Stock	13.1373	13.2327	12.8967	13.07	53841000.0
2016-09-13	TLT	Stock	135.87	136.0	133.36	134.05	15645423.0
2016-09-13	ES	Stock	54.24	54.27	53.38	53.61	2782200.0
2016-09-13	CL	Stock	72.32	72.32	71.71	71.84	4278300.0
2016-09-13	A	Stock	45.36	45.42	44.61	44.9	3461800.0
2016-09-13	AA.B-DELISTED	Stock	32.33	32.33	31.32	31.56	46811.0
2016-09-13	AAAP-DELISTED	Stock	34.76	34.76	34.0	34.0	50480.0
2016-09-13	AABA-DELISTED	Stock	43.18	43.52	42.69	43.05	8863743.0
2016-09-13	AAC-DELISTED	Stock	18.65	18.65	17.92	18.23	150556.0
2016-09-13	AACG	Stock	4.88	4.88	4.52	4.52	600.0
2016-09-13	AAIC-DELISTED	Stock	14.75	14.89	14.63	14.72	158641.0
2016-09-13	AAL	Stock	38.12	38.31	37.22	37.37	9330300.0
2016-09-13	AAMC-DELISTED	Stock	4.0529	4.1912	4.0324	4.0324	25391.0
2016-09-13	AAME	Stock	3.38	3.5	3.35	3.49	2400.0
2016-09-13	AAMI	Stock	13.17	13.2	12.8	12.85	97900.0
2016-09-13	AAOI	Stock	20.07	20.46	19.67	20.3	394800.0
2016-09-13	AAON	Stock	18.2	18.3	18.08	18.16	198000.0
2016-09-13	AAP	Stock	152.93	154.01	150.66	151.18	1177000.0
2016-09-13	AAT	Stock	43.17	44.0	42.1	42.12	263300.0
2016-09-13	AAU-DELISTED	Stock	1.42	1.5	1.34	1.36	273072.0
2016-09-13	AAUAF-DELISTED	Stock	1.42	1.5	1.34	1.38	278949.0
2016-09-13	AAV-DELISTED	Stock	6.84	6.85	6.66	6.67	64870.0
2016-09-13	AAWW-DELISTED	Stock	38.43	38.6205	37.71	37.88	188037.0
2016-09-13	AAXJ	Stock	58.76	58.9	58.04	58.32	1685997.0
2016-09-13	AAXN-DELISTED	Stock	25.26	25.6	24.92	25.01	727899.0
2016-09-13	AB	Stock	21.71	22.15	21.55	21.93	239700.0
2016-09-13	ABAC-DELISTED	Stock	1.86	1.86	1.71	1.8	22033.0
2016-09-13	ABAX-DELISTED	Stock	47.97	48.02	46.87	47.61	68381.0
2016-09-13	ABB-DELISTED	Stock	22.41	22.48	22.12	22.24	2766789.0
2016-09-13	ABBNY-DELISTED	Stock	22.41	22.48	22.12	22.24	2838682.0
2016-09-13	ABBV	Stock	63.66	64.15	63.01	63.34	7640400.0
2016-09-13	ABC-DELISTED	Stock	85.8034	86.55	84.59	84.87	2419416.0
2016-09-13	ABCB	Stock	35.37	35.6	35.07	35.46	136900.0
2016-09-13	ABCD-DELISTED	Stock	5.31	5.34	5.18	5.25	38601.0
2016-09-13	ABCO-DELISTED	Stock	43.2	44.34	42.5	43.2	177533.0
2016-09-13	ABDC-DELISTED	Stock	12.75	12.795	12.72	12.77	22363.0
2016-09-13	ABE-DELISTED	Stock	12.47	12.47	12.29	12.29	4046.0
2016-09-13	ABEO	Stock	126.0	126.25	121.0	123.0	4596.0
2016-09-13	ABEOW-DELISTED	Stock	2.57	2.57	2.13	2.13	600.0
2016-09-13	ABEV	Stock	5.95	5.99	5.78	5.82	30608700.0
2016-09-13	ABG	Stock	54.38	55.56	53.96	55.02	305100.0
2016-09-13	ABIL-DELISTED	Stock	3.87	3.87	3.7952	3.7952	13773.0
2016-09-13	ABM	Stock	38.15	38.86	38.15	38.77	323700.0
2016-09-13	ABMD-DELISTED	Stock	118.8	119.14	116.79	117.38	237926.0

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

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