PREVIEW / stock_daily / 2013-04-24

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-24.parquet
  size:    207 KB
  rows:    6,285
  symbols: 3,496

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
2013-04-24	AAPL	Stock	14.055	14.8304	14.0179	14.4807	969651200.0
2013-04-24	MSFT	Stock	30.62	31.92	30.6	31.76	90946600.0
2013-04-24	NVDA	Stock	0.324	0.3368	0.3238	0.334	556556000.0
2013-04-24	AMZN	Stock	13.475	13.5735	13.3405	13.439	37056000.0
2013-04-24	META	Stock	25.93	26.4	25.8	26.11	19729900.0
2013-04-24	TSLA	Stock	3.3933	3.4033	3.2653	3.362	39450000.0
2013-04-24	TLT	Stock	122.47	122.82	122.3	122.8	3673536.0
2013-04-24	ES	Stock	44.81	45.07	44.44	44.93	1207600.0
2013-04-24	CL	Stock	60.525	60.525	58.845	58.95	4436200.0
2013-04-24	A	Stock	30.5579	30.7868	30.3076	30.6509	4222799.0
2013-04-24	AABA-DELISTED	Stock	24.44	24.965	24.43	24.755	15035648.0
2013-04-24	AACC-DELISTED	Stock	6.48	6.51	6.48	6.485	60187.0
2013-04-24	AAIC-DELISTED	Stock	26.06	26.3	25.941	26.23	145363.0
2013-04-24	AAMC-DELISTED	Stock	42.6471	46.1765	42.6471	44.4118	89549.0
2013-04-24	AAME	Stock	3.43	3.45	3.36	3.45	8500.0
2013-04-24	AAMRQ-DELISTED	Stock	3.88	4.0	3.83	3.97	4679540.0
2013-04-24	AAON	Stock	8.3526	8.3881	8.2074	8.3378	155588.0
2013-04-24	AAP	Stock	80.47	81.43	80.47	81.18	663800.0
2013-04-24	AAT	Stock	33.11	33.34	32.68	33.25	85200.0
2013-04-24	AAU-DELISTED	Stock	1.62	1.64	1.53	1.5949	192141.0
2013-04-24	AAUAF-DELISTED	Stock	1.61	1.63	1.53	1.6	192948.0
2013-04-24	AAV-DELISTED	Stock	3.69	3.91	3.68	3.88	551356.0
2013-04-24	AAWW-DELISTED	Stock	38.55	39.01	38.33	38.67	204727.0
2013-04-24	AAXJ	Stock	58.58	59.07	58.58	58.93	247181.0
2013-04-24	AAXN-DELISTED	Stock	8.14	8.37	8.09	8.3	423053.0
2013-04-24	AB	Stock	22.9	22.96	22.64	22.76	162800.0
2013-04-24	ABAC-DELISTED	Stock	0.702	0.729	0.7	0.702	14900.0
2013-04-24	ABAX-DELISTED	Stock	44.77	44.98	44.39	44.56	56075.0
2013-04-24	ABB-DELISTED	Stock	22.27	22.55	22.21	22.43	1775199.0
2013-04-24	ABBNY-DELISTED	Stock	22.27	22.55	22.21	22.43	1812556.0
2013-04-24	ABBV	Stock	45.14	45.34	43.94	44.32	5541300.0
2013-04-24	ABC-DELISTED	Stock	56.33	56.595	55.63	55.81	3070563.0
2013-04-24	ABCB	Stock	13.93	13.99	13.7	13.88	12800.0
2013-04-24	ABCD-DELISTED	Stock	0.95	0.98	0.9453	0.98	47013.0
2013-04-24	ABCO-DELISTED	Stock	47.02	47.2	46.54	46.79	178249.0
2013-04-24	ABCW-DELISTED	Stock	0.645	0.659	0.6203	0.659	12510.0
2013-04-24	ABE-DELISTED	Stock	20.83	20.98	20.7625	20.96	6218.0
2013-04-24	ABEO	Stock	462.5	487.5	462.5	487.5	8.0
2013-04-24	ABFS-DELISTED	Stock	11.66	11.93	11.41	11.63	307284.0
2013-04-24	ABG	Stock	37.83	38.78	35.86	38.09	654100.0
2013-04-24	ABM	Stock	20.85	21.16	20.73	21.15	199200.0
2013-04-24	ABMD-DELISTED	Stock	17.99	17.99	17.72	17.85	185204.0
2013-04-24	ABR	Stock	7.43	7.56	7.35	7.47	159700.0
2013-04-24	ABR.A-DELISTED	Stock	25.94	25.94	25.882	25.89	1350.0
2013-04-24	ABT	Stock	37.27	37.35	36.39	36.52	5434100.0
2013-04-24	ABTL-DELISTED	Stock	4.24	4.24	4.14	4.19	12948.0
2013-04-24	ABUS	Stock	4.87	5.13	4.83	5.05	182000.0
2013-04-24	ABV-DELISTED	Stock	40.07	40.18	39.52	39.65	2746053.0
2013-04-24	ABX-DELISTED	Stock	18.34	19.1	17.95	18.89	30019234.0
2013-04-24	ACAD	Stock	13.73	13.8	12.95	13.5	4024300.0

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

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