PREVIEW / stock_daily / 2012-01-31

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-31.parquet
  size:    198 KB
  rows:    6,157
  symbols: 3,543

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-31	AAPL	Stock	16.2711	16.3657	16.1811	16.3029	391683600.0
2012-01-31	MSFT	Stock	29.66	29.7	29.23	29.53	50572400.0
2012-01-31	NVDA	Stock	0.371	0.3713	0.3628	0.3692	357900000.0
2012-01-31	AMZN	Stock	9.7	9.7815	9.485	9.722	255444000.0
2012-01-31	TSLA	Stock	1.9933	2.0	1.9247	1.938	14346000.0
2012-01-31	TLT	Stock	119.26	120.91	119.19	120.85	7998257.0
2012-01-31	ES	Stock	34.73	34.81	34.47	34.75	1500500.0
2012-01-31	CL	Stock	44.89	45.465	44.885	45.36	5923200.0
2012-01-31	A	Stock	30.9943	31.1445	30.2647	30.3791	4697979.0
2012-01-31	AABA-DELISTED	Stock	15.56	15.62	15.41	15.47	10652387.0
2012-01-31	AACC-DELISTED	Stock	4.6	4.71	4.5	4.68	5885.0
2012-01-31	AACG	Stock	6.64	6.8	6.63	6.63	2900.0
2012-01-31	AAIC-DELISTED	Stock	22.66	22.83	22.31	22.4	43286.0
2012-01-31	AAME	Stock	2.05	2.05	2.02	2.03	2600.0
2012-01-31	AAMRQ-DELISTED	Stock	0.712	0.729	0.6814	0.683	9130319.0
2012-01-31	AAON	Stock	6.0593	6.0593	5.92	5.9911	134663.0
2012-01-31	AAP	Stock	76.7	77.07	76.2	76.64	779800.0
2012-01-31	AAT	Stock	22.09	22.28	21.55	22.14	142000.0
2012-01-31	AAU-DELISTED	Stock	2.58	2.65	2.43	2.54	166806.0
2012-01-31	AAUAF-DELISTED	Stock	2.58	2.65	2.43	2.55	167006.0
2012-01-31	AAV-DELISTED	Stock	3.6	3.66	3.41	3.53	890559.0
2012-01-31	AAWW-DELISTED	Stock	47.47	47.93	46.6	47.64	559770.0
2012-01-31	AAXJ	Stock	55.3	55.48	54.872	55.08	392019.0
2012-01-31	AAXN-DELISTED	Stock	4.7	4.77	4.64	4.75	227526.0
2012-01-31	AB	Stock	15.03	15.31	14.97	15.22	309600.0
2012-01-31	ABAC-DELISTED	Stock	1.62	1.62	1.5601	1.6	5176.0
2012-01-31	ABAX-DELISTED	Stock	27.08	27.19	26.58	27.08	85746.0
2012-01-31	ABB-DELISTED	Stock	21.17	21.18	20.64	20.82	6887902.0
2012-01-31	ABBNY-DELISTED	Stock	21.15	21.18	20.64	20.83	7547613.0
2012-01-31	ABC-DELISTED	Stock	39.02	39.68	38.86	38.98	2746354.0
2012-01-31	ABCB	Stock	10.82	10.82	10.6	10.7	183100.0
2012-01-31	ABCD-DELISTED	Stock	3.18	3.25	3.15	3.21	17686.0
2012-01-31	ABCO-DELISTED	Stock	39.23	39.32	38.01	38.11	274360.0
2012-01-31	ABCW-DELISTED	Stock	0.3614	0.3614	0.3113	0.3113	31010.0
2012-01-31	ABD-DELISTED	Stock	10.56	10.81	10.31	10.62	1252400.0
2012-01-31	ABE-DELISTED	Stock	18.57	18.8	18.47	18.77	19906.0
2012-01-31	ABEO	Stock	1687.5	1712.5	1637.5	1712.5	39.0
2012-01-31	ABFS-DELISTED	Stock	18.11	18.54	17.68	18.12	731589.0
2012-01-31	ABG	Stock	23.43	23.46	22.82	22.91	171500.0
2012-01-31	ABH-DELISTED	Stock	14.33	14.51	14.295	14.47	632713.0
2012-01-31	ABM	Stock	21.73	21.84	21.35	21.7	426200.0
2012-01-31	ABMD-DELISTED	Stock	17.53	18.83	17.53	18.5	731058.0
2012-01-31	ABR	Stock	4.3	4.3	4.2	4.24	26300.0
2012-01-31	ABT	Stock	26.1827	26.269	25.89	25.9812	25874114.0
2012-01-31	ABTL-DELISTED	Stock	4.55	4.65	4.4	4.6	12502.0
2012-01-31	ABUS	Stock	2.17	2.2	2.0	2.08	14300.0
2012-01-31	ABV-DELISTED	Stock	36.87	36.88	36.28	36.42	3490195.0
2012-01-31	ABVA-DELISTED	Stock	3.4	3.47	3.4	3.45	34782.0
2012-01-31	ABVT-DELISTED	Stock	66.89	67.0	66.06	66.42	80512.0
2012-01-31	ABX-DELISTED	Stock	49.95	50.23	48.76	49.28	6484321.0

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

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