PREVIEW / stock_daily / 2012-10-17

all stock daily files

  file:    by_date/stock_daily/2012/2012-10-17.parquet
  size:    199 KB
  rows:    6,142
  symbols: 3,478

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-10-17	AAPL	Stock	23.1739	23.3139	23.0	23.0218	389037600.0
2012-10-17	MSFT	Stock	29.3	29.64	29.09	29.59	44206100.0
2012-10-17	NVDA	Stock	0.325	0.328	0.3218	0.3265	391752000.0
2012-10-17	AMZN	Stock	12.1685	12.44	12.165	12.3745	66054000.0
2012-10-17	META	Stock	19.5	20.48	19.37	19.88	44074500.0
2012-10-17	TSLA	Stock	1.8833	1.9227	1.8533	1.9213	10020000.0
2012-10-17	TLT	Stock	121.17	121.26	120.57	120.85	6932539.0
2012-10-17	ES	Stock	39.23	39.78	39.09	39.5	1929800.0
2012-10-17	CL	Stock	54.285	55.485	54.285	55.285	4812000.0
2012-10-17	A	Stock	27.1745	27.3605	26.9671	27.2246	5400334.0
2012-10-17	AABA-DELISTED	Stock	15.85	16.12	15.83	16.09	19496320.0
2012-10-17	AACC-DELISTED	Stock	7.6	7.72	7.6	7.71	4131.0
2012-10-17	AACG	Stock	4.9	5.29	4.72	4.72	1400.0
2012-10-17	AAIC-DELISTED	Stock	22.06	22.4	22.06	22.4	137384.0
2012-10-17	AAME	Stock	2.65	2.8	2.64	2.8	3700.0
2012-10-17	AAMRQ-DELISTED	Stock	0.3651	0.3793	0.365	0.37	1731396.0
2012-10-17	AAON	Stock	5.7304	5.8667	5.6741	5.7689	161663.0
2012-10-17	AAP	Stock	68.1	68.36	67.32	68.35	698400.0
2012-10-17	AAT	Stock	28.17	28.33	28.02	28.02	76500.0
2012-10-17	AAU-DELISTED	Stock	2.5	2.55	2.5	2.54	50912.0
2012-10-17	AAUAF-DELISTED	Stock	2.5	2.55	2.5	2.54	51112.0
2012-10-17	AAV-DELISTED	Stock	4.09	4.2	3.94	3.96	305121.0
2012-10-17	AAWW-DELISTED	Stock	52.87	53.71	52.7139	53.4305	66674.0
2012-10-17	AAXJ	Stock	56.94	57.51	56.79	57.39	263952.0
2012-10-17	AAXN-DELISTED	Stock	6.2	6.48	6.2	6.4	636782.0
2012-10-17	AB	Stock	16.35	16.63	16.28	16.54	218700.0
2012-10-17	ABAC-DELISTED	Stock	1.27	1.38	1.27	1.38	4600.0
2012-10-17	ABAX-DELISTED	Stock	37.04	38.36	37.04	37.58	65458.0
2012-10-17	ABB-DELISTED	Stock	19.5	19.63	19.46	19.57	1478277.0
2012-10-17	ABBNY-DELISTED	Stock	19.5	19.63	19.46	19.56	1512298.0
2012-10-17	ABC-DELISTED	Stock	40.83	40.95	40.37	40.535	2469844.0
2012-10-17	ABCB	Stock	12.41	12.5	12.26	12.5	28600.0
2012-10-17	ABCD-DELISTED	Stock	0.9727	0.9727	0.97	0.97	700.0
2012-10-17	ABCO-DELISTED	Stock	48.7	48.74	47.35	48.5	159700.0
2012-10-17	ABCW-DELISTED	Stock	0.4	0.405	0.36	0.3601	31963.0
2012-10-17	ABE-DELISTED	Stock	20.74	20.9	20.74	20.9	6565.0
2012-10-17	ABEO	Stock	437.5	450.0	375.0	375.0	105.0
2012-10-17	ABFS-DELISTED	Stock	8.24	8.36	8.14	8.23	225280.0
2012-10-17	ABG	Stock	30.15	30.52	29.72	30.5	131800.0
2012-10-17	ABM	Stock	18.52	18.56	18.37	18.54	172600.0
2012-10-17	ABMD-DELISTED	Stock	21.0	21.05	20.5	20.65	351102.0
2012-10-17	ABR	Stock	5.55	5.59	5.52	5.55	141700.0
2012-10-17	ABT	Stock	34.4448	34.5216	32.7895	33.1254	44251563.0
2012-10-17	ABTL-DELISTED	Stock	3.85	3.85	3.8	3.82	11680.0
2012-10-17	ABUS	Stock	3.98	3.98	3.93	3.95	5000.0
2012-10-17	ABV-DELISTED	Stock	41.24	41.46	41.01	41.31	2107744.0
2012-10-17	ABX-DELISTED	Stock	39.77	40.31	39.22	39.94	6215175.0
2012-10-17	ACAD	Stock	2.46	2.64	2.4	2.55	2448200.0
2012-10-17	ACAS-DELISTED	Stock	11.6	11.92	11.55	11.895	1912743.0
2012-10-17	ACAT-DELISTED	Stock	39.83	41.67	39.83	41.63	115783.0

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

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