PREVIEW / stock_daily / 2013-02-04

all stock daily files

  file:    by_date/stock_daily/2013/2013-02-04.parquet
  size:    203 KB
  rows:    6,237
  symbols: 3,497

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
2013-02-04	AAPL	Stock	16.2111	16.2836	15.7857	15.7971	477117200.0
2013-02-04	MSFT	Stock	27.87	28.02	27.42	27.44	50540000.0
2013-02-04	NVDA	Stock	0.3075	0.3138	0.3038	0.304	511744000.0
2013-02-04	AMZN	Stock	13.139	13.234	12.9535	12.999	74472000.0
2013-02-04	META	Stock	29.06	29.2	28.01	28.11	92362200.0
2013-02-04	TSLA	Stock	2.56	2.5613	2.506	2.516	16920000.0
2013-02-04	TLT	Stock	116.59	117.28	116.42	117.02	9292144.0
2013-02-04	ES	Stock	41.07	41.17	40.95	40.99	1315300.0
2013-02-04	CL	Stock	54.42	54.7	54.32	54.365	3299000.0
2013-02-04	A	Stock	32.0458	32.1674	31.3877	31.6595	4852458.0
2013-02-04	AABA-DELISTED	Stock	19.79	19.81	19.31	19.34	23780578.0
2013-02-04	AACC-DELISTED	Stock	5.27	5.39	5.17	5.26	18215.0
2013-02-04	AACG	Stock	5.65	5.7	5.63	5.69	5100.0
2013-02-04	AAIC-DELISTED	Stock	23.64	23.72	23.29	23.55	139206.0
2013-02-04	AAMC-DELISTED	Stock	36.7647	37.0588	36.3235	37.0588	30172.0
2013-02-04	AAME	Stock	3.35	3.37	3.33	3.35	5600.0
2013-02-04	AAMRQ-DELISTED	Stock	1.245	1.29	1.19	1.24	1878142.0
2013-02-04	AAON	Stock	6.8148	6.8681	6.7407	6.8148	239963.0
2013-02-04	AAP	Stock	73.31	73.72	72.14	72.23	1063400.0
2013-02-04	AAT	Stock	29.36	29.49	29.1	29.48	223800.0
2013-02-04	AAU-DELISTED	Stock	2.75	2.8	2.7	2.73	81599.0
2013-02-04	AAUAF-DELISTED	Stock	2.76	2.8	2.71	2.72	81605.0
2013-02-04	AAV-DELISTED	Stock	2.9	2.91	2.84	2.87	165793.0
2013-02-04	AAWW-DELISTED	Stock	44.77	45.17	44.11	44.21	261721.0
2013-02-04	AAXJ	Stock	60.47	60.49	59.85	59.95	742187.0
2013-02-04	AAXN-DELISTED	Stock	8.35	8.41	8.03	8.035	560657.0
2013-02-04	AB	Stock	20.3	20.35	20.0	20.13	237200.0
2013-02-04	ABAC-DELISTED	Stock	0.8322	0.9499	0.8322	0.9	900.0
2013-02-04	ABAX-DELISTED	Stock	44.1	44.6599	43.34	43.51	402724.0
2013-02-04	ABB-DELISTED	Stock	21.27	21.34	21.0	21.04	1882373.0
2013-02-04	ABBNY-DELISTED	Stock	21.27	21.34	21.0	21.03	1892714.0
2013-02-04	ABBV	Stock	36.64	37.3	36.55	37.28	6348000.0
2013-02-04	ABC-DELISTED	Stock	46.35	46.61	45.99	46.04	2546022.0
2013-02-04	ABCB	Stock	13.35	13.46	13.26	13.31	20700.0
2013-02-04	ABCD-DELISTED	Stock	1.4	1.4	1.26	1.26	10750.0
2013-02-04	ABCO-DELISTED	Stock	54.58	54.72	52.92	53.4	354725.0
2013-02-04	ABCW-DELISTED	Stock	0.6	0.645	0.6	0.62	5100.0
2013-02-04	ABE-DELISTED	Stock	21.85	21.8642	21.75	21.75	5281.0
2013-02-04	ABEO	Stock	600.0	600.0	537.5	550.0	21.0
2013-02-04	ABFS-DELISTED	Stock	10.09	10.4	10.0	10.28	310858.0
2013-02-04	ABG	Stock	35.64	35.87	35.01	35.38	156800.0
2013-02-04	ABM	Stock	22.04	22.04	21.69	21.76	242500.0
2013-02-04	ABMD-DELISTED	Stock	13.81	14.03	13.76	13.96	591729.0
2013-02-04	ABR	Stock	7.04	7.13	7.01	7.07	93200.0
2013-02-04	ABT	Stock	33.37	33.66	33.37	33.5	14632500.0
2013-02-04	ABTL-DELISTED	Stock	4.04	4.236	4.04	4.2	4647.0
2013-02-04	ABUS	Stock	4.77	4.8	4.67	4.7	101200.0
2013-02-04	ABV-DELISTED	Stock	46.59	47.07	46.46	46.78	1703709.0
2013-02-04	ABX-DELISTED	Stock	32.06	32.73	32.0	32.35	12794099.0
2013-02-04	ACAD	Stock	6.01	6.26	5.91	6.13	2255300.0

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

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