PREVIEW / stock_daily / 2014-02-25

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-25.parquet
  size:    217 KB
  rows:    6,469
  symbols: 3,528

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
2014-02-25	AAPL	Stock	18.9064	18.9132	18.6071	18.645	231952000.0
2014-02-25	MSFT	Stock	37.61	37.85	37.35	37.54	30736500.0
2014-02-25	NVDA	Stock	0.47	0.472	0.4635	0.4685	242184000.0
2014-02-25	AMZN	Stock	17.65	18.054	17.579	17.916	74728000.0
2014-02-25	META	Stock	70.95	71.0	69.45	69.85	52077000.0
2014-02-25	TSLA	Stock	15.3333	17.28	15.23	16.5333	490225500.0
2014-02-25	TLT	Stock	106.91	107.36	106.89	107.35	6225905.0
2014-02-25	ES	Stock	44.52	44.84	44.31	44.42	1858000.0
2014-02-25	CL	Stock	62.04	62.23	61.68	62.07	3961200.0
2014-02-25	A	Stock	40.6295	41.1803	40.5937	40.6938	4718390.0
2014-02-25	AABA-DELISTED	Stock	37.48	37.58	37.02	37.25	9130656.0
2014-02-25	AACG	Stock	4.0	4.1	4.0	4.0	4700.0
2014-02-25	AAIC-DELISTED	Stock	26.1	26.3	26.1	26.21	72920.0
2014-02-25	AAL	Stock	36.63	37.15	36.51	37.0	8990100.0
2014-02-25	AAMC-DELISTED	Stock	262.3206	274.9941	259.1206	269.7029	42463.0
2014-02-25	AAME	Stock	3.93	3.96	3.92	3.93	4400.0
2014-02-25	AAOI	Stock	20.2	20.99	19.47	20.0	126500.0
2014-02-25	AAON	Stock	13.1244	13.2444	12.56	12.6489	261225.0
2014-02-25	AAP	Stock	126.64	127.83	125.38	125.5	823000.0
2014-02-25	AAT	Stock	33.29	33.42	33.13	33.29	264600.0
2014-02-25	AAU-DELISTED	Stock	1.69	1.7603	1.67	1.7	125555.0
2014-02-25	AAUAF-DELISTED	Stock	1.67	1.7396	1.65	1.7	128549.0
2014-02-25	AAV-DELISTED	Stock	4.1	4.11	4.05	4.07	134155.0
2014-02-25	AAWW-DELISTED	Stock	31.98	32.0	31.46	31.59	358884.0
2014-02-25	AAXJ	Stock	57.46	57.57	57.09	57.21	559125.0
2014-02-25	AAXN-DELISTED	Stock	19.19	19.5399	19.01	19.09	1584404.0
2014-02-25	AB	Stock	24.46	24.75	24.05	24.12	272800.0
2014-02-25	ABAC-DELISTED	Stock	1.7201	1.81	1.7201	1.8099	11000.0
2014-02-25	ABAX-DELISTED	Stock	39.08	39.09	38.46	38.72	109102.0
2014-02-25	ABB-DELISTED	Stock	25.23	25.28	25.04	25.22	1858336.0
2014-02-25	ABBNY-DELISTED	Stock	25.22	25.28	25.04	25.23	2702106.0
2014-02-25	ABBV	Stock	50.93	51.13	50.5	50.72	5425000.0
2014-02-25	ABC-DELISTED	Stock	68.39	68.99	68.24	68.72	1306215.0
2014-02-25	ABCB	Stock	20.4	20.53	20.34	20.49	88000.0
2014-02-25	ABCD-DELISTED	Stock	2.0	2.0	1.94	1.94	20687.0
2014-02-25	ABCO-DELISTED	Stock	64.43	64.81	63.76	64.15	247169.0
2014-02-25	ABE-DELISTED	Stock	12.49	12.61	12.43	12.44	22793.0
2014-02-25	ABEO	Stock	475.0	475.0	450.0	475.0	6.0
2014-02-25	ABEV	Stock	7.03	7.18	7.0	7.02	8354800.0
2014-02-25	ABFS-DELISTED	Stock	33.49	33.952	32.65	33.36	294911.0
2014-02-25	ABG	Stock	48.08	49.37	47.82	49.08	386700.0
2014-02-25	ABGB-DELISTED	Stock	22.76	23.81	22.76	23.64	75452.0
2014-02-25	ABIL-DELISTED	Stock	9.6	9.62	9.6	9.62	299.0
2014-02-25	ABM	Stock	27.93	27.96	27.64	27.74	209100.0
2014-02-25	ABMD-DELISTED	Stock	28.66	29.18	28.4805	28.94	238398.0
2014-02-25	ABR	Stock	6.78	6.91	6.77	6.8	48300.0
2014-02-25	ABR.A-DELISTED	Stock	24.11	24.11	23.85	23.86	17600.0
2014-02-25	ABR.B-DELISTED	Stock	23.0	23.0	22.87	22.87	1425.0
2014-02-25	ABT	Stock	38.99	39.52	38.91	39.25	7952100.0
2014-02-25	ABTL-DELISTED	Stock	14.97	15.75	14.9	15.4225	331679.0

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

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