PREVIEW / stock_daily / 2016-07-18

all stock daily files

  file:    by_date/stock_daily/2016/2016-07-18.parquet
  size:    219 KB
  rows:    6,555
  symbols: 3,257

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-18	AAPL	Stock	24.675	25.0325	24.65	24.9575	145975600.0
2016-07-18	MSFT	Stock	53.7	54.34	53.55	53.96	31433900.0
2016-07-18	NVDA	Stock	1.3338	1.3358	1.3193	1.3243	252992000.0
2016-07-18	AMZN	Stock	36.7745	37.08	36.436	36.8035	59098000.0
2016-07-18	GOOGL	Stock	36.8955	37.7568	36.8255	37.66	38698000.0
2016-07-18	META	Stock	117.32	119.61	116.89	119.37	20868400.0
2016-07-18	TSLA	Stock	14.6427	15.1393	14.5533	15.0833	51181500.0
2016-07-18	TLT	Stock	139.07	139.26	137.73	138.26	5955878.0
2016-07-18	ES	Stock	57.93	58.36	57.79	58.13	1236300.0
2016-07-18	CL	Stock	74.78	74.92	74.44	74.5	2675800.0
2016-07-18	A	Stock	46.6	46.88	46.34	46.8	1362900.0
2016-07-18	AA.B-DELISTED	Stock	36.99	37.33	36.7	37.2	19355.0
2016-07-18	AAAP-DELISTED	Stock	30.7	30.86	30.5	30.5	39731.0
2016-07-18	AABA-DELISTED	Stock	37.68	37.97	37.5	37.95	14829537.0
2016-07-18	AAC-DELISTED	Stock	23.13	23.15	22.92	23.02	76089.0
2016-07-18	AACG	Stock	4.3	4.43	4.3	4.32	2800.0
2016-07-18	AAIC-DELISTED	Stock	13.25	13.54	13.17	13.33	132036.0
2016-07-18	AAL	Stock	36.03	36.34	35.76	36.03	8606800.0
2016-07-18	AAMC-DELISTED	Stock	4.0471	4.25	3.9265	3.9706	95458.0
2016-07-18	AAME	Stock	4.3	4.3	4.11	4.25	800.0
2016-07-18	AAMI	Stock	14.13	14.24	14.01	14.15	147800.0
2016-07-18	AAOI	Stock	11.9	12.05	11.66	11.76	206500.0
2016-07-18	AAON	Stock	18.68	18.7667	18.4867	18.56	150900.0
2016-07-18	AAP	Stock	164.92	164.92	163.95	164.4	516800.0
2016-07-18	AAT	Stock	44.38	44.91	43.99	44.63	253600.0
2016-07-18	AAU-DELISTED	Stock	1.44	1.45	1.42	1.45	317338.0
2016-07-18	AAUAF-DELISTED	Stock	1.44	1.45	1.42	1.44	320910.0
2016-07-18	AAV-DELISTED	Stock	6.29	6.4901	6.26	6.48	211533.0
2016-07-18	AAWW-DELISTED	Stock	42.95	43.5	42.7501	43.26	79356.0
2016-07-18	AAXJ	Stock	56.63	57.13	56.63	57.1	221229.0
2016-07-18	AAXN-DELISTED	Stock	27.77	28.42	27.4292	27.99	1487688.0
2016-07-18	AB	Stock	23.61	23.96	23.61	23.82	145300.0
2016-07-18	ABAC-DELISTED	Stock	0.775	0.775	0.645	0.7462	30525.0
2016-07-18	ABAX-DELISTED	Stock	53.89	54.26	53.26	53.36	126026.0
2016-07-18	ABB-DELISTED	Stock	19.97	20.05	19.9	19.93	1533459.0
2016-07-18	ABBNY-DELISTED	Stock	19.97	20.05	19.9	19.93	1566950.0
2016-07-18	ABBV	Stock	63.23	63.77	63.18	63.56	6384800.0
2016-07-18	ABC-DELISTED	Stock	85.73	86.12	85.55	86.04	980357.0
2016-07-18	ABCB	Stock	31.22	31.23	30.76	30.77	98200.0
2016-07-18	ABCD-DELISTED	Stock	4.98	5.0	4.87	4.96	12632.0
2016-07-18	ABCO-DELISTED	Stock	39.26	39.4299	38.31	39.0	206730.0
2016-07-18	ABDC-DELISTED	Stock	12.15	12.25	12.15	12.19	17408.0
2016-07-18	ABE-DELISTED	Stock	12.53	12.599	12.53	12.56	2533.0
2016-07-18	ABEO	Stock	61.25	62.0	59.0	60.25	2000.0
2016-07-18	ABEV	Stock	5.77	5.86	5.76	5.83	10212000.0
2016-07-18	ABG	Stock	57.48	59.37	57.15	59.22	182400.0
2016-07-18	ABIL-DELISTED	Stock	4.591	4.69	4.48	4.48	26760.0
2016-07-18	ABM	Stock	37.28	37.41	37.01	37.05	133500.0
2016-07-18	ABMD-DELISTED	Stock	117.91	118.26	116.661	117.35	304088.0
2016-07-18	ABR	Stock	7.17	7.23	7.11	7.15	121900.0

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

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