PREVIEW / stock_daily / 2015-05-27

all stock daily files

  file:    by_date/stock_daily/2015/2015-05-27.parquet
  size:    225 KB
  rows:    6,680
  symbols: 3,521

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-27	AAPL	Stock	32.585	33.065	32.5125	33.01	183332800.0
2015-05-27	MSFT	Stock	46.82	47.77	46.62	47.61	27335600.0
2015-05-27	NVDA	Stock	0.5218	0.5485	0.52	0.546	432332000.0
2015-05-27	AMZN	Stock	21.3725	21.5925	21.2505	21.571	44622000.0
2015-05-27	GOOGL	Stock	27.434	27.7645	27.3291	27.7125	34844740.0
2015-05-27	META	Stock	79.6	80.66	79.43	80.55	14160900.0
2015-05-27	TSLA	Stock	16.5673	16.6333	16.37	16.4953	51123000.0
2015-05-27	TLT	Stock	122.18	122.86	121.6052	122.74	6490255.0
2015-05-27	ES	Stock	48.67	48.9	48.54	48.77	756600.0
2015-05-27	CL	Stock	67.3	67.75	67.28	67.54	3315600.0
2015-05-27	A	Stock	42.27	42.93	42.1	42.61	2506300.0
2015-05-27	AA.B-DELISTED	Stock	44.31	44.61	44.2	44.49	90733.0
2015-05-27	AABA-DELISTED	Stock	42.6	43.44	42.28	43.39	12119251.0
2015-05-27	AAC-DELISTED	Stock	38.6	39.1776	38.326	38.7001	102726.0
2015-05-27	AACG	Stock	5.1	5.2	4.74	4.75	34400.0
2015-05-27	AAIC-DELISTED	Stock	20.78	20.93	20.705	20.86	194662.0
2015-05-27	AAL	Stock	41.65	42.45	41.6	42.24	13017800.0
2015-05-27	AAMC-DELISTED	Stock	50.0	51.1471	46.1765	50.9853	70268.0
2015-05-27	AAME	Stock	3.19	3.27	3.09	3.13	24300.0
2015-05-27	AAMI	Stock	19.52	19.52	19.3	19.45	86500.0
2015-05-27	AAOI	Stock	19.0	19.0	18.06	18.77	577200.0
2015-05-27	AAON	Stock	16.0933	16.3733	16.0267	16.2733	357300.0
2015-05-27	AAP	Stock	158.29	158.8	156.51	157.22	870800.0
2015-05-27	AAT	Stock	39.79	40.54	39.54	40.32	129800.0
2015-05-27	AAU-DELISTED	Stock	0.9041	0.9095	0.85	0.8899	84641.0
2015-05-27	AAUAF-DELISTED	Stock	0.9041	0.9095	0.85	0.8899	85043.0
2015-05-27	AAV-DELISTED	Stock	5.99	6.04	5.95	6.0	118445.0
2015-05-27	AAVL-DELISTED	Stock	37.21	39.48	36.9821	39.02	395389.0
2015-05-27	AAWW-DELISTED	Stock	56.68	58.475	56.2	58.05	421028.0
2015-05-27	AAXJ	Stock	67.43	67.7799	67.34	67.74	1531508.0
2015-05-27	AAXN-DELISTED	Stock	31.35	31.65	31.24	31.41	1059847.0
2015-05-27	AB	Stock	31.8	31.89	31.26	31.56	260400.0
2015-05-27	ABAC-DELISTED	Stock	1.6699	1.67	1.58	1.6	5200.0
2015-05-27	ABAX-DELISTED	Stock	53.39	53.63	52.74	53.43	67826.0
2015-05-27	ABB-DELISTED	Stock	21.77	21.95	21.76	21.9101	1726655.0
2015-05-27	ABBNY-DELISTED	Stock	21.77	21.95	21.76	21.9	2052525.0
2015-05-27	ABBV	Stock	66.75	67.99	66.57	67.38	40778800.0
2015-05-27	ABC-DELISTED	Stock	112.91	113.82	112.77	113.58	1107552.0
2015-05-27	ABCB	Stock	25.24	25.46	24.78	25.28	212000.0
2015-05-27	ABCD-DELISTED	Stock	3.81	3.85	3.74	3.78	38542.0
2015-05-27	ABCO-DELISTED	Stock	47.97	49.63	47.73	49.58	363417.0
2015-05-27	ABCW-DELISTED	Stock	37.0401	37.22	37.02	37.15	9510.0
2015-05-27	ABDC-DELISTED	Stock	13.99	13.99	13.78	13.84	38591.0
2015-05-27	ABE-DELISTED	Stock	12.96	13.0	12.94	12.98	6035.0
2015-05-27	ABEO	Stock	229.75	248.25	219.0	221.25	133204.0
2015-05-27	ABEOW-DELISTED	Stock	4.3686	4.94	3.97	4.128	113287.0
2015-05-27	ABEV	Stock	5.8	5.88	5.73	5.85	24141500.0
2015-05-27	ABG	Stock	85.71	87.16	85.12	86.92	210800.0
2015-05-27	ABGB-DELISTED	Stock	16.37	16.65	16.3096	16.52	19202.0
2015-05-27	ABM	Stock	32.41	32.86	32.16	32.79	175200.0

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

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