PREVIEW / stock_daily / 2011-12-29

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-29.parquet
  size:    198 KB
  rows:    6,205
  symbols: 3,587

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
2011-12-29	AAPL	Stock	14.4071	14.4875	14.3039	14.4686	215978000.0
2011-12-29	MSFT	Stock	25.95	26.05	25.86	26.02	22616900.0
2011-12-29	NVDA	Stock	0.3462	0.35	0.3413	0.3493	211112000.0
2011-12-29	AMZN	Stock	8.481	8.7275	8.3485	8.693	164186000.0
2011-12-29	TSLA	Stock	1.906	1.956	1.9033	1.9153	7323000.0
2011-12-29	TLT	Stock	120.48	121.09	120.06	120.86	4304960.0
2011-12-29	ES	Stock	35.96	36.3	35.92	36.24	1045400.0
2011-12-29	CL	Stock	46.375	46.655	46.21	46.61	3420400.0
2011-12-29	A	Stock	24.4206	25.1288	24.3419	25.0787	2669201.0
2011-12-29	AABA-DELISTED	Stock	15.97	16.23	15.8	16.13	14602787.0
2011-12-29	AACC-DELISTED	Stock	3.63	3.88	3.55	3.85	12442.0
2011-12-29	AACG	Stock	8.0	8.0	7.53	7.69	5400.0
2011-12-29	AAIC-DELISTED	Stock	21.95	22.32	21.86	22.14	47382.0
2011-12-29	AAME	Stock	1.99	1.99	1.99	1.99	4500.0
2011-12-29	AAON	Stock	6.0563	6.1807	6.0415	6.1481	599738.0
2011-12-29	AAP	Stock	70.51	71.14	69.54	70.35	483400.0
2011-12-29	AAT	Stock	20.52	20.96	20.5	20.85	67700.0
2011-12-29	AATI-DELISTED	Stock	5.76	5.78	5.76	5.78	162976.0
2011-12-29	AAU-DELISTED	Stock	2.16	2.54	2.111	2.47	286403.0
2011-12-29	AAUAF-DELISTED	Stock	2.16	2.54	2.111	2.47	287003.0
2011-12-29	AAV-DELISTED	Stock	3.99	4.12	3.97	4.1	300620.0
2011-12-29	AAWW-DELISTED	Stock	37.6	38.79	37.4	38.54	145565.0
2011-12-29	AAXJ	Stock	49.67	50.07	49.655	50.03	340695.0
2011-12-29	AAXN-DELISTED	Stock	5.41	5.47	5.31	5.38	259469.0
2011-12-29	AB	Stock	13.11	13.31	13.02	13.2	346700.0
2011-12-29	ABAC-DELISTED	Stock	1.36	1.36	1.29	1.3	11040.0
2011-12-29	ABAX-DELISTED	Stock	27.47	27.75	27.41	27.71	42437.0
2011-12-29	ABB-DELISTED	Stock	18.52	18.74	18.48	18.7	1606832.0
2011-12-29	ABBNY-DELISTED	Stock	18.52	18.74	18.48	18.71	1606474.0
2011-12-29	ABC-DELISTED	Stock	36.87	37.4	36.81	37.34	887104.0
2011-12-29	ABCB	Stock	10.2	10.4	10.15	10.37	47400.0
2011-12-29	ABCD-DELISTED	Stock	3.05	3.22	3.05	3.13	10282.0
2011-12-29	ABCO-DELISTED	Stock	36.66	36.85	36.48	36.72	47864.0
2011-12-29	ABCW-DELISTED	Stock	0.3313	0.3414	0.3313	0.3313	77870.0
2011-12-29	ABD-DELISTED	Stock	9.795	10.015	9.795	9.805	172610.0
2011-12-29	ABE-DELISTED	Stock	17.22	17.45	17.2	17.45	10260.0
2011-12-29	ABEO	Stock	1575.0	1687.5	1575.0	1687.5	14.0
2011-12-29	ABFS-DELISTED	Stock	18.92	19.28	18.92	19.28	312702.0
2011-12-29	ABG	Stock	21.1	21.47	20.85	21.4	134000.0
2011-12-29	ABH-DELISTED	Stock	14.6	14.6	14.42	14.54	79963.0
2011-12-29	ABM	Stock	20.62	20.97	20.49	20.81	189600.0
2011-12-29	ABMD-DELISTED	Stock	18.27	18.49	18.23	18.38	143718.0
2011-12-29	ABR	Stock	3.55	3.62	3.52	3.6	29000.0
2011-12-29	ABT	Stock	26.7776	27.0559	26.7776	27.0271	9254689.0
2011-12-29	ABTL-DELISTED	Stock	3.9085	3.9613	3.6972	3.75	146808.0
2011-12-29	ABUS	Stock	1.51	1.58	1.5	1.5	13300.0
2011-12-29	ABV-DELISTED	Stock	35.8	36.25	35.77	36.15	1345753.0
2011-12-29	ABVA-DELISTED	Stock	3.5	3.5	3.36	3.4	14318.0
2011-12-29	ABVT-DELISTED	Stock	64.35	64.98	64.35	64.64	75561.0
2011-12-29	ABX-DELISTED	Stock	43.89	45.24	43.7207	45.17	4894664.0

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

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