PREVIEW / stock_daily / 2015-07-29

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-29.parquet
  size:    222 KB
  rows:    6,633
  symbols: 3,471

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-29	AAPL	Stock	30.7875	30.875	30.5675	30.7475	148046800.0
2015-07-29	MSFT	Stock	45.4	46.78	45.26	46.29	40945900.0
2015-07-29	NVDA	Stock	0.4923	0.5032	0.4902	0.4992	232680000.0
2015-07-29	AMZN	Stock	26.546	26.6485	26.251	26.45	75052000.0
2015-07-29	GOOGL	Stock	33.113	33.1665	32.642	33.0715	36756100.0
2015-07-29	META	Stock	96.32	97.28	94.74	96.99	64648300.0
2015-07-29	TSLA	Stock	17.618	17.8593	17.4667	17.588	41851500.0
2015-07-29	TLT	Stock	121.02	121.17	120.4159	120.7	6706432.0
2015-07-29	ES	Stock	48.1	48.34	47.81	48.29	1170600.0
2015-07-29	CL	Stock	68.25	69.23	68.13	68.93	4974900.0
2015-07-29	A	Stock	40.5	40.73	40.24	40.4	2014100.0
2015-07-29	AA.B-DELISTED	Stock	36.46	37.46	36.44	37.28	32710.0
2015-07-29	AABA-DELISTED	Stock	37.92	37.92	37.38	37.67	8494293.0
2015-07-29	AAC-DELISTED	Stock	39.55	40.27	38.41	39.08	193645.0
2015-07-29	AACG	Stock	3.68	3.68	3.46	3.53	14200.0
2015-07-29	AAIC-DELISTED	Stock	18.78	18.92	18.38	18.9	535790.0
2015-07-29	AAL	Stock	41.09	41.33	40.44	40.73	6801400.0
2015-07-29	AAMC-DELISTED	Stock	40.1588	41.2941	40.1588	40.2941	13314.0
2015-07-29	AAME	Stock	3.7	3.7	3.58	3.67	3400.0
2015-07-29	AAMI	Stock	17.68	18.0	17.55	17.81	344700.0
2015-07-29	AAOI	Stock	18.44	18.47	18.02	18.2	152000.0
2015-07-29	AAON	Stock	14.8733	15.0	14.8533	14.8867	213450.0
2015-07-29	AAP	Stock	170.65	173.61	169.88	173.06	838000.0
2015-07-29	AAT	Stock	41.82	41.82	40.92	41.31	380100.0
2015-07-29	AAU-DELISTED	Stock	0.5894	0.6084	0.5894	0.6006	48319.0
2015-07-29	AAUAF-DELISTED	Stock	0.5851	0.604	0.5851	0.5963	49476.0
2015-07-29	AAV-DELISTED	Stock	5.5	5.7	5.38	5.64	54308.0
2015-07-29	AAVL-DELISTED	Stock	14.25	14.67	14.07	14.29	432523.0
2015-07-29	AAWW-DELISTED	Stock	49.88	51.77	49.59	51.65	742250.0
2015-07-29	AAXJ	Stock	58.99	59.71	58.97	59.59	1413393.0
2015-07-29	AAXN-DELISTED	Stock	31.04	31.78	30.4	31.7	2065000.0
2015-07-29	AB	Stock	27.16	27.59	27.1	27.42	265400.0
2015-07-29	ABAC-DELISTED	Stock	1.16	1.2	1.14	1.14	6622.0
2015-07-29	ABAX-DELISTED	Stock	48.44	49.54	48.22	48.76	105631.0
2015-07-29	ABB-DELISTED	Stock	19.81	20.06	19.8	19.94	1342634.0
2015-07-29	ABBNY-DELISTED	Stock	19.81	20.06	19.8	19.94	1413427.0
2015-07-29	ABBV	Stock	71.29	71.51	70.74	70.77	6793300.0
2015-07-29	ABC-DELISTED	Stock	107.79	109.08	107.07	107.76	2094136.0
2015-07-29	ABCB	Stock	26.15	26.64	25.98	26.47	117800.0
2015-07-29	ABCD-DELISTED	Stock	4.89	4.89	4.75	4.76	49725.0
2015-07-29	ABCO-DELISTED	Stock	57.66	59.15	57.66	58.56	252853.0
2015-07-29	ABCW-DELISTED	Stock	37.8	38.428	37.05	37.62	6712.0
2015-07-29	ABDC-DELISTED	Stock	12.33	12.69	12.315	12.55	43071.0
2015-07-29	ABE-DELISTED	Stock	12.69	12.7585	12.61	12.65	10458.0
2015-07-29	ABEO	Stock	150.0	159.0	144.75	153.0	10244.0
2015-07-29	ABEOW-DELISTED	Stock	2.3	2.59	2.08	2.19	10053.0
2015-07-29	ABEV	Stock	5.56	5.66	5.52	5.6	22395600.0
2015-07-29	ABG	Stock	83.63	85.96	83.51	85.71	409000.0
2015-07-29	ABGB-DELISTED	Stock	12.03	12.15	11.94	12.04	11712.0
2015-07-29	ABIL-DELISTED	Stock	10.0	10.0	10.0	10.0	755.0

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

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