PREVIEW / stock_daily / 2015-08-26

all stock daily files

  file:    by_date/stock_daily/2015/2015-08-26.parquet
  size:    222 KB
  rows:    6,687
  symbols: 3,472

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-26	AAPL	Stock	26.7725	27.4725	26.2625	27.4225	387098400.0
2015-08-26	MSFT	Stock	42.01	42.84	41.06	42.71	63408000.0
2015-08-26	NVDA	Stock	0.5235	0.5458	0.5195	0.5452	614976000.0
2015-08-26	AMZN	Stock	24.201	25.186	23.938	25.0385	127172000.0
2015-08-26	GOOGL	Stock	32.155	33.124	31.5185	32.987	87739700.0
2015-08-26	META	Stock	85.95	87.46	83.26	87.19	45124300.0
2015-08-26	TSLA	Stock	15.1953	15.2	14.3673	14.9893	74445000.0
2015-08-26	TLT	Stock	123.0	123.51	121.36	121.93	16429934.0
2015-08-26	ES	Stock	47.6	48.19	47.06	48.08	1617400.0
2015-08-26	CL	Stock	61.53	62.4	60.54	62.23	5329000.0
2015-08-26	A	Stock	35.36	35.7	34.47	35.62	3233800.0
2015-08-26	AA.B-DELISTED	Stock	32.36	32.36	31.12	31.54	77348.0
2015-08-26	AABA-DELISTED	Stock	32.45	32.62	31.11	32.52	24014394.0
2015-08-26	AAC-DELISTED	Stock	21.61	22.5	19.94	21.61	684647.0
2015-08-26	AACG	Stock	2.33	2.38	2.25	2.25	15800.0
2015-08-26	AAIC-DELISTED	Stock	16.41	16.47	15.94	16.31	354486.0
2015-08-26	AAL	Stock	38.77	39.01	36.97	38.85	15679800.0
2015-08-26	AAMC-DELISTED	Stock	9.5147	10.0884	8.7059	9.8235	127327.0
2015-08-26	AAME	Stock	3.6	3.6	3.38	3.38	2600.0
2015-08-26	AAMI	Stock	15.49	16.27	15.34	16.22	330600.0
2015-08-26	AAOI	Stock	19.55	19.73	18.945	19.7	434500.0
2015-08-26	AAON	Stock	13.54	13.5733	13.24	13.42	424650.0
2015-08-26	AAP	Stock	173.94	174.47	169.13	171.46	2015800.0
2015-08-26	AAT	Stock	38.78	39.08	38.0	38.88	199700.0
2015-08-26	AAU-DELISTED	Stock	0.539	0.541	0.5	0.5	61849.0
2015-08-26	AAUAF-DELISTED	Stock	0.538	0.54	0.5	0.5	62563.0
2015-08-26	AAV-DELISTED	Stock	4.86	5.06	4.81	5.03	189082.0
2015-08-26	AAVL-DELISTED	Stock	10.31	10.53	9.79	10.52	391997.0
2015-08-26	AAWW-DELISTED	Stock	40.07	40.21	38.76	39.46	560070.0
2015-08-26	AAXJ	Stock	51.87	52.37	50.97	52.31	4026901.0
2015-08-26	AAXN-DELISTED	Stock	21.88	22.83	21.365	22.36	2724229.0
2015-08-26	AB	Stock	25.92	26.61	25.52	26.48	233300.0
2015-08-26	ABAC-DELISTED	Stock	0.7099	0.7393	0.6999	0.7392	5927.0
2015-08-26	ABAX-DELISTED	Stock	47.24	47.24	46.08	46.98	141915.0
2015-08-26	ABB-DELISTED	Stock	19.05	19.08	18.68	19.08	2789071.0
2015-08-26	ABBNY-DELISTED	Stock	19.05	19.08	18.68	19.07	2864642.0
2015-08-26	ABBV	Stock	62.47	63.22	60.88	63.14	15289600.0
2015-08-26	ABC-DELISTED	Stock	99.39	100.86	97.05	100.62	2226623.0
2015-08-26	ABCB	Stock	26.72	26.92	25.94	26.62	169300.0
2015-08-26	ABCD-DELISTED	Stock	4.99	4.99	4.88	4.955	98048.0
2015-08-26	ABCO-DELISTED	Stock	50.43	50.43	48.45	49.66	303877.0
2015-08-26	ABCW-DELISTED	Stock	39.86	39.97	38.58	39.895	10983.0
2015-08-26	ABDC-DELISTED	Stock	11.8	12.035	11.24	11.81	92933.0
2015-08-26	ABE-DELISTED	Stock	10.95	10.95	10.58	10.65	13231.0
2015-08-26	ABEO	Stock	112.5	115.25	110.0	114.5	6588.0
2015-08-26	ABEOW-DELISTED	Stock	2.0	2.0	1.62	1.6737	3116.0
2015-08-26	ABEV	Stock	5.1	5.24	5.08	5.22	22391300.0
2015-08-26	ABG	Stock	79.75	79.88	77.04	79.02	288000.0
2015-08-26	ABGB-DELISTED	Stock	6.38	6.58	5.9062	6.2	444685.0
2015-08-26	ABIL-DELISTED	Stock	10.05	10.05	10.05	10.05	200.0

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

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