PREVIEW / stock_daily / 2015-07-22

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-22.parquet
  size:    223 KB
  rows:    6,647
  symbols: 3,479

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
2015-07-22	AAPL	Stock	30.4975	31.375	30.4975	31.305	461802400.0
2015-07-22	MSFT	Stock	45.44	46.93	45.2	45.54	59152400.0
2015-07-22	NVDA	Stock	0.4912	0.4912	0.4793	0.4852	356472000.0
2015-07-22	AMZN	Stock	24.2995	24.625	24.245	24.4135	62298000.0
2015-07-22	GOOGL	Stock	34.701	35.6665	34.581	34.755	83099740.0
2015-07-22	META	Stock	96.74	97.58	95.92	97.04	28299500.0
2015-07-22	TSLA	Stock	17.418	17.9627	17.3907	17.858	46575000.0
2015-07-22	TLT	Stock	119.01	119.9	118.95	119.6	6228919.0
2015-07-22	ES	Stock	47.64	48.44	47.36	47.83	3469100.0
2015-07-22	CL	Stock	66.94	67.18	66.73	67.0	2825500.0
2015-07-22	A	Stock	39.29	40.42	39.29	40.33	2949400.0
2015-07-22	AA.B-DELISTED	Stock	37.56	37.6299	37.0	37.0	26418.0
2015-07-22	AABA-DELISTED	Stock	38.66	39.63	38.26	39.24	16349332.0
2015-07-22	AAC-DELISTED	Stock	38.99	39.4899	38.2	38.55	306659.0
2015-07-22	AACG	Stock	4.1	4.3	4.03	4.13	21100.0
2015-07-22	AAIC-DELISTED	Stock	19.86	20.03	19.78	19.89	246587.0
2015-07-22	AAL	Stock	40.96	41.61	40.96	41.43	8302900.0
2015-07-22	AAMC-DELISTED	Stock	39.9941	41.5353	39.3971	39.3971	11754.0
2015-07-22	AAME	Stock	3.67	3.7	3.67	3.67	3900.0
2015-07-22	AAMI	Stock	17.68	17.92	17.58	17.68	142200.0
2015-07-22	AAOI	Stock	18.51	18.81	17.95	18.31	171600.0
2015-07-22	AAON	Stock	15.04	15.3467	15.0067	15.34	148950.0
2015-07-22	AAP	Stock	167.48	169.84	166.84	168.22	1013000.0
2015-07-22	AAT	Stock	41.06	41.42	40.87	41.22	183700.0
2015-07-22	AAU-DELISTED	Stock	0.629	0.6667	0.6268	0.631	95141.0
2015-07-22	AAUAF-DELISTED	Stock	0.63	0.6678	0.6278	0.632	95909.0
2015-07-22	AAV-DELISTED	Stock	5.73	5.91	5.67	5.77	43160.0
2015-07-22	AAVL-DELISTED	Stock	16.42	16.77	16.25	16.5	282711.0
2015-07-22	AAWW-DELISTED	Stock	51.28	52.15	50.49	50.59	801255.0
2015-07-22	AAXJ	Stock	60.89	60.9301	60.63	60.69	1105389.0
2015-07-22	AAXN-DELISTED	Stock	32.59	33.36	32.15	32.18	1270439.0
2015-07-22	AB	Stock	28.44	28.45	27.87	27.94	134500.0
2015-07-22	ABAC-DELISTED	Stock	1.19	1.19	1.1301	1.19	1993.0
2015-07-22	ABAX-DELISTED	Stock	55.64	56.78	55.27	56.77	153871.0
2015-07-22	ABB-DELISTED	Stock	20.22	20.52	20.21	20.38	2689241.0
2015-07-22	ABBNY-DELISTED	Stock	20.22	20.52	20.21	20.39	2991611.0
2015-07-22	ABBV	Stock	70.26	70.65	70.03	70.56	5701700.0
2015-07-22	ABC-DELISTED	Stock	114.01	115.41	113.8706	115.0	2139892.0
2015-07-22	ABCB	Stock	26.0	26.35	26.0	26.35	126900.0
2015-07-22	ABCD-DELISTED	Stock	5.06	5.23	5.02	5.075	143217.0
2015-07-22	ABCO-DELISTED	Stock	57.14	57.86	57.1	57.49	406246.0
2015-07-22	ABCW-DELISTED	Stock	39.77	40.01	39.13	39.29	8563.0
2015-07-22	ABDC-DELISTED	Stock	12.85	13.0	12.8	12.93	30240.0
2015-07-22	ABE-DELISTED	Stock	12.98	13.139	12.98	13.08	21015.0
2015-07-22	ABEO	Stock	142.25	150.0	137.5	147.5	5608.0
2015-07-22	ABEOW-DELISTED	Stock	1.83	2.0	1.83	1.9	4792.0
2015-07-22	ABEV	Stock	6.1	6.13	5.97	6.01	11878200.0
2015-07-22	ABG	Stock	89.01	89.68	86.16	86.94	836200.0
2015-07-22	ABGB-DELISTED	Stock	14.43	14.4599	14.2507	14.45	33190.0
2015-07-22	ABIL-DELISTED	Stock	9.9999	9.9999	9.9999	9.9999	855.0

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

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