PREVIEW / stock_daily / 2012-04-24

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-24.parquet
  size:    200 KB
  rows:    6,195
  symbols: 3,570

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-24	AAPL	Stock	20.0932	20.2746	19.8214	20.01	1076149200.0
2012-04-24	MSFT	Stock	32.21	32.52	31.83	31.92	40871100.0
2012-04-24	NVDA	Stock	0.3318	0.3345	0.3188	0.3205	730440000.0
2012-04-24	AMZN	Stock	9.434	9.535	9.3255	9.5165	67526000.0
2012-04-24	TSLA	Stock	2.1213	2.1467	2.0667	2.1213	10117500.0
2012-04-24	TLT	Stock	117.61	117.76	117.08	117.09	4336567.0
2012-04-24	ES	Stock	36.12	36.44	36.06	36.41	2133300.0
2012-04-24	CL	Stock	49.0	49.265	48.86	49.215	2960400.0
2012-04-24	A	Stock	28.8841	28.9485	28.0043	28.4692	10706443.0
2012-04-24	AABA-DELISTED	Stock	15.33	15.52	15.33	15.44	11962897.0
2012-04-24	AACC-DELISTED	Stock	4.96	5.11	4.91	5.09	69368.0
2012-04-24	AACG	Stock	6.4	6.54	6.4	6.5	11900.0
2012-04-24	AAIC-DELISTED	Stock	22.96	23.7	22.91	23.47	218793.0
2012-04-24	AAME	Stock	2.89	2.93	2.81	2.9	3700.0
2012-04-24	AAMRQ-DELISTED	Stock	0.562	0.599	0.56	0.575	3977171.0
2012-04-24	AAON	Stock	5.6267	5.757	5.6267	5.7422	181913.0
2012-04-24	AAP	Stock	90.56	91.12	88.17	88.85	721900.0
2012-04-24	AAT	Stock	22.56	23.29	22.53	23.2	97500.0
2012-04-24	AAU-DELISTED	Stock	2.19	2.25	2.17	2.18	89786.0
2012-04-24	AAUAF-DELISTED	Stock	2.2	2.255	2.17	2.17	89786.0
2012-04-24	AAV-DELISTED	Stock	2.83	2.9	2.83	2.9	100652.0
2012-04-24	AAWW-DELISTED	Stock	44.34	45.44	44.25	45.2	437513.0
2012-04-24	AAXJ	Stock	55.35	55.61	55.29	55.39	117583.0
2012-04-24	AAXN-DELISTED	Stock	4.02	4.11	4.0	4.11	181375.0
2012-04-24	AB	Stock	14.1	14.5	14.09	14.29	130600.0
2012-04-24	ABAC-DELISTED	Stock	1.91	1.95	1.82	1.82	61016.0
2012-04-24	ABAX-DELISTED	Stock	28.89	29.27	28.52	28.62	110596.0
2012-04-24	ABB-DELISTED	Stock	19.93	20.24	19.89	20.219	3262811.0
2012-04-24	ABBNY-DELISTED	Stock	19.93	20.24	19.89	20.22	3268461.0
2012-04-24	ABC-DELISTED	Stock	37.42	37.715	37.23	37.51	2510791.0
2012-04-24	ABCB	Stock	12.72	13.0	12.72	12.98	64300.0
2012-04-24	ABCD-DELISTED	Stock	2.32	2.57	2.31	2.57	11159.0
2012-04-24	ABCO-DELISTED	Stock	44.12	44.51	43.69	44.15	154719.0
2012-04-24	ABCW-DELISTED	Stock	0.6627	0.7028	0.6627	0.7028	7010.0
2012-04-24	ABD-DELISTED	Stock	10.69	10.8	10.41	10.73	1241290.0
2012-04-24	ABE-DELISTED	Stock	19.12	19.2	19.07	19.2	9691.0
2012-04-24	ABEO	Stock	1462.5	1462.5	1337.5	1400.0	9.0
2012-04-24	ABFS-DELISTED	Stock	17.46	17.85	17.45	17.78	214180.0
2012-04-24	ABG	Stock	26.32	26.35	25.54	25.86	812500.0
2012-04-24	ABH-DELISTED	Stock	13.01	13.18	12.96	13.09	123213.0
2012-04-24	ABM	Stock	22.77	23.11	22.61	22.97	152600.0
2012-04-24	ABMD-DELISTED	Stock	22.37	22.88	22.0	22.77	437354.0
2012-04-24	ABR	Stock	5.5	5.58	5.46	5.57	12800.0
2012-04-24	ABT	Stock	28.74	29.167	28.74	29.1383	18150271.0
2012-04-24	ABTL-DELISTED	Stock	4.4873	4.6127	4.4623	4.6127	2117.0
2012-04-24	ABUS	Stock	2.29	2.29	2.26	2.26	1000.0
2012-04-24	ABV-DELISTED	Stock	43.76	43.85	42.95	43.17	2942721.0
2012-04-24	ABVA-DELISTED	Stock	4.05	4.05	4.03	4.03	746.0
2012-04-24	ABVT-DELISTED	Stock	83.03	83.13	83.03	83.12	117783.0
2012-04-24	ABX-DELISTED	Stock	40.01	40.09	39.32	39.61	4553383.0

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

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