PREVIEW / stock_daily / 2016-10-21

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-21.parquet
  size:    215 KB
  rows:    6,480
  symbols: 3,170

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-21	AAPL	Stock	29.2025	29.2275	29.07	29.15	92770800.0
2016-10-21	MSFT	Stock	60.28	60.45	59.49	59.66	80032200.0
2016-10-21	NVDA	Stock	1.6872	1.6915	1.6725	1.6885	279508000.0
2016-10-21	AMZN	Stock	40.468	40.971	40.45	40.9495	55860000.0
2016-10-21	GOOGL	Stock	41.0	41.2145	40.9155	41.203	32316280.0
2016-10-21	META	Stock	129.78	132.13	129.7	132.07	19088800.0
2016-10-21	TSLA	Stock	13.24	13.438	13.1607	13.3393	44151000.0
2016-10-21	TLT	Stock	133.52	133.72	132.87	133.31	9222747.0
2016-10-21	ES	Stock	53.74	54.26	53.74	54.0	1826600.0
2016-10-21	CL	Stock	70.94	71.15	70.61	70.92	3633100.0
2016-10-21	A	Stock	45.67	45.67	45.29	45.57	1011300.0
2016-10-21	AA	Stock	21.2826	21.6751	21.0903	21.5309	7769288.0
2016-10-21	AA.B-DELISTED	Stock	29.56	29.7	29.03	29.38	93957.0
2016-10-21	AAAP-DELISTED	Stock	38.56	38.56	37.7	38.3	48492.0
2016-10-21	AABA-DELISTED	Stock	42.1	42.2	41.73	42.175	6793320.0
2016-10-21	AAC-DELISTED	Stock	17.07	17.25	16.81	16.86	132233.0
2016-10-21	AACG	Stock	3.73	3.76	3.73	3.74	700.0
2016-10-21	AAIC-DELISTED	Stock	14.49	14.72	14.46	14.7	236370.0
2016-10-21	AAL	Stock	39.97	40.24	39.65	39.9	9981500.0
2016-10-21	AAMC-DELISTED	Stock	10.7206	11.6029	10.5735	11.3382	75579.0
2016-10-21	AAME	Stock	4.1	4.1	3.86	3.86	1400.0
2016-10-21	AAMI	Stock	14.1	14.42	14.1	14.41	69300.0
2016-10-21	AAOI	Stock	20.63	20.71	20.22	20.565	181100.0
2016-10-21	AAON	Stock	19.0667	19.7333	19.0667	19.7	168600.0
2016-10-21	AAP	Stock	140.68	142.2	139.76	141.93	502200.0
2016-10-21	AAT	Stock	40.0	40.43	39.8	40.17	225400.0
2016-10-21	AAU-DELISTED	Stock	1.28	1.28	1.23	1.24	101771.0
2016-10-21	AAUAF-DELISTED	Stock	1.28	1.28	1.23	1.25	102609.0
2016-10-21	AAV-DELISTED	Stock	7.52	7.57	7.42	7.5	51641.0
2016-10-21	AAWW-DELISTED	Stock	42.15	42.75	41.7	42.5	58162.0
2016-10-21	AAXJ	Stock	59.6	59.93	59.56	59.86	192139.0
2016-10-21	AAXN-DELISTED	Stock	23.0	23.2	22.86	23.2	371072.0
2016-10-21	AB	Stock	21.9	22.4	21.9	21.95	159300.0
2016-10-21	ABAC-DELISTED	Stock	2.3011	2.3011	2.27	2.2902	8004.0
2016-10-21	ABAX-DELISTED	Stock	52.27	52.92	50.275	52.5	68394.0
2016-10-21	ABB-DELISTED	Stock	22.21	22.36	22.2	22.36	1161368.0
2016-10-21	ABBNY-DELISTED	Stock	22.21	22.36	22.2	22.35	1717003.0
2016-10-21	ABBV	Stock	61.38	61.44	60.65	60.98	4341700.0
2016-10-21	ABC-DELISTED	Stock	80.16	80.53	79.93	80.02	1046284.0
2016-10-21	ABCB	Stock	35.35	36.0	35.35	35.85	118000.0
2016-10-21	ABCD-DELISTED	Stock	5.1	5.15	5.07	5.08	5488.0
2016-10-21	ABCO-DELISTED	Stock	43.16	43.28	42.58	42.59	168263.0
2016-10-21	ABDC-DELISTED	Stock	12.98	12.98	12.72	12.85	24730.0
2016-10-21	ABE-DELISTED	Stock	12.34	12.48	12.34	12.45	6228.0
2016-10-21	ABEO	Stock	219.25	221.5	200.0	208.5	33020.0
2016-10-21	ABEOW-DELISTED	Stock	4.8	4.85	4.64	4.79	3515.0
2016-10-21	ABEV	Stock	6.18	6.28	6.17	6.26	27601300.0
2016-10-21	ABG	Stock	52.8	53.35	52.2	53.1	174000.0
2016-10-21	ABM	Stock	37.75	38.22	37.69	37.98	195600.0
2016-10-21	ABMD-DELISTED	Stock	124.91	126.055	123.73	124.86	227352.0

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

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