PREVIEW / stock_daily / 2015-09-18

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-18.parquet
  size:    223 KB
  rows:    6,672
  symbols: 3,453

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-09-18	AAPL	Stock	28.0525	28.575	27.9675	28.3625	297141200.0
2015-09-18	MSFT	Stock	43.5	43.99	43.33	43.48	63143700.0
2015-09-18	NVDA	Stock	0.5748	0.5872	0.5712	0.5822	326412000.0
2015-09-18	AMZN	Stock	26.731	27.312	26.5675	27.013	123202000.0
2015-09-18	GOOGL	Stock	33.253	33.492	33.0015	33.046	72544200.0
2015-09-18	META	Stock	93.2	95.19	93.05	94.4	62300000.0
2015-09-18	TSLA	Stock	17.1973	17.588	17.1667	17.3747	56446500.0
2015-09-18	TLT	Stock	121.21	122.2	121.13	122.1	14963338.0
2015-09-18	ES	Stock	47.43	48.08	47.09	47.22	3593800.0
2015-09-18	CL	Stock	62.68	63.66	62.65	62.69	13468600.0
2015-09-18	A	Stock	35.86	36.22	35.59	35.74	3352300.0
2015-09-18	AA.B-DELISTED	Stock	35.6	35.9386	35.33	35.55	28495.0
2015-09-18	AABA-DELISTED	Stock	30.51	30.8	30.41	30.73	18255922.0
2015-09-18	AAC-DELISTED	Stock	23.33	24.22	23.01	23.79	247139.0
2015-09-18	AACG	Stock	2.38	2.45	2.35	2.35	19200.0
2015-09-18	AAIC-DELISTED	Stock	15.34	15.85	15.34	15.72	639494.0
2015-09-18	AAL	Stock	43.43	44.03	43.28	43.49	12446900.0
2015-09-18	AAMC-DELISTED	Stock	7.8559	8.0265	7.4941	7.6	58769.0
2015-09-18	AAME	Stock	3.42	3.72	3.38	3.72	37100.0
2015-09-18	AAMI	Stock	16.23	16.43	15.94	16.05	285700.0
2015-09-18	AAOI	Stock	19.22	19.72	19.05	19.54	614400.0
2015-09-18	AAON	Stock	13.44	13.5867	13.2333	13.3	517350.0
2015-09-18	AAP	Stock	176.4	177.59	173.3	173.7	922400.0
2015-09-18	AAT	Stock	39.65	40.5	39.52	39.58	419300.0
2015-09-18	AAU-DELISTED	Stock	0.52	0.5501	0.5164	0.5219	74603.0
2015-09-18	AAUAF-DELISTED	Stock	0.52	0.5501	0.5164	0.5219	75342.0
2015-09-18	AAV-DELISTED	Stock	5.43	5.52	5.33	5.42	60087.0
2015-09-18	AAVL-DELISTED	Stock	11.18	11.39	10.97	11.27	469415.0
2015-09-18	AAWW-DELISTED	Stock	38.26	39.17	37.77	38.03	284166.0
2015-09-18	AAXJ	Stock	54.48	54.86	53.99	54.1	1071628.0
2015-09-18	AAXN-DELISTED	Stock	23.75	24.17	23.75	23.95	1225223.0
2015-09-18	AB	Stock	26.98	27.25	26.31	26.55	273200.0
2015-09-18	ABAC-DELISTED	Stock	0.71	0.71	0.65	0.6799	11749.0
2015-09-18	ABAX-DELISTED	Stock	48.18	49.12	47.77	48.25	348698.0
2015-09-18	ABB-DELISTED	Stock	18.34	18.405	18.14	18.165	3858299.0
2015-09-18	ABBNY-DELISTED	Stock	18.34	18.405	18.14	18.17	3953111.0
2015-09-18	ABBV	Stock	59.42	61.83	58.97	61.22	28957000.0
2015-09-18	ABC-DELISTED	Stock	105.91	106.915	105.296	106.11	1908984.0
2015-09-18	ABCB	Stock	27.97	28.22	27.01	27.66	1548300.0
2015-09-18	ABCD-DELISTED	Stock	4.9	5.092	4.9	5.05	115590.0
2015-09-18	ABCO-DELISTED	Stock	47.83	48.98	47.65	47.98	257524.0
2015-09-18	ABCW-DELISTED	Stock	39.88	40.71	38.11	38.24	313937.0
2015-09-18	ABDC-DELISTED	Stock	12.73	13.11	12.42	12.75	51820.0
2015-09-18	ABE-DELISTED	Stock	11.44	11.44	11.33	11.33	3337.0
2015-09-18	ABEO	Stock	127.25	135.75	124.5	131.5	8644.0
2015-09-18	ABEOW-DELISTED	Stock	2.0	2.395	1.81	2.08	9060.0
2015-09-18	ABEV	Stock	4.95	5.05	4.88	4.89	19825300.0
2015-09-18	ABG	Stock	83.9	84.99	82.78	83.27	366300.0
2015-09-18	ABGB-DELISTED	Stock	5.12	5.21	5.05	5.0825	53518.0
2015-09-18	ABM	Stock	29.61	29.8	29.39	29.54	688700.0

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

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