PREVIEW / stock_daily / 2017-08-23

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-23.parquet
  size:    213 KB
  rows:    6,415
  symbols: 2,924

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-08-23	AAPL	Stock	39.7675	40.1175	39.72	39.995	77596400.0
2017-08-23	MSFT	Stock	72.96	73.15	72.53	72.72	13766500.0
2017-08-23	NVDA	Stock	4.03	4.1562	4.0212	4.145	579520000.0
2017-08-23	AMZN	Stock	47.969	48.1	47.71	47.9	53366000.0
2017-08-23	GOOGL	Stock	46.85	47.2712	46.762	47.129	22689280.0
2017-08-23	META	Stock	168.84	169.36	168.2	168.71	9856500.0
2017-08-23	TSLA	Stock	22.5993	23.566	22.5533	23.518	74317500.0
2017-08-23	TLT	Stock	127.04	127.31	126.76	127.3	7446363.0
2017-08-23	ES	Stock	62.94	63.19	62.76	63.14	1531600.0
2017-08-23	CL	Stock	71.5	71.5	71.06	71.22	2148100.0
2017-08-23	A	Stock	62.72	63.37	62.6	62.77	1445700.0
2017-08-23	AA	Stock	39.56	41.44	39.45	41.06	4827300.0
2017-08-23	AAAP-DELISTED	Stock	48.94	49.05	48.5359	49.0	20183.0
2017-08-23	AABA-DELISTED	Stock	65.01	66.0	64.64	65.81	3140185.0
2017-08-23	AAC-DELISTED	Stock	9.1	9.142	8.84	8.93	43826.0
2017-08-23	AACG	Stock	4.74	4.8	4.62	4.79	1400.0
2017-08-23	AAIC-DELISTED	Stock	12.9	13.05	12.89	12.95	260477.0
2017-08-23	AAL	Stock	45.17	45.24	43.52	43.97	8159200.0
2017-08-23	AAM.A-DELISTED	Stock	26.03	26.37	26.03	26.13	18938.0
2017-08-23	AAMC-DELISTED	Stock	22.9412	24.0484	22.9412	24.0484	9972.0
2017-08-23	AAME	Stock	3.4	3.4	3.4	3.4	400.0
2017-08-23	AAMI	Stock	13.52	13.62	13.485	13.52	293100.0
2017-08-23	AAOI	Stock	60.29	64.25	60.121	63.51	2280600.0
2017-08-23	AAON	Stock	21.4333	21.4333	21.1667	21.2333	100800.0
2017-08-23	AAP	Stock	95.29	95.96	93.1	93.54	1775600.0
2017-08-23	AAT	Stock	39.83	40.59	39.81	40.16	173400.0
2017-08-23	AAU-DELISTED	Stock	1.12	1.14	1.08	1.12	212537.0
2017-08-23	AAUAF-DELISTED	Stock	1.12	1.14	1.08	1.12	214415.0
2017-08-23	AAV-DELISTED	Stock	6.3	6.5	6.3	6.45	39175.0
2017-08-23	AAWW-DELISTED	Stock	63.15	63.85	62.6233	63.05	187365.0
2017-08-23	AAXJ	Stock	71.13	71.55	71.11	71.47	369146.0
2017-08-23	AAXN-DELISTED	Stock	21.58	21.99	21.45	21.66	593491.0
2017-08-23	AB	Stock	23.25	23.75	23.25	23.55	226200.0
2017-08-23	ABAC-DELISTED	Stock	2.061	2.19	2.061	2.19	6690.0
2017-08-23	ABAX-DELISTED	Stock	46.26	46.5	45.8	46.15	96442.0
2017-08-23	ABB-DELISTED	Stock	23.15	23.19	23.09	23.13	1099977.0
2017-08-23	ABBNY-DELISTED	Stock	23.15	23.19	23.09	23.13	1134175.0
2017-08-23	ABBV	Stock	71.29	71.9	71.27	71.52	3071300.0
2017-08-23	ABC-DELISTED	Stock	78.98	79.0	77.96	78.14	1273783.0
2017-08-23	ABCB	Stock	43.3	44.25	43.3	43.7	67300.0
2017-08-23	ABCD-DELISTED	Stock	5.11	5.27	5.06	5.15	48678.0
2017-08-23	ABCO-DELISTED	Stock	51.4	51.7	51.05	51.4	588372.0
2017-08-23	ABDC-DELISTED	Stock	10.39	10.64	10.34	10.46	59787.0
2017-08-23	ABE-DELISTED	Stock	13.8	14.14	13.8	14.13	2092.0
2017-08-23	ABEO	Stock	200.0	223.75	199.5	218.75	31904.0
2017-08-23	ABEOW-DELISTED	Stock	4.4799	4.4999	4.348	4.348	1908.0
2017-08-23	ABEV	Stock	6.23	6.3	6.2	6.29	10100900.0
2017-08-23	ABG	Stock	51.05	51.65	50.8	50.9	202100.0
2017-08-23	ABIL-DELISTED	Stock	0.6107	0.79	0.5828	0.66	268630.0
2017-08-23	ABM	Stock	43.45	43.88	43.45	43.72	117200.0

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

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