PREVIEW / stock_daily / 2016-10-18

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-18.parquet
  size:    216 KB
  rows:    6,526
  symbols: 3,185

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-10-18	AAPL	Stock	29.545	29.5525	29.3625	29.3675	98214000.0
2016-10-18	MSFT	Stock	57.53	57.95	57.41	57.66	19149500.0
2016-10-18	NVDA	Stock	1.663	1.6748	1.6562	1.6652	269372000.0
2016-10-18	AMZN	Stock	41.1055	41.163	40.751	40.8825	50250000.0
2016-10-18	GOOGL	Stock	40.7105	41.4405	40.6665	41.0745	45785300.0
2016-10-18	META	Stock	128.68	129.39	128.01	128.57	13504000.0
2016-10-18	TSLA	Stock	13.066	13.298	12.884	13.2733	85207500.0
2016-10-18	TLT	Stock	131.86	132.89	131.83	132.86	7151001.0
2016-10-18	ES	Stock	54.05	54.3	53.36	54.13	1308800.0
2016-10-18	CL	Stock	72.64	72.64	71.93	71.93	2729900.0
2016-10-18	A	Stock	45.7	45.83	45.27	45.44	1949100.0
2016-10-18	AA.B-DELISTED	Stock	29.04	29.21	28.35	29.21	50926.0
2016-10-18	AAAP-DELISTED	Stock	38.5	39.16	38.5	39.0	97259.0
2016-10-18	AABA-DELISTED	Stock	42.04	42.605	41.63	41.66	12496471.0
2016-10-18	AAC-DELISTED	Stock	17.1	17.1	16.62	16.87	141010.0
2016-10-18	AACG	Stock	4.03	4.03	4.03	4.03	400.0
2016-10-18	AAIC-DELISTED	Stock	14.4	14.48	14.32	14.36	167369.0
2016-10-18	AAL	Stock	38.84	39.89	38.84	39.35	10538200.0
2016-10-18	AAMC-DELISTED	Stock	9.8235	12.3235	9.7941	11.1618	297871.0
2016-10-18	AAME	Stock	4.0	4.65	3.85	4.05	8600.0
2016-10-18	AAMI	Stock	14.16	14.19	14.0	14.03	122100.0
2016-10-18	AAOI	Stock	20.1	20.36	19.814	20.05	443600.0
2016-10-18	AAON	Stock	19.7333	19.9	19.4	19.4667	172650.0
2016-10-18	AAP	Stock	144.15	144.89	140.58	142.99	1504100.0
2016-10-18	AAT	Stock	41.08	41.08	40.74	40.9	139400.0
2016-10-18	AAU-DELISTED	Stock	1.21	1.26	1.21	1.25	210686.0
2016-10-18	AAUAF-DELISTED	Stock	1.21	1.26	1.21	1.25	211371.0
2016-10-18	AAV-DELISTED	Stock	7.77	7.8372	7.65	7.66	111548.0
2016-10-18	AAWW-DELISTED	Stock	41.55	42.05	41.2	42.0	113630.0
2016-10-18	AAXJ	Stock	60.01	60.05	59.79	59.92	386129.0
2016-10-18	AAXN-DELISTED	Stock	23.05	23.17	22.58	22.62	865407.0
2016-10-18	AB	Stock	22.0	22.1	21.8	21.8	116500.0
2016-10-18	ABAC-DELISTED	Stock	2.0	2.0684	2.0	2.0684	2920.0
2016-10-18	ABAX-DELISTED	Stock	52.95	54.23	52.24	52.6	97098.0
2016-10-18	ABB-DELISTED	Stock	22.4	22.5	22.32	22.46	1559564.0
2016-10-18	ABBNY-DELISTED	Stock	22.4	22.5	22.32	22.45	1597192.0
2016-10-18	ABBV	Stock	60.62	61.62	60.4	61.55	6655100.0
2016-10-18	ABC-DELISTED	Stock	80.46	81.24	80.165	81.07	1758741.0
2016-10-18	ABCB	Stock	36.25	36.25	35.6	35.75	155000.0
2016-10-18	ABCD-DELISTED	Stock	5.2	5.2317	5.08	5.11	20171.0
2016-10-18	ABCO-DELISTED	Stock	43.73	44.5	42.92	43.51	239887.0
2016-10-18	ABDC-DELISTED	Stock	12.86	12.93	12.51	12.63	23407.0
2016-10-18	ABE-DELISTED	Stock	12.4	12.5	12.31	12.5	24301.0
2016-10-18	ABEO	Stock	171.5	202.5	168.75	198.75	106116.0
2016-10-18	ABEOW-DELISTED	Stock	3.7999	4.3	3.7799	4.25	12265.0
2016-10-18	ABEV	Stock	6.14	6.19	6.11	6.12	12547400.0
2016-10-18	ABG	Stock	55.8	55.8	54.4	54.7	116100.0
2016-10-18	ABIL-DELISTED	Stock	3.62	3.67	3.61	3.6599	8666.0
2016-10-18	ABM	Stock	38.2	38.34	38.06	38.12	174000.0
2016-10-18	ABMD-DELISTED	Stock	128.97	131.39	127.99	129.0301	155969.0

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

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