PREVIEW / stock_daily / 2012-12-26

all stock daily files

  file:    by_date/stock_daily/2012/2012-12-26.parquet
  size:    200 KB
  rows:    6,206
  symbols: 3,497

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-26	AAPL	Stock	18.5357	18.5521	18.2543	18.3214	302436400.0
2012-12-26	MSFT	Stock	27.03	27.2	26.7	26.86	31631100.0
2012-12-26	NVDA	Stock	0.3055	0.3105	0.3048	0.306	196740000.0
2012-12-26	AMZN	Stock	12.8575	12.871	12.402	12.4315	83054000.0
2012-12-26	META	Stock	27.03	27.18	26.38	26.51	33175400.0
2012-12-26	TSLA	Stock	2.264	2.3	2.2333	2.2393	9021000.0
2012-12-26	TLT	Stock	121.95	122.21	121.81	122.2	2247827.0
2012-12-26	ES	Stock	39.15	39.31	38.71	38.77	1753000.0
2012-12-26	CL	Stock	52.525	52.67	52.185	52.355	2688400.0
2012-12-26	A	Stock	29.4063	29.4921	29.1631	29.2489	3578321.0
2012-12-26	AABA-DELISTED	Stock	19.72	19.75	19.52	19.57	9331307.0
2012-12-26	AACC-DELISTED	Stock	4.55	4.6	4.41	4.48	17028.0
2012-12-26	AACG	Stock	5.44	6.01	5.36	5.86	12500.0
2012-12-26	AAIC-DELISTED	Stock	21.06	21.46	20.8	20.87	187334.0
2012-12-26	AAMC-DELISTED	Stock	23.5294	26.4706	22.6471	22.6471	159025.0
2012-12-26	AAME	Stock	2.74	2.85	2.69	2.83	3500.0
2012-12-26	AAMRQ-DELISTED	Stock	0.77	0.82	0.7221	0.8099	2223619.0
2012-12-26	AAON	Stock	5.9793	5.9852	5.9081	5.9378	287888.0
2012-12-26	AAP	Stock	70.78	71.17	70.12	70.6	511600.0
2012-12-26	AAT	Stock	27.48	27.64	27.22	27.29	28000.0
2012-12-26	AAU-DELISTED	Stock	3.02	3.16	2.99	3.16	129708.0
2012-12-26	AAUAF-DELISTED	Stock	3.05	3.19	3.02	3.16	128985.0
2012-12-26	AAV-DELISTED	Stock	3.25	3.29	3.21	3.21	105212.0
2012-12-26	AAWW-DELISTED	Stock	44.48	44.86	44.1245	44.61	133975.0
2012-12-26	AAXJ	Stock	59.43	59.48	59.14	59.15	481063.0
2012-12-26	AAXN-DELISTED	Stock	8.8	8.88	8.58	8.64	544406.0
2012-12-26	AB	Stock	16.98	17.12	16.78	16.89	188000.0
2012-12-26	ABAC-DELISTED	Stock	0.9396	0.9396	0.9	0.92	5400.0
2012-12-26	ABAX-DELISTED	Stock	37.25	37.4	36.52	37.2	80794.0
2012-12-26	ABB-DELISTED	Stock	20.62	20.78	20.57	20.63	801229.0
2012-12-26	ABBNY-DELISTED	Stock	20.62	20.78	20.57	20.64	888273.0
2012-12-26	ABC-DELISTED	Stock	43.52	43.61	42.95	43.12	1271447.0
2012-12-26	ABCB	Stock	12.42	12.49	12.31	12.38	17000.0
2012-12-26	ABCD-DELISTED	Stock	1.35	1.35	1.18	1.35	15217.0
2012-12-26	ABCO-DELISTED	Stock	48.95	49.07	47.97	48.31	127463.0
2012-12-26	ABCW-DELISTED	Stock	0.36	0.37	0.3475	0.3475	37992.0
2012-12-26	ABE-DELISTED	Stock	20.981	21.24	20.981	21.23	11932.0
2012-12-26	ABEO	Stock	275.0	312.5	262.5	312.5	555.0
2012-12-26	ABFS-DELISTED	Stock	9.47	9.54	9.34	9.46	270435.0
2012-12-26	ABG	Stock	31.15	31.15	30.64	30.91	214700.0
2012-12-26	ABM	Stock	20.11	20.17	19.9	20.06	122400.0
2012-12-26	ABMD-DELISTED	Stock	13.55	13.73	13.3001	13.68	518059.0
2012-12-26	ABR	Stock	6.0	6.07	5.97	6.05	60200.0
2012-12-26	ABT	Stock	31.4509	31.4605	31.139	31.2158	9052730.0
2012-12-26	ABTL-DELISTED	Stock	3.8889	4.11	3.88	3.97	8023.0
2012-12-26	ABUS	Stock	4.99	5.08	4.97	4.97	17000.0
2012-12-26	ABV-DELISTED	Stock	42.27	42.28	41.61	41.69	876043.0
2012-12-26	ABX-DELISTED	Stock	33.85	34.32	33.75	34.07	4796170.0
2012-12-26	ACAD	Stock	4.65	4.65	4.45	4.56	1055000.0
2012-12-26	ACAS-DELISTED	Stock	12.275	12.3	12.05	12.06	1189957.0

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

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