PREVIEW / stock_daily / 2015-08-31

all stock daily files

  file:    by_date/stock_daily/2015/2015-08-31.parquet
  size:    223 KB
  rows:    6,682
  symbols: 3,469

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
2015-08-31	AAPL	Stock	28.0075	28.6325	28.0	28.19	224917200.0
2015-08-31	MSFT	Stock	43.56	43.93	43.1	43.52	34441700.0
2015-08-31	NVDA	Stock	0.5655	0.5695	0.5598	0.562	219352000.0
2015-08-31	AMZN	Stock	25.822	25.9705	25.4535	25.6445	60046000.0
2015-08-31	GOOGL	Stock	32.717	33.2205	32.3175	32.391	38936880.0
2015-08-31	META	Stock	90.6	91.05	88.89	89.43	32850700.0
2015-08-31	TSLA	Stock	16.3747	16.9967	16.3673	16.604	70503000.0
2015-08-31	TLT	Stock	123.36	123.47	121.34	121.42	8617562.0
2015-08-31	ES	Stock	48.12	48.29	46.89	47.24	2731700.0
2015-08-31	CL	Stock	62.88	63.05	62.4	62.81	3634600.0
2015-08-31	A	Stock	36.44	36.55	35.95	36.31	2554700.0
2015-08-31	AA.B-DELISTED	Stock	34.95	35.36	34.56	35.0	61240.0
2015-08-31	AABA-DELISTED	Stock	32.88	32.99	32.23	32.24	12566392.0
2015-08-31	AAC-DELISTED	Stock	22.29	24.75	22.0244	23.6399	403775.0
2015-08-31	AACG	Stock	2.45	2.48	2.34	2.4	5600.0
2015-08-31	AAIC-DELISTED	Stock	16.59	16.77	16.33	16.65	205250.0
2015-08-31	AAL	Stock	38.63	39.76	38.62	38.98	12409600.0
2015-08-31	AAMC-DELISTED	Stock	10.5882	11.8235	10.15	11.3206	50391.0
2015-08-31	AAME	Stock	3.65	3.65	3.47	3.6	1800.0
2015-08-31	AAMI	Stock	16.25	16.55	16.23	16.52	249700.0
2015-08-31	AAOI	Stock	21.0	21.21	20.51	20.61	422900.0
2015-08-31	AAON	Stock	13.62	13.88	13.6067	13.7867	189450.0
2015-08-31	AAP	Stock	175.91	176.99	174.3	175.25	950000.0
2015-08-31	AAT	Stock	39.29	39.56	38.44	38.52	253100.0
2015-08-31	AAU-DELISTED	Stock	0.54	0.55	0.53	0.54	34165.0
2015-08-31	AAUAF-DELISTED	Stock	0.54	0.55	0.53	0.54	34608.0
2015-08-31	AAV-DELISTED	Stock	5.26	5.6	5.21	5.57	213545.0
2015-08-31	AAVL-DELISTED	Stock	10.67	10.91	10.345	10.46	318726.0
2015-08-31	AAWW-DELISTED	Stock	41.31	41.8	41.18	41.28	228873.0
2015-08-31	AAXJ	Stock	53.33	53.535	52.94	53.34	2275204.0
2015-08-31	AAXN-DELISTED	Stock	23.45	23.8331	23.3	23.41	1105555.0
2015-08-31	AB	Stock	27.06	27.64	27.0	27.34	232400.0
2015-08-31	ABAC-DELISTED	Stock	0.7101	0.786	0.7101	0.786	3100.0
2015-08-31	ABAX-DELISTED	Stock	47.58	48.365	46.93	46.99	102212.0
2015-08-31	ABB-DELISTED	Stock	19.12	19.37	19.065	19.31	1234330.0
2015-08-31	ABBNY-DELISTED	Stock	19.12	19.37	19.065	19.31	1276612.0
2015-08-31	ABBV	Stock	64.14	64.31	62.25	62.41	15581100.0
2015-08-31	ABC-DELISTED	Stock	100.87	101.84	95.61	100.045	1162362.0
2015-08-31	ABCB	Stock	26.67	27.42	26.64	27.27	145300.0
2015-08-31	ABCD-DELISTED	Stock	5.34	5.4	5.06	5.21	239770.0
2015-08-31	ABCO-DELISTED	Stock	49.72	49.87	48.57	48.65	182214.0
2015-08-31	ABCW-DELISTED	Stock	40.5	41.15	40.141	40.91	10524.0
2015-08-31	ABDC-DELISTED	Stock	12.88	13.1699	12.6	12.9801	47073.0
2015-08-31	ABE-DELISTED	Stock	11.09	11.1815	11.0745	11.1815	1422.0
2015-08-31	ABEO	Stock	118.75	124.0	115.75	116.75	7668.0
2015-08-31	ABEOW-DELISTED	Stock	2.0	2.0	1.8	1.8	3545.0
2015-08-31	ABEV	Stock	5.06	5.29	5.03	5.27	18225600.0
2015-08-31	ABG	Stock	80.51	81.97	80.01	80.57	401300.0
2015-08-31	ABGB-DELISTED	Stock	5.82	5.99	5.81	5.82	71391.0
2015-08-31	ABM	Stock	31.79	32.17	31.66	32.01	262700.0

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

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