PREVIEW / stock_daily / 2015-11-19

all stock daily files

  file:    by_date/stock_daily/2015/2015-11-19.parquet
  size:    222 KB
  rows:    6,642
  symbols: 3,417

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-11-19	AAPL	Stock	29.41	29.9375	29.19	29.695	173183200.0
2015-11-19	MSFT	Stock	53.99	54.66	53.78	53.94	28149200.0
2015-11-19	NVDA	Stock	0.7785	0.7858	0.7723	0.778	254072000.0
2015-11-19	AMZN	Stock	33.2495	33.643	32.95	33.0635	94104000.0
2015-11-19	GOOGL	Stock	37.989	38.1615	37.8615	37.997	28078260.0
2015-11-19	META	Stock	107.36	107.73	105.95	106.26	25520600.0
2015-11-19	TSLA	Stock	14.7027	15.0793	14.6867	14.7867	37566000.0
2015-11-19	TLT	Stock	120.88	121.15	120.675	120.82	6643031.0
2015-11-19	ES	Stock	50.77	51.29	50.49	51.04	1610900.0
2015-11-19	CL	Stock	66.32	66.95	66.2	66.38	2964600.0
2015-11-19	A	Stock	39.16	39.7	38.31	38.5	7274500.0
2015-11-19	AA.B-DELISTED	Stock	30.29	31.13	30.22	30.9	33067.0
2015-11-19	AAAP-DELISTED	Stock	24.855	25.9999	24.71	25.33	109085.0
2015-11-19	AABA-DELISTED	Stock	33.21	33.5	32.58	32.62	13272520.0
2015-11-19	AAC-DELISTED	Stock	22.53	22.785	22.05	22.34	171224.0
2015-11-19	AACG	Stock	4.88	4.91	4.6	4.91	18200.0
2015-11-19	AAIC-DELISTED	Stock	13.53	13.7	13.491	13.64	140137.0
2015-11-19	AAL	Stock	41.94	42.73	41.89	42.3	6545500.0
2015-11-19	AAMC-DELISTED	Stock	3.8088	4.2156	3.8088	3.8676	72427.0
2015-11-19	AAME	Stock	4.92	4.99	4.9	4.9	1700.0
2015-11-19	AAMI	Stock	16.17	16.22	16.07	16.15	71900.0
2015-11-19	AAOI	Stock	17.32	18.0	17.21	17.33	434200.0
2015-11-19	AAON	Stock	16.08	16.1867	15.8667	15.9733	218100.0
2015-11-19	AAP	Stock	164.19	165.27	162.22	162.37	684200.0
2015-11-19	AAT	Stock	39.98	40.17	39.67	39.85	113900.0
2015-11-19	AAU-DELISTED	Stock	0.5322	0.5399	0.521	0.5299	25932.0
2015-11-19	AAUAF-DELISTED	Stock	0.5322	0.5399	0.521	0.5299	26030.0
2015-11-19	AAV-DELISTED	Stock	5.53	5.61	5.46	5.49	46321.0
2015-11-19	AAVL-DELISTED	Stock	8.41	8.61	8.19	8.45	369891.0
2015-11-19	AAWW-DELISTED	Stock	40.69	41.095	39.98	40.88	101123.0
2015-11-19	AAXJ	Stock	55.77	56.09	55.73	55.86	696673.0
2015-11-19	AAXN-DELISTED	Stock	18.55	18.64	17.6644	17.81	1754812.0
2015-11-19	AB	Stock	24.71	25.65	24.4	25.54	245000.0
2015-11-19	ABAC-DELISTED	Stock	0.65	0.65	0.61	0.61	3110.0
2015-11-19	ABAX-DELISTED	Stock	52.01	52.46	51.02	51.15	81362.0
2015-11-19	ABB-DELISTED	Stock	18.68	18.84	18.67	18.82	1596356.0
2015-11-19	ABBNY-DELISTED	Stock	18.68	18.84	18.67	18.83	1630489.0
2015-11-19	ABBV	Stock	61.22	61.73	60.14	60.55	5571200.0
2015-11-19	ABC-DELISTED	Stock	100.33	100.86	99.04	99.15	1808582.0
2015-11-19	ABCB	Stock	33.1	33.65	32.92	33.58	166000.0
2015-11-19	ABCD-DELISTED	Stock	5.19	5.24	4.97	5.08	41208.0
2015-11-19	ABCO-DELISTED	Stock	52.02	52.32	51.45	51.71	166375.0
2015-11-19	ABCW-DELISTED	Stock	40.99	41.1	40.58	41.06	14239.0
2015-11-19	ABDC-DELISTED	Stock	11.65	11.91	11.65	11.91	47588.0
2015-11-19	ABE-DELISTED	Stock	11.23	11.2899	11.13	11.28	7488.0
2015-11-19	ABEO	Stock	100.0	102.5	98.75	101.75	2288.0
2015-11-19	ABEOW-DELISTED	Stock	1.51	1.51	1.5	1.5	200.0
2015-11-19	ABEV	Stock	5.15	5.16	5.1	5.14	28353300.0
2015-11-19	ABG	Stock	70.56	71.25	70.25	70.79	434900.0
2015-11-19	ABGB-DELISTED	Stock	4.95	4.95	4.8	4.8	7358.0

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

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