PREVIEW / stock_daily / 2016-09-07

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-07.parquet
  size:    219 KB
  rows:    6,583
  symbols: 3,248

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-07	AAPL	Stock	26.9575	27.19	26.7675	27.09	169457200.0
2016-09-07	MSFT	Stock	57.47	57.84	57.41	57.66	17493400.0
2016-09-07	NVDA	Stock	1.573	1.5808	1.5458	1.5548	397988000.0
2016-09-07	AMZN	Stock	39.4765	39.5395	39.2165	39.224	48492000.0
2016-09-07	GOOGL	Stock	40.3965	40.53	40.186	40.3995	22914480.0
2016-09-07	META	Stock	130.04	131.98	129.95	131.05	27990800.0
2016-09-07	TSLA	Stock	13.7	13.7667	13.3807	13.4473	54613500.0
2016-09-07	TLT	Stock	140.37	140.42	139.54	139.54	5421827.0
2016-09-07	ES	Stock	54.9	54.97	54.56	54.87	903200.0
2016-09-07	CL	Stock	74.96	75.0	73.68	73.76	3297100.0
2016-09-07	A	Stock	47.07	47.17	46.86	47.11	1542400.0
2016-09-07	AA.B-DELISTED	Stock	35.03	35.03	34.32	34.57	17757.0
2016-09-07	AAAP-DELISTED	Stock	34.57	35.12	34.45	34.89	30666.0
2016-09-07	AABA-DELISTED	Stock	44.55	44.92	44.19	44.34	7603147.0
2016-09-07	AAC-DELISTED	Stock	20.0	20.335	19.26	19.765	180713.0
2016-09-07	AACG	Stock	4.6	4.73	4.41	4.69	2400.0
2016-09-07	AAIC-DELISTED	Stock	15.09	15.25	15.04	15.23	218512.0
2016-09-07	AAL	Stock	37.5	39.52	37.42	38.75	13775000.0
2016-09-07	AAMC-DELISTED	Stock	3.9471	4.0029	3.7971	3.8882	23280.0
2016-09-07	AAME	Stock	3.45	3.45	3.35	3.35	2900.0
2016-09-07	AAMI	Stock	13.55	13.655	13.37	13.51	314500.0
2016-09-07	AAOI	Stock	21.15	21.18	19.58	19.85	1721200.0
2016-09-07	AAON	Stock	19.3267	19.4867	19.14	19.2067	134850.0
2016-09-07	AAP	Stock	160.3	162.28	160.02	161.88	908600.0
2016-09-07	AAT	Stock	45.14	45.5	44.79	45.43	196800.0
2016-09-07	AAU-DELISTED	Stock	1.73	1.75	1.55	1.63	389983.0
2016-09-07	AAUAF-DELISTED	Stock	1.73	1.75	1.55	1.63	476446.0
2016-09-07	AAV-DELISTED	Stock	7.17	7.17	7.02	7.04	48800.0
2016-09-07	AAWW-DELISTED	Stock	38.88	40.38	38.42	40.19	325250.0
2016-09-07	AAXJ	Stock	61.08	61.22	60.92	61.12	1400854.0
2016-09-07	AAXN-DELISTED	Stock	26.38	26.51	25.92	26.13	783083.0
2016-09-07	AB	Stock	22.0	22.2	22.0	22.03	218300.0
2016-09-07	ABAC-DELISTED	Stock	0.63	0.6565	0.61	0.6221	24960.0
2016-09-07	ABAX-DELISTED	Stock	49.0	49.31	48.76	49.2	101921.0
2016-09-07	ABB-DELISTED	Stock	22.63	22.68	22.54	22.6	1064893.0
2016-09-07	ABBNY-DELISTED	Stock	22.63	22.68	22.54	22.6	1111553.0
2016-09-07	ABBV	Stock	64.37	65.14	64.29	64.97	5714300.0
2016-09-07	ABC-DELISTED	Stock	87.6	88.439	87.45	87.77	1337781.0
2016-09-07	ABCB	Stock	35.1	35.83	34.9	35.8	248700.0
2016-09-07	ABCD-DELISTED	Stock	4.901	5.11	4.901	5.05	41662.0
2016-09-07	ABCO-DELISTED	Stock	42.87	43.6	42.6175	43.5	180438.0
2016-09-07	ABDC-DELISTED	Stock	12.77	12.95	12.731	12.82	29478.0
2016-09-07	ABE-DELISTED	Stock	12.78	12.78	12.78	12.78	100.0
2016-09-07	ABEO	Stock	118.25	121.25	113.5	119.75	5508.0
2016-09-07	ABEOW-DELISTED	Stock	2.13	2.13	2.07	2.13	756.0
2016-09-07	ABEV	Stock	6.22	6.25	6.15	6.2	10302400.0
2016-09-07	ABG	Stock	54.77	55.47	54.46	55.15	326600.0
2016-09-07	ABIL-DELISTED	Stock	4.32	4.32	3.93	4.01	72765.0
2016-09-07	ABM	Stock	38.92	39.06	38.43	38.65	416000.0
2016-09-07	ABMD-DELISTED	Stock	118.39	119.06	117.73	119.05	341962.0

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

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