PREVIEW / stock_daily / 2017-01-19

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-19.parquet
  size:    213 KB
  rows:    6,468
  symbols: 3,088

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
2017-01-19	AAPL	Stock	29.85	30.0225	29.8425	29.945	102389200.0
2017-01-19	MSFT	Stock	62.24	62.98	62.2	62.3	18451700.0
2017-01-19	NVDA	Stock	2.5768	2.6615	2.5745	2.629	644872000.0
2017-01-19	AMZN	Stock	40.5	40.6755	40.366	40.452	50816000.0
2017-01-19	GOOGL	Stock	41.45	41.65	41.198	41.2185	21409080.0
2017-01-19	META	Stock	128.23	128.35	127.45	127.55	12195500.0
2017-01-19	TSLA	Stock	16.4833	16.5787	16.05	16.2507	115984500.0
2017-01-19	TLT	Stock	120.49	120.58	119.55	120.18	11795590.0
2017-01-19	ES	Stock	55.25	55.67	54.98	55.07	1232700.0
2017-01-19	CL	Stock	67.49	67.55	66.91	67.04	2767900.0
2017-01-19	A	Stock	48.04	48.09	47.51	47.64	1346100.0
2017-01-19	AA	Stock	34.22	35.63	34.18	35.42	5050100.0
2017-01-19	AAAP-DELISTED	Stock	28.39	28.66	27.9	28.48	29717.0
2017-01-19	AABA-DELISTED	Stock	42.05	42.19	41.9	42.09	5683159.0
2017-01-19	AAC-DELISTED	Stock	8.0	8.08	7.81	7.86	69014.0
2017-01-19	AACG	Stock	3.25	3.25	3.11	3.11	6500.0
2017-01-19	AAIC-DELISTED	Stock	15.14	15.14	14.9	14.94	292460.0
2017-01-19	AAL	Stock	47.64	48.09	46.88	47.26	3729300.0
2017-01-19	AAMC-DELISTED	Stock	21.0882	21.9191	20.8088	21.4706	26642.0
2017-01-19	AAME	Stock	4.05	4.05	4.0	4.0	5400.0
2017-01-19	AAMI	Stock	14.25	14.36	14.12	14.25	399800.0
2017-01-19	AAOI	Stock	31.15	31.15	30.03	30.48	350600.0
2017-01-19	AAON	Stock	21.5333	21.7333	21.3333	21.5	169050.0
2017-01-19	AAP	Stock	174.21	174.82	171.22	171.72	606300.0
2017-01-19	AAT	Stock	43.2	43.2	42.76	42.8	119500.0
2017-01-19	AAU-DELISTED	Stock	0.9966	1.02	0.95	0.9965	287832.0
2017-01-19	AAUAF-DELISTED	Stock	0.9966	1.02	0.95	0.9965	289645.0
2017-01-19	AAV-DELISTED	Stock	6.3	6.5	6.3	6.4	83090.0
2017-01-19	AAWW-DELISTED	Stock	51.85	51.9	50.6	50.85	60937.0
2017-01-19	AAXJ	Stock	57.6	57.61	57.26	57.43	524191.0
2017-01-19	AAXN-DELISTED	Stock	25.02	25.36	24.83	25.09	631043.0
2017-01-19	AB	Stock	23.1	23.15	22.95	23.1	136500.0
2017-01-19	ABAC-DELISTED	Stock	3.54	3.65	3.54	3.6481	3800.0
2017-01-19	ABAX-DELISTED	Stock	48.5	48.7	47.985	48.49	145155.0
2017-01-19	ABB-DELISTED	Stock	22.48	22.58	22.39	22.55	1571968.0
2017-01-19	ABBNY-DELISTED	Stock	22.48	22.58	22.39	22.56	1619796.0
2017-01-19	ABBV	Stock	61.45	61.88	61.12	61.38	5384200.0
2017-01-19	ABC-DELISTED	Stock	85.28	85.78	84.82	85.45	1400147.0
2017-01-19	ABCB	Stock	42.2	42.4	41.6	42.25	124500.0
2017-01-19	ABCD-DELISTED	Stock	5.17	5.23	5.04	5.14	50179.0
2017-01-19	ABCO-DELISTED	Stock	41.4	41.8	41.1	41.55	517691.0
2017-01-19	ABDC-DELISTED	Stock	12.51	12.51	12.28	12.44	36170.0
2017-01-19	ABE-DELISTED	Stock	11.45	11.47	11.4	11.4378	13036.0
2017-01-19	ABEO	Stock	133.75	136.0	123.75	125.0	13752.0
2017-01-19	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	200.0
2017-01-19	ABEV	Stock	5.41	5.42	5.34	5.36	13597600.0
2017-01-19	ABG	Stock	64.85	65.9	64.1	64.6	191800.0
2017-01-19	ABIL-DELISTED	Stock	3.32	3.44	3.28	3.38	10739.0
2017-01-19	ABM	Stock	39.77	39.81	39.08	39.38	446400.0
2017-01-19	ABMD-DELISTED	Stock	113.47	113.64	111.62	112.19	314472.0

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

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