PREVIEW / stock_daily / 2012-02-23

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-23.parquet
  size:    200 KB
  rows:    6,178
  symbols: 3,551

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-23	AAPL	Stock	18.3957	18.4939	18.1964	18.4425	568027600.0
2012-02-23	MSFT	Stock	31.2	31.59	31.0	31.37	35034700.0
2012-02-23	NVDA	Stock	0.3962	0.4	0.39	0.3978	323968000.0
2012-02-23	AMZN	Stock	8.982	9.0375	8.848	8.9445	103076000.0
2012-02-23	TSLA	Stock	2.266	2.3313	2.2373	2.302	12306000.0
2012-02-23	TLT	Stock	116.14	117.22	115.93	116.736	5164243.0
2012-02-23	ES	Stock	35.88	35.98	35.62	35.74	1244000.0
2012-02-23	CL	Stock	46.425	46.95	46.325	46.665	4214200.0
2012-02-23	A	Stock	30.5651	31.216	30.4006	31.0515	3357017.0
2012-02-23	AABA-DELISTED	Stock	14.55	14.81	14.37	14.78	14612333.0
2012-02-23	AACC-DELISTED	Stock	4.4	4.45	4.2008	4.39	6885.0
2012-02-23	AACG	Stock	7.29	7.45	7.29	7.45	2000.0
2012-02-23	AAIC-DELISTED	Stock	23.0	23.91	22.91	23.84	43699.0
2012-02-23	AAME	Stock	2.35	2.4	2.26	2.34	8500.0
2012-02-23	AAMRQ-DELISTED	Stock	0.506	0.53	0.506	0.5075	1884287.0
2012-02-23	AAON	Stock	5.6385	5.9496	5.6119	5.9141	238613.0
2012-02-23	AAP	Stock	85.33	85.56	84.8	85.15	1985500.0
2012-02-23	AAT	Stock	22.34	22.37	22.11	22.36	189600.0
2012-02-23	AAU-DELISTED	Stock	2.93	2.9602	2.88	2.9	167255.0
2012-02-23	AAUAF-DELISTED	Stock	2.92	2.95	2.87	2.91	168476.0
2012-02-23	AAV-DELISTED	Stock	4.05	4.08	3.97	4.02	361286.0
2012-02-23	AAWW-DELISTED	Stock	45.06	45.88	44.07	44.63	403184.0
2012-02-23	AAXJ	Stock	57.52	57.595	57.22	57.49	320299.0
2012-02-23	AAXN-DELISTED	Stock	4.4	4.49	4.045	4.21	1169129.0
2012-02-23	AB	Stock	13.19	14.25	13.18	14.22	653400.0
2012-02-23	ABAC-DELISTED	Stock	1.5999	1.68	1.58	1.58	11782.0
2012-02-23	ABAX-DELISTED	Stock	26.21	26.74	26.13	26.66	56762.0
2012-02-23	ABB-DELISTED	Stock	20.63	20.91	20.47	20.9	2417504.0
2012-02-23	ABBNY-DELISTED	Stock	20.63	20.91	20.47	20.9	2467620.0
2012-02-23	ABC-DELISTED	Stock	36.89	37.45	36.89	37.42	2854650.0
2012-02-23	ABCB	Stock	11.04	11.43	11.0	11.4	57500.0
2012-02-23	ABCD-DELISTED	Stock	2.97	3.07	2.91	3.07	21850.0
2012-02-23	ABCO-DELISTED	Stock	38.35	39.29	38.08	38.94	156775.0
2012-02-23	ABCW-DELISTED	Stock	0.3414	0.4117	0.3414	0.4016	100290.0
2012-02-23	ABD-DELISTED	Stock	12.07	12.3	12.04	12.29	408970.0
2012-02-23	ABE-DELISTED	Stock	18.6	18.7	18.51	18.69	66767.0
2012-02-23	ABEO	Stock	1562.5	1625.0	1512.5	1625.0	35.0
2012-02-23	ABFS-DELISTED	Stock	18.57	18.93	18.38	18.81	210284.0
2012-02-23	ABG	Stock	25.2	25.44	24.79	25.02	504100.0
2012-02-23	ABH-DELISTED	Stock	15.49	15.53	15.35	15.42	154752.0
2012-02-23	ABM	Stock	22.67	23.37	22.6	23.34	235300.0
2012-02-23	ABMD-DELISTED	Stock	21.35	21.79	21.185	21.42	331281.0
2012-02-23	ABR	Stock	4.68	4.77	4.65	4.77	18800.0
2012-02-23	ABT	Stock	26.9504	27.0607	26.936	27.0079	14109004.0
2012-02-23	ABTL-DELISTED	Stock	5.2015	5.2015	4.9495	5.05	16631.0
2012-02-23	ABUS	Stock	2.37	2.4	2.37	2.4	500.0
2012-02-23	ABV-DELISTED	Stock	38.83	38.84	38.15	38.45	2026445.0
2012-02-23	ABVA-DELISTED	Stock	3.53	3.631	3.53	3.6	3400.0
2012-02-23	ABVT-DELISTED	Stock	70.77	73.51	70.54	72.25	285448.0
2012-02-23	ABX-DELISTED	Stock	49.68	50.02	49.2	49.58	6584942.0

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

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