PREVIEW / stock_daily / 2017-01-23

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-23.parquet
  size:    216 KB
  rows:    6,500
  symbols: 3,104

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-23	AAPL	Stock	30.0	30.2025	29.9425	30.02	88200800.0
2017-01-23	MSFT	Stock	62.7	63.12	62.57	62.96	23097600.0
2017-01-23	NVDA	Stock	2.595	2.6475	2.5925	2.6272	369904000.0
2017-01-23	AMZN	Stock	40.34	40.925	40.254	40.894	55950000.0
2017-01-23	GOOGL	Stock	41.5805	42.2771	41.435	42.2215	49147540.0
2017-01-23	META	Stock	127.31	129.25	126.95	128.93	16593600.0
2017-01-23	TSLA	Stock	16.39	16.726	16.3667	16.5947	93943500.0
2017-01-23	TLT	Stock	120.34	121.87	120.02	121.14	13118414.0
2017-01-23	ES	Stock	55.17	55.37	54.71	54.74	1913900.0
2017-01-23	CL	Stock	67.7	67.88	67.52	67.55	2872900.0
2017-01-23	A	Stock	47.6	47.83	47.23	47.39	2013900.0
2017-01-23	AA	Stock	35.92	36.395	35.455	36.29	5245000.0
2017-01-23	AAAP-DELISTED	Stock	28.65	28.95	28.09	28.95	60688.0
2017-01-23	AABA-DELISTED	Stock	41.86	42.45	41.84	42.4	12385669.0
2017-01-23	AAC-DELISTED	Stock	8.04	8.04	7.87	7.94	77974.0
2017-01-23	AACG	Stock	3.2	3.2	3.08	3.1	13200.0
2017-01-23	AAIC-DELISTED	Stock	15.14	15.33	15.051	15.32	232846.0
2017-01-23	AAL	Stock	47.9	48.09	46.75	46.94	4284200.0
2017-01-23	AAMC-DELISTED	Stock	20.7794	20.8235	16.6324	18.5294	74953.0
2017-01-23	AAME	Stock	3.85	3.85	3.85	3.85	1300.0
2017-01-23	AAMI	Stock	14.46	14.62	14.41	14.46	339900.0
2017-01-23	AAOI	Stock	30.58	31.39	30.01	31.29	410300.0
2017-01-23	AAON	Stock	21.6667	21.9333	21.6333	21.8667	173850.0
2017-01-23	AAP	Stock	167.08	168.63	164.27	167.78	1416800.0
2017-01-23	AAT	Stock	43.15	43.96	43.04	43.81	145300.0
2017-01-23	AAU-DELISTED	Stock	1.03	1.03	1.0	1.03	236029.0
2017-01-23	AAUAF-DELISTED	Stock	1.03	1.03	1.0	1.03	237934.0
2017-01-23	AAV-DELISTED	Stock	6.4	6.4	6.15	6.275	96083.0
2017-01-23	AAWW-DELISTED	Stock	50.35	51.3	50.15	50.3	83867.0
2017-01-23	AAXJ	Stock	57.74	58.13	57.74	58.07	619076.0
2017-01-23	AAXN-DELISTED	Stock	24.8	24.98	24.67	24.81	301335.0
2017-01-23	AB	Stock	23.1	23.3	23.05	23.1	181000.0
2017-01-23	ABAC-DELISTED	Stock	3.57	3.6	3.52	3.5631	1050.0
2017-01-23	ABAX-DELISTED	Stock	48.41	48.41	47.63	48.27	115312.0
2017-01-23	ABB-DELISTED	Stock	22.74	22.81	22.625	22.79	1577568.0
2017-01-23	ABBNY-DELISTED	Stock	22.74	22.81	22.625	22.78	1621864.0
2017-01-23	ABBV	Stock	61.02	61.26	60.68	60.96	5244700.0
2017-01-23	ABC-DELISTED	Stock	83.72	85.1	83.31	84.89	1163440.0
2017-01-23	ABCB	Stock	43.0	43.45	42.54	43.2	195200.0
2017-01-23	ABCD-DELISTED	Stock	5.2	5.32	5.19	5.235	33129.0
2017-01-23	ABCO-DELISTED	Stock	42.6	43.075	42.0	42.85	758164.0
2017-01-23	ABDC-DELISTED	Stock	12.5	12.5535	12.26	12.26	43290.0
2017-01-23	ABE-DELISTED	Stock	11.49	11.67	11.49	11.61	17495.0
2017-01-23	ABEO	Stock	123.75	126.25	116.25	122.5	7420.0
2017-01-23	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	100.0
2017-01-23	ABEV	Stock	5.42	5.49	5.38	5.48	9669500.0
2017-01-23	ABG	Stock	63.55	64.2	62.85	63.35	230600.0
2017-01-23	ABIL-DELISTED	Stock	3.3	3.3899	3.21	3.26	11037.0
2017-01-23	ABM	Stock	39.68	39.99	39.2	39.46	337900.0
2017-01-23	ABMD-DELISTED	Stock	111.6	112.6	110.26	111.57	306898.0

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

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