PREVIEW / stock_daily / 2016-07-26

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-26.parquet
  size:    220 KB
  rows:    6,558
  symbols: 3,252

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-07-26	AAPL	Stock	24.205	24.4925	24.105	24.1675	224959200.0
2016-07-26	MSFT	Stock	56.52	57.29	56.51	56.76	28079000.0
2016-07-26	NVDA	Stock	1.4043	1.423	1.4023	1.4158	514508000.0
2016-07-26	AMZN	Stock	37.1355	37.1565	36.6375	36.7795	50594000.0
2016-07-26	GOOGL	Stock	37.876	37.963	37.6375	37.8825	23791460.0
2016-07-26	META	Stock	122.0	122.07	120.75	121.22	17612000.0
2016-07-26	TSLA	Stock	15.1793	15.3333	15.02	15.3007	51450000.0
2016-07-26	TLT	Stock	139.52	139.52	138.46	138.92	5243406.0
2016-07-26	ES	Stock	58.87	58.92	58.17	58.31	1048700.0
2016-07-26	CL	Stock	74.04	74.64	73.8	73.98	2145600.0
2016-07-26	A	Stock	46.21	46.95	45.79	46.95	1792700.0
2016-07-26	AA.B-DELISTED	Stock	35.5	36.4	35.5	36.24	65489.0
2016-07-26	AAAP-DELISTED	Stock	31.3	31.55	30.78	30.82	65705.0
2016-07-26	AABA-DELISTED	Stock	38.21	38.83	37.9	38.77	14108373.0
2016-07-26	AAC-DELISTED	Stock	22.7	22.86	22.14	22.71	37503.0
2016-07-26	AACG	Stock	3.82	3.82	3.56	3.72	14800.0
2016-07-26	AAIC-DELISTED	Stock	13.37	13.54	13.37	13.48	168828.0
2016-07-26	AAL	Stock	35.91	36.68	35.65	36.55	8871200.0
2016-07-26	AAMC-DELISTED	Stock	4.1382	4.2176	3.9118	3.9441	84446.0
2016-07-26	AAME	Stock	3.95	3.96	3.95	3.96	600.0
2016-07-26	AAMI	Stock	13.84	14.06	13.69	13.85	110700.0
2016-07-26	AAOI	Stock	12.36	12.79	12.36	12.67	253000.0
2016-07-26	AAON	Stock	17.6933	17.8667	17.6067	17.7267	118650.0
2016-07-26	AAP	Stock	166.94	168.12	165.67	166.23	878000.0
2016-07-26	AAT	Stock	45.54	45.56	45.17	45.56	177600.0
2016-07-26	AAU-DELISTED	Stock	1.34	1.36	1.32	1.33	296376.0
2016-07-26	AAUAF-DELISTED	Stock	1.34	1.36	1.32	1.32	299876.0
2016-07-26	AAV-DELISTED	Stock	6.17	6.41	6.17	6.375	58390.0
2016-07-26	AAWW-DELISTED	Stock	41.74	42.47	41.29	41.75	133715.0
2016-07-26	AAXJ	Stock	57.2	57.47	57.15	57.38	427545.0
2016-07-26	AAXN-DELISTED	Stock	28.68	28.9165	28.389	28.66	606701.0
2016-07-26	AB	Stock	24.55	24.64	23.98	24.11	163700.0
2016-07-26	ABAC-DELISTED	Stock	0.74	0.7999	0.74	0.74	21465.0
2016-07-26	ABAX-DELISTED	Stock	47.72	49.23	47.21	48.74	224044.0
2016-07-26	ABB-DELISTED	Stock	20.84	20.99	20.78	20.98	1342669.0
2016-07-26	ABBNY-DELISTED	Stock	20.84	20.99	20.78	20.97	1391555.0
2016-07-26	ABBV	Stock	64.41	64.73	63.96	64.45	4885200.0
2016-07-26	ABC-DELISTED	Stock	85.28	86.04	84.62	85.72	1440102.0
2016-07-26	ABCB	Stock	32.55	33.13	32.39	33.04	260100.0
2016-07-26	ABCD-DELISTED	Stock	4.95	4.95	4.85	4.86	3268.0
2016-07-26	ABCO-DELISTED	Stock	37.81	38.28	37.39	37.56	235200.0
2016-07-26	ABDC-DELISTED	Stock	12.2	12.2	12.15	12.18	15809.0
2016-07-26	ABE-DELISTED	Stock	12.52	12.52	12.52	12.52	100.0
2016-07-26	ABEO	Stock	63.75	65.0	63.25	63.5	1964.0
2016-07-26	ABEV	Stock	5.86	5.94	5.86	5.89	6192100.0
2016-07-26	ABG	Stock	60.97	62.09	59.94	61.44	208300.0
2016-07-26	ABIL-DELISTED	Stock	4.31	4.45	4.3	4.32	31273.0
2016-07-26	ABM	Stock	37.07	37.62	37.07	37.52	177100.0
2016-07-26	ABMD-DELISTED	Stock	114.2	114.96	114.05	114.26	751844.0
2016-07-26	ABR	Stock	7.11	7.15	7.06	7.07	40500.0

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

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