PREVIEW / stock_daily / 2015-04-27

all stock daily files

  file:    by_date/stock_daily/2015/2015-04-27.parquet
  size:    224 KB
  rows:    6,658
  symbols: 3,520

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-04-27	AAPL	Stock	33.0775	33.2825	32.7875	33.1625	387816800.0
2015-04-27	MSFT	Stock	47.23	48.13	47.22	48.03	59248200.0
2015-04-27	NVDA	Stock	0.5525	0.5648	0.5478	0.555	248456000.0
2015-04-27	AMZN	Stock	22.193	22.3495	21.8705	21.928	108618000.0
2015-04-27	GOOGL	Stock	28.6385	28.776	28.115	28.306	48062100.0
2015-04-27	META	Stock	81.87	82.93	81.63	81.91	25446000.0
2015-04-27	TSLA	Stock	14.8373	15.9167	14.8	15.4367	175089000.0
2015-04-27	TLT	Stock	129.07	129.5	128.37	129.07	4334926.0
2015-04-27	ES	Stock	50.38	50.57	49.7	49.82	1224900.0
2015-04-27	CL	Stock	69.3	69.43	68.82	68.98	2265400.0
2015-04-27	A	Stock	42.74	42.77	41.97	41.98	2297800.0
2015-04-27	AA.B-DELISTED	Stock	45.2	45.79	45.2	45.26	97190.0
2015-04-27	AABA-DELISTED	Stock	44.65	45.1	44.25	44.37	10199251.0
2015-04-27	AAC-DELISTED	Stock	32.66	32.99	31.3101	31.41	92755.0
2015-04-27	AACG	Stock	4.89	4.89	4.78	4.79	24100.0
2015-04-27	AAIC-DELISTED	Stock	23.65	23.8	23.37	23.39	385015.0
2015-04-27	AAL	Stock	52.68	52.68	51.7	51.87	9843400.0
2015-04-27	AAMC-DELISTED	Stock	63.4676	63.4853	62.0588	63.4853	32739.0
2015-04-27	AAME	Stock	3.96	3.97	3.96	3.97	1300.0
2015-04-27	AAMI	Stock	19.38	19.79	19.3	19.44	105600.0
2015-04-27	AAOI	Stock	14.82	15.25	14.776	14.87	162900.0
2015-04-27	AAON	Stock	16.5133	16.74	16.1	16.3867	234750.0
2015-04-27	AAP	Stock	148.99	148.99	144.54	144.99	905700.0
2015-04-27	AAT	Stock	41.6	41.87	41.23	41.7	122700.0
2015-04-27	AAU-DELISTED	Stock	0.8	0.8259	0.8	0.8176	108361.0
2015-04-27	AAUAF-DELISTED	Stock	0.8	0.8234	0.8	0.8151	111608.0
2015-04-27	AAV-DELISTED	Stock	5.93	6.03	5.93	5.94	54172.0
2015-04-27	AAVL-DELISTED	Stock	36.31	37.18	33.7298	35.42	458140.0
2015-04-27	AAWW-DELISTED	Stock	43.07	43.452	42.32	42.45	101601.0
2015-04-27	AAXJ	Stock	69.88	69.94	69.6799	69.87	987909.0
2015-04-27	AAXN-DELISTED	Stock	29.76	29.8999	28.1	28.37	2458228.0
2015-04-27	AB	Stock	31.69	31.85	31.2	31.29	180800.0
2015-04-27	ABAC-DELISTED	Stock	1.7	1.7399	1.7	1.732	2523.0
2015-04-27	ABAX-DELISTED	Stock	63.41	64.17	62.2	62.48	86493.0
2015-04-27	ABB-DELISTED	Stock	21.9	22.15	21.84	21.95	1560689.0
2015-04-27	ABBNY-DELISTED	Stock	21.9	22.15	21.84	21.97	2134345.0
2015-04-27	ABBV	Stock	66.02	66.66	64.86	65.02	18141700.0
2015-04-27	ABC-DELISTED	Stock	115.88	115.88	113.854	114.12	1392190.0
2015-04-27	ABCB	Stock	24.78	25.0	24.47	24.95	146100.0
2015-04-27	ABCD-DELISTED	Stock	3.07	3.1999	3.04	3.05	34235.0
2015-04-27	ABCO-DELISTED	Stock	52.31	52.4	52.03	52.31	161078.0
2015-04-27	ABCW-DELISTED	Stock	34.0325	34.5	34.0325	34.32	11505.0
2015-04-27	ABDC-DELISTED	Stock	13.6	13.9	13.6	13.76	42707.0
2015-04-27	ABE-DELISTED	Stock	13.4452	13.46	13.3801	13.42	5350.0
2015-04-27	ABEO	Stock	95.0	96.25	83.25	86.75	14588.0
2015-04-27	ABEOW-DELISTED	Stock	1.52	1.52	1.515	1.515	200.0
2015-04-27	ABEV	Stock	6.44	6.5	6.39	6.42	10750100.0
2015-04-27	ABG	Stock	88.16	88.5	85.22	86.57	465000.0
2015-04-27	ABGB-DELISTED	Stock	16.24	16.43	16.2	16.2	16399.0
2015-04-27	ABIL-DELISTED	Stock	10.11	10.11	10.07	10.07	1915.0

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

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