PREVIEW / stock_daily / 2017-01-24

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-24.parquet
  size:    216 KB
  rows:    6,483
  symbols: 3,086

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-24	AAPL	Stock	29.8875	30.025	29.875	29.9925	92844000.0
2017-01-24	MSFT	Stock	63.2	63.74	62.94	63.52	24672900.0
2017-01-24	NVDA	Stock	2.6375	2.6895	2.6225	2.6832	428052000.0
2017-01-24	AMZN	Stock	41.1	41.1995	40.725	41.122	59434000.0
2017-01-24	GOOGL	Stock	42.349	42.576	42.114	42.4765	33767500.0
2017-01-24	META	Stock	129.38	129.9	128.38	129.37	15162700.0
2017-01-24	TSLA	Stock	16.6667	16.9867	16.6433	16.974	74482500.0
2017-01-24	TLT	Stock	120.77	121.1263	119.8	120.31	8394978.0
2017-01-24	ES	Stock	54.7	54.92	54.41	54.55	1220200.0
2017-01-24	CL	Stock	67.67	68.35	67.64	68.26	2786300.0
2017-01-24	A	Stock	47.77	48.21	47.05	47.35	2741900.0
2017-01-24	AA	Stock	37.18	38.38	37.18	37.5	11911100.0
2017-01-24	AAAP-DELISTED	Stock	28.8	29.27	28.71	29.26	26508.0
2017-01-24	AABA-DELISTED	Stock	43.65	44.22	43.43	43.89	23639717.0
2017-01-24	AAC-DELISTED	Stock	8.0	8.307	7.83	8.16	60434.0
2017-01-24	AACG	Stock	3.11	3.12	2.98	2.98	10900.0
2017-01-24	AAIC-DELISTED	Stock	15.31	15.375	15.15	15.34	277896.0
2017-01-24	AAL	Stock	47.05	47.8	46.8	47.54	4926700.0
2017-01-24	AAMC-DELISTED	Stock	18.3235	19.3235	17.8382	18.7941	14297.0
2017-01-24	AAME	Stock	3.85	3.95	3.85	3.88	10900.0
2017-01-24	AAMI	Stock	14.44	14.71	14.34	14.6	332100.0
2017-01-24	AAOI	Stock	31.25	32.56	31.08	32.0	758100.0
2017-01-24	AAON	Stock	22.0	22.6667	22.0	22.6	162300.0
2017-01-24	AAP	Stock	168.8	170.98	167.78	168.29	882400.0
2017-01-24	AAT	Stock	43.77	44.02	43.41	43.98	116800.0
2017-01-24	AAU-DELISTED	Stock	1.04	1.04	1.0	1.01	229918.0
2017-01-24	AAUAF-DELISTED	Stock	1.04	1.04	1.0	1.01	232517.0
2017-01-24	AAV-DELISTED	Stock	6.3	6.575	6.3	6.5	86769.0
2017-01-24	AAWW-DELISTED	Stock	50.5	51.95	50.5	51.85	141794.0
2017-01-24	AAXJ	Stock	58.34	58.6556	58.34	58.47	492600.0
2017-01-24	AAXN-DELISTED	Stock	24.84	25.45	24.82	25.18	414085.0
2017-01-24	AB	Stock	23.2	23.6	23.15	23.4	204400.0
2017-01-24	ABAC-DELISTED	Stock	3.6	3.75	3.4	3.75	14433.0
2017-01-24	ABAX-DELISTED	Stock	48.3	48.3	47.34	47.84	136581.0
2017-01-24	ABB-DELISTED	Stock	22.87	23.01	22.86	22.96	1697130.0
2017-01-24	ABBNY-DELISTED	Stock	22.87	23.01	22.86	22.95	1745201.0
2017-01-24	ABBV	Stock	60.91	60.93	59.67	60.58	6642000.0
2017-01-24	ABC-DELISTED	Stock	84.7	85.19	84.06	84.41	1297457.0
2017-01-24	ABCB	Stock	43.4	44.35	43.35	44.3	266700.0
2017-01-24	ABCD-DELISTED	Stock	5.22	5.39	5.22	5.27	114996.0
2017-01-24	ABCO-DELISTED	Stock	42.9	43.5	42.45	43.45	514488.0
2017-01-24	ABDC-DELISTED	Stock	12.4	12.4	12.1	12.2	40371.0
2017-01-24	ABE-DELISTED	Stock	11.66	11.75	11.66	11.71	8200.0
2017-01-24	ABEO	Stock	122.5	123.75	116.25	120.0	5316.0
2017-01-24	ABEOW-DELISTED	Stock	3.15	3.15	3.02	3.035	500.0
2017-01-24	ABEV	Stock	5.4	5.47	5.39	5.43	12787000.0
2017-01-24	ABG	Stock	63.95	65.8	63.55	65.5	200400.0
2017-01-24	ABIL-DELISTED	Stock	3.2	3.3	3.17	3.23	22179.0
2017-01-24	ABM	Stock	39.4	40.67	39.4	40.48	405900.0
2017-01-24	ABMD-DELISTED	Stock	111.82	112.6	110.45	112.25	246309.0

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

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