PREVIEW / stock_daily / 2014-03-20

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-20.parquet
  size:    218 KB
  rows:    6,493
  symbols: 3,541

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-03-20	AAPL	Stock	18.9246	19.0239	18.8339	18.8821	208398400.0
2014-03-20	MSFT	Stock	39.25	40.65	39.24	40.33	59269800.0
2014-03-20	NVDA	Stock	0.4615	0.4683	0.4595	0.4643	191800000.0
2014-03-20	AMZN	Stock	18.532	18.65	18.311	18.4485	51170000.0
2014-03-20	META	Stock	68.01	68.23	66.82	66.97	44439000.0
2014-03-20	TSLA	Stock	15.744	15.95	15.5573	15.6607	57268500.0
2014-03-20	TLT	Stock	107.09	107.63	106.99	107.07	5224411.0
2014-03-20	ES	Stock	44.24	44.24	43.7	44.05	1935100.0
2014-03-20	CL	Stock	63.3	63.7	63.07	63.59	1978900.0
2014-03-20	A	Stock	40.4435	40.7225	40.1717	40.5579	2528143.0
2014-03-20	AABA-DELISTED	Stock	38.37	38.4656	37.42	37.78	18802810.0
2014-03-20	AACG	Stock	4.35	4.35	4.18	4.22	14000.0
2014-03-20	AAIC-DELISTED	Stock	27.74	27.999	27.59	27.89	92830.0
2014-03-20	AAL	Stock	36.61	37.09	36.28	36.56	6952100.0
2014-03-20	AAMC-DELISTED	Stock	311.7647	313.6235	303.7441	310.5882	112023.0
2014-03-20	AAME	Stock	3.55	3.67	3.55	3.65	3200.0
2014-03-20	AAOI	Stock	25.08	27.0	25.0	25.7	1383700.0
2014-03-20	AAON	Stock	12.8889	13.1111	12.8267	12.9378	342000.0
2014-03-20	AAP	Stock	124.37	125.07	123.37	124.75	588700.0
2014-03-20	AAT	Stock	33.23	33.39	32.87	33.33	158500.0
2014-03-20	AAU-DELISTED	Stock	1.46	1.5051	1.45	1.48	80557.0
2014-03-20	AAUAF-DELISTED	Stock	1.46	1.5	1.45	1.48	82007.0
2014-03-20	AAV-DELISTED	Stock	4.2	4.27	4.14	4.26	101904.0
2014-03-20	AAWW-DELISTED	Stock	32.63	32.91	32.23	32.62	104176.0
2014-03-20	AAXJ	Stock	55.93	56.51	55.86	56.45	504789.0
2014-03-20	AAXN-DELISTED	Stock	18.14	18.42	18.0	18.1	818900.0
2014-03-20	AB	Stock	25.13	25.75	25.13	25.52	492600.0
2014-03-20	ABAC-DELISTED	Stock	1.82	1.82	1.7	1.79	17300.0
2014-03-20	ABAX-DELISTED	Stock	39.55	39.73	39.31	39.49	69320.0
2014-03-20	ABB-DELISTED	Stock	24.81	25.13	24.74	25.07	797733.0
2014-03-20	ABBNY-DELISTED	Stock	24.81	25.13	24.74	25.06	855684.0
2014-03-20	ABBV	Stock	52.86	53.8	52.52	53.68	6922700.0
2014-03-20	ABC-DELISTED	Stock	66.74	66.9	66.26	66.48	1417220.0
2014-03-20	ABCB	Stock	23.78	24.04	23.75	23.93	63300.0
2014-03-20	ABCD-DELISTED	Stock	2.12	2.12	2.0	2.04	22428.0
2014-03-20	ABCO-DELISTED	Stock	68.04	69.71	67.9	69.58	144707.0
2014-03-20	ABE-DELISTED	Stock	12.5	12.79	12.5	12.55	8149.0
2014-03-20	ABEO	Stock	600.0	637.5	600.0	625.0	50.0
2014-03-20	ABEV	Stock	7.1	7.2	7.02	7.16	7316800.0
2014-03-20	ABFS-DELISTED	Stock	36.22	36.585	35.71	36.03	336619.0
2014-03-20	ABG	Stock	53.58	54.03	53.5	53.91	87900.0
2014-03-20	ABGB-DELISTED	Stock	23.5	23.5	22.8613	23.01	3077.0
2014-03-20	ABIL-DELISTED	Stock	9.64	9.71	9.64	9.69	2144.0
2014-03-20	ABM	Stock	28.77	28.87	28.62	28.78	133600.0
2014-03-20	ABMD-DELISTED	Stock	26.79	27.1599	25.77	26.2	540654.0
2014-03-20	ABR	Stock	6.7	6.74	6.67	6.73	79400.0
2014-03-20	ABR.A-DELISTED	Stock	24.55	24.62	24.45	24.62	7493.0
2014-03-20	ABR.B-DELISTED	Stock	22.99	23.0	22.9	22.999	8080.0
2014-03-20	ABR.C-DELISTED	Stock	24.78	24.87	24.72	24.76	10054.0
2014-03-20	ABT	Stock	39.46	39.64	38.78	38.87	11396600.0

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

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