PREVIEW / stock_daily / 2012-01-30

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-30.parquet
  size:    198 KB
  rows:    6,159
  symbols: 3,548

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-30	AAPL	Stock	15.9182	16.2107	15.9068	16.1789	379341200.0
2012-01-30	MSFT	Stock	28.97	29.62	28.83	29.61	51114800.0
2012-01-30	NVDA	Stock	0.3662	0.3718	0.3608	0.37	399076000.0
2012-01-30	AMZN	Stock	9.684	9.75	9.5065	9.6075	108482000.0
2012-01-30	TSLA	Stock	1.966	1.974	1.902	1.9713	10935000.0
2012-01-30	TLT	Stock	119.84	120.39	119.34	119.47	8388363.0
2012-01-30	ES	Stock	34.6	34.71	34.32	34.54	1302700.0
2012-01-30	CL	Stock	45.29	45.345	44.61	44.755	5652400.0
2012-01-30	A	Stock	29.9928	30.8941	29.8426	30.8727	4085935.0
2012-01-30	AABA-DELISTED	Stock	15.61	15.65	15.5	15.55	11016497.0
2012-01-30	AACC-DELISTED	Stock	4.65	4.88	4.6	4.68	17143.0
2012-01-30	AACG	Stock	6.32	6.63	6.32	6.59	7200.0
2012-01-30	AAIC-DELISTED	Stock	22.46	22.96	22.22	22.45	57418.0
2012-01-30	AAME	Stock	2.04	2.05	2.02	2.05	1700.0
2012-01-30	AAMRQ-DELISTED	Stock	0.705	0.719	0.6511	0.711	9766747.0
2012-01-30	AAON	Stock	6.1422	6.1926	6.0207	6.0296	77288.0
2012-01-30	AAP	Stock	76.96	76.97	75.01	76.57	1028700.0
2012-01-30	AAT	Stock	21.87	22.14	21.7	21.96	146300.0
2012-01-30	AAU-DELISTED	Stock	2.48	2.56	2.4448	2.55	141929.0
2012-01-30	AAUAF-DELISTED	Stock	2.48	2.55	2.4399	2.55	143173.0
2012-01-30	AAV-DELISTED	Stock	3.63	3.67	3.59	3.65	327732.0
2012-01-30	AAWW-DELISTED	Stock	46.52	47.14	46.19	47.03	241361.0
2012-01-30	AAXJ	Stock	54.32	54.88	54.24	54.77	542133.0
2012-01-30	AAXN-DELISTED	Stock	4.67	4.79	4.65	4.67	347898.0
2012-01-30	AB	Stock	14.96	15.09	14.84	14.92	336100.0
2012-01-30	ABAC-DELISTED	Stock	1.58	1.6	1.579	1.58	18475.0
2012-01-30	ABAX-DELISTED	Stock	27.07	27.17	26.7	26.94	101708.0
2012-01-30	ABB-DELISTED	Stock	20.63	20.7	20.44	20.54	5920510.0
2012-01-30	ABBNY-DELISTED	Stock	20.63	20.7	20.44	20.55	5924451.0
2012-01-30	ABC-DELISTED	Stock	38.88	39.0	38.56	38.81	3900209.0
2012-01-30	ABCB	Stock	10.74	10.79	10.64	10.74	18400.0
2012-01-30	ABCD-DELISTED	Stock	3.21	3.21	3.17	3.17	11368.0
2012-01-30	ABCO-DELISTED	Stock	39.52	39.52	38.6	38.98	340484.0
2012-01-30	ABCW-DELISTED	Stock	0.3614	0.3614	0.2962	0.3213	9460.0
2012-01-30	ABD-DELISTED	Stock	9.67	10.5	9.64	10.44	1498570.0
2012-01-30	ABE-DELISTED	Stock	18.5	18.65	18.33	18.43	11485.0
2012-01-30	ABEO	Stock	1675.0	1687.5	1625.0	1687.5	31.0
2012-01-30	ABFS-DELISTED	Stock	18.85	18.97	18.205	18.27	831271.0
2012-01-30	ABG	Stock	23.29	23.48	23.15	23.29	192800.0
2012-01-30	ABH-DELISTED	Stock	14.25	14.43	14.2	14.29	599330.0
2012-01-30	ABM	Stock	21.67	21.8	21.41	21.53	237600.0
2012-01-30	ABMD-DELISTED	Stock	17.54	17.67	17.09	17.35	412779.0
2012-01-30	ABR	Stock	4.22	4.35	4.19	4.26	49700.0
2012-01-30	ABT	Stock	26.2115	26.2355	25.9428	26.1347	20086078.0
2012-01-30	ABTL-DELISTED	Stock	4.2621	4.563	4.2621	4.5379	44014.0
2012-01-30	ABUS	Stock	2.11	2.21	2.11	2.15	9700.0
2012-01-30	ABV-DELISTED	Stock	36.21	36.64	35.67	36.59	1733237.0
2012-01-30	ABVA-DELISTED	Stock	3.46	3.46	3.4	3.4	1300.0
2012-01-30	ABVT-DELISTED	Stock	66.58	66.85	66.01	66.6	45113.0
2012-01-30	ABX-DELISTED	Stock	48.5	49.56	48.28	49.18	5204336.0

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

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