PREVIEW / stock_daily / 2014-04-07

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-07.parquet
  size:    219 KB
  rows:    6,542
  symbols: 3,557

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-04-07	AAPL	Stock	18.8579	18.9607	18.6389	18.6954	289850400.0
2014-04-07	MSFT	Stock	39.96	40.27	39.74	39.8	37559600.0
2014-04-07	NVDA	Stock	0.454	0.464	0.4515	0.4552	428576000.0
2014-04-07	AMZN	Stock	16.0495	16.247	15.6565	15.888	141548000.0
2014-04-07	GOOGL	Stock	27.2395	27.4925	26.5265	27.0315	79231040.0
2014-04-07	META	Stock	55.9	58.0	55.44	56.95	108488000.0
2014-04-07	TSLA	Stock	13.7207	14.4133	13.5673	13.8347	147832500.0
2014-04-07	TLT	Stock	108.62	109.29	108.6	109.11	7562895.0
2014-04-07	ES	Stock	45.13	45.74	45.08	45.1	1435300.0
2014-04-07	CL	Stock	63.92	65.3	63.91	64.92	4229000.0
2014-04-07	A	Stock	39.7425	39.814	38.5837	38.877	3613131.0
2014-04-07	AABA-DELISTED	Stock	34.04	34.37	32.53	33.07	46191878.0
2014-04-07	AACG	Stock	4.09	4.09	4.04	4.09	2000.0
2014-04-07	AAIC-DELISTED	Stock	25.91	25.98	25.1721	25.56	419467.0
2014-04-07	AAL	Stock	36.78	37.48	35.46	35.78	10569800.0
2014-04-07	AAMC-DELISTED	Stock	320.2941	323.1529	308.8206	314.1676	51255.0
2014-04-07	AAME	Stock	3.67	3.67	3.65	3.67	3000.0
2014-04-07	AAOI	Stock	22.19	22.52	20.74	20.99	304800.0
2014-04-07	AAON	Stock	11.8178	11.8178	11.4756	11.5244	531225.0
2014-04-07	AAP	Stock	121.44	121.66	117.52	118.11	1238900.0
2014-04-07	AAT	Stock	33.59	34.06	33.48	33.75	176600.0
2014-04-07	AAU-DELISTED	Stock	1.4599	1.5	1.39	1.3901	84461.0
2014-04-07	AAUAF-DELISTED	Stock	1.46	1.5	1.39	1.3901	85355.0
2014-04-07	AAV-DELISTED	Stock	5.25	5.25	5.03	5.15	302553.0
2014-04-07	AAWW-DELISTED	Stock	35.7	36.06	34.73	34.97	447302.0
2014-04-07	AAXJ	Stock	59.59	59.9	59.37	59.53	475021.0
2014-04-07	AAXN-DELISTED	Stock	17.55	17.732	16.82	17.07	1128647.0
2014-04-07	AB	Stock	25.17	25.51	24.97	25.03	820200.0
2014-04-07	ABAC-DELISTED	Stock	1.84	1.85	1.8199	1.82	9233.0
2014-04-07	ABAX-DELISTED	Stock	37.67	39.49	36.88	39.47	155575.0
2014-04-07	ABB-DELISTED	Stock	26.01	26.04	25.64	25.73	1865577.0
2014-04-07	ABBNY-DELISTED	Stock	26.01	26.04	25.64	25.73	1988098.0
2014-04-07	ABBV	Stock	51.68	52.31	49.65	50.62	9146600.0
2014-04-07	ABC-DELISTED	Stock	64.94	65.08	63.61	64.19	2779920.0
2014-04-07	ABCB	Stock	23.41	23.73	23.01	23.09	61500.0
2014-04-07	ABCD-DELISTED	Stock	2.15	2.29	2.15	2.2	44588.0
2014-04-07	ABCO-DELISTED	Stock	62.36	63.48	59.66	60.28	230075.0
2014-04-07	ABE-DELISTED	Stock	13.33	13.41	13.2519	13.33	15362.0
2014-04-07	ABEO	Stock	637.5	637.5	562.5	625.0	11.0
2014-04-07	ABEV	Stock	7.55	7.59	7.47	7.54	14739500.0
2014-04-07	ABFS-DELISTED	Stock	36.49	37.3	35.27	35.478	283961.0
2014-04-07	ABG	Stock	56.47	56.63	54.6	55.22	409500.0
2014-04-07	ABGB-DELISTED	Stock	25.6	25.6	24.67	25.19	15615.0
2014-04-07	ABIL-DELISTED	Stock	9.63	9.75	9.63	9.69	12733.0
2014-04-07	ABM	Stock	28.2	28.26	27.99	28.15	193100.0
2014-04-07	ABMD-DELISTED	Stock	25.11	25.11	23.87	24.14	519256.0
2014-04-07	ABR	Stock	7.17	7.32	7.17	7.23	180800.0
2014-04-07	ABR.A-DELISTED	Stock	24.9001	25.0	24.81	24.81	3500.0
2014-04-07	ABR.B-DELISTED	Stock	23.0	23.0	22.95	22.99	13403.0
2014-04-07	ABR.C-DELISTED	Stock	24.86	24.86	24.7999	24.83	9822.0

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

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