PREVIEW / stock_daily / 2014-02-26

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-26.parquet
  size:    217 KB
  rows:    6,475
  symbols: 3,538

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-26	AAPL	Stock	18.7004	18.75	18.4143	18.4768	276217200.0
2014-02-26	MSFT	Stock	37.58	37.74	37.19	37.47	41041800.0
2014-02-26	NVDA	Stock	0.4675	0.4745	0.4662	0.4678	360884000.0
2014-02-26	AMZN	Stock	17.993	18.2375	17.8585	17.99	72442000.0
2014-02-26	META	Stock	70.19	71.22	68.85	69.26	55322700.0
2014-02-26	TSLA	Stock	17.2387	17.6667	16.5	16.8667	369069000.0
2014-02-26	TLT	Stock	107.31	107.92	107.24	107.92	7226557.0
2014-02-26	ES	Stock	44.64	44.68	44.19	44.23	1510500.0
2014-02-26	CL	Stock	62.11	62.54	61.86	61.95	3026300.0
2014-02-26	A	Stock	40.7582	41.216	40.5937	40.8441	3356458.0
2014-02-26	AABA-DELISTED	Stock	37.35	38.1	37.34	37.63	14568473.0
2014-02-26	AACG	Stock	4.0	4.0	3.95	3.99	17100.0
2014-02-26	AAIC-DELISTED	Stock	26.17	26.46	26.15	26.46	98584.0
2014-02-26	AAL	Stock	37.12	37.28	36.58	36.75	10514100.0
2014-02-26	AAMC-DELISTED	Stock	260.3176	270.8824	208.8235	227.0588	294858.0
2014-02-26	AAME	Stock	3.92	3.96	3.91	3.95	12500.0
2014-02-26	AAOI	Stock	20.35	20.57	19.61	19.79	95600.0
2014-02-26	AAON	Stock	12.6489	13.0667	12.5778	12.9111	170100.0
2014-02-26	AAP	Stock	126.09	126.82	124.5	125.79	1105500.0
2014-02-26	AAT	Stock	33.42	33.52	33.15	33.4	108700.0
2014-02-26	AAU-DELISTED	Stock	1.65	1.68	1.56	1.58	279202.0
2014-02-26	AAUAF-DELISTED	Stock	1.65	1.68	1.56	1.59	291279.0
2014-02-26	AAV-DELISTED	Stock	4.06	4.075	4.0	4.04	201406.0
2014-02-26	AAWW-DELISTED	Stock	31.45	31.97	30.91	31.44	322012.0
2014-02-26	AAXJ	Stock	57.69	57.76	57.31	57.39	156538.0
2014-02-26	AAXN-DELISTED	Stock	20.0	20.01	18.07	18.92	4084897.0
2014-02-26	AB	Stock	24.21	24.33	23.91	24.11	224500.0
2014-02-26	ABAC-DELISTED	Stock	1.82	1.88	1.82	1.86	17060.0
2014-02-26	ABAX-DELISTED	Stock	38.84	38.98	38.32	38.66	172738.0
2014-02-26	ABB-DELISTED	Stock	25.28	25.37	25.14	25.26	2016945.0
2014-02-26	ABBNY-DELISTED	Stock	25.28	25.37	25.14	25.26	2432526.0
2014-02-26	ABBV	Stock	49.95	50.97	49.93	50.74	5710700.0
2014-02-26	ABC-DELISTED	Stock	68.87	69.165	67.96	68.26	1380665.0
2014-02-26	ABCB	Stock	20.57	20.96	20.41	20.8	53700.0
2014-02-26	ABCD-DELISTED	Stock	1.94	2.0001	1.9	1.95	26205.0
2014-02-26	ABCO-DELISTED	Stock	64.32	65.53	63.93	64.3	144385.0
2014-02-26	ABE-DELISTED	Stock	12.55	12.57	12.494	12.494	19968.0
2014-02-26	ABEO	Stock	462.5	487.5	462.5	487.5	30.0
2014-02-26	ABEV	Stock	7.12	7.21	7.05	7.08	8012400.0
2014-02-26	ABFS-DELISTED	Stock	33.43	35.12	33.31	33.69	432453.0
2014-02-26	ABG	Stock	49.34	51.04	49.32	50.41	318800.0
2014-02-26	ABGB-DELISTED	Stock	23.2	23.2	22.5301	22.6001	29392.0
2014-02-26	ABIL-DELISTED	Stock	9.62	9.74	9.62	9.64	17471.0
2014-02-26	ABM	Stock	27.84	28.03	27.68	27.97	294600.0
2014-02-26	ABMD-DELISTED	Stock	29.02	29.11	28.72	28.94	124930.0
2014-02-26	ABR	Stock	6.86	6.86	6.79	6.79	45000.0
2014-02-26	ABR.A-DELISTED	Stock	23.87	23.92	23.72	23.92	13952.0
2014-02-26	ABR.B-DELISTED	Stock	23.0	23.0	22.81	22.81	8483.0
2014-02-26	ABT	Stock	39.29	39.66	39.03	39.39	8752600.0
2014-02-26	ABTL-DELISTED	Stock	15.4	16.32	15.33	15.89	176678.0

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

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