PREVIEW / stock_daily / 2011-02-02

all stock daily files

  file:    by_date/stock_daily/2011/2011-02-02.parquet
  size:    195 KB
  rows:    6,055
  symbols: 3,532

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-02-02	AAPL	Stock	12.3018	12.3304	12.2696	12.2971	258955200.0
2011-02-02	MSFT	Stock	27.93	28.11	27.88	27.94	45824000.0
2011-02-02	NVDA	Stock	0.6082	0.6543	0.6082	0.6395	1606616000.0
2011-02-02	AMZN	Stock	8.571	8.76	8.5435	8.6765	90950000.0
2011-02-02	TSLA	Stock	1.6107	1.612	1.578	1.596	8542500.0
2011-02-02	TLT	Stock	90.9	91.0	89.9	90.47	13624781.0
2011-02-02	ES	Stock	33.59	33.85	33.49	33.72	1822900.0
2011-02-02	CL	Stock	38.115	38.115	37.43	38.025	15127600.0
2011-02-02	A	Stock	29.8641	29.9785	29.1989	29.4921	5551178.0
2011-02-02	AABA-DELISTED	Stock	16.26	16.66	16.25	16.57	20558662.0
2011-02-02	AACC-DELISTED	Stock	6.26	6.34	6.08	6.16	10639.0
2011-02-02	AACG	Stock	4.17	4.2	4.17	4.19	3000.0
2011-02-02	AAI-DELISTED	Stock	7.38	7.41	7.35	7.36	3485045.0
2011-02-02	AAIC-DELISTED	Stock	25.29	25.75	25.29	25.33	31605.0
2011-02-02	AAME	Stock	2.2	2.22	2.17	2.17	4100.0
2011-02-02	AAON	Stock	5.4519	5.4815	5.3156	5.3689	63281.0
2011-02-02	AAP	Stock	63.35	63.35	61.3	61.61	1224900.0
2011-02-02	AAT	Stock	21.15	21.25	21.06	21.11	168300.0
2011-02-02	AATI-DELISTED	Stock	4.05	4.16	4.05	4.16	287961.0
2011-02-02	AAU-DELISTED	Stock	3.75	3.75	3.65	3.68	241752.0
2011-02-02	AAUAF-DELISTED	Stock	3.75	3.75	3.65	3.68	242452.0
2011-02-02	AAV-DELISTED	Stock	7.59	7.7	7.54	7.64	513113.0
2011-02-02	AAWW-DELISTED	Stock	53.5	54.22	52.7301	52.7301	174943.0
2011-02-02	AAXJ	Stock	62.6	62.82	62.34	62.46	574389.0
2011-02-02	AAXN-DELISTED	Stock	4.28	4.35	4.22	4.22	310136.0
2011-02-02	AB	Stock	21.36	21.48	20.63	21.08	1768600.0
2011-02-02	ABAC-DELISTED	Stock	5.2	5.2	5.02	5.0899	37727.0
2011-02-02	ABAX-DELISTED	Stock	26.41	26.41	25.87	26.0	56420.0
2011-02-02	ABB-DELISTED	Stock	23.18	23.41	23.18	23.33	3819289.0
2011-02-02	ABBC-DELISTED	Stock	12.95	12.95	12.52	12.59	106879.0
2011-02-02	ABBNY-DELISTED	Stock	23.18	23.41	23.18	23.35	3820089.0
2011-02-02	ABC-DELISTED	Stock	35.58	36.29	35.31	35.49	3919868.0
2011-02-02	ABCB	Stock	9.78	9.95	9.62	9.78	30300.0
2011-02-02	ABCD-DELISTED	Stock	3.4	3.45	3.28	3.29	13002.0
2011-02-02	ABCO-DELISTED	Stock	24.86	25.41	24.71	24.91	58319.0
2011-02-02	ABCW-DELISTED	Stock	1.4772	1.8293	1.4772	1.8	926710.0
2011-02-02	ABD-DELISTED	Stock	8.48	8.59	8.43	8.51	96980.0
2011-02-02	ABE-DELISTED	Stock	18.58	18.787	18.4	18.63	9848.0
2011-02-02	ABEO	Stock	3062.5	3125.0	3062.5	3125.0	3.0
2011-02-02	ABFS-DELISTED	Stock	26.0	26.11	24.86	24.96	428596.0
2011-02-02	ABG	Stock	18.6	18.99	18.39	18.5	147800.0
2011-02-02	ABH-DELISTED	Stock	26.81	26.97	26.32	26.8	664198.0
2011-02-02	ABM	Stock	26.5	26.8	26.33	26.38	133500.0
2011-02-02	ABMD-DELISTED	Stock	9.92	10.16	9.89	10.11	179563.0
2011-02-02	ABR	Stock	6.13	6.16	5.75	6.07	31800.0
2011-02-02	ABT	Stock	21.7205	21.97	21.6438	21.9413	26265527.0
2011-02-02	ABTL-DELISTED	Stock	4.6995	4.9016	4.5999	4.75	13462.0
2011-02-02	ABUS	Stock	5.96	6.0	5.89	5.93	14900.0
2011-02-02	ABV-DELISTED	Stock	26.94	27.46	26.79	27.18	2125738.0
2011-02-02	ABVA-DELISTED	Stock	4.8999	4.9	4.89	4.8999	1206.0

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

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