PREVIEW / stock_daily / 2016-07-22

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-22.parquet
  size:    220 KB
  rows:    6,543
  symbols: 3,246

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-07-22	AAPL	Stock	24.815	24.825	24.5775	24.665	113254800.0
2016-07-22	MSFT	Stock	56.08	56.63	55.78	56.57	32157200.0
2016-07-22	NVDA	Stock	1.3352	1.3668	1.3255	1.3668	315768000.0
2016-07-22	AMZN	Stock	37.3895	37.564	37.1765	37.243	45554000.0
2016-07-22	GOOGL	Stock	37.866	37.9725	37.6328	37.964	20920480.0
2016-07-22	META	Stock	119.9	121.01	119.31	121.0	18422400.0
2016-07-22	TSLA	Stock	14.7993	14.9667	14.592	14.818	38695500.0
2016-07-22	TLT	Stock	137.93	139.24	137.87	138.8	5811415.0
2016-07-22	ES	Stock	58.05	59.03	58.05	58.88	1215900.0
2016-07-22	CL	Stock	74.12	74.62	73.94	74.61	3407200.0
2016-07-22	A	Stock	46.72	46.79	46.42	46.58	1512400.0
2016-07-22	AA.B-DELISTED	Stock	36.4799	36.4799	36.02	36.19	98174.0
2016-07-22	AAAP-DELISTED	Stock	30.55	30.69	30.3588	30.51	17646.0
2016-07-22	AABA-DELISTED	Stock	38.9	39.42	38.78	39.37	10711969.0
2016-07-22	AAC-DELISTED	Stock	21.85	22.21	21.5	22.1	20661.0
2016-07-22	AACG	Stock	4.22	4.22	4.01	4.06	7200.0
2016-07-22	AAIC-DELISTED	Stock	13.45	13.48	13.38	13.48	121601.0
2016-07-22	AAL	Stock	36.45	36.56	35.6	36.36	14704700.0
2016-07-22	AAMC-DELISTED	Stock	4.3324	4.5703	4.2176	4.4911	120513.0
2016-07-22	AAMI	Stock	13.82	14.03	13.75	13.9	110300.0
2016-07-22	AAOI	Stock	12.11	12.27	12.02	12.24	157300.0
2016-07-22	AAON	Stock	17.66	17.9067	17.5067	17.6933	129000.0
2016-07-22	AAP	Stock	164.71	166.23	164.2	166.03	586000.0
2016-07-22	AAT	Stock	44.96	45.42	44.96	45.31	125700.0
2016-07-22	AAU-DELISTED	Stock	1.35	1.37	1.33	1.35	160054.0
2016-07-22	AAUAF-DELISTED	Stock	1.35	1.37	1.33	1.35	161691.0
2016-07-22	AAV-DELISTED	Stock	6.45	6.58	6.42	6.5563	162314.0
2016-07-22	AAWW-DELISTED	Stock	41.72	43.24	40.09	42.03	110739.0
2016-07-22	AAXJ	Stock	57.12	57.29	57.0	57.24	522454.0
2016-07-22	AAXN-DELISTED	Stock	28.14	28.65	27.8678	28.49	803638.0
2016-07-22	AB	Stock	24.14	24.45	24.06	24.42	157000.0
2016-07-22	ABAC-DELISTED	Stock	0.8	0.8	0.7997	0.8	48700.0
2016-07-22	ABAX-DELISTED	Stock	49.5	49.5	46.015	46.3501	1003519.0
2016-07-22	ABB-DELISTED	Stock	20.95	20.96	20.735	20.9	2204032.0
2016-07-22	ABBNY-DELISTED	Stock	20.95	20.96	20.735	20.91	2299618.0
2016-07-22	ABBV	Stock	64.0	64.09	63.58	63.81	4972900.0
2016-07-22	ABC-DELISTED	Stock	86.01	86.21	85.1949	85.855	1178582.0
2016-07-22	ABCB	Stock	30.92	31.95	30.79	31.93	196400.0
2016-07-22	ABCD-DELISTED	Stock	4.92	4.96	4.84	4.84	20947.0
2016-07-22	ABCO-DELISTED	Stock	38.08	38.89	37.82	38.0	143083.0
2016-07-22	ABDC-DELISTED	Stock	12.3	12.34	12.26	12.34	13590.0
2016-07-22	ABE-DELISTED	Stock	12.488	12.488	12.48	12.48	600.0
2016-07-22	ABEO	Stock	61.75	64.0	61.5	62.5	2720.0
2016-07-22	ABEOW-DELISTED	Stock	1.05	1.05	1.05	1.05	1000.0
2016-07-22	ABEV	Stock	5.84	5.93	5.79	5.91	10933100.0
2016-07-22	ABG	Stock	61.15	61.42	60.39	61.13	136900.0
2016-07-22	ABIL-DELISTED	Stock	4.6	4.6	4.56	4.5608	6400.0
2016-07-22	ABM	Stock	37.07	37.67	36.9	37.52	121600.0
2016-07-22	ABMD-DELISTED	Stock	116.07	116.47	115.07	116.2	385550.0
2016-07-22	ABR	Stock	7.13	7.16	7.03	7.14	52900.0

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

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