PREVIEW / stock_daily / 2015-02-23

all stock daily files

  file:    by_date/stock_daily/2015/2015-02-23.parquet
  size:    223 KB
  rows:    6,650
  symbols: 3,536

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-02-23	AAPL	Stock	32.505	33.25	32.415	33.25	283896400.0
2015-02-23	MSFT	Stock	43.7	44.19	43.65	44.15	32518800.0
2015-02-23	NVDA	Stock	0.5582	0.5582	0.5512	0.554	125008000.0
2015-02-23	AMZN	Stock	19.172	19.227	18.9	19.007	43540000.0
2015-02-23	GOOGL	Stock	26.95	26.965	26.6	26.75	32905520.0
2015-02-23	META	Stock	79.96	80.19	78.38	78.84	24139100.0
2015-02-23	TSLA	Stock	14.3773	14.5467	13.7553	13.8227	127497000.0
2015-02-23	TLT	Stock	127.19	128.17	127.16	127.99	7500542.0
2015-02-23	ES	Stock	52.44	52.94	52.11	52.7	1164200.0
2015-02-23	CL	Stock	71.01	71.01	70.46	70.68	2389100.0
2015-02-23	A	Stock	41.89	41.96	41.49	41.73	1967900.0
2015-02-23	AA.B-DELISTED	Stock	50.31	50.31	49.7	50.12	80508.0
2015-02-23	AABA-DELISTED	Stock	43.99	43.99	43.42	43.53	11621573.0
2015-02-23	AAC-DELISTED	Stock	30.07	32.15	30.07	32.1	81286.0
2015-02-23	AACG	Stock	4.25	4.39	4.23	4.23	2600.0
2015-02-23	AAIC-DELISTED	Stock	24.75	24.8	24.66	24.8	222852.0
2015-02-23	AAL	Stock	51.75	52.2	50.95	51.31	9508700.0
2015-02-23	AAMC-DELISTED	Stock	60.3265	63.2353	60.0941	63.2353	18513.0
2015-02-23	AAME	Stock	3.99	4.01	3.99	4.01	1800.0
2015-02-23	AAMI	Stock	17.16	17.66	17.143	17.34	266400.0
2015-02-23	AAOI	Stock	10.21	10.235	9.97	10.06	216200.0
2015-02-23	AAON	Stock	15.8067	15.9	15.6467	15.7333	361800.0
2015-02-23	AAP	Stock	155.59	157.21	154.71	157.18	853700.0
2015-02-23	AAT	Stock	42.75	42.94	42.01	42.6	146200.0
2015-02-23	AAU-DELISTED	Stock	1.11	1.113	1.09	1.097	169395.0
2015-02-23	AAUAF-DELISTED	Stock	1.11	1.11	1.09	1.1	171128.0
2015-02-23	AAV-DELISTED	Stock	5.35	5.35	5.075	5.25	118238.0
2015-02-23	AAVL-DELISTED	Stock	39.11	40.21	36.64	36.84	256913.0
2015-02-23	AAWW-DELISTED	Stock	47.28	47.707	46.98	47.65	166208.0
2015-02-23	AAXJ	Stock	63.3	63.5	63.09	63.21	487617.0
2015-02-23	AAXN-DELISTED	Stock	27.72	27.93	27.22	27.75	1295545.0
2015-02-23	AB	Stock	27.17	27.3	26.72	26.95	266900.0
2015-02-23	ABAC-DELISTED	Stock	1.57	1.57	1.57	1.57	100.0
2015-02-23	ABAX-DELISTED	Stock	59.97	62.05	59.586	62.04	170142.0
2015-02-23	ABB-DELISTED	Stock	21.44	21.46	21.325	21.36	947017.0
2015-02-23	ABBNY-DELISTED	Stock	21.44	21.46	21.325	21.38	1061703.0
2015-02-23	ABBV	Stock	61.54	61.9	60.24	60.57	11582700.0
2015-02-23	ABC-DELISTED	Stock	101.98	102.89	101.79	102.77	982390.0
2015-02-23	ABCB	Stock	25.85	26.09	25.54	26.04	60800.0
2015-02-23	ABCD-DELISTED	Stock	2.65	2.73	2.64	2.65	7998.0
2015-02-23	ABCO-DELISTED	Stock	53.23	53.988	52.996	53.62	239569.0
2015-02-23	ABCW-DELISTED	Stock	34.68	35.0	33.6	34.7	16374.0
2015-02-23	ABDC-DELISTED	Stock	13.49	13.92	13.49	13.92	49805.0
2015-02-23	ABE-DELISTED	Stock	13.21	13.21	13.11	13.13	14167.0
2015-02-23	ABEO	Stock	77.75	79.5	75.0	77.5	516.0
2015-02-23	ABEOW-DELISTED	Stock	0.96	0.96	0.9	0.95	3326.0
2015-02-23	ABEV	Stock	6.43	6.45	6.35	6.44	16489500.0
2015-02-23	ABG	Stock	78.83	78.93	77.9	78.53	203800.0
2015-02-23	ABGB-DELISTED	Stock	17.08	18.01	16.838	17.81	145915.0
2015-02-23	ABM	Stock	30.5	30.94	30.25	30.93	130900.0

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

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