PREVIEW / stock_daily / 2016-05-06

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-06.parquet
  size:    218 KB
  rows:    6,532
  symbols: 3,278

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-05-06	AAPL	Stock	23.3425	23.3625	22.9625	23.18	174799600.0
2016-05-06	MSFT	Stock	49.92	50.39	49.66	50.39	24787300.0
2016-05-06	NVDA	Stock	0.8728	0.8855	0.871	0.8832	183240000.0
2016-05-06	AMZN	Stock	32.8025	33.8475	32.8005	33.6975	87306000.0
2016-05-06	GOOGL	Stock	35.61	36.2995	35.5975	36.259	39952560.0
2016-05-06	META	Stock	117.16	119.64	117.11	119.49	26395600.0
2016-05-06	TSLA	Stock	14.058	14.4247	13.874	14.3287	85278000.0
2016-05-06	TLT	Stock	130.85	130.86	130.295	130.45	7232476.0
2016-05-06	ES	Stock	57.41	57.42	56.48	57.16	2007600.0
2016-05-06	CL	Stock	71.49	71.85	71.19	71.82	2467600.0
2016-05-06	A	Stock	40.86	41.62	40.72	41.43	1403500.0
2016-05-06	AA.B-DELISTED	Stock	35.49	35.51	35.0	35.01	26803.0
2016-05-06	AAAP-DELISTED	Stock	32.56	32.58	30.13	30.89	24315.0
2016-05-06	AABA-DELISTED	Stock	36.55	37.31	36.49	37.23	8516937.0
2016-05-06	AAC-DELISTED	Stock	21.32	21.84	21.16	21.3	134061.0
2016-05-06	AACG	Stock	5.37	5.71	5.26	5.56	9200.0
2016-05-06	AAIC-DELISTED	Stock	12.31	12.673	12.31	12.56	131372.0
2016-05-06	AAL	Stock	32.67	33.15	32.19	33.03	12749100.0
2016-05-06	AAMC-DELISTED	Stock	3.6618	3.997	3.603	3.7206	58035.0
2016-05-06	AAME	Stock	4.17	4.17	4.11	4.11	700.0
2016-05-06	AAMI	Stock	13.98	14.18	13.91	14.03	219400.0
2016-05-06	AAOI	Stock	10.58	10.7	10.34	10.56	268200.0
2016-05-06	AAON	Stock	18.5533	18.7733	18.42	18.6667	413700.0
2016-05-06	AAP	Stock	150.15	151.06	147.26	150.52	1011100.0
2016-05-06	AAT	Stock	41.43	41.89	41.27	41.89	164500.0
2016-05-06	AAU-DELISTED	Stock	1.08	1.14	1.06	1.12	318121.0
2016-05-06	AAUAF-DELISTED	Stock	1.08	1.14	1.06	1.13	323461.0
2016-05-06	AAV-DELISTED	Stock	5.34	5.37	5.24	5.31	85488.0
2016-05-06	AAVL-DELISTED	Stock	4.7	4.83	4.1	4.11	512718.0
2016-05-06	AAWW-DELISTED	Stock	48.4	48.58	44.7	46.79	1086502.0
2016-05-06	AAXJ	Stock	52.01	52.3	51.9	52.12	1573016.0
2016-05-06	AAXN-DELISTED	Stock	18.0	18.39	17.755	18.14	1097083.0
2016-05-06	AB	Stock	22.1	22.87	22.1	22.85	153500.0
2016-05-06	ABAC-DELISTED	Stock	0.744	0.75	0.671	0.71	7618.0
2016-05-06	ABAX-DELISTED	Stock	44.49	44.7	43.93	44.49	154530.0
2016-05-06	ABB-DELISTED	Stock	20.5	20.625	20.48	20.595	2523648.0
2016-05-06	ABBNY-DELISTED	Stock	20.5	20.625	20.48	20.6	2605937.0
2016-05-06	ABBV	Stock	62.0	62.75	61.65	62.51	10880700.0
2016-05-06	ABC-DELISTED	Stock	77.96	78.15	75.35	76.51	6317093.0
2016-05-06	ABCB	Stock	30.47	30.81	30.17	30.79	198100.0
2016-05-06	ABCD-DELISTED	Stock	4.25	4.25	4.16	4.25	12701.0
2016-05-06	ABCO-DELISTED	Stock	32.32	35.36	32.13	32.89	1422270.0
2016-05-06	ABDC-DELISTED	Stock	11.3	11.8299	11.3	11.54	37728.0
2016-05-06	ABE-DELISTED	Stock	11.6	11.72	11.3201	11.66	9914.0
2016-05-06	ABEO	Stock	60.25	61.25	58.0	60.25	1980.0
2016-05-06	ABEV	Stock	5.35	5.38	5.3	5.33	19915300.0
2016-05-06	ABG	Stock	56.3	57.15	55.88	56.18	669000.0
2016-05-06	ABIL-DELISTED	Stock	3.8	3.8	2.77	2.98	375956.0
2016-05-06	ABM	Stock	32.57	32.82	32.03	32.52	399200.0
2016-05-06	ABMD-DELISTED	Stock	93.82	95.95	93.0	94.94	404144.0

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

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