PREVIEW / stock_daily / 2012-02-03

all stock daily files

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

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-03	AAPL	Stock	16.3321	16.4286	16.27	16.4171	286599600.0
2012-02-03	MSFT	Stock	30.14	30.4	30.09	30.24	41838500.0
2012-02-03	NVDA	Stock	0.393	0.3988	0.3922	0.3955	495232000.0
2012-02-03	AMZN	Stock	9.1415	9.395	9.0945	9.384	162410000.0
2012-02-03	TSLA	Stock	2.0273	2.0887	2.0167	2.0767	11467500.0
2012-02-03	TLT	Stock	116.46	116.8	115.97	116.57	12467695.0
2012-02-03	ES	Stock	35.33	35.48	35.04	35.3	897400.0
2012-02-03	CL	Stock	45.77	46.05	45.66	45.77	4805000.0
2012-02-03	A	Stock	31.7597	32.4034	31.6237	32.3891	4875106.0
2012-02-03	AABA-DELISTED	Stock	15.95	15.975	15.83	15.93	13090748.0
2012-02-03	AACC-DELISTED	Stock	4.67	4.75	4.67	4.7	10760.0
2012-02-03	AACG	Stock	6.73	7.1	6.73	7.0	6300.0
2012-02-03	AAIC-DELISTED	Stock	23.54	23.95	23.54	23.7	63389.0
2012-02-03	AAME	Stock	2.05	2.05	2.01	2.05	2000.0
2012-02-03	AAMRQ-DELISTED	Stock	0.645	0.661	0.637	0.644	7868877.0
2012-02-03	AAON	Stock	6.5304	6.5304	6.4474	6.48	229838.0
2012-02-03	AAP	Stock	77.12	77.21	76.66	76.92	1193700.0
2012-02-03	AAT	Stock	22.75	23.12	22.49	23.11	188700.0
2012-02-03	AAU-DELISTED	Stock	2.54	2.61	2.52	2.54	150475.0
2012-02-03	AAUAF-DELISTED	Stock	2.54	2.61	2.52	2.54	150675.0
2012-02-03	AAV-DELISTED	Stock	3.81	3.87	3.73	3.79	698415.0
2012-02-03	AAWW-DELISTED	Stock	49.96	51.28	49.65	50.8	299717.0
2012-02-03	AAXJ	Stock	56.99	57.315	56.81	57.29	262923.0
2012-02-03	AAXN-DELISTED	Stock	4.97	5.01	4.87	4.98	419350.0
2012-02-03	AB	Stock	16.18	16.75	16.1	16.52	654900.0
2012-02-03	ABAC-DELISTED	Stock	1.61	1.65	1.56	1.57	20024.0
2012-02-03	ABAX-DELISTED	Stock	28.3	28.67	27.99	28.5	92120.0
2012-02-03	ABB-DELISTED	Stock	21.67	21.955	21.66	21.92	1713417.0
2012-02-03	ABBNY-DELISTED	Stock	21.67	21.955	21.66	21.91	2050627.0
2012-02-03	ABC-DELISTED	Stock	39.42	39.72	39.08	39.2	2687612.0
2012-02-03	ABCB	Stock	11.2	11.44	11.09	11.35	73500.0
2012-02-03	ABCD-DELISTED	Stock	3.28	3.33	3.24	3.3	52327.0
2012-02-03	ABCO-DELISTED	Stock	37.6	38.19	37.49	37.7	241092.0
2012-02-03	ABCW-DELISTED	Stock	0.2309	0.3313	0.2309	0.3012	40990.0
2012-02-03	ABD-DELISTED	Stock	11.0	11.16	10.96	11.01	544540.0
2012-02-03	ABE-DELISTED	Stock	19.25	19.4	19.25	19.35	10090.0
2012-02-03	ABEO	Stock	1750.0	1800.0	1750.0	1800.0	38.0
2012-02-03	ABFS-DELISTED	Stock	18.95	19.2	18.7	18.95	418642.0
2012-02-03	ABG	Stock	24.2	24.85	24.1	24.47	389100.0
2012-02-03	ABH-DELISTED	Stock	15.43	15.9	15.39	15.9	505521.0
2012-02-03	ABM	Stock	22.88	23.62	22.76	23.18	314100.0
2012-02-03	ABMD-DELISTED	Stock	21.75	21.92	19.75	20.97	2076349.0
2012-02-03	ABR	Stock	4.27	4.31	4.17	4.28	87300.0
2012-02-03	ABT	Stock	26.2834	26.4562	26.2259	26.389	16573364.0
2012-02-03	ABTL-DELISTED	Stock	4.4589	4.5911	4.3915	4.5911	50973.0
2012-02-03	ABUS	Stock	2.23	2.23	2.0	2.2	22400.0
2012-02-03	ABV-DELISTED	Stock	38.29	38.43	37.85	37.91	3244085.0
2012-02-03	ABVA-DELISTED	Stock	3.45	3.45	3.44	3.45	20544.0
2012-02-03	ABVT-DELISTED	Stock	69.61	69.9	68.57	68.8	127471.0
2012-02-03	ABX-DELISTED	Stock	49.26	49.335	48.43	49.04	9872422.0

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

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