PREVIEW / stock_daily / 2016-09-20

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-20.parquet
  size:    217 KB
  rows:    6,508
  symbols: 3,200

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-20	AAPL	Stock	28.2625	28.53	28.1275	28.3925	138057200.0
2016-09-20	MSFT	Stock	57.35	57.35	56.75	56.81	17384000.0
2016-09-20	NVDA	Stock	1.61	1.61	1.5685	1.5773	331112000.0
2016-09-20	AMZN	Stock	38.8	39.0685	38.8	39.011	38744000.0
2016-09-20	GOOGL	Stock	40.0	40.1375	39.913	39.989	21000820.0
2016-09-20	META	Stock	128.65	129.17	128.03	128.64	11083800.0
2016-09-20	TSLA	Stock	13.79	13.85	13.594	13.6427	36157500.0
2016-09-20	TLT	Stock	135.15	135.58	134.67	134.78	6054765.0
2016-09-20	ES	Stock	54.86	55.02	54.41	54.43	1633100.0
2016-09-20	CL	Stock	72.66	72.9	72.46	72.48	2438200.0
2016-09-20	A	Stock	45.33	45.95	45.15	45.71	2333000.0
2016-09-20	AA.B-DELISTED	Stock	31.1	31.516	30.92	31.45	63743.0
2016-09-20	AAAP-DELISTED	Stock	35.66	38.95	33.031	38.68	111049.0
2016-09-20	AABA-DELISTED	Stock	43.24	43.385	42.66	42.79	9192917.0
2016-09-20	AAC-DELISTED	Stock	17.85	18.1074	17.1	17.11	135483.0
2016-09-20	AACG	Stock	4.72	4.88	4.7	4.71	13700.0
2016-09-20	AAIC-DELISTED	Stock	15.13	15.13	14.94	14.95	159712.0
2016-09-20	AAL	Stock	35.75	35.86	35.13	35.15	6666500.0
2016-09-20	AAMC-DELISTED	Stock	4.35	4.4059	4.3088	4.3441	37182.0
2016-09-20	AAME	Stock	3.36	3.4	3.35	3.37	2400.0
2016-09-20	AAMI	Stock	13.27	13.53	13.21	13.5	189100.0
2016-09-20	AAOI	Stock	22.1	22.18	20.65	21.26	631300.0
2016-09-20	AAON	Stock	18.9333	19.1467	18.8733	18.94	256800.0
2016-09-20	AAP	Stock	149.05	149.26	145.28	145.89	1197100.0
2016-09-20	AAT	Stock	42.79	42.92	42.55	42.65	108900.0
2016-09-20	AAU-DELISTED	Stock	1.36	1.38	1.36	1.38	63650.0
2016-09-20	AAUAF-DELISTED	Stock	1.36	1.38	1.36	1.38	64272.0
2016-09-20	AAV-DELISTED	Stock	6.5	6.71	6.5	6.69	61974.0
2016-09-20	AAWW-DELISTED	Stock	38.54	38.76	38.06	38.33	193637.0
2016-09-20	AAXJ	Stock	60.05	60.1058	59.71	59.72	1337591.0
2016-09-20	AAXN-DELISTED	Stock	26.27	26.47	26.06	26.42	567943.0
2016-09-20	AB	Stock	22.72	22.89	22.5	22.59	223300.0
2016-09-20	ABAC-DELISTED	Stock	2.24	2.39	2.2	2.23	14684.0
2016-09-20	ABAX-DELISTED	Stock	51.14	52.15	50.95	51.48	139120.0
2016-09-20	ABB-DELISTED	Stock	22.31	22.31	22.12	22.14	1100698.0
2016-09-20	ABBNY-DELISTED	Stock	22.31	22.31	22.12	22.13	1306931.0
2016-09-20	ABBV	Stock	63.36	63.55	62.76	63.28	4826500.0
2016-09-20	ABC-DELISTED	Stock	83.65	83.68	82.07	82.09	2250563.0
2016-09-20	ABCB	Stock	35.4	35.56	35.03	35.1	203000.0
2016-09-20	ABCD-DELISTED	Stock	5.32	5.3567	5.3096	5.32	3807.0
2016-09-20	ABCO-DELISTED	Stock	43.25	43.29	42.86	42.98	133327.0
2016-09-20	ABDC-DELISTED	Stock	12.99	13.24	12.99	13.08	71788.0
2016-09-20	ABE-DELISTED	Stock	12.6	12.6	12.5	12.5899	1542.0
2016-09-20	ABEO	Stock	128.5	146.25	127.75	144.5	24984.0
2016-09-20	ABEOW-DELISTED	Stock	2.5	2.75	2.5	2.65	4480.0
2016-09-20	ABEV	Stock	5.97	5.99	5.92	5.95	8342900.0
2016-09-20	ABG	Stock	53.6	54.06	52.22	52.78	184900.0
2016-09-20	ABIL-DELISTED	Stock	3.82	3.95	3.82	3.8899	12970.0
2016-09-20	ABM	Stock	39.2	39.26	38.58	38.6	407000.0
2016-09-20	ABMD-DELISTED	Stock	126.07	126.45	124.89	125.12	199876.0

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

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