PREVIEW / stock_daily / 2015-07-13

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-13.parquet
  size:    224 KB
  rows:    6,673
  symbols: 3,495

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-07-13	AAPL	Stock	31.2575	31.44	31.08	31.415	165762000.0
2015-07-13	MSFT	Stock	44.98	45.62	44.95	45.54	28178300.0
2015-07-13	NVDA	Stock	0.4988	0.4998	0.4938	0.497	212472000.0
2015-07-13	AMZN	Stock	22.4145	22.8935	22.377	22.7785	79136000.0
2015-07-13	GOOGL	Stock	27.9755	28.6425	27.935	28.5865	41792820.0
2015-07-13	META	Stock	88.66	90.22	88.42	90.1	29976700.0
2015-07-13	TSLA	Stock	17.4833	17.5033	17.07	17.4773	44404500.0
2015-07-13	TLT	Stock	115.39	116.46	115.39	115.69	8006723.0
2015-07-13	ES	Stock	47.15	47.39	46.81	47.04	1331700.0
2015-07-13	CL	Stock	66.95	67.5	66.91	67.44	2087300.0
2015-07-13	A	Stock	39.72	40.0	39.54	39.96	1579700.0
2015-07-13	AA.B-DELISTED	Stock	39.65	39.75	38.9859	39.23	73921.0
2015-07-13	AABA-DELISTED	Stock	38.25	38.8	38.1	38.76	8262895.0
2015-07-13	AAC-DELISTED	Stock	42.61	44.17	42.37	43.66	206139.0
2015-07-13	AACG	Stock	4.93	4.99	4.34	4.44	174800.0
2015-07-13	AAIC-DELISTED	Stock	20.06	20.28	20.03	20.13	308048.0
2015-07-13	AAL	Stock	41.96	42.72	41.96	42.42	12077000.0
2015-07-13	AAMC-DELISTED	Stock	40.5853	42.5735	39.9	42.5706	8558.0
2015-07-13	AAME	Stock	3.69	3.7	3.66	3.67	1400.0
2015-07-13	AAMI	Stock	17.73	17.77	17.55	17.65	115700.0
2015-07-13	AAOI	Stock	19.26	20.93	18.63	19.96	1830200.0
2015-07-13	AAON	Stock	15.16	15.52	15.08	15.4533	213900.0
2015-07-13	AAP	Stock	165.05	169.33	164.98	169.31	1609200.0
2015-07-13	AAT	Stock	41.24	41.68	40.74	41.0	100100.0
2015-07-13	AAU-DELISTED	Stock	0.76	0.78	0.74	0.78	78373.0
2015-07-13	AAUAF-DELISTED	Stock	0.77	0.79	0.75	0.78	78019.0
2015-07-13	AAV-DELISTED	Stock	6.21	6.28	6.07	6.21	60773.0
2015-07-13	AAVL-DELISTED	Stock	16.37	16.69	16.3	16.43	339886.0
2015-07-13	AAWW-DELISTED	Stock	53.61	53.65	52.11	52.96	747762.0
2015-07-13	AAXJ	Stock	62.0	62.13	61.41	61.55	2693500.0
2015-07-13	AAXN-DELISTED	Stock	33.14	33.44	32.52	33.05	1476840.0
2015-07-13	AB	Stock	29.23	29.27	28.75	28.84	121900.0
2015-07-13	ABAC-DELISTED	Stock	1.15	1.15	1.0401	1.0799	30086.0
2015-07-13	ABAX-DELISTED	Stock	53.53	54.13	53.0	53.78	78349.0
2015-07-13	ABB-DELISTED	Stock	20.77	20.835	20.71	20.77	1295713.0
2015-07-13	ABBNY-DELISTED	Stock	20.76	20.835	20.71	20.76	1447352.0
2015-07-13	ABBV	Stock	69.42	69.7	69.17	69.57	5507000.0
2015-07-13	ABC-DELISTED	Stock	110.52	110.65	109.36	110.08	866891.0
2015-07-13	ABCB	Stock	26.07	26.25	25.9	25.91	99000.0
2015-07-13	ABCD-DELISTED	Stock	4.8	4.94	4.7902	4.83	211112.0
2015-07-13	ABCO-DELISTED	Stock	58.48	58.95	57.25	58.35	556372.0
2015-07-13	ABCW-DELISTED	Stock	40.63	41.575	40.39	40.59	34153.0
2015-07-13	ABDC-DELISTED	Stock	13.16	13.48	12.7901	12.95	45989.0
2015-07-13	ABE-DELISTED	Stock	13.27	13.38	12.9	12.95	9441.0
2015-07-13	ABEO	Stock	140.25	168.0	140.0	166.5	27032.0
2015-07-13	ABEOW-DELISTED	Stock	2.3	2.75	2.3	2.56	23768.0
2015-07-13	ABEV	Stock	6.18	6.24	6.17	6.23	10929000.0
2015-07-13	ABG	Stock	92.0	94.19	91.67	93.93	355200.0
2015-07-13	ABGB-DELISTED	Stock	15.78	15.82	15.58	15.73	18624.0
2015-07-13	ABIL-DELISTED	Stock	10.0	10.0	10.0	10.0	188.0

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

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