PREVIEW / stock_daily / 2016-02-24

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-24.parquet
  size:    217 KB
  rows:    6,553
  symbols: 3,324

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
2016-02-24	AAPL	Stock	23.495	24.095	23.33	24.025	145022800.0
2016-02-24	MSFT	Stock	50.69	51.5	50.2	51.36	33014500.0
2016-02-24	NVDA	Stock	0.7868	0.7968	0.765	0.7955	336852000.0
2016-02-24	AMZN	Stock	27.2875	27.7135	26.6575	27.702	124634000.0
2016-02-24	GOOGL	Stock	35.5305	36.061	35.101	36.045	37092240.0
2016-02-24	META	Stock	104.21	106.95	102.74	106.88	34412400.0
2016-02-24	TSLA	Stock	11.5167	11.9667	11.1893	11.9333	80934000.0
2016-02-24	TLT	Stock	132.4	133.39	130.95	131.21	9091189.0
2016-02-24	ES	Stock	55.54	56.49	55.54	56.23	1720300.0
2016-02-24	CL	Stock	66.94	66.99	66.03	66.32	5260200.0
2016-02-24	A	Stock	36.65	37.5	36.47	37.48	1454900.0
2016-02-24	AA.B-DELISTED	Stock	29.39	30.46	29.0	30.4399	32370.0
2016-02-24	AAAP-DELISTED	Stock	31.46	33.18	31.46	31.9925	141871.0
2016-02-24	AABA-DELISTED	Stock	30.41	31.115	29.8	30.95	12072947.0
2016-02-24	AAC-DELISTED	Stock	22.79	23.895	22.79	23.045	156995.0
2016-02-24	AACG	Stock	4.21	4.6	4.21	4.6	8700.0
2016-02-24	AAIC-DELISTED	Stock	11.5	11.51	10.84	11.32	504873.0
2016-02-24	AAL	Stock	40.02	40.83	39.39	40.66	6103700.0
2016-02-24	AAMC-DELISTED	Stock	5.2588	5.5294	4.9824	5.2794	67912.0
2016-02-24	AAMI	Stock	11.04	11.45	10.7	11.4	60000.0
2016-02-24	AAOI	Stock	16.17	16.28	15.6	15.97	287500.0
2016-02-24	AAON	Stock	14.0533	15.2067	14.0533	14.9467	369450.0
2016-02-24	AAP	Stock	147.34	150.62	145.47	150.42	624900.0
2016-02-24	AAT	Stock	36.02	37.02	36.02	36.89	157000.0
2016-02-24	AAU-DELISTED	Stock	0.8	0.8148	0.7453	0.7688	199273.0
2016-02-24	AAUAF-DELISTED	Stock	0.8	0.8148	0.7453	0.7688	200031.0
2016-02-24	AAV-DELISTED	Stock	4.99	5.1	4.96	5.05	49713.0
2016-02-24	AAVL-DELISTED	Stock	5.3	5.38	5.02	5.28	248275.0
2016-02-24	AAWW-DELISTED	Stock	35.42	36.94	34.917	36.58	276780.0
2016-02-24	AAXJ	Stock	48.58	49.3	48.32	49.15	579232.0
2016-02-24	AAXN-DELISTED	Stock	16.8	17.235	16.3005	17.22	850874.0
2016-02-24	AB	Stock	18.35	19.12	18.1	18.92	220600.0
2016-02-24	ABAC-DELISTED	Stock	0.6202	0.6233	0.6101	0.6101	7000.0
2016-02-24	ABAX-DELISTED	Stock	39.06	39.88	38.79	39.6	145585.0
2016-02-24	ABB-DELISTED	Stock	17.35	17.709	17.26	17.685	1509862.0
2016-02-24	ABBNY-DELISTED	Stock	17.35	17.709	17.26	17.69	1547863.0
2016-02-24	ABBV	Stock	54.66	55.07	54.01	54.89	6633800.0
2016-02-24	ABC-DELISTED	Stock	86.52	87.28	85.8	87.1	2480426.0
2016-02-24	ABCB	Stock	26.06	26.46	25.8	26.4	150300.0
2016-02-24	ABCD-DELISTED	Stock	4.02	4.23	3.97	4.23	18384.0
2016-02-24	ABCO-DELISTED	Stock	23.36	28.08	18.87	26.5	8050233.0
2016-02-24	ABCW-DELISTED	Stock	41.0	41.2	40.74	41.05	129147.0
2016-02-24	ABDC-DELISTED	Stock	9.5137	9.59	9.26	9.51	16935.0
2016-02-24	ABE-DELISTED	Stock	10.4	10.43	10.37	10.42	3500.0
2016-02-24	ABEO	Stock	59.25	61.25	57.0	60.0	2080.0
2016-02-24	ABEOW-DELISTED	Stock	0.57	0.57	0.57	0.57	827.0
2016-02-24	ABEV	Stock	4.48	4.57	4.43	4.55	13337800.0
2016-02-24	ABG	Stock	55.2	58.68	54.53	58.4	582500.0
2016-02-24	ABGB-DELISTED	Stock	0.78	0.79	0.71	0.77	100642.0
2016-02-24	ABIL-DELISTED	Stock	7.05	7.19	6.81	7.18	5910.0

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

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