PREVIEW / stock_daily / 2016-01-19

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-19.parquet
  size:    221 KB
  rows:    6,663
  symbols: 3,399

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-01-19	AAPL	Stock	24.6025	24.6625	23.875	24.165	212350800.0
2016-01-19	MSFT	Stock	51.48	51.68	50.06	50.56	43564500.0
2016-01-19	NVDA	Stock	0.6918	0.7113	0.6805	0.6832	457140000.0
2016-01-19	AMZN	Stock	28.8545	29.2	28.3225	28.724	96144000.0
2016-01-19	GOOGL	Stock	36.0075	36.2675	35.4925	35.954	48724400.0
2016-01-19	META	Stock	96.53	97.42	93.92	95.26	30998300.0
2016-01-19	TSLA	Stock	13.914	14.0313	13.3853	13.648	60580500.0
2016-01-19	TLT	Stock	125.13	126.07	124.95	125.36	8926594.0
2016-01-19	ES	Stock	51.45	52.75	51.38	52.59	2777800.0
2016-01-19	CL	Stock	63.79	64.52	63.7	64.29	5106800.0
2016-01-19	A	Stock	37.64	37.92	36.79	37.2	2506500.0
2016-01-19	AA.B-DELISTED	Stock	25.14	25.14	23.53	24.37	31576.0
2016-01-19	AAAP-DELISTED	Stock	24.7	27.062	23.95	25.4	56973.0
2016-01-19	AABA-DELISTED	Stock	29.85	30.0	29.31	29.73	18901525.0
2016-01-19	AAC-DELISTED	Stock	16.71	16.96	15.39	15.53	137211.0
2016-01-19	AACG	Stock	5.59	5.74	5.5	5.53	48700.0
2016-01-19	AAIC-DELISTED	Stock	10.8	10.8	10.24	10.36	370642.0
2016-01-19	AAL	Stock	39.59	39.78	38.21	38.86	10505900.0
2016-01-19	AAMC-DELISTED	Stock	5.1176	5.15	4.8147	5.0029	119779.0
2016-01-19	AAME	Stock	4.67	4.67	4.61	4.61	1100.0
2016-01-19	AAMI	Stock	11.97	12.045	11.49	11.65	217600.0
2016-01-19	AAOI	Stock	13.6	13.82	12.15	12.61	472100.0
2016-01-19	AAON	Stock	13.36	13.3667	12.8533	12.9933	210600.0
2016-01-19	AAP	Stock	145.09	146.44	142.9	144.62	1184000.0
2016-01-19	AAT	Stock	36.93	37.29	36.74	37.09	177700.0
2016-01-19	AAU-DELISTED	Stock	0.57	0.5709	0.5	0.5002	197305.0
2016-01-19	AAUAF-DELISTED	Stock	0.57	0.5709	0.5	0.5002	199974.0
2016-01-19	AAV-DELISTED	Stock	4.6	4.61	4.28	4.32	73287.0
2016-01-19	AAVL-DELISTED	Stock	6.18	6.33	5.54	5.75	369189.0
2016-01-19	AAWW-DELISTED	Stock	34.4	36.05	33.84	34.92	328281.0
2016-01-19	AAXJ	Stock	48.67	48.76	47.93	48.28	762128.0
2016-01-19	AAXN-DELISTED	Stock	14.63	14.89	14.185	14.49	1322308.0
2016-01-19	AB	Stock	19.69	19.77	18.55	18.67	430800.0
2016-01-19	ABAC-DELISTED	Stock	0.79	0.79	0.7242	0.7699	400.0
2016-01-19	ABAX-DELISTED	Stock	51.98	52.39	51.13	51.73	266785.0
2016-01-19	ABB-DELISTED	Stock	16.38	16.46	16.125	16.24	3055425.0
2016-01-19	ABBNY-DELISTED	Stock	16.38	16.46	16.125	16.26	3243165.0
2016-01-19	ABBV	Stock	57.53	57.73	54.23	54.99	13644500.0
2016-01-19	ABC-DELISTED	Stock	93.29	93.341	91.59	92.53	3088309.0
2016-01-19	ABCB	Stock	30.01	30.21	29.27	29.57	139600.0
2016-01-19	ABCD-DELISTED	Stock	4.48	4.54	4.14	4.28	50166.0
2016-01-19	ABCO-DELISTED	Stock	44.64	45.02	43.65	44.2	158450.0
2016-01-19	ABCW-DELISTED	Stock	42.85	42.85	41.95	42.31	48451.0
2016-01-19	ABDC-DELISTED	Stock	10.29	10.42	9.66	9.73	75035.0
2016-01-19	ABE-DELISTED	Stock	9.9	9.92	9.82	9.82	3196.0
2016-01-19	ABEO	Stock	74.25	74.25	68.0	70.75	4392.0
2016-01-19	ABEV	Stock	4.08	4.15	4.07	4.13	9357400.0
2016-01-19	ABG	Stock	48.46	49.06	44.81	45.97	484200.0
2016-01-19	ABGB-DELISTED	Stock	1.04	1.04	0.9701	0.9998	22153.0
2016-01-19	ABIL-DELISTED	Stock	9.29	9.35	9.17	9.17	61999.0

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

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