PREVIEW / stock_daily / 2011-12-22

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-22.parquet
  size:    196 KB
  rows:    6,154
  symbols: 3,553

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-22	AAPL	Stock	14.1786	14.2546	14.1464	14.2339	202358800.0
2011-12-22	MSFT	Stock	25.82	25.86	25.48	25.81	35794100.0
2011-12-22	NVDA	Stock	0.344	0.3588	0.344	0.3578	576560000.0
2011-12-22	AMZN	Stock	8.7545	8.9835	8.7105	8.9515	93898000.0
2011-12-22	TSLA	Stock	1.84	1.87	1.82	1.8513	15141000.0
2011-12-22	TLT	Stock	120.0	120.42	119.35	119.6	5247376.0
2011-12-22	ES	Stock	35.34	35.38	34.77	35.3	1603200.0
2011-12-22	CL	Stock	46.445	46.445	45.95	46.205	3233200.0
2011-12-22	A	Stock	24.2561	25.0644	24.2561	24.9213	2636488.0
2011-12-22	AABA-DELISTED	Stock	16.36	16.4	15.95	15.99	32797887.0
2011-12-22	AACC-DELISTED	Stock	3.69	3.85	3.581	3.81	14377.0
2011-12-22	AACG	Stock	8.5	8.81	8.03	8.77	15700.0
2011-12-22	AAIC-DELISTED	Stock	22.94	23.48	22.84	23.26	77501.0
2011-12-22	AAME	Stock	1.96	2.0	1.96	2.0	5700.0
2011-12-22	AAON	Stock	6.5867	6.5956	6.3822	6.403	156600.0
2011-12-22	AAP	Stock	69.65	70.89	68.97	69.38	912100.0
2011-12-22	AAT	Stock	21.03	21.12	20.67	20.69	151800.0
2011-12-22	AATI-DELISTED	Stock	5.77	5.77	5.76	5.77	321212.0
2011-12-22	AAU-DELISTED	Stock	2.15	2.23	2.15	2.17	102286.0
2011-12-22	AAUAF-DELISTED	Stock	2.15	2.23	2.15	2.17	102886.0
2011-12-22	AAV-DELISTED	Stock	3.94	4.01	3.92	3.99	307145.0
2011-12-22	AAWW-DELISTED	Stock	38.72	38.99	37.67	38.58	240209.0
2011-12-22	AAXJ	Stock	50.04	50.52	50.0	50.35	2805945.0
2011-12-22	AAXN-DELISTED	Stock	5.73	5.75	5.57	5.59	271314.0
2011-12-22	AB	Stock	13.08	13.47	13.04	13.38	705300.0
2011-12-22	ABAC-DELISTED	Stock	1.4	1.472	1.4	1.4371	2500.0
2011-12-22	ABAX-DELISTED	Stock	27.92	28.42	27.75	28.0	146253.0
2011-12-22	ABB-DELISTED	Stock	18.17	18.48	18.12	18.46	1774666.0
2011-12-22	ABBNY-DELISTED	Stock	18.17	18.48	18.12	18.47	1775029.0
2011-12-22	ABC-DELISTED	Stock	37.04	37.33	36.96	37.09	1550626.0
2011-12-22	ABCB	Stock	10.21	10.38	10.11	10.38	20800.0
2011-12-22	ABCD-DELISTED	Stock	3.25	3.28	3.0206	3.2	33661.0
2011-12-22	ABCO-DELISTED	Stock	36.99	37.17	36.68	36.96	99702.0
2011-12-22	ABCW-DELISTED	Stock	0.2621	0.3113	0.2621	0.2912	78300.0
2011-12-22	ABD-DELISTED	Stock	9.95	10.01	9.83	9.87	183690.0
2011-12-22	ABE-DELISTED	Stock	17.2	17.29	16.97	17.29	8548.0
2011-12-22	ABEO	Stock	1637.5	1700.0	1612.5	1700.0	19.0
2011-12-22	ABFS-DELISTED	Stock	18.94	19.45	18.65	19.41	528400.0
2011-12-22	ABG	Stock	20.5	20.98	20.46	20.68	204300.0
2011-12-22	ABH-DELISTED	Stock	14.37	14.76	14.37	14.66	167002.0
2011-12-22	ABM	Stock	20.93	21.22	20.86	20.99	167700.0
2011-12-22	ABMD-DELISTED	Stock	18.0	18.69	17.86	18.53	421824.0
2011-12-22	ABR	Stock	3.48	3.6	3.46	3.5	50200.0
2011-12-22	ABT	Stock	26.6049	26.7968	26.4418	26.7009	19157982.0
2011-12-22	ABTL-DELISTED	Stock	4.4064	4.4064	3.9965	4.1	223618.0
2011-12-22	ABUS	Stock	1.64	1.69	1.64	1.65	12900.0
2011-12-22	ABV-DELISTED	Stock	36.15	36.15	35.62	35.87	2486320.0
2011-12-22	ABVA-DELISTED	Stock	3.4	3.5	3.4	3.5	2351.0
2011-12-22	ABVT-DELISTED	Stock	64.85	65.0783	64.6	64.85	117775.0
2011-12-22	ABX-DELISTED	Stock	46.08	46.28	45.3	45.95	8703439.0

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

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