PREVIEW / stock_daily / 2015-05-20

all stock daily files

  file:    by_date/stock_daily/2015/2015-05-20.parquet
  size:    223 KB
  rows:    6,665
  symbols: 3,519

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-05-20	AAPL	Stock	32.5	32.745	32.335	32.515	145819600.0
2015-05-20	MSFT	Stock	47.39	47.93	47.27	47.58	25047900.0
2015-05-20	NVDA	Stock	0.5262	0.5325	0.5255	0.526	196824000.0
2015-05-20	AMZN	Stock	21.03	21.355	20.918	21.193	43924000.0
2015-05-20	GOOGL	Stock	27.546	27.8033	27.255	27.6255	30839240.0
2015-05-20	META	Stock	80.47	81.1	79.46	80.55	23056900.0
2015-05-20	TSLA	Stock	16.4753	16.516	16.0913	16.29	56334000.0
2015-05-20	TLT	Stock	118.77	119.45	118.18	118.69	7789665.0
2015-05-20	ES	Stock	49.23	49.86	49.12	49.47	1570000.0
2015-05-20	CL	Stock	69.18	69.28	68.89	68.89	2020700.0
2015-05-20	A	Stock	42.5	42.84	42.43	42.61	2652300.0
2015-05-20	AA.B-DELISTED	Stock	45.05	45.1999	44.94	45.0716	53000.0
2015-05-20	AABA-DELISTED	Stock	42.27	43.04	42.16	42.785	49731073.0
2015-05-20	AAC-DELISTED	Stock	36.0	36.43	35.62	35.67	226349.0
2015-05-20	AACG	Stock	4.6	4.6	4.5	4.51	32700.0
2015-05-20	AAIC-DELISTED	Stock	21.41	21.56	21.3	21.35	114513.0
2015-05-20	AAL	Stock	47.56	47.56	42.97	43.06	51460300.0
2015-05-20	AAMC-DELISTED	Stock	52.2118	54.5589	52.2118	53.5294	12318.0
2015-05-20	AAME	Stock	3.51	3.59	3.38	3.51	9300.0
2015-05-20	AAMI	Stock	19.78	19.78	19.51	19.62	28300.0
2015-05-20	AAOI	Stock	14.65	15.16	14.53	15.16	220300.0
2015-05-20	AAON	Stock	15.7933	16.2333	15.5933	16.1933	339600.0
2015-05-20	AAP	Stock	152.76	153.97	149.9	149.9	1580900.0
2015-05-20	AAT	Stock	40.85	41.2	40.45	40.71	225700.0
2015-05-20	AAU-DELISTED	Stock	0.9012	0.92	0.8988	0.9	54347.0
2015-05-20	AAUAF-DELISTED	Stock	0.9025	0.9207	0.9	0.9	54627.0
2015-05-20	AAV-DELISTED	Stock	6.06	6.215	6.04	6.19	96085.0
2015-05-20	AAVL-DELISTED	Stock	38.43	39.652	37.7	39.06	340851.0
2015-05-20	AAWW-DELISTED	Stock	59.28	59.35	57.56	58.45	387328.0
2015-05-20	AAXJ	Stock	67.77	67.92	67.47	67.77	2167986.0
2015-05-20	AAXN-DELISTED	Stock	32.3	32.48	31.42	31.85	1704684.0
2015-05-20	AB	Stock	31.63	31.87	31.27	31.63	188000.0
2015-05-20	ABAC-DELISTED	Stock	1.6604	1.68	1.66	1.68	20670.0
2015-05-20	ABAX-DELISTED	Stock	52.99	53.04	52.35	52.63	84914.0
2015-05-20	ABB-DELISTED	Stock	21.65	21.82	21.626	21.77	1182420.0
2015-05-20	ABBNY-DELISTED	Stock	21.63	21.82	21.626	21.77	1234385.0
2015-05-20	ABBV	Stock	65.92	66.2	65.39	65.89	9956000.0
2015-05-20	ABC-DELISTED	Stock	115.1	115.51	114.7	114.7	1718260.0
2015-05-20	ABCB	Stock	25.6	26.13	25.44	25.88	236800.0
2015-05-20	ABCD-DELISTED	Stock	3.69	3.97	3.61	3.73	94242.0
2015-05-20	ABCO-DELISTED	Stock	48.15	48.27	47.77	47.82	250247.0
2015-05-20	ABCW-DELISTED	Stock	37.38	37.5	37.03	37.04	6112.0
2015-05-20	ABDC-DELISTED	Stock	14.05	14.05	13.94	13.95	41993.0
2015-05-20	ABE-DELISTED	Stock	13.419	13.44	13.35	13.44	15095.0
2015-05-20	ABEO	Stock	254.75	271.25	226.0	232.5	336100.0
2015-05-20	ABEOW-DELISTED	Stock	5.14	5.78	4.11	4.3	384770.0
2015-05-20	ABEV	Stock	6.28	6.29	6.21	6.22	13095200.0
2015-05-20	ABG	Stock	86.48	87.22	85.72	86.75	132400.0
2015-05-20	ABGB-DELISTED	Stock	16.59	16.66	16.5079	16.56	11788.0
2015-05-20	ABM	Stock	32.67	33.03	32.51	32.96	208800.0

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

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