PREVIEW / stock_daily / 2016-10-07

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-07.parquet
  size:    217 KB
  rows:    6,484
  symbols: 3,172

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
2016-10-07	AAPL	Stock	28.5775	28.64	28.3775	28.515	97433600.0
2016-10-07	MSFT	Stock	57.85	57.98	57.42	57.8	20089000.0
2016-10-07	NVDA	Stock	1.6948	1.6992	1.6665	1.6712	286260000.0
2016-10-07	AMZN	Stock	42.2895	42.2975	41.8725	41.9715	48524000.0
2016-10-07	GOOGL	Stock	40.2965	40.297	39.841	40.0355	23277980.0
2016-10-07	META	Stock	129.04	129.25	128.33	128.99	12804400.0
2016-10-07	TSLA	Stock	13.4	13.4213	13.0533	13.1073	52395000.0
2016-10-07	TLT	Stock	133.93	134.285	133.09	133.92	9953220.0
2016-10-07	ES	Stock	53.01	53.57	52.29	52.44	1509700.0
2016-10-07	CL	Stock	73.4	73.61	72.46	73.05	3315800.0
2016-10-07	A	Stock	47.33	47.49	46.99	47.38	1663100.0
2016-10-07	AA.B-DELISTED	Stock	33.86	33.9142	33.281	33.68	14911.0
2016-10-07	AAAP-DELISTED	Stock	38.5	39.61	38.0	38.8	294801.0
2016-10-07	AABA-DELISTED	Stock	43.29	43.68	43.12	43.21	7591556.0
2016-10-07	AAC-DELISTED	Stock	17.17	17.28	16.98	17.15	119367.0
2016-10-07	AACG	Stock	4.28	4.32	4.08	4.08	3900.0
2016-10-07	AAIC-DELISTED	Stock	14.31	14.43	14.111	14.19	167484.0
2016-10-07	AAL	Stock	38.25	38.48	37.4	37.73	5133200.0
2016-10-07	AAMC-DELISTED	Stock	6.65	7.8118	6.65	7.3651	214866.0
2016-10-07	AAME	Stock	3.35	3.35	3.33	3.33	3100.0
2016-10-07	AAMI	Stock	14.13	14.13	13.865	14.09	86000.0
2016-10-07	AAOI	Stock	23.05	23.1	22.62	22.72	162800.0
2016-10-07	AAON	Stock	20.4267	20.4267	19.6867	19.7267	410550.0
2016-10-07	AAP	Stock	149.39	149.67	147.23	148.13	396800.0
2016-10-07	AAT	Stock	40.85	41.14	40.43	40.65	102100.0
2016-10-07	AAU-DELISTED	Stock	1.24	1.28	1.19	1.22	293581.0
2016-10-07	AAUAF-DELISTED	Stock	1.24	1.28	1.19	1.22	296822.0
2016-10-07	AAV-DELISTED	Stock	7.45	7.45	7.11	7.231	119794.0
2016-10-07	AAWW-DELISTED	Stock	42.66	43.09	41.49	42.14	185592.0
2016-10-07	AAXJ	Stock	60.94	61.04	60.37	60.75	909007.0
2016-10-07	AAXN-DELISTED	Stock	23.16	23.21	22.42	22.425	1243001.0
2016-10-07	AB	Stock	22.61	22.61	22.1	22.52	121100.0
2016-10-07	ABAC-DELISTED	Stock	2.04	2.1	2.04	2.09	622.0
2016-10-07	ABAX-DELISTED	Stock	52.36	52.7	51.87	52.53	60056.0
2016-10-07	ABB-DELISTED	Stock	22.88	22.893	22.575	22.71	1737534.0
2016-10-07	ABBNY-DELISTED	Stock	22.88	22.893	22.575	22.72	1784117.0
2016-10-07	ABBV	Stock	63.1	63.58	62.5	62.93	3812700.0
2016-10-07	ABC-DELISTED	Stock	80.43	80.55	78.7	79.4	1648710.0
2016-10-07	ABCB	Stock	35.67	35.69	35.31	35.61	102900.0
2016-10-07	ABCD-DELISTED	Stock	5.44	5.44	5.35	5.37	5504.0
2016-10-07	ABCO-DELISTED	Stock	43.01	43.1	42.5251	42.6	126736.0
2016-10-07	ABDC-DELISTED	Stock	12.8	12.86	12.44	12.45	82967.0
2016-10-07	ABE-DELISTED	Stock	12.56	12.6299	12.47	12.6259	26611.0
2016-10-07	ABEO	Stock	163.25	179.75	160.25	169.75	28328.0
2016-10-07	ABEOW-DELISTED	Stock	3.7	3.833	3.5992	3.77	9724.0
2016-10-07	ABEV	Stock	6.13	6.13	6.01	6.06	14275300.0
2016-10-07	ABG	Stock	55.16	55.31	53.64	54.02	196500.0
2016-10-07	ABIL-DELISTED	Stock	3.739	3.8	3.66	3.8	11714.0
2016-10-07	ABM	Stock	39.26	39.3	38.53	38.78	222200.0
2016-10-07	ABMD-DELISTED	Stock	128.58	129.54	126.53	128.5	297688.0

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

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