PREVIEW / stock_daily / 2016-09-27

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-27.parquet
  size:    218 KB
  rows:    6,511
  symbols: 3,191

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-27	AAPL	Stock	28.25	28.295	28.085	28.2725	98429600.0
2016-09-27	MSFT	Stock	56.93	58.06	56.68	57.95	28065100.0
2016-09-27	NVDA	Stock	1.6023	1.666	1.6015	1.6635	402752000.0
2016-09-27	AMZN	Stock	40.0925	40.832	40.0555	40.8055	76392000.0
2016-09-27	GOOGL	Stock	40.0915	40.6745	40.0915	40.5365	27345420.0
2016-09-27	META	Stock	127.61	129.01	127.43	128.69	15637100.0
2016-09-27	TSLA	Stock	13.9767	13.9987	13.6407	13.7207	50598000.0
2016-09-27	TLT	Stock	138.59	138.8	137.95	138.7	9450445.0
2016-09-27	ES	Stock	56.66	56.84	55.3	55.41	1374900.0
2016-09-27	CL	Stock	73.34	73.71	73.03	73.46	2292200.0
2016-09-27	A	Stock	46.53	46.71	46.23	46.7	1587100.0
2016-09-27	AA.B-DELISTED	Stock	31.99	31.99	31.24	31.53	620495.0
2016-09-27	AAAP-DELISTED	Stock	38.3	38.55	37.32	38.47	32578.0
2016-09-27	AABA-DELISTED	Stock	42.43	43.41	42.32	43.37	8273298.0
2016-09-27	AAC-DELISTED	Stock	16.94	17.02	16.6	16.86	127024.0
2016-09-27	AACG	Stock	4.56	4.56	4.1	4.4	13200.0
2016-09-27	AAIC-DELISTED	Stock	15.49	15.6	15.25	15.33	445219.0
2016-09-27	AAL	Stock	34.98	36.13	34.9	36.0	5068900.0
2016-09-27	AAMC-DELISTED	Stock	4.5412	4.7882	4.4118	4.7735	35506.0
2016-09-27	AAME	Stock	3.42	3.46	3.34	3.44	4000.0
2016-09-27	AAMI	Stock	13.26	13.66	13.17	13.64	150000.0
2016-09-27	AAOI	Stock	21.04	21.49	21.04	21.31	242400.0
2016-09-27	AAON	Stock	18.7133	18.9333	18.64	18.88	116550.0
2016-09-27	AAP	Stock	151.58	152.7	150.59	151.01	1151000.0
2016-09-27	AAT	Stock	44.46	44.46	43.74	43.91	173500.0
2016-09-27	AAU-DELISTED	Stock	1.35	1.38	1.33	1.38	186329.0
2016-09-27	AAUAF-DELISTED	Stock	1.35	1.38	1.33	1.35	198421.0
2016-09-27	AAV-DELISTED	Stock	6.71	6.71	6.61	6.67	47455.0
2016-09-27	AAWW-DELISTED	Stock	39.98	40.38	39.69	40.23	249811.0
2016-09-27	AAXJ	Stock	60.28	60.7	60.15	60.7	1063164.0
2016-09-27	AAXN-DELISTED	Stock	28.26	28.5277	28.19	28.42	504159.0
2016-09-27	AB	Stock	22.25	22.34	22.0	22.26	191100.0
2016-09-27	ABAC-DELISTED	Stock	2.15	2.1999	2.0501	2.0901	11296.0
2016-09-27	ABAX-DELISTED	Stock	50.7	50.99	50.26	50.86	57965.0
2016-09-27	ABB-DELISTED	Stock	22.31	22.525	22.275	22.49	1200395.0
2016-09-27	ABBNY-DELISTED	Stock	22.31	22.525	22.275	22.49	1232664.0
2016-09-27	ABBV	Stock	63.95	64.75	63.69	64.57	4358300.0
2016-09-27	ABC-DELISTED	Stock	82.75	83.74	82.46	83.26	1407431.0
2016-09-27	ABCB	Stock	34.48	34.82	33.8	34.56	201000.0
2016-09-27	ABCD-DELISTED	Stock	5.539	5.539	5.4	5.42	9978.0
2016-09-27	ABCO-DELISTED	Stock	43.61	43.715	42.75	43.18	136969.0
2016-09-27	ABDC-DELISTED	Stock	13.21	13.3699	13.02	13.33	89660.0
2016-09-27	ABE-DELISTED	Stock	12.67	12.76	12.67	12.75	5199.0
2016-09-27	ABEO	Stock	154.5	154.5	136.5	140.25	23116.0
2016-09-27	ABEOW-DELISTED	Stock	3.92	3.92	3.19	3.27	7460.0
2016-09-27	ABEV	Stock	6.05	6.09	5.99	6.09	8203200.0
2016-09-27	ABG	Stock	55.01	55.6	54.25	55.09	144600.0
2016-09-27	ABIL-DELISTED	Stock	3.88	4.0	3.83	3.89	13932.0
2016-09-27	ABM	Stock	39.41	39.66	39.38	39.4	379600.0
2016-09-27	ABMD-DELISTED	Stock	127.2	131.11	126.08	129.16	504602.0

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

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