PREVIEW / stock_daily / 2016-05-05

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-05.parquet
  size:    218 KB
  rows:    6,539
  symbols: 3,285

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-05	AAPL	Stock	23.5	23.5175	23.17	23.31	143562000.0
2016-05-05	MSFT	Stock	49.87	50.3	49.73	49.94	25390700.0
2016-05-05	NVDA	Stock	0.8762	0.8845	0.8678	0.8742	246884000.0
2016-05-05	AMZN	Stock	33.6655	33.8245	32.8	32.9545	97682000.0
2016-05-05	GOOGL	Stock	35.75	35.8775	35.4725	35.7355	29667140.0
2016-05-05	META	Stock	118.04	118.98	117.25	117.81	22056700.0
2016-05-05	TSLA	Stock	15.2307	15.2427	13.986	14.102	168822000.0
2016-05-05	TLT	Stock	130.06	131.07	129.7	131.01	7870447.0
2016-05-05	ES	Stock	55.64	58.26	55.64	57.4	2212100.0
2016-05-05	CL	Stock	71.66	72.31	71.19	71.47	3006200.0
2016-05-05	A	Stock	40.64	41.03	40.51	40.96	1084000.0
2016-05-05	AA.B-DELISTED	Stock	35.4	35.45	34.86	34.9483	11016.0
2016-05-05	AAAP-DELISTED	Stock	34.95	34.95	32.56	33.03	15550.0
2016-05-05	AABA-DELISTED	Stock	37.06	37.45	36.858	36.94	13052612.0
2016-05-05	AAC-DELISTED	Stock	21.15	22.54	20.72	21.53	438809.0
2016-05-05	AACG	Stock	5.46	5.57	5.46	5.52	10000.0
2016-05-05	AAIC-DELISTED	Stock	12.45	12.7	12.35	12.35	226525.0
2016-05-05	AAL	Stock	33.28	33.52	32.73	32.81	11606100.0
2016-05-05	AAMC-DELISTED	Stock	4.1	4.6176	3.7235	3.7735	110735.0
2016-05-05	AAME	Stock	4.09	4.2	4.05	4.18	1900.0
2016-05-05	AAMI	Stock	13.28	14.148	12.83	13.97	322200.0
2016-05-05	AAOI	Stock	10.65	10.87	10.35	10.6	316700.0
2016-05-05	AAON	Stock	17.2867	18.76	17.28	18.6533	351450.0
2016-05-05	AAP	Stock	152.99	153.11	148.2	148.74	1548500.0
2016-05-05	AAT	Stock	41.58	41.98	41.44	41.62	102400.0
2016-05-05	AAU-DELISTED	Stock	1.11	1.14	1.04	1.07	282128.0
2016-05-05	AAUAF-DELISTED	Stock	1.11	1.14	1.04	1.07	284341.0
2016-05-05	AAV-DELISTED	Stock	5.4	5.47	5.26	5.28	93659.0
2016-05-05	AAVL-DELISTED	Stock	5.05	5.26	4.75	4.82	307734.0
2016-05-05	AAWW-DELISTED	Stock	50.94	57.77	45.0	48.66	3807136.0
2016-05-05	AAXJ	Stock	52.6	52.66	52.14	52.29	1051504.0
2016-05-05	AAXN-DELISTED	Stock	18.24	19.13	17.76	18.31	2511904.0
2016-05-05	AB	Stock	22.69	22.94	22.19	22.33	150500.0
2016-05-05	ABAC-DELISTED	Stock	0.67	0.775	0.67	0.73	28957.0
2016-05-05	ABAX-DELISTED	Stock	44.36	45.01	43.985	44.82	125178.0
2016-05-05	ABB-DELISTED	Stock	20.78	20.78	20.48	20.55	1179855.0
2016-05-05	ABBNY-DELISTED	Stock	20.78	20.78	20.48	20.54	1223609.0
2016-05-05	ABBV	Stock	61.41	62.4	61.09	62.34	8646200.0
2016-05-05	ABC-DELISTED	Stock	77.95	79.68	76.82	78.02	11198723.0
2016-05-05	ABCB	Stock	30.73	31.03	30.56	30.57	392600.0
2016-05-05	ABCD-DELISTED	Stock	4.44	4.4501	4.19	4.19	56890.0
2016-05-05	ABCO-DELISTED	Stock	30.41	30.78	28.9901	29.32	627969.0
2016-05-05	ABDC-DELISTED	Stock	11.87	11.89	11.39	11.83	21601.0
2016-05-05	ABE-DELISTED	Stock	11.9	11.95	11.67	11.67	9501.0
2016-05-05	ABEO	Stock	60.5	62.25	57.25	60.5	5176.0
2016-05-05	ABEV	Stock	5.49	5.49	5.34	5.35	13008100.0
2016-05-05	ABG	Stock	57.36	58.35	56.26	56.29	234200.0
2016-05-05	ABIL-DELISTED	Stock	4.08	4.15	3.8	3.8	55298.0
2016-05-05	ABM	Stock	32.78	32.9	32.46	32.79	450000.0
2016-05-05	ABMD-DELISTED	Stock	94.88	96.29	93.45	94.77	531536.0

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

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