PREVIEW / stock_daily / 2017-08-16

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-16.parquet
  size:    214 KB
  rows:    6,448
  symbols: 2,951

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-16	AAPL	Stock	40.485	40.6275	40.0375	40.2375	110686400.0
2017-08-16	MSFT	Stock	73.34	74.1	73.17	73.65	18150400.0
2017-08-16	NVDA	Stock	4.1898	4.2135	4.096	4.1288	596632000.0
2017-08-16	AMZN	Stock	49.0825	49.323	48.661	48.909	62642000.0
2017-08-16	GOOGL	Stock	47.0625	47.495	47.002	47.2135	26905220.0
2017-08-16	META	Stock	171.25	171.38	169.24	170.0	15779900.0
2017-08-16	TSLA	Stock	24.2	24.4333	24.168	24.194	51207000.0
2017-08-16	TLT	Stock	124.83	126.02	124.805	125.71	5283779.0
2017-08-16	ES	Stock	62.6	62.88	62.36	62.8	836100.0
2017-08-16	CL	Stock	71.79	72.0	71.51	71.93	2258600.0
2017-08-16	A	Stock	62.15	62.42	60.76	62.14	6892000.0
2017-08-16	AA	Stock	37.96	39.33	37.91	39.23	4301900.0
2017-08-16	AAAP-DELISTED	Stock	50.0	50.0	49.25	49.61	16242.0
2017-08-16	AABA-DELISTED	Stock	60.43	60.85	60.21	60.64	6061389.0
2017-08-16	AAC-DELISTED	Stock	8.76	8.98	8.518	8.69	99313.0
2017-08-16	AACG	Stock	4.7	4.74	4.61	4.7	14100.0
2017-08-16	AAIC-DELISTED	Stock	13.11	13.24	13.105	13.16	469991.0
2017-08-16	AAL	Stock	48.64	48.73	48.27	48.41	4187300.0
2017-08-16	AAM.A-DELISTED	Stock	25.98	26.1	25.95	25.99	36717.0
2017-08-16	AAMC-DELISTED	Stock	21.5	22.7941	21.4706	21.9118	22821.0
2017-08-16	AAME	Stock	3.35	3.35	3.35	3.35	200.0
2017-08-16	AAMI	Stock	13.83	13.91	13.69	13.72	231400.0
2017-08-16	AAOI	Stock	67.88	68.17	64.8	65.79	3373100.0
2017-08-16	AAON	Stock	21.9333	22.0	21.6	21.6	244650.0
2017-08-16	AAP	Stock	86.56	92.85	86.55	91.51	6530800.0
2017-08-16	AAT	Stock	40.69	40.88	40.53	40.69	129300.0
2017-08-16	AAU-DELISTED	Stock	1.06	1.1211	1.06	1.115	163012.0
2017-08-16	AAUAF-DELISTED	Stock	1.06	1.1211	1.06	1.12	172412.0
2017-08-16	AAV-DELISTED	Stock	6.25	6.35	6.25	6.3	39169.0
2017-08-16	AAWW-DELISTED	Stock	62.9	63.1	61.9	62.2	155596.0
2017-08-16	AAXJ	Stock	70.47	70.72	70.47	70.7	364633.0
2017-08-16	AAXN-DELISTED	Stock	21.65	21.8	21.34	21.67	619848.0
2017-08-16	AB	Stock	23.8	23.95	23.55	23.6	158900.0
2017-08-16	ABAC-DELISTED	Stock	2.1151	2.1151	1.9901	2.05	11538.0
2017-08-16	ABAX-DELISTED	Stock	46.9	47.85	46.76	47.27	62946.0
2017-08-16	ABB-DELISTED	Stock	23.04	23.26	23.04	23.22	2288559.0
2017-08-16	ABBNY-DELISTED	Stock	23.04	23.26	23.04	23.21	2824395.0
2017-08-16	ABBV	Stock	70.49	70.75	70.11	70.42	4751600.0
2017-08-16	ABC-DELISTED	Stock	80.29	80.58	79.5307	80.03	1399010.0
2017-08-16	ABCB	Stock	45.0	45.25	44.6	45.0	122000.0
2017-08-16	ABCD-DELISTED	Stock	5.0	5.1599	5.0	5.13	43799.0
2017-08-16	ABCO-DELISTED	Stock	51.7	51.95	51.525	51.85	323014.0
2017-08-16	ABDC-DELISTED	Stock	10.82	10.9326	10.71	10.8	55978.0
2017-08-16	ABE-DELISTED	Stock	13.84	13.8444	13.84	13.8444	344.0
2017-08-16	ABEO	Stock	203.75	221.0	199.0	212.5	27332.0
2017-08-16	ABEOW-DELISTED	Stock	4.3881	4.5	4.25	4.4152	1450.0
2017-08-16	ABEV	Stock	6.21	6.26	6.17	6.23	15237300.0
2017-08-16	ABG	Stock	51.6	51.8	51.0	51.2	193700.0
2017-08-16	ABIL-DELISTED	Stock	0.64	0.7201	0.6343	0.6799	48929.0
2017-08-16	ABM	Stock	43.84	44.14	43.56	44.04	213100.0

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

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