PREVIEW / stock_daily / 2014-03-31

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-31.parquet
  size:    219 KB
  rows:    6,552
  symbols: 3,564

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-31	AAPL	Stock	19.2582	19.3146	19.1404	19.1693	168669200.0
2014-03-31	MSFT	Stock	40.43	41.5	40.4	40.99	46886300.0
2014-03-31	NVDA	Stock	0.4482	0.4522	0.4452	0.4478	273404000.0
2014-03-31	AMZN	Stock	17.12	17.3145	16.703	16.8185	85950000.0
2014-03-31	META	Stock	60.78	61.52	59.87	60.24	53011000.0
2014-03-31	TSLA	Stock	14.4333	14.45	13.7593	13.8967	125700000.0
2014-03-31	TLT	Stock	108.74	111.07	108.34	109.1	7488392.0
2014-03-31	ES	Stock	45.16	45.69	44.99	45.5	1327100.0
2014-03-31	CL	Stock	64.5	64.92	64.03	64.87	3568300.0
2014-03-31	A	Stock	39.3205	40.093	39.0343	40.0	3062738.0
2014-03-31	AABA-DELISTED	Stock	36.46	36.58	35.73	35.89	14522739.0
2014-03-31	AACG	Stock	4.07	4.43	3.95	3.98	58100.0
2014-03-31	AAIC-DELISTED	Stock	26.05	26.54	26.02	26.48	914289.0
2014-03-31	AAL	Stock	35.84	36.87	35.75	36.6	8415300.0
2014-03-31	AAMC-DELISTED	Stock	314.7059	323.6765	314.7059	316.0735	39545.0
2014-03-31	AAME	Stock	3.66	3.74	3.63	3.64	23700.0
2014-03-31	AAOI	Stock	24.7	24.84	24.5	24.67	511700.0
2014-03-31	AAON	Stock	12.3111	12.5778	12.2	12.3867	263700.0
2014-03-31	AAP	Stock	125.26	126.6	124.76	126.5	534100.0
2014-03-31	AAT	Stock	33.68	34.2	33.25	33.74	109000.0
2014-03-31	AAU-DELISTED	Stock	1.35	1.391	1.35	1.39	126785.0
2014-03-31	AAUAF-DELISTED	Stock	1.35	1.391	1.35	1.3899	127657.0
2014-03-31	AAV-DELISTED	Stock	4.95	5.1	4.87	4.93	482185.0
2014-03-31	AAWW-DELISTED	Stock	34.53	35.32	34.0675	35.27	239428.0
2014-03-31	AAXJ	Stock	59.33	59.39	59.05	59.09	282716.0
2014-03-31	AAXN-DELISTED	Stock	18.45	18.61	18.18	18.28	1179514.0
2014-03-31	AB	Stock	25.2	25.74	24.96	24.97	551700.0
2014-03-31	ABAC-DELISTED	Stock	1.8	1.87	1.79	1.86	6835.0
2014-03-31	ABAX-DELISTED	Stock	38.16	39.39	37.96	38.8	120651.0
2014-03-31	ABB-DELISTED	Stock	25.85	25.89	25.75	25.785	1000265.0
2014-03-31	ABBNY-DELISTED	Stock	25.85	25.89	25.75	25.79	1097406.0
2014-03-31	ABBV	Stock	51.34	51.7	50.95	51.4	4813100.0
2014-03-31	ABC-DELISTED	Stock	65.3	65.64	65.06	65.58	1344652.0
2014-03-31	ABCB	Stock	23.16	23.58	22.91	23.3	97300.0
2014-03-31	ABCD-DELISTED	Stock	2.16	2.16	2.12	2.13	4600.0
2014-03-31	ABCO-DELISTED	Stock	63.62	64.52	63.31	64.23	146901.0
2014-03-31	ABE-DELISTED	Stock	13.13	13.32	13.13	13.3	22444.0
2014-03-31	ABEO	Stock	650.0	687.5	625.0	687.5	29.0
2014-03-31	ABEV	Stock	7.45	7.5	7.39	7.41	7004800.0
2014-03-31	ABFS-DELISTED	Stock	35.43	37.2	35.43	36.95	281251.0
2014-03-31	ABG	Stock	54.46	55.74	54.05	55.31	524000.0
2014-03-31	ABGB-DELISTED	Stock	23.4999	23.524	23.3	23.3	7091.0
2014-03-31	ABM	Stock	28.34	28.81	28.21	28.74	293000.0
2014-03-31	ABMD-DELISTED	Stock	25.9	26.26	25.64	26.03	322574.0
2014-03-31	ABR	Stock	6.85	6.94	6.79	6.92	116300.0
2014-03-31	ABR.A-DELISTED	Stock	24.7	24.788	24.7	24.788	1650.0
2014-03-31	ABR.B-DELISTED	Stock	22.85	22.99	22.85	22.86	12581.0
2014-03-31	ABR.C-DELISTED	Stock	24.7	24.8	24.6701	24.7501	10510.0
2014-03-31	ABT	Stock	38.48	38.58	38.1	38.51	8038000.0
2014-03-31	ABTL-DELISTED	Stock	12.15	12.55	11.81	12.428	177051.0

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

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