PREVIEW / stock_daily / 2012-12-31

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-31.parquet
  size:    205 KB
  rows:    6,298
  symbols: 3,545

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-12-31	AAPL	Stock	18.2332	19.1214	18.1786	19.0061	659492400.0
2012-12-31	MSFT	Stock	26.59	26.77	26.37	26.71	42749500.0
2012-12-31	NVDA	Stock	0.3015	0.3078	0.3008	0.3065	326460000.0
2012-12-31	AMZN	Stock	12.1875	12.6205	12.1375	12.5435	68380000.0
2012-12-31	META	Stock	26.2	26.99	26.11	26.62	60374500.0
2012-12-31	TSLA	Stock	2.2	2.2647	2.2	2.258	8923500.0
2012-12-31	TLT	Stock	122.87	122.97	120.911	121.18	6422918.0
2012-12-31	ES	Stock	38.38	39.14	38.12	39.08	1651400.0
2012-12-31	CL	Stock	51.885	52.315	51.41	52.27	3558400.0
2012-12-31	A	Stock	28.3906	29.3062	28.3548	29.2847	4707905.0
2012-12-31	AABA-DELISTED	Stock	19.43	19.97	19.4	19.9	20502999.0
2012-12-31	AACC-DELISTED	Stock	4.53	4.66	4.35	4.49	119620.0
2012-12-31	AACG	Stock	6.58	6.99	6.49	6.97	75400.0
2012-12-31	AAIC-DELISTED	Stock	20.32	20.915	20.14	20.77	196811.0
2012-12-31	AAMC-DELISTED	Stock	21.1765	26.4706	21.1765	24.1176	147869.0
2012-12-31	AAME	Stock	2.95	3.35	2.95	3.09	26900.0
2012-12-31	AAMRQ-DELISTED	Stock	0.7821	0.805	0.782	0.795	2495661.0
2012-12-31	AAON	Stock	6.0119	6.2074	5.9763	6.1837	241313.0
2012-12-31	AAP	Stock	71.39	72.55	71.3	72.35	454500.0
2012-12-31	AAT	Stock	27.22	27.97	27.1	27.93	80500.0
2012-12-31	AAU-DELISTED	Stock	3.12	3.2	3.09	3.17	196465.0
2012-12-31	AAUAF-DELISTED	Stock	3.15	3.21	3.12	3.17	194713.0
2012-12-31	AAV-DELISTED	Stock	3.15	3.24	3.14	3.22	289611.0
2012-12-31	AAWW-DELISTED	Stock	43.39	44.36	43.16	44.31	100065.0
2012-12-31	AAXJ	Stock	59.86	60.52	59.5302	60.52	729070.0
2012-12-31	AAXN-DELISTED	Stock	8.63	9.015	8.51	8.96	923305.0
2012-12-31	AB	Stock	17.38	17.67	17.21	17.43	232500.0
2012-12-31	ABAC-DELISTED	Stock	0.86	0.9	0.81	0.85	22398.0
2012-12-31	ABAX-DELISTED	Stock	36.0	37.17	35.13	37.06	116862.0
2012-12-31	ABB-DELISTED	Stock	20.53	20.85	20.47	20.79	1535834.0
2012-12-31	ABBNY-DELISTED	Stock	20.53	20.85	20.47	20.79	1549413.0
2012-12-31	ABC-DELISTED	Stock	42.74	43.22	42.63	43.19	1277366.0
2012-12-31	ABCB	Stock	12.37	12.55	12.28	12.49	50800.0
2012-12-31	ABCD-DELISTED	Stock	1.0	1.19	0.9002	1.08	62620.0
2012-12-31	ABCO-DELISTED	Stock	46.9	46.96	46.42	46.79	364017.0
2012-12-31	ABCW-DELISTED	Stock	0.35	0.388	0.3375	0.385	33348.0
2012-12-31	ABE-DELISTED	Stock	21.3	21.53	20.956	21.5	20000.0
2012-12-31	ABEO	Stock	300.0	312.5	275.0	300.0	109.0
2012-12-31	ABFS-DELISTED	Stock	9.28	9.62	9.13	9.55	291303.0
2012-12-31	ABG	Stock	30.65	32.24	30.65	32.03	350000.0
2012-12-31	ABM	Stock	19.64	19.98	19.55	19.95	185100.0
2012-12-31	ABMD-DELISTED	Stock	13.36	13.67	12.95	13.45	1083125.0
2012-12-31	ABR	Stock	5.98	6.13	5.95	5.99	279300.0
2012-12-31	ABT	Stock	30.7696	31.4413	30.712	31.4269	19018133.0
2012-12-31	ABTL-DELISTED	Stock	3.99	4.03	3.828	3.98	10728.0
2012-12-31	ABUS	Stock	4.96	5.02	4.9	4.96	16200.0
2012-12-31	ABV-DELISTED	Stock	41.63	42.015	41.5	41.98	1154986.0
2012-12-31	ABX-DELISTED	Stock	34.04	35.18	34.0	35.02	8043740.0
2012-12-31	ACAD	Stock	4.47	4.68	4.45	4.65	1290800.0
2012-12-31	ACAS-DELISTED	Stock	11.85	12.03	11.83	12.02	3872425.0

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

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