PREVIEW / stock_daily / 2012-02-02

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-02.parquet
  size:    198 KB
  rows:    6,157
  symbols: 3,545

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-02-02	AAPL	Stock	16.2821	16.3275	16.2136	16.2543	186796400.0
2012-02-02	MSFT	Stock	29.9	30.17	29.71	29.95	52223300.0
2012-02-02	NVDA	Stock	0.3753	0.3888	0.3715	0.3873	696236000.0
2012-02-02	AMZN	Stock	8.9825	9.097	8.84	9.086	174726000.0
2012-02-02	TSLA	Stock	1.9813	2.0587	1.974	2.0167	12085500.0
2012-02-02	TLT	Stock	118.96	119.48	118.64	119.13	5596854.0
2012-02-02	ES	Stock	35.21	35.49	35.03	35.11	1151300.0
2012-02-02	CL	Stock	45.84	45.935	45.39	45.445	3845000.0
2012-02-02	A	Stock	31.6237	31.8312	31.2303	31.2732	3112787.0
2012-02-02	AABA-DELISTED	Stock	15.74	15.82	15.69	15.71	9813416.0
2012-02-02	AACC-DELISTED	Stock	4.66	4.749	4.59	4.66	3900.0
2012-02-02	AAIC-DELISTED	Stock	23.17	23.38	23.0	23.29	45971.0
2012-02-02	AAME	Stock	2.05	2.05	1.91	2.03	20800.0
2012-02-02	AAMRQ-DELISTED	Stock	0.606	0.832	0.605	0.633	13015538.0
2012-02-02	AAON	Stock	6.3111	6.5007	6.2489	6.3822	167063.0
2012-02-02	AAP	Stock	77.05	77.05	75.69	76.27	984000.0
2012-02-02	AAT	Stock	22.69	22.69	22.19	22.56	169500.0
2012-02-02	AAU-DELISTED	Stock	2.51	2.6	2.51	2.51	151403.0
2012-02-02	AAUAF-DELISTED	Stock	2.51	2.6	2.51	2.51	151803.0
2012-02-02	AAV-DELISTED	Stock	3.58	3.8	3.56	3.77	1020698.0
2012-02-02	AAWW-DELISTED	Stock	49.06	49.69	48.35	48.6988	277821.0
2012-02-02	AAXJ	Stock	56.41	56.72	56.29	56.38	339914.0
2012-02-02	AAXN-DELISTED	Stock	4.97	5.05	4.86	4.91	354992.0
2012-02-02	AB	Stock	15.4	16.03	15.34	16.01	449000.0
2012-02-02	ABAC-DELISTED	Stock	1.61	1.69	1.6	1.6	8850.0
2012-02-02	ABAX-DELISTED	Stock	27.56	27.91	27.42	27.81	68670.0
2012-02-02	ABB-DELISTED	Stock	21.66	21.72	21.59	21.68	1558485.0
2012-02-02	ABBNY-DELISTED	Stock	21.66	21.72	21.59	21.67	1560171.0
2012-02-02	ABC-DELISTED	Stock	39.58	39.79	38.93	39.35	2575629.0
2012-02-02	ABCB	Stock	10.77	11.2	10.66	11.04	260400.0
2012-02-02	ABCD-DELISTED	Stock	3.18	3.22	3.18	3.22	8856.0
2012-02-02	ABCO-DELISTED	Stock	38.42	38.5	36.94	36.96	550979.0
2012-02-02	ABCW-DELISTED	Stock	0.3012	0.3514	0.3012	0.3113	24930.0
2012-02-02	ABD-DELISTED	Stock	10.87	10.98	10.82	10.9	473270.0
2012-02-02	ABE-DELISTED	Stock	19.06	19.15	19.05	19.14	5636.0
2012-02-02	ABEO	Stock	1650.0	1800.0	1650.0	1800.0	27.0
2012-02-02	ABFS-DELISTED	Stock	18.82	19.1	18.7	18.95	256578.0
2012-02-02	ABG	Stock	23.35	24.08	23.29	23.75	252800.0
2012-02-02	ABH-DELISTED	Stock	14.79	15.33	14.71	15.31	357250.0
2012-02-02	ABM	Stock	22.43	22.7	22.24	22.54	228700.0
2012-02-02	ABMD-DELISTED	Stock	19.09	20.23	18.96	19.23	977789.0
2012-02-02	ABR	Stock	4.22	4.27	4.15	4.23	48700.0
2012-02-02	ABT	Stock	26.0244	26.1779	25.89	26.1251	19152147.0
2012-02-02	ABTL-DELISTED	Stock	4.6017	4.7028	4.3984	4.45	71454.0
2012-02-02	ABUS	Stock	2.11	2.5	2.11	2.5	600.0
2012-02-02	ABV-DELISTED	Stock	37.72	37.9	37.5	37.59	2332658.0
2012-02-02	ABVA-DELISTED	Stock	3.45	3.47	3.35	3.45	44857.0
2012-02-02	ABVT-DELISTED	Stock	68.28	68.91	68.28	68.7	55249.0
2012-02-02	ABX-DELISTED	Stock	49.7	50.39	49.37	49.83	5830286.0
2012-02-02	ACAD	Stock	1.6	1.75	1.59	1.74	807600.0

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

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