PREVIEW / stock_daily / 2016-10-12

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-12.parquet
  size:    216 KB
  rows:    6,464
  symbols: 3,159

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-12	AAPL	Stock	29.3375	29.495	29.1875	29.335	150347200.0
2016-10-12	MSFT	Stock	57.11	57.27	56.4	57.11	22177500.0
2016-10-12	NVDA	Stock	1.6465	1.6695	1.6328	1.6608	419920000.0
2016-10-12	AMZN	Stock	41.7	41.8835	41.505	41.7045	47608000.0
2016-10-12	GOOGL	Stock	40.598	40.725	40.4277	40.5885	18157520.0
2016-10-12	META	Stock	129.01	129.66	128.46	129.05	11073000.0
2016-10-12	TSLA	Stock	13.3967	13.592	13.3613	13.434	29560500.0
2016-10-12	TLT	Stock	132.67	133.02	132.24	132.96	7582449.0
2016-10-12	ES	Stock	52.05	52.66	52.03	52.58	2211900.0
2016-10-12	CL	Stock	72.15	72.6	72.02	72.43	2202800.0
2016-10-12	A	Stock	45.78	45.82	45.42	45.47	1736100.0
2016-10-12	AA.B-DELISTED	Stock	30.28	30.28	29.54	29.61	45785.0
2016-10-12	AAAP-DELISTED	Stock	37.97	38.44	37.8	38.02	64768.0
2016-10-12	AABA-DELISTED	Stock	42.6	42.78	42.05	42.36	6868244.0
2016-10-12	AAC-DELISTED	Stock	17.25	17.6	16.97	17.2	139556.0
2016-10-12	AACG	Stock	4.17	4.25	4.1	4.15	2200.0
2016-10-12	AAIC-DELISTED	Stock	14.22	14.44	14.16	14.33	167233.0
2016-10-12	AAL	Stock	38.12	38.38	37.36	37.38	7410000.0
2016-10-12	AAMC-DELISTED	Stock	9.9088	14.5265	9.9088	14.4118	674417.0
2016-10-12	AAME	Stock	3.49	3.49	3.35	3.42	1800.0
2016-10-12	AAMI	Stock	13.94	14.01	13.8	13.96	96300.0
2016-10-12	AAOI	Stock	22.0	22.062	20.57	21.43	348100.0
2016-10-12	AAON	Stock	19.6333	20.2333	19.6	19.7333	99450.0
2016-10-12	AAP	Stock	146.63	149.07	146.57	147.96	513000.0
2016-10-12	AAT	Stock	40.34	40.8	40.23	40.74	262400.0
2016-10-12	AAU-DELISTED	Stock	1.23	1.23	1.17	1.18	183070.0
2016-10-12	AAUAF-DELISTED	Stock	1.23	1.23	1.17	1.19	184870.0
2016-10-12	AAV-DELISTED	Stock	7.29	7.33	7.211	7.26	35959.0
2016-10-12	AAWW-DELISTED	Stock	42.62	43.19	42.36	42.81	121903.0
2016-10-12	AAXJ	Stock	59.51	59.77	59.4	59.63	698257.0
2016-10-12	AAXN-DELISTED	Stock	22.47	22.69	22.26	22.49	640091.0
2016-10-12	AB	Stock	21.65	22.2	21.65	22.15	130400.0
2016-10-12	ABAC-DELISTED	Stock	2.02	2.19	2.02	2.16	16190.0
2016-10-12	ABAX-DELISTED	Stock	52.54	52.86	51.86	52.5	73805.0
2016-10-12	ABB-DELISTED	Stock	22.38	22.44	22.29	22.39	958448.0
2016-10-12	ABBNY-DELISTED	Stock	22.38	22.44	22.29	22.39	996477.0
2016-10-12	ABBV	Stock	62.0	62.23	61.02	61.21	4563800.0
2016-10-12	ABC-DELISTED	Stock	79.69	81.05	79.42	80.615	2120915.0
2016-10-12	ABCB	Stock	35.75	36.22	35.74	35.9	136500.0
2016-10-12	ABCD-DELISTED	Stock	5.48	5.49	5.29	5.36	3691.0
2016-10-12	ABCO-DELISTED	Stock	43.0	44.0	42.98	43.78	211125.0
2016-10-12	ABDC-DELISTED	Stock	12.84	13.0	12.72	12.9	28542.0
2016-10-12	ABE-DELISTED	Stock	12.4339	12.4339	12.3735	12.3735	1389.0
2016-10-12	ABEO	Stock	164.0	168.75	161.5	163.5	6776.0
2016-10-12	ABEOW-DELISTED	Stock	3.4427	3.56	3.4427	3.51	2903.0
2016-10-12	ABEV	Stock	6.04	6.08	5.96	5.99	11143800.0
2016-10-12	ABG	Stock	54.7	55.45	54.35	55.3	78600.0
2016-10-12	ABIL-DELISTED	Stock	3.5564	3.7	3.5564	3.7	3110.0
2016-10-12	ABM	Stock	38.25	38.4	37.95	38.07	352500.0
2016-10-12	ABMD-DELISTED	Stock	127.88	128.28	126.93	127.4	170755.0

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

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