PREVIEW / stock_daily / 2016-01-20

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-20.parquet
  size:    221 KB
  rows:    6,669
  symbols: 3,402

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-20	AAPL	Stock	23.775	24.5475	23.355	24.1975	289337600.0
2016-01-20	MSFT	Stock	49.98	51.38	49.1	50.79	63273000.0
2016-01-20	NVDA	Stock	0.6702	0.6958	0.6612	0.687	481180000.0
2016-01-20	AMZN	Stock	28.218	28.9225	27.359	28.5885	159328000.0
2016-01-20	GOOGL	Stock	35.295	36.3475	34.389	35.928	82440200.0
2016-01-20	META	Stock	92.83	95.0	89.37	94.35	59051400.0
2016-01-20	TSLA	Stock	13.2933	13.4187	12.75	13.2467	87579000.0
2016-01-20	TLT	Stock	126.98	127.92	126.42	126.68	17283292.0
2016-01-20	ES	Stock	52.37	52.65	50.52	51.15	3408700.0
2016-01-20	CL	Stock	63.46	63.68	61.4	62.45	8221500.0
2016-01-20	A	Stock	36.68	37.61	36.13	37.26	2469100.0
2016-01-20	AA.B-DELISTED	Stock	24.12	24.27	22.55	24.2	55570.0
2016-01-20	AAAP-DELISTED	Stock	26.78	27.93	26.1	26.575	28244.0
2016-01-20	AABA-DELISTED	Stock	28.99	29.11	27.44	28.77	19487566.0
2016-01-20	AAC-DELISTED	Stock	15.47	16.45	14.36	16.33	319185.0
2016-01-20	AACG	Stock	5.15	5.34	5.12	5.17	17400.0
2016-01-20	AAIC-DELISTED	Stock	10.14	10.37	9.42	10.23	475489.0
2016-01-20	AAL	Stock	38.53	39.85	36.2	39.06	16089100.0
2016-01-20	AAMC-DELISTED	Stock	5.0588	5.0588	4.3353	4.8176	116076.0
2016-01-20	AAME	Stock	4.56	4.68	3.39	3.93	18600.0
2016-01-20	AAMI	Stock	11.41	11.61	10.96	11.58	296200.0
2016-01-20	AAOI	Stock	12.37	12.61	11.34	12.36	531900.0
2016-01-20	AAON	Stock	12.8533	13.4867	12.7067	13.2867	227100.0
2016-01-20	AAP	Stock	142.58	145.11	139.41	143.39	616700.0
2016-01-20	AAT	Stock	36.83	36.83	34.87	36.02	352900.0
2016-01-20	AAU-DELISTED	Stock	0.5002	0.54	0.5	0.5377	80800.0
2016-01-20	AAUAF-DELISTED	Stock	0.5002	0.54	0.5	0.5377	81686.0
2016-01-20	AAV-DELISTED	Stock	4.19	5.35	4.165	4.89	447645.0
2016-01-20	AAVL-DELISTED	Stock	5.58	6.29	5.41	6.19	423995.0
2016-01-20	AAWW-DELISTED	Stock	34.36	36.67	33.86	36.2	344632.0
2016-01-20	AAXJ	Stock	46.84	47.42	46.14	47.06	2594136.0
2016-01-20	AAXN-DELISTED	Stock	14.15	15.4162	13.5601	15.1	2833103.0
2016-01-20	AB	Stock	18.38	18.52	17.67	18.15	677100.0
2016-01-20	ABAC-DELISTED	Stock	0.72	0.7266	0.65	0.65	10435.0
2016-01-20	ABAX-DELISTED	Stock	51.03	53.82	50.1	53.31	238932.0
2016-01-20	ABB-DELISTED	Stock	16.12	16.185	15.74	16.08	3912204.0
2016-01-20	ABBNY-DELISTED	Stock	16.12	16.185	15.74	16.09	3981044.0
2016-01-20	ABBV	Stock	54.21	57.93	53.7	57.15	11993100.0
2016-01-20	ABC-DELISTED	Stock	91.79	92.25	89.68	90.92	4104433.0
2016-01-20	ABCB	Stock	29.18	29.67	28.68	29.28	196000.0
2016-01-20	ABCD-DELISTED	Stock	4.2	4.2299	3.92	4.17	93471.0
2016-01-20	ABCO-DELISTED	Stock	43.62	45.4	42.93	44.78	181110.0
2016-01-20	ABCW-DELISTED	Stock	41.7	41.92	41.03	41.73	162166.0
2016-01-20	ABDC-DELISTED	Stock	9.65	9.69	8.87	9.4	155905.0
2016-01-20	ABE-DELISTED	Stock	9.53	9.63	9.08	9.6103	21407.0
2016-01-20	ABEO	Stock	67.75	73.0	63.75	71.0	5040.0
2016-01-20	ABEV	Stock	4.07	4.08	3.93	4.03	12204900.0
2016-01-20	ABG	Stock	45.47	49.0	44.81	48.19	492900.0
2016-01-20	ABGB-DELISTED	Stock	0.93	0.93	0.8575	0.86	35270.0
2016-01-20	ABIL-DELISTED	Stock	9.18	9.18	8.78	9.0	36568.0

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

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