PREVIEW / stock_daily / 2012-03-02

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-02.parquet
  size:    199 KB
  rows:    6,133
  symbols: 3,520

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-03-02	AAPL	Stock	19.4371	19.5286	19.3757	19.4707	431712400.0
2012-03-02	MSFT	Stock	32.31	32.44	32.0	32.08	47314200.0
2012-03-02	NVDA	Stock	0.38	0.39	0.38	0.3845	684076000.0
2012-03-02	AMZN	Stock	8.974	9.092	8.946	8.965	73156000.0
2012-03-02	TSLA	Stock	2.2933	2.3	2.2473	2.2693	8250000.0
2012-03-02	TLT	Stock	116.6	117.48	116.55	117.15	6669512.0
2012-03-02	ES	Stock	36.01	36.19	35.76	36.08	1443600.0
2012-03-02	CL	Stock	46.405	46.64	46.365	46.6	2521600.0
2012-03-02	A	Stock	31.5951	31.7597	31.073	31.2732	2975783.0
2012-03-02	AABA-DELISTED	Stock	14.88	14.92	14.66	14.72	9142549.0
2012-03-02	AACC-DELISTED	Stock	4.64	4.97	4.64	4.83	20642.0
2012-03-02	AACG	Stock	5.99	6.02	5.87	6.02	10400.0
2012-03-02	AAIC-DELISTED	Stock	23.01	23.18	22.8	22.95	44519.0
2012-03-02	AAME	Stock	2.58	2.83	2.58	2.7	3400.0
2012-03-02	AAMRQ-DELISTED	Stock	0.5	0.509	0.4911	0.492	1548604.0
2012-03-02	AAON	Stock	5.4756	5.5881	5.3185	5.3363	238613.0
2012-03-02	AAP	Stock	86.27	87.06	85.95	86.71	1319600.0
2012-03-02	AAT	Stock	21.24	21.74	21.18	21.64	312400.0
2012-03-02	AAU-DELISTED	Stock	3.04	3.04	2.88	2.96	152067.0
2012-03-02	AAUAF-DELISTED	Stock	3.04	3.04	2.88	2.98	152367.0
2012-03-02	AAV-DELISTED	Stock	3.91	3.97	3.86	3.93	424867.0
2012-03-02	AAWW-DELISTED	Stock	43.47	43.47	41.9	42.3	245496.0
2012-03-02	AAXJ	Stock	58.3	58.32	57.96	58.2	495876.0
2012-03-02	AAXN-DELISTED	Stock	4.22	4.27	4.05	4.05	615109.0
2012-03-02	AB	Stock	14.35	14.37	13.98	14.23	224600.0
2012-03-02	ABAC-DELISTED	Stock	1.65	1.79	1.62	1.7	14177.0
2012-03-02	ABAX-DELISTED	Stock	26.47	26.6	26.25	26.51	104953.0
2012-03-02	ABB-DELISTED	Stock	20.6	20.64	20.42	20.58	1883200.0
2012-03-02	ABBNY-DELISTED	Stock	20.6	20.64	20.42	20.6	1886789.0
2012-03-02	ABC-DELISTED	Stock	37.22	37.3	36.555	36.6	2141997.0
2012-03-02	ABCB	Stock	11.52	11.67	11.1	11.2	81800.0
2012-03-02	ABCD-DELISTED	Stock	2.92	2.95	2.81	2.88	18188.0
2012-03-02	ABCO-DELISTED	Stock	40.97	41.08	39.78	39.9	368435.0
2012-03-02	ABCW-DELISTED	Stock	0.4016	0.4317	0.3916	0.4217	22110.0
2012-03-02	ABD-DELISTED	Stock	12.02	12.41	11.92	12.01	584290.0
2012-03-02	ABE-DELISTED	Stock	19.55	19.67	19.53	19.65	25720.0
2012-03-02	ABEO	Stock	1637.5	1675.0	1500.0	1562.5	85.0
2012-03-02	ABFS-DELISTED	Stock	18.17	18.24	17.65	17.82	227446.0
2012-03-02	ABG	Stock	26.61	27.49	26.32	26.48	911600.0
2012-03-02	ABH-DELISTED	Stock	15.33	15.37	15.11	15.11	134970.0
2012-03-02	ABM	Stock	23.11	23.28	22.45	22.53	524300.0
2012-03-02	ABMD-DELISTED	Stock	21.0	21.0	20.22	20.4	554628.0
2012-03-02	ABR	Stock	4.74	4.91	4.74	4.91	165500.0
2012-03-02	ABT	Stock	27.4829	27.5981	27.3102	27.5357	11347228.0
2012-03-02	ABTL-DELISTED	Stock	5.0716	5.0716	4.7821	4.85	92417.0
2012-03-02	ABUS	Stock	2.78	2.78	2.52	2.52	10200.0
2012-03-02	ABV-DELISTED	Stock	39.61	39.96	39.5	39.85	1588820.0
2012-03-02	ABVA-DELISTED	Stock	3.94	3.94	3.78	3.8	14757.0
2012-03-02	ABVT-DELISTED	Stock	69.65	70.57	69.2	69.49	232520.0
2012-03-02	ABX-DELISTED	Stock	47.8	47.98	47.11	47.42	5434331.0

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

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