PREVIEW / stock_daily / 2013-07-03

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-03.parquet
  size:    204 KB
  rows:    6,180
  symbols: 3,410

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-07-03	AAPL	Stock	15.0307	15.1064	14.9089	15.0286	240928800.0
2013-07-03	MSFT	Stock	33.66	34.37	33.6	34.01	15994400.0
2013-07-03	NVDA	Stock	0.3493	0.3575	0.3493	0.3533	140388000.0
2013-07-03	AMZN	Stock	14.1	14.27	14.1	14.2015	27460000.0
2013-07-03	META	Stock	24.22	24.71	24.15	24.52	10404400.0
2013-07-03	TSLA	Stock	7.8667	7.95	7.618	7.6827	72100500.0
2013-07-03	TLT	Stock	110.31	110.65	110.01	110.01	3842216.0
2013-07-03	ES	Stock	41.11	41.41	40.86	41.38	732900.0
2013-07-03	CL	Stock	57.54	57.94	57.19	57.82	2443200.0
2013-07-03	A	Stock	30.6295	31.0873	30.5579	30.8798	2712959.0
2013-07-03	AABA-DELISTED	Stock	24.84	25.64	24.82	25.58	6028987.0
2013-07-03	AACG	Stock	4.96	4.96	4.9	4.9	6600.0
2013-07-03	AAIC-DELISTED	Stock	26.74	26.89	26.35	26.44	76402.0
2013-07-03	AAME	Stock	3.81	3.81	3.72	3.78	7900.0
2013-07-03	AAMRQ-DELISTED	Stock	4.096	4.26	3.92	4.15	2203396.0
2013-07-03	AAON	Stock	10.0533	10.1778	9.8933	10.0489	181800.0
2013-07-03	AAP	Stock	81.22	82.2	81.03	81.99	262900.0
2013-07-03	AAT	Stock	31.8	32.01	31.5	31.98	413700.0
2013-07-03	AAU-DELISTED	Stock	1.48	1.4958	1.4152	1.44	46836.0
2013-07-03	AAUAF-DELISTED	Stock	1.49	1.5009	1.42	1.43	46979.0
2013-07-03	AAV-DELISTED	Stock	3.86	3.92	3.83	3.89	224358.0
2013-07-03	AAWW-DELISTED	Stock	42.49	42.93	42.0603	42.58	87138.0
2013-07-03	AAXJ	Stock	53.61	54.13	53.51	53.84	299770.0
2013-07-03	AAXN-DELISTED	Stock	8.55	8.8	8.51	8.73	175278.0
2013-07-03	AB	Stock	20.44	20.71	20.09	20.14	397100.0
2013-07-03	ABAC-DELISTED	Stock	0.583	0.638	0.54	0.566	45498.0
2013-07-03	ABAX-DELISTED	Stock	47.65	48.4404	47.2	47.77	23068.0
2013-07-03	ABB-DELISTED	Stock	21.29	21.5	21.26	21.48	710359.0
2013-07-03	ABBNY-DELISTED	Stock	21.29	21.5	21.26	21.49	724726.0
2013-07-03	ABBV	Stock	41.88	42.31	41.61	42.23	2417500.0
2013-07-03	ABC-DELISTED	Stock	54.51	55.235	54.4	55.07	1053823.0
2013-07-03	ABCB	Stock	17.73	18.08	17.73	18.0	26300.0
2013-07-03	ABCD-DELISTED	Stock	1.21	1.21	1.21	1.21	111.0
2013-07-03	ABCO-DELISTED	Stock	54.66	55.18	54.27	54.77	55674.0
2013-07-03	ABCW-DELISTED	Stock	0.52	0.52	0.5	0.5	15200.0
2013-07-03	ABE-DELISTED	Stock	19.68	19.74	19.321	19.354	5393.0
2013-07-03	ABEO	Stock	637.5	637.5	550.0	550.0	24.0
2013-07-03	ABFS-DELISTED	Stock	22.37	22.87	22.1	22.8	188877.0
2013-07-03	ABG	Stock	40.71	41.19	40.64	40.93	55000.0
2013-07-03	ABM	Stock	24.31	24.53	24.14	24.26	234400.0
2013-07-03	ABMD-DELISTED	Stock	21.9	22.33	21.87	22.13	43959.0
2013-07-03	ABR	Stock	6.22	6.37	6.22	6.36	38800.0
2013-07-03	ABR.A-DELISTED	Stock	25.24	25.24	25.23	25.24	3346.0
2013-07-03	ABR.B-DELISTED	Stock	24.25	24.25	24.25	24.25	100.0
2013-07-03	ABT	Stock	34.72	34.72	33.72	34.25	8381100.0
2013-07-03	ABTL-DELISTED	Stock	4.71	4.713	4.7	4.707	12982.0
2013-07-03	ABUS	Stock	4.75	4.8	4.75	4.8	6300.0
2013-07-03	ABV-DELISTED	Stock	36.19	36.5	35.77	36.11	2193727.0
2013-07-03	ABX-DELISTED	Stock	14.6	14.93	14.47	14.67	16281817.0
2013-07-03	ACAD	Stock	17.44	18.11	17.02	17.91	1060900.0

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

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