PREVIEW / stock_daily / 2015-11-27

all stock daily files

  file:    by_date/stock_daily/2015/2015-11-27.parquet
  size:    214 KB
  rows:    6,484
  symbols: 3,318

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-11-27	AAPL	Stock	29.5725	29.6025	29.4	29.4525	52185600.0
2015-11-27	MSFT	Stock	53.8	54.08	53.79	53.93	9009100.0
2015-11-27	NVDA	Stock	0.7798	0.7872	0.7758	0.7848	86996000.0
2015-11-27	AMZN	Stock	34.04	34.0495	33.605	33.663	39336000.0
2015-11-27	GOOGL	Stock	38.458	38.7	38.35	38.5985	14446400.0
2015-11-27	META	Stock	105.78	105.96	104.86	105.45	5913100.0
2015-11-27	TSLA	Stock	15.404	15.4833	15.134	15.4407	29241000.0
2015-11-27	TLT	Stock	121.25	121.32	120.96	120.97	2570644.0
2015-11-27	ES	Stock	50.55	50.91	50.3	50.53	951000.0
2015-11-27	CL	Stock	66.51	66.75	66.19	66.56	1265500.0
2015-11-27	A	Stock	41.32	42.2	41.16	41.97	1935700.0
2015-11-27	AA.B-DELISTED	Stock	33.08	33.08	32.29	32.4	14686.0
2015-11-27	AAAP-DELISTED	Stock	25.37	26.5	25.0101	26.5	14551.0
2015-11-27	AABA-DELISTED	Stock	32.79	33.085	32.44	32.95	5036215.0
2015-11-27	AAC-DELISTED	Stock	24.65	25.0025	24.2	24.23	54662.0
2015-11-27	AACG	Stock	5.3	5.72	5.13	5.5	35800.0
2015-11-27	AAIC-DELISTED	Stock	13.89	14.19	13.8601	14.1	135220.0
2015-11-27	AAL	Stock	41.38	42.25	41.17	41.69	3066600.0
2015-11-27	AAMC-DELISTED	Stock	4.2529	4.8918	4.2529	4.8853	49133.0
2015-11-27	AAME	Stock	4.74	4.8	4.72	4.78	1100.0
2015-11-27	AAMI	Stock	16.3	16.44	16.18	16.37	31200.0
2015-11-27	AAOI	Stock	18.46	18.75	18.11	18.56	129800.0
2015-11-27	AAON	Stock	16.6267	16.8933	16.5067	16.7667	153150.0
2015-11-27	AAP	Stock	164.88	164.88	162.83	164.84	293400.0
2015-11-27	AAT	Stock	39.99	40.29	39.81	40.24	138500.0
2015-11-27	AAU-DELISTED	Stock	0.52	0.52	0.5001	0.5001	5400.0
2015-11-27	AAUAF-DELISTED	Stock	0.52	0.52	0.5001	0.5001	5406.0
2015-11-27	AAV-DELISTED	Stock	5.33	5.38	5.26	5.29	13709.0
2015-11-27	AAVL-DELISTED	Stock	9.99	10.3294	9.94	10.1	244091.0
2015-11-27	AAWW-DELISTED	Stock	40.92	41.65	40.9	40.97	74062.0
2015-11-27	AAXJ	Stock	55.29	55.34	55.11	55.17	371727.0
2015-11-27	AAXN-DELISTED	Stock	19.22	19.2699	18.51	18.83	841452.0
2015-11-27	AB	Stock	25.79	25.95	25.38	25.38	83100.0
2015-11-27	ABAC-DELISTED	Stock	0.69	0.69	0.631	0.6624	4500.0
2015-11-27	ABAX-DELISTED	Stock	53.48	54.09	53.15	53.38	32462.0
2015-11-27	ABB-DELISTED	Stock	18.69	18.75	18.61	18.68	954225.0
2015-11-27	ABBNY-DELISTED	Stock	18.69	18.75	18.61	18.68	970312.0
2015-11-27	ABBV	Stock	60.17	60.45	59.61	60.0	2404100.0
2015-11-27	ABC-DELISTED	Stock	99.02	99.7	98.47	99.0	694652.0
2015-11-27	ABCB	Stock	33.74	34.42	33.63	34.38	82200.0
2015-11-27	ABCD-DELISTED	Stock	5.14	5.16	5.01	5.05	8752.0
2015-11-27	ABCO-DELISTED	Stock	52.61	53.47	52.27	52.82	39509.0
2015-11-27	ABCW-DELISTED	Stock	42.12	42.14	41.82	41.99	11753.0
2015-11-27	ABDC-DELISTED	Stock	11.99	12.54	11.99	12.22	25855.0
2015-11-27	ABE-DELISTED	Stock	11.26	11.26	11.26	11.26	100.0
2015-11-27	ABEO	Stock	117.5	120.75	115.75	120.0	4160.0
2015-11-27	ABEOW-DELISTED	Stock	1.64	1.77	1.64	1.76	4400.0
2015-11-27	ABEV	Stock	5.01	5.01	4.89	4.9	7985000.0
2015-11-27	ABG	Stock	76.98	77.33	76.39	76.53	53900.0
2015-11-27	ABGB-DELISTED	Stock	1.6	2.1	1.6	1.73	343835.0

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

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