PREVIEW / stock_daily / 2013-12-09

all stock daily files

  file:    by_date/stock_daily/2013/2013-12-09.parquet
  size:    216 KB
  rows:    6,470
  symbols: 3,554

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
2013-12-09	AAPL	Stock	20.0321	20.3421	20.0321	20.2296	320493600.0
2013-12-09	MSFT	Stock	38.56	38.87	38.37	38.71	30286000.0
2013-12-09	NVDA	Stock	0.3868	0.388	0.3795	0.3803	385220000.0
2013-12-09	AMZN	Stock	19.4055	19.4105	19.1285	19.2445	55236000.0
2013-12-09	META	Stock	48.09	48.97	47.74	48.84	36056000.0
2013-12-09	TSLA	Stock	9.1333	9.4467	8.9473	9.44	135922500.0
2013-12-09	TLT	Stock	102.9	103.23	102.83	103.16	5679779.0
2013-12-09	ES	Stock	41.64	41.72	41.13	41.34	1305500.0
2013-12-09	CL	Stock	65.73	65.99	65.5	65.69	2340700.0
2013-12-09	A	Stock	39.1989	39.6495	39.1559	39.3848	2961663.0
2013-12-09	AABA-DELISTED	Stock	39.19	39.2	38.57	38.87	13813780.0
2013-12-09	AACG	Stock	3.98	4.02	3.8	3.95	18600.0
2013-12-09	AAIC-DELISTED	Stock	26.14	26.68	25.96	26.53	228115.0
2013-12-09	AAMC-DELISTED	Stock	264.7029	286.7647	264.7029	285.5853	74103.0
2013-12-09	AAME	Stock	4.0	4.03	4.0	4.03	4400.0
2013-12-09	AAOI	Stock	14.71	15.84	14.5	14.88	195100.0
2013-12-09	AAON	Stock	13.6756	13.7778	13.0	13.48	400275.0
2013-12-09	AAP	Stock	104.75	105.6	103.94	104.33	760600.0
2013-12-09	AAT	Stock	31.72	31.99	31.5	31.67	223300.0
2013-12-09	AAU-DELISTED	Stock	1.07	1.1	1.0401	1.1	218513.0
2013-12-09	AAUAF-DELISTED	Stock	1.07	1.1	1.0401	1.1	219598.0
2013-12-09	AAV-DELISTED	Stock	4.21	4.3	4.161	4.23	82736.0
2013-12-09	AAWW-DELISTED	Stock	37.39	38.24	37.22	38.08	315176.0
2013-12-09	AAXJ	Stock	60.78	61.24	60.78	61.24	1287851.0
2013-12-09	AAXN-DELISTED	Stock	16.84	17.04	16.63	16.74	688268.0
2013-12-09	AB	Stock	22.14	22.45	22.0	22.35	551900.0
2013-12-09	ABAC-DELISTED	Stock	2.26	2.3899	2.26	2.3	156341.0
2013-12-09	ABAX-DELISTED	Stock	36.41	36.91	36.244	36.91	114843.0
2013-12-09	ABB-DELISTED	Stock	25.32	25.38	25.28	25.35	781650.0
2013-12-09	ABBNY-DELISTED	Stock	25.32	25.38	25.28	25.36	835263.0
2013-12-09	ABBV	Stock	51.45	51.81	50.77	51.21	5470800.0
2013-12-09	ABC-DELISTED	Stock	70.47	71.21	70.25	70.64	1354463.0
2013-12-09	ABCB	Stock	20.13	20.36	19.95	20.21	56600.0
2013-12-09	ABCD-DELISTED	Stock	1.5	1.57	1.5	1.555	13635.0
2013-12-09	ABCO-DELISTED	Stock	63.63	64.2	62.33	63.13	180586.0
2013-12-09	ABE-DELISTED	Stock	19.66	20.34	19.66	20.0	26743.0
2013-12-09	ABEO	Stock	325.0	362.5	325.0	362.5	53.0
2013-12-09	ABEV	Stock	7.14	7.32	7.14	7.26	7647400.0
2013-12-09	ABFS-DELISTED	Stock	33.71	34.07	33.37	33.6	268766.0
2013-12-09	ABG	Stock	52.5	52.92	51.62	51.88	455700.0
2013-12-09	ABGB-DELISTED	Stock	12.9	12.979	12.82	12.83	2350.0
2013-12-09	ABM	Stock	27.84	27.97	27.51	27.75	318300.0
2013-12-09	ABMD-DELISTED	Stock	27.75	27.97	27.07	27.88	307370.0
2013-12-09	ABR	Stock	6.59	6.66	6.54	6.66	203900.0
2013-12-09	ABR.A-DELISTED	Stock	24.3	24.3275	24.0	24.011	5680.0
2013-12-09	ABR.B-DELISTED	Stock	22.375	22.5	21.69	22.1499	16950.0
2013-12-09	ABT	Stock	37.57	37.58	37.16	37.2	4972400.0
2013-12-09	ABTL-DELISTED	Stock	12.42	12.5	11.87	12.12	126555.0
2013-12-09	ABUS	Stock	8.03	8.03	7.66	7.75	87200.0
2013-12-09	ABX-DELISTED	Stock	15.63	16.15	15.5975	16.0	17131829.0

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

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