PREVIEW / stock_daily / 2012-01-09

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-09.parquet
  size:    196 KB
  rows:    6,147
  symbols: 3,552

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-01-09	AAPL	Stock	15.1964	15.2768	15.0482	15.0618	394024400.0
2012-01-09	MSFT	Stock	28.05	28.1	27.72	27.74	59706800.0
2012-01-09	NVDA	Stock	0.3638	0.3705	0.361	0.3635	508244000.0
2012-01-09	AMZN	Stock	9.138	9.2185	8.85	8.928	101138000.0
2012-01-09	TSLA	Stock	1.8	1.8327	1.7413	1.8167	13455000.0
2012-01-09	TLT	Stock	118.47	119.54	118.3	118.52	5582580.0
2012-01-09	ES	Stock	34.45	34.83	34.37	34.51	1824400.0
2012-01-09	CL	Stock	45.07	45.125	44.74	44.89	4152400.0
2012-01-09	A	Stock	26.9099	27.4821	26.8026	27.4535	4429563.0
2012-01-09	AABA-DELISTED	Stock	15.6	15.62	15.35	15.47	12874237.0
2012-01-09	AACC-DELISTED	Stock	4.13	4.29	4.02	4.16	12117.0
2012-01-09	AACG	Stock	7.4	7.49	7.36	7.45	2000.0
2012-01-09	AAIC-DELISTED	Stock	20.71	20.75	20.388	20.59	49322.0
2012-01-09	AAME	Stock	2.03	2.04	2.0	2.02	5800.0
2012-01-09	AAMRQ-DELISTED	Stock	0.398	0.43	0.342	0.37	17885922.0
2012-01-09	AAON	Stock	5.9822	6.0119	5.8726	5.9407	286538.0
2012-01-09	AAP	Stock	71.86	71.9	70.76	71.48	686100.0
2012-01-09	AAT	Stock	20.38	20.38	19.79	19.92	89400.0
2012-01-09	AATI-DELISTED	Stock	5.8	5.8	5.78	5.785	553388.0
2012-01-09	AAU-DELISTED	Stock	2.5	2.6201	2.5	2.6	131034.0
2012-01-09	AAUAF-DELISTED	Stock	2.5	2.6201	2.5	2.6	131234.0
2012-01-09	AAV-DELISTED	Stock	4.3	4.3099	4.21	4.21	215568.0
2012-01-09	AAWW-DELISTED	Stock	39.32	40.33	38.87	39.9	216035.0
2012-01-09	AAXJ	Stock	50.56	50.82	50.51	50.62	240885.0
2012-01-09	AAXN-DELISTED	Stock	5.14	5.17	5.1	5.14	245668.0
2012-01-09	AB	Stock	14.88	15.04	14.7	14.81	609600.0
2012-01-09	ABAC-DELISTED	Stock	1.34	1.39	1.33	1.33	1750.0
2012-01-09	ABAX-DELISTED	Stock	28.03	28.03	27.42	27.56	80490.0
2012-01-09	ABB-DELISTED	Stock	19.41	19.64	19.32	19.58	2656609.0
2012-01-09	ABBNY-DELISTED	Stock	19.41	19.64	19.32	19.6	2739643.0
2012-01-09	ABC-DELISTED	Stock	38.58	38.72	38.15	38.58	1222176.0
2012-01-09	ABCB	Stock	10.35	10.71	10.35	10.62	29800.0
2012-01-09	ABCD-DELISTED	Stock	3.14	3.14	3.08	3.09	15964.0
2012-01-09	ABCO-DELISTED	Stock	37.05	37.26	36.21	36.72	282692.0
2012-01-09	ABCW-DELISTED	Stock	0.3715	0.3815	0.3715	0.3715	15210.0
2012-01-09	ABD-DELISTED	Stock	9.35	9.4	9.25	9.33	196020.0
2012-01-09	ABE-DELISTED	Stock	17.78	17.85	17.71	17.85	1817.0
2012-01-09	ABEO	Stock	1587.5	1712.5	1587.5	1700.0	8.0
2012-01-09	ABFS-DELISTED	Stock	20.53	20.53	20.11	20.32	412814.0
2012-01-09	ABG	Stock	21.75	22.59	21.62	22.39	319000.0
2012-01-09	ABH-DELISTED	Stock	15.29	15.37	14.92	15.08	102886.0
2012-01-09	ABM	Stock	20.42	20.46	20.24	20.32	198700.0
2012-01-09	ABMD-DELISTED	Stock	18.2	18.41	17.99	18.2	185987.0
2012-01-09	ABR	Stock	3.6	3.78	3.6	3.72	52200.0
2012-01-09	ABT	Stock	26.8688	26.888	26.6481	26.7968	10789496.0
2012-01-09	ABTL-DELISTED	Stock	3.7626	3.7879	3.6364	3.7374	1848.0
2012-01-09	ABUS	Stock	1.63	1.65	1.63	1.65	10600.0
2012-01-09	ABV-DELISTED	Stock	34.68	35.09	34.66	34.79	3046536.0
2012-01-09	ABVA-DELISTED	Stock	3.43	3.43	3.43	3.43	100.0
2012-01-09	ABVT-DELISTED	Stock	64.95	65.33	64.65	65.16	223507.0

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

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