PREVIEW / stock_daily / 2015-03-19

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-19.parquet
  size:    222 KB
  rows:    6,626
  symbols: 3,509

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-03-19	AAPL	Stock	32.1875	32.3125	31.85	31.875	183238000.0
2015-03-19	MSFT	Stock	42.26	42.59	42.22	42.29	33879100.0
2015-03-19	NVDA	Stock	0.5738	0.5825	0.5695	0.5805	310756000.0
2015-03-19	AMZN	Stock	18.6935	18.8555	18.6095	18.662	38314000.0
2015-03-19	GOOGL	Stock	28.226	28.348	28.106	28.1835	24659380.0
2015-03-19	META	Stock	81.12	83.0	81.0	82.75	42099500.0
2015-03-19	TSLA	Stock	13.4667	13.6393	12.9687	13.0433	127128000.0
2015-03-19	TLT	Stock	131.2	131.62	130.27	130.82	9543795.0
2015-03-19	ES	Stock	50.71	51.5	50.37	50.73	1261500.0
2015-03-19	CL	Stock	68.18	68.53	67.81	68.29	2881200.0
2015-03-19	A	Stock	42.05	42.25	41.82	42.21	1085700.0
2015-03-19	AA.B-DELISTED	Stock	44.75	44.75	43.41	44.067	83258.0
2015-03-19	AABA-DELISTED	Stock	44.9	45.45	44.81	44.97	13716196.0
2015-03-19	AAC-DELISTED	Stock	29.71	30.23	29.17	30.17	167692.0
2015-03-19	AACG	Stock	4.0	4.0	3.9	3.99	2400.0
2015-03-19	AAIC-DELISTED	Stock	24.82	25.1	24.82	24.94	337366.0
2015-03-19	AAL	Stock	54.57	55.24	54.45	55.19	18897700.0
2015-03-19	AAMC-DELISTED	Stock	62.0294	62.0294	59.7059	60.0647	25371.0
2015-03-19	AAME	Stock	4.0	4.04	3.98	4.03	5600.0
2015-03-19	AAMI	Stock	18.04	18.395	17.75	18.31	161000.0
2015-03-19	AAOI	Stock	13.25	13.93	13.143	13.78	239600.0
2015-03-19	AAON	Stock	14.9333	15.0	14.7533	14.9667	123000.0
2015-03-19	AAP	Stock	149.06	149.42	147.42	149.19	912500.0
2015-03-19	AAT	Stock	42.98	43.78	42.98	43.48	75400.0
2015-03-19	AAU-DELISTED	Stock	0.96	0.96	0.91	0.93	31503.0
2015-03-19	AAUAF-DELISTED	Stock	0.95	0.95	0.9	0.93	32820.0
2015-03-19	AAV-DELISTED	Stock	5.3	5.36	5.245	5.27	144259.0
2015-03-19	AAVL-DELISTED	Stock	41.74	45.14	41.41	44.33	368412.0
2015-03-19	AAWW-DELISTED	Stock	47.0	47.82	46.78	46.97	133872.0
2015-03-19	AAXJ	Stock	63.38	63.38	63.01	63.31	1987352.0
2015-03-19	AAXN-DELISTED	Stock	23.83	24.49	23.8	24.37	1012985.0
2015-03-19	AB	Stock	30.33	30.67	30.15	30.46	302700.0
2015-03-19	ABAC-DELISTED	Stock	1.56	1.71	1.53	1.57	13288.0
2015-03-19	ABAX-DELISTED	Stock	63.23	64.5	63.04	64.27	75960.0
2015-03-19	ABB-DELISTED	Stock	20.9	20.91	20.7	20.81	1485995.0
2015-03-19	ABBNY-DELISTED	Stock	20.9	20.91	20.7	20.8	1637267.0
2015-03-19	ABBV	Stock	60.09	61.48	59.99	61.19	14110500.0
2015-03-19	ABC-DELISTED	Stock	111.88	112.5	111.07	112.4	1247260.0
2015-03-19	ABCB	Stock	26.11	26.3	25.94	26.02	57800.0
2015-03-19	ABCD-DELISTED	Stock	3.1	3.2	3.0489	3.17	96481.0
2015-03-19	ABCO-DELISTED	Stock	51.77	52.93	51.24	52.51	101630.0
2015-03-19	ABCW-DELISTED	Stock	34.09	34.11	34.05	34.11	1663.0
2015-03-19	ABDC-DELISTED	Stock	13.85	13.93	13.8372	13.85	18637.0
2015-03-19	ABE-DELISTED	Stock	12.54	12.56	12.51	12.54	37083.0
2015-03-19	ABEO	Stock	82.25	87.25	80.5	82.75	1492.0
2015-03-19	ABEOW-DELISTED	Stock	0.9898	1.01	0.92	0.92	2823.0
2015-03-19	ABEV	Stock	5.69	5.72	5.59	5.62	10303300.0
2015-03-19	ABG	Stock	78.3	79.99	78.3	79.48	231200.0
2015-03-19	ABGB-DELISTED	Stock	16.88	16.9	16.55	16.58	21896.0
2015-03-19	ABIL-DELISTED	Stock	9.88	9.9	9.88	9.9	700.0

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

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