PREVIEW / stock_daily / 2012-12-27

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-27.parquet
  size:    205 KB
  rows:    6,254
  symbols: 3,527

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-27	AAPL	Stock	18.3407	18.4375	18.0236	18.395	455120400.0
2012-12-27	MSFT	Stock	26.89	27.09	26.57	26.96	39394000.0
2012-12-27	NVDA	Stock	0.3065	0.307	0.3005	0.304	299804000.0
2012-12-27	AMZN	Stock	12.414	12.4675	12.143	12.4155	72786000.0
2012-12-27	META	Stock	26.55	26.8	25.52	26.05	43481700.0
2012-12-27	TSLA	Stock	2.2333	2.2607	2.2	2.246	8416500.0
2012-12-27	TLT	Stock	121.88	123.29	121.83	122.61	4262619.0
2012-12-27	ES	Stock	38.7	38.9	38.43	38.78	1338000.0
2012-12-27	CL	Stock	52.28	52.77	52.26	52.635	2801800.0
2012-12-27	A	Stock	29.1989	29.2489	28.6195	29.0701	2823680.0
2012-12-27	AABA-DELISTED	Stock	19.54	19.67	19.44	19.6	13697764.0
2012-12-27	AACC-DELISTED	Stock	4.49	4.66	4.38	4.5	21363.0
2012-12-27	AACG	Stock	5.82	6.35	5.66	6.24	36100.0
2012-12-27	AAIC-DELISTED	Stock	20.85	20.999	20.37	20.6	128440.0
2012-12-27	AAMC-DELISTED	Stock	22.0588	22.0647	16.1765	17.3529	179421.0
2012-12-27	AAME	Stock	2.84	2.89	2.84	2.88	500.0
2012-12-27	AAMRQ-DELISTED	Stock	0.8095	0.85	0.79	0.79	2664287.0
2012-12-27	AAON	Stock	5.9585	6.003	5.8252	5.8785	263925.0
2012-12-27	AAP	Stock	70.57	71.53	70.09	71.34	619300.0
2012-12-27	AAT	Stock	27.23	27.49	26.97	27.44	37500.0
2012-12-27	AAU-DELISTED	Stock	3.0997	3.13	2.9813	3.08	126577.0
2012-12-27	AAUAF-DELISTED	Stock	3.14	3.1701	3.02	3.08	125259.0
2012-12-27	AAV-DELISTED	Stock	3.2	3.24	3.18	3.2	366629.0
2012-12-27	AAWW-DELISTED	Stock	44.47	45.99	43.51	44.2	146001.0
2012-12-27	AAXJ	Stock	59.41	59.41	58.9	59.3	206680.0
2012-12-27	AAXN-DELISTED	Stock	8.63	8.71	8.39	8.65	677324.0
2012-12-27	AB	Stock	16.87	17.15	16.82	16.95	172600.0
2012-12-27	ABAC-DELISTED	Stock	0.95	0.9842	0.85	0.862	7650.0
2012-12-27	ABAX-DELISTED	Stock	37.19	37.2799	35.72	36.57	125002.0
2012-12-27	ABB-DELISTED	Stock	20.82	20.84	20.583	20.78	1244160.0
2012-12-27	ABBNY-DELISTED	Stock	20.82	20.84	20.583	20.79	1308504.0
2012-12-27	ABC-DELISTED	Stock	43.18	43.34	42.76	43.24	1535663.0
2012-12-27	ABCB	Stock	12.43	12.49	12.16	12.42	60400.0
2012-12-27	ABCD-DELISTED	Stock	1.4	1.4	1.22	1.22	15140.0
2012-12-27	ABCO-DELISTED	Stock	48.21	48.74	47.82	48.4	156595.0
2012-12-27	ABCW-DELISTED	Stock	0.35	0.37	0.325	0.37	37758.0
2012-12-27	ABE-DELISTED	Stock	21.26	21.29	20.79	21.11	26390.0
2012-12-27	ABEO	Stock	275.0	350.0	275.0	300.0	87.0
2012-12-27	ABFS-DELISTED	Stock	9.49	9.52	9.05	9.27	238194.0
2012-12-27	ABG	Stock	31.05	31.05	30.02	30.78	142600.0
2012-12-27	ABM	Stock	20.04	20.04	19.6	19.88	161100.0
2012-12-27	ABMD-DELISTED	Stock	13.55	13.7	13.4	13.63	687421.0
2012-12-27	ABR	Stock	6.09	6.09	6.0	6.07	38600.0
2012-12-27	ABT	Stock	31.1726	31.4173	31.0095	31.211	10701542.0
2012-12-27	ABTL-DELISTED	Stock	3.87	4.0	3.82	3.9	12569.0
2012-12-27	ABUS	Stock	4.99	4.99	4.92	4.92	31000.0
2012-12-27	ABV-DELISTED	Stock	41.72	42.06	41.38	41.92	1205153.0
2012-12-27	ABX-DELISTED	Stock	33.73	34.69	33.71	34.28	7109933.0
2012-12-27	ACAD	Stock	4.57	4.63	4.39	4.54	1019900.0
2012-12-27	ACAS-DELISTED	Stock	12.04	12.1	11.86	12.0	3032104.0

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

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