PREVIEW / stock_daily / 2012-12-28

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-28.parquet
  size:    204 KB
  rows:    6,264
  symbols: 3,524

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-28	AAPL	Stock	18.2246	18.3743	18.1471	18.1996	354278400.0
2012-12-28	MSFT	Stock	26.71	26.9	26.55	26.55	28239900.0
2012-12-28	NVDA	Stock	0.3012	0.3073	0.3008	0.3025	220600000.0
2012-12-28	AMZN	Stock	12.2925	12.372	12.2525	12.259	37174000.0
2012-12-28	META	Stock	25.48	26.11	25.15	25.91	56574800.0
2012-12-28	TSLA	Stock	2.2253	2.2433	2.2013	2.2147	6211500.0
2012-12-28	TLT	Stock	123.14	123.34	122.78	123.31	3928559.0
2012-12-28	ES	Stock	38.47	38.96	38.37	38.44	1265100.0
2012-12-28	CL	Stock	52.395	52.635	51.98	52.02	2012600.0
2012-12-28	A	Stock	28.7697	28.8913	28.4692	28.4907	3250490.0
2012-12-28	AABA-DELISTED	Stock	19.45	19.57	19.28	19.5	15574859.0
2012-12-28	AACC-DELISTED	Stock	4.49	4.63	4.4	4.54	50487.0
2012-12-28	AACG	Stock	6.29	6.5	6.29	6.49	26200.0
2012-12-28	AAIC-DELISTED	Stock	20.43	20.62	20.22	20.22	161822.0
2012-12-28	AAMC-DELISTED	Stock	17.2059	22.0588	16.6176	21.2794	309240.0
2012-12-28	AAME	Stock	2.9	2.96	2.9	2.95	5700.0
2012-12-28	AAMRQ-DELISTED	Stock	0.7875	0.8079	0.758	0.7909	2350575.0
2012-12-28	AAON	Stock	5.8548	6.08	5.8311	6.0119	552488.0
2012-12-28	AAP	Stock	70.92	71.85	70.79	71.51	422100.0
2012-12-28	AAT	Stock	27.3	27.58	27.28	27.29	50300.0
2012-12-28	AAU-DELISTED	Stock	3.07	3.15	3.02	3.15	95470.0
2012-12-28	AAUAF-DELISTED	Stock	3.07	3.15	3.02	3.15	95670.0
2012-12-28	AAV-DELISTED	Stock	3.17	3.23	3.17	3.2	217666.0
2012-12-28	AAWW-DELISTED	Stock	43.83	44.319	43.36	43.39	90073.0
2012-12-28	AAXJ	Stock	59.24	59.78	59.24	59.61	2651601.0
2012-12-28	AAXN-DELISTED	Stock	8.6	8.9	8.5814	8.635	655401.0
2012-12-28	AB	Stock	16.84	17.58	16.71	17.48	384400.0
2012-12-28	ABAC-DELISTED	Stock	0.8801	0.9313	0.861	0.861	2700.0
2012-12-28	ABAX-DELISTED	Stock	36.35	37.24	36.11	36.56	122023.0
2012-12-28	ABB-DELISTED	Stock	20.56	20.635	20.46	20.485	1782044.0
2012-12-28	ABBNY-DELISTED	Stock	20.56	20.635	20.46	20.49	1844895.0
2012-12-28	ABC-DELISTED	Stock	43.04	43.34	42.8	42.83	1023191.0
2012-12-28	ABCB	Stock	12.4	12.45	12.25	12.34	16600.0
2012-12-28	ABCD-DELISTED	Stock	1.22	1.35	1.18	1.23	35896.0
2012-12-28	ABCO-DELISTED	Stock	48.1	48.67	46.98	46.99	250002.0
2012-12-28	ABCW-DELISTED	Stock	0.365	0.388	0.3425	0.355	38047.0
2012-12-28	ABE-DELISTED	Stock	21.11	21.2112	21.06	21.21	24715.0
2012-12-28	ABEO	Stock	312.5	312.5	300.0	312.5	32.0
2012-12-28	ABFS-DELISTED	Stock	9.26	9.499	9.06	9.25	249990.0
2012-12-28	ABG	Stock	30.53	30.94	30.45	30.61	117800.0
2012-12-28	ABM	Stock	19.84	19.87	19.58	19.58	139300.0
2012-12-28	ABMD-DELISTED	Stock	13.54	13.7	13.41	13.47	635502.0
2012-12-28	ABR	Stock	6.01	6.06	5.98	6.0	44700.0
2012-12-28	ABT	Stock	31.0814	31.1966	30.8799	30.9087	11238850.0
2012-12-28	ABTL-DELISTED	Stock	4.0	4.12	3.9227	3.94	12101.0
2012-12-28	ABUS	Stock	4.92	4.92	4.81	4.81	22300.0
2012-12-28	ABV-DELISTED	Stock	41.97	42.07	41.75	41.97	1528789.0
2012-12-28	ABX-DELISTED	Stock	34.24	34.42	34.01	34.02	4011336.0
2012-12-28	ACAD	Stock	4.46	4.62	4.44	4.51	961100.0
2012-12-28	ACAS-DELISTED	Stock	11.92	12.02	11.9	11.925	2167917.0

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

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