PREVIEW / stock_daily / 2017-01-13

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-13.parquet
  size:    216 KB
  rows:    6,498
  symbols: 3,113

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-13	AAPL	Stock	29.7775	29.905	29.7025	29.76	104447600.0
2017-01-13	MSFT	Stock	62.62	62.87	62.35	62.7	19422300.0
2017-01-13	NVDA	Stock	2.59	2.625	2.5765	2.5858	457820000.0
2017-01-13	AMZN	Stock	40.716	41.0825	40.57	40.857	75838000.0
2017-01-13	GOOGL	Stock	41.55	41.7325	41.476	41.547	25803640.0
2017-01-13	META	Stock	127.49	129.27	127.37	128.34	24884300.0
2017-01-13	TSLA	Stock	15.3333	15.8567	15.306	15.85	91395000.0
2017-01-13	TLT	Stock	121.33	121.75	120.62	121.31	9820003.0
2017-01-13	ES	Stock	55.17	55.42	54.76	55.15	1053400.0
2017-01-13	CL	Stock	65.9	66.03	65.61	65.88	1888100.0
2017-01-13	A	Stock	48.6	48.85	48.41	48.69	1568500.0
2017-01-13	AA	Stock	32.82	33.43	32.53	33.01	3026200.0
2017-01-13	AAAP-DELISTED	Stock	29.26	29.57	29.01	29.22	44564.0
2017-01-13	AABA-DELISTED	Stock	42.11	42.46	42.02	42.27	3787910.0
2017-01-13	AAC-DELISTED	Stock	8.03	8.26	8.03	8.1	46994.0
2017-01-13	AACG	Stock	3.41	3.44	3.29	3.41	4500.0
2017-01-13	AAIC-DELISTED	Stock	15.21	15.27	15.07	15.23	221979.0
2017-01-13	AAL	Stock	48.16	48.43	47.54	47.65	3541700.0
2017-01-13	AAMC-DELISTED	Stock	18.7059	20.3959	18.7059	20.3405	50602.0
2017-01-13	AAME	Stock	4.05	4.05	3.95	3.95	4800.0
2017-01-13	AAMI	Stock	14.57	14.71	14.52	14.6	461700.0
2017-01-13	AAOI	Stock	30.5	30.54	27.82	28.22	1532400.0
2017-01-13	AAON	Stock	21.8333	22.2	21.8333	21.9333	178200.0
2017-01-13	AAP	Stock	174.42	175.86	173.52	174.79	1196200.0
2017-01-13	AAT	Stock	43.13	43.4	42.92	43.01	93000.0
2017-01-13	AAU-DELISTED	Stock	1.0	1.07	1.0	1.07	286439.0
2017-01-13	AAUAF-DELISTED	Stock	1.0	1.07	1.0	1.07	287904.0
2017-01-13	AAV-DELISTED	Stock	6.5	6.6	6.45	6.55	101406.0
2017-01-13	AAWW-DELISTED	Stock	52.0	52.9	52.0	52.15	148774.0
2017-01-13	AAXJ	Stock	57.7	57.82	57.61	57.77	670238.0
2017-01-13	AAXN-DELISTED	Stock	24.29	25.4697	24.29	25.22	916174.0
2017-01-13	AB	Stock	23.55	24.05	23.45	23.7	259600.0
2017-01-13	ABAC-DELISTED	Stock	3.6361	3.7399	3.6361	3.72	5680.0
2017-01-13	ABAX-DELISTED	Stock	49.71	50.125	49.02	49.16	135584.0
2017-01-13	ABB-DELISTED	Stock	22.46	22.505	22.4	22.47	1656373.0
2017-01-13	ABBNY-DELISTED	Stock	22.46	22.505	22.3709	22.48	2241897.0
2017-01-13	ABBV	Stock	61.35	62.41	61.05	61.99	7295100.0
2017-01-13	ABC-DELISTED	Stock	84.08	85.12	83.51	84.62	1168501.0
2017-01-13	ABCB	Stock	43.5	44.6	43.1	43.25	132100.0
2017-01-13	ABCD-DELISTED	Stock	5.22	5.45	5.22	5.33	67534.0
2017-01-13	ABCO-DELISTED	Stock	41.25	42.6	41.05	41.75	971791.0
2017-01-13	ABDC-DELISTED	Stock	12.41	12.45	12.25	12.44	17582.0
2017-01-13	ABE-DELISTED	Stock	11.46	11.5	11.43	11.43	14932.0
2017-01-13	ABEO	Stock	133.75	137.5	130.0	132.5	9112.0
2017-01-13	ABEV	Stock	5.22	5.31	5.18	5.31	17484600.0
2017-01-13	ABG	Stock	64.1	64.65	63.3	63.65	162500.0
2017-01-13	ABIL-DELISTED	Stock	3.24	3.45	3.24	3.45	17004.0
2017-01-13	ABM	Stock	40.02	41.0	40.02	40.47	314700.0
2017-01-13	ABMD-DELISTED	Stock	112.87	115.73	112.22	115.65	312811.0
2017-01-13	ABR	Stock	7.53	7.59	7.53	7.56	58200.0

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

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