PREVIEW / stock_daily / 2017-01-18

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-18.parquet
  size:    216 KB
  rows:    6,497
  symbols: 3,110

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-18	AAPL	Stock	30.0	30.125	29.9275	29.9975	94852000.0
2017-01-18	MSFT	Stock	62.67	62.7	62.12	62.5	19670100.0
2017-01-18	NVDA	Stock	2.506	2.5808	2.4778	2.5738	654424000.0
2017-01-18	AMZN	Stock	40.475	40.5865	40.2135	40.374	47084000.0
2017-01-18	GOOGL	Stock	41.49	41.4905	41.204	41.451	20553960.0
2017-01-18	META	Stock	128.41	128.43	126.84	127.92	13145900.0
2017-01-18	TSLA	Stock	15.7767	15.9807	15.7053	15.8907	56535000.0
2017-01-18	TLT	Stock	121.77	121.96	120.91	121.01	9064689.0
2017-01-18	ES	Stock	55.69	55.9	55.42	55.52	1288700.0
2017-01-18	CL	Stock	67.2	68.19	67.18	67.86	5127300.0
2017-01-18	A	Stock	48.67	48.73	48.0	48.25	1523500.0
2017-01-18	AA	Stock	32.95	34.83	32.64	34.81	6420100.0
2017-01-18	AAAP-DELISTED	Stock	29.08	29.08	28.03	28.41	61824.0
2017-01-18	AABA-DELISTED	Stock	42.15	42.15	41.8	42.03	3049917.0
2017-01-18	AAC-DELISTED	Stock	8.06	8.09	7.91	7.97	80951.0
2017-01-18	AACG	Stock	3.46	3.49	3.22	3.22	1600.0
2017-01-18	AAIC-DELISTED	Stock	15.02	15.15	14.94	15.11	208689.0
2017-01-18	AAL	Stock	47.4	47.8	46.65	47.64	5176500.0
2017-01-18	AAMC-DELISTED	Stock	20.7206	21.9706	20.5882	20.6765	53747.0
2017-01-18	AAME	Stock	3.95	3.98	3.95	3.98	2100.0
2017-01-18	AAMI	Stock	14.39	14.41	14.03	14.27	317400.0
2017-01-18	AAOI	Stock	30.49	31.61	29.81	30.84	911400.0
2017-01-18	AAON	Stock	21.5333	21.6667	21.3333	21.4667	154050.0
2017-01-18	AAP	Stock	173.01	174.18	171.76	173.98	791400.0
2017-01-18	AAT	Stock	43.07	43.49	42.97	43.45	145200.0
2017-01-18	AAU-DELISTED	Stock	1.0	1.0384	0.9815	0.9847	206289.0
2017-01-18	AAUAF-DELISTED	Stock	1.0	1.0384	0.9815	0.9847	208247.0
2017-01-18	AAV-DELISTED	Stock	6.45	6.5	6.2	6.25	120556.0
2017-01-18	AAWW-DELISTED	Stock	51.1	51.7	50.975	51.7	82359.0
2017-01-18	AAXJ	Stock	57.85	57.93	57.52	57.57	473153.0
2017-01-18	AAXN-DELISTED	Stock	24.86	25.37	24.69	25.11	485083.0
2017-01-18	AB	Stock	23.2	23.31	22.9	23.05	198100.0
2017-01-18	ABAC-DELISTED	Stock	3.582	3.65	3.582	3.65	1200.0
2017-01-18	ABAX-DELISTED	Stock	48.14	48.79	47.85	48.5	110481.0
2017-01-18	ABB-DELISTED	Stock	22.34	22.47	22.33	22.41	1628291.0
2017-01-18	ABBNY-DELISTED	Stock	22.34	22.47	22.33	22.41	2777025.0
2017-01-18	ABBV	Stock	61.76	62.14	61.32	61.66	5519400.0
2017-01-18	ABC-DELISTED	Stock	85.95	86.18	85.19	85.5	1776215.0
2017-01-18	ABCB	Stock	42.0	42.13	41.6	42.1	117800.0
2017-01-18	ABCD-DELISTED	Stock	5.23	5.4	5.18	5.34	114029.0
2017-01-18	ABCO-DELISTED	Stock	40.6	41.35	40.3	41.3	398826.0
2017-01-18	ABDC-DELISTED	Stock	12.62	12.62	12.25	12.46	40918.0
2017-01-18	ABE-DELISTED	Stock	11.5	11.5065	11.4382	11.4382	11646.0
2017-01-18	ABEO	Stock	128.75	131.25	126.25	127.5	7768.0
2017-01-18	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	200.0
2017-01-18	ABEV	Stock	5.28	5.42	5.28	5.31	16791600.0
2017-01-18	ABG	Stock	64.4	65.5	63.7	65.5	166800.0
2017-01-18	ABIL-DELISTED	Stock	3.43	3.43	3.3356	3.34	5850.0
2017-01-18	ABM	Stock	39.77	40.33	39.76	39.85	387800.0
2017-01-18	ABMD-DELISTED	Stock	114.82	114.82	112.91	113.23	179435.0

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

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