PREVIEW / stock_daily / 2016-10-20

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-20.parquet
  size:    214 KB
  rows:    6,466
  symbols: 3,152

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-20	AAPL	Stock	29.215	29.345	29.0825	29.265	96503200.0
2016-10-20	MSFT	Stock	57.5	57.52	56.66	57.25	49455600.0
2016-10-20	NVDA	Stock	1.6812	1.6988	1.6575	1.6932	312084000.0
2016-10-20	AMZN	Stock	40.6995	40.7855	40.155	40.516	63040000.0
2016-10-20	GOOGL	Stock	41.378	41.4233	41.0275	41.0815	27877400.0
2016-10-20	META	Stock	130.07	130.66	129.5	130.0	13167500.0
2016-10-20	TSLA	Stock	13.4747	13.5333	13.1367	13.2733	76093500.0
2016-10-20	TLT	Stock	133.64	133.7526	132.9	133.11	6082274.0
2016-10-20	ES	Stock	54.16	54.59	53.91	54.12	1070000.0
2016-10-20	CL	Stock	71.32	71.62	70.86	70.92	3317200.0
2016-10-20	A	Stock	46.0	46.22	45.65	46.05	1493600.0
2016-10-20	AA	Stock	21.603	21.7712	21.3226	21.3787	9917978.0
2016-10-20	AA.B-DELISTED	Stock	29.58	29.82	29.28	29.43	43400.0
2016-10-20	AAAP-DELISTED	Stock	38.11	38.36	37.6	38.2	28841.0
2016-10-20	AABA-DELISTED	Stock	42.69	42.69	42.07	42.38	10623217.0
2016-10-20	AAC-DELISTED	Stock	16.75	17.26	16.7	17.24	86841.0
2016-10-20	AACG	Stock	3.74	3.99	3.73	3.99	800.0
2016-10-20	AAIC-DELISTED	Stock	14.45	14.59	14.425	14.52	99549.0
2016-10-20	AAL	Stock	40.93	40.93	39.41	40.59	14695900.0
2016-10-20	AAMC-DELISTED	Stock	9.9853	10.8235	9.9853	10.7794	60129.0
2016-10-20	AAME	Stock	4.15	4.15	4.0	4.0	3000.0
2016-10-20	AAMI	Stock	14.19	14.36	14.12	14.23	91500.0
2016-10-20	AAOI	Stock	20.13	21.03	20.13	20.75	194500.0
2016-10-20	AAON	Stock	19.0333	19.4333	19.0	19.2667	120750.0
2016-10-20	AAP	Stock	142.09	142.73	140.87	141.3	923700.0
2016-10-20	AAT	Stock	40.58	40.9	40.17	40.4	194100.0
2016-10-20	AAU-DELISTED	Stock	1.28	1.28	1.25	1.27	106774.0
2016-10-20	AAUAF-DELISTED	Stock	1.28	1.28	1.25	1.27	107568.0
2016-10-20	AAV-DELISTED	Stock	7.64	7.73	7.49	7.583	55666.0
2016-10-20	AAWW-DELISTED	Stock	42.6	43.0	42.3	42.6	55529.0
2016-10-20	AAXJ	Stock	59.94	60.18	59.79	59.93	478008.0
2016-10-20	AAXN-DELISTED	Stock	23.25	23.29	23.08	23.11	438463.0
2016-10-20	AB	Stock	21.85	22.1	21.8	22.0	173900.0
2016-10-20	ABAC-DELISTED	Stock	2.2655	2.35	2.2534	2.2601	6579.0
2016-10-20	ABAX-DELISTED	Stock	52.43	52.81	51.8075	52.75	33540.0
2016-10-20	ABB-DELISTED	Stock	22.33	22.449	22.285	22.38	1268974.0
2016-10-20	ABBNY-DELISTED	Stock	22.33	22.449	22.285	22.37	1402920.0
2016-10-20	ABBV	Stock	61.45	61.98	61.33	61.76	4391300.0
2016-10-20	ABC-DELISTED	Stock	80.28	81.765	80.23	80.74	2063620.0
2016-10-20	ABCB	Stock	35.7	35.95	35.35	35.55	151300.0
2016-10-20	ABCD-DELISTED	Stock	5.16	5.24	5.1352	5.18	10140.0
2016-10-20	ABCO-DELISTED	Stock	43.01	43.32	42.5	43.13	241944.0
2016-10-20	ABDC-DELISTED	Stock	12.89	12.99	12.83	12.9399	15069.0
2016-10-20	ABEO	Stock	194.25	236.0	194.0	217.5	141964.0
2016-10-20	ABEOW-DELISTED	Stock	4.3	5.4	4.25	5.0	31605.0
2016-10-20	ABEV	Stock	6.17	6.25	6.16	6.23	6904700.0
2016-10-20	ABG	Stock	54.65	54.95	52.25	53.2	259400.0
2016-10-20	ABIL-DELISTED	Stock	3.5063	3.6499	3.5063	3.6499	1500.0
2016-10-20	ABM	Stock	37.83	38.12	37.67	38.01	143900.0
2016-10-20	ABMD-DELISTED	Stock	126.5	127.58	123.3544	125.28	533096.0

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

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