PREVIEW / stock_daily / 2012-04-17

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-17.parquet
  size:    200 KB
  rows:    6,194
  symbols: 3,565

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
2012-04-17	AAPL	Stock	20.6764	21.7857	20.4254	21.775	1025528000.0
2012-04-17	MSFT	Stock	31.27	31.61	31.2	31.44	34361500.0
2012-04-17	NVDA	Stock	0.3508	0.355	0.3493	0.3505	460696000.0
2012-04-17	AMZN	Stock	9.3605	9.502	9.3435	9.4195	56584000.0
2012-04-17	TSLA	Stock	2.162	2.2047	2.136	2.1493	16732500.0
2012-04-17	TLT	Stock	116.53	116.8281	116.25	116.6	5398578.0
2012-04-17	ES	Stock	36.34	36.37	35.92	36.31	1938400.0
2012-04-17	CL	Stock	49.025	49.36	48.73	49.295	3506200.0
2012-04-17	A	Stock	30.329	30.5866	30.279	30.5079	2901130.0
2012-04-17	AABA-DELISTED	Stock	14.82	15.18	14.82	15.0	20143014.0
2012-04-17	AACC-DELISTED	Stock	4.95	5.0	4.95	4.98	77779.0
2012-04-17	AACG	Stock	6.69	6.7	6.4	6.44	4800.0
2012-04-17	AAIC-DELISTED	Stock	22.7	22.835	22.5999	22.67	76286.0
2012-04-17	AAME	Stock	2.87	2.94	2.83	2.94	2400.0
2012-04-17	AAMRQ-DELISTED	Stock	0.496	0.496	0.48	0.482	1112195.0
2012-04-17	AAON	Stock	5.8696	5.9556	5.8252	5.843	130613.0
2012-04-17	AAP	Stock	90.13	90.75	89.43	90.19	598400.0
2012-04-17	AAT	Stock	22.89	23.3	22.81	23.1	72100.0
2012-04-17	AAU-DELISTED	Stock	2.29	2.32	2.24	2.26	84950.0
2012-04-17	AAUAF-DELISTED	Stock	2.31	2.34	2.26	2.26	81973.0
2012-04-17	AAV-DELISTED	Stock	3.02	3.1	3.02	3.09	181459.0
2012-04-17	AAWW-DELISTED	Stock	47.0	49.02	46.99	48.17	280957.0
2012-04-17	AAXJ	Stock	56.08	56.46	55.76	56.3	357640.0
2012-04-17	AAXN-DELISTED	Stock	4.12	4.27	4.12	4.21	232831.0
2012-04-17	AB	Stock	14.8	14.99	14.49	14.68	132700.0
2012-04-17	ABAC-DELISTED	Stock	1.71	1.8899	1.71	1.78	80450.0
2012-04-17	ABAX-DELISTED	Stock	26.97	27.58	26.75	27.29	74057.0
2012-04-17	ABB-DELISTED	Stock	20.17	20.3511	20.0	20.27	5151842.0
2012-04-17	ABBNY-DELISTED	Stock	20.17	20.3511	20.0	20.27	5168626.0
2012-04-17	ABC-DELISTED	Stock	37.7	38.38	37.6	38.21	2315435.0
2012-04-17	ABCB	Stock	13.11	13.15	12.95	12.98	103100.0
2012-04-17	ABCD-DELISTED	Stock	2.38	2.45	2.37	2.39	28190.0
2012-04-17	ABCO-DELISTED	Stock	44.01	44.37	43.66	43.8	291390.0
2012-04-17	ABCW-DELISTED	Stock	0.8534	0.8534	0.7229	0.8534	79020.0
2012-04-17	ABD-DELISTED	Stock	11.605	11.715	11.375	11.385	1803530.0
2012-04-17	ABE-DELISTED	Stock	18.98	19.16	18.98	19.135	6294.0
2012-04-17	ABEO	Stock	1425.0	1475.0	1375.0	1475.0	11.0
2012-04-17	ABFS-DELISTED	Stock	18.37	18.89	18.37	18.7	145968.0
2012-04-17	ABG	Stock	27.78	28.2	27.71	27.76	283800.0
2012-04-17	ABH-DELISTED	Stock	13.47	13.55	13.3	13.34	222570.0
2012-04-17	ABM	Stock	23.71	23.86	23.28	23.33	337900.0
2012-04-17	ABMD-DELISTED	Stock	20.7	21.0499	20.65	20.88	202309.0
2012-04-17	ABR	Stock	5.59	5.69	5.55	5.67	18400.0
2012-04-17	ABT	Stock	28.7688	29.0567	28.6633	28.9943	12614423.0
2012-04-17	ABTL-DELISTED	Stock	4.4	4.4	4.25	4.35	19488.0
2012-04-17	ABUS	Stock	2.4	2.4	2.4	2.4	1500.0
2012-04-17	ABV-DELISTED	Stock	42.8	43.02	42.36	42.84	2181553.0
2012-04-17	ABVA-DELISTED	Stock	4.14	4.15	4.09	4.09	900.0
2012-04-17	ABVT-DELISTED	Stock	83.2	83.24	83.06	83.06	658666.0
2012-04-17	ABX-DELISTED	Stock	41.08	41.71	40.67	41.31	5292402.0

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

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