PREVIEW / stock_daily / 2013-04-04

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-04.parquet
  size:    206 KB
  rows:    6,254
  symbols: 3,469

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-04-04	AAPL	Stock	15.4914	15.5357	15.1875	15.2757	358447600.0
2013-04-04	MSFT	Stock	28.39	28.61	28.27	28.6	45263200.0
2013-04-04	NVDA	Stock	0.3022	0.3073	0.3012	0.3062	294676000.0
2013-04-04	AMZN	Stock	12.9615	13.0205	12.806	12.954	39288000.0
2013-04-04	META	Stock	26.62	27.23	26.11	27.07	82016800.0
2013-04-04	TSLA	Stock	2.7407	2.8167	2.7207	2.8007	33972000.0
2013-04-04	TLT	Stock	119.59	120.41	119.47	120.39	9367035.0
2013-04-04	ES	Stock	43.34	43.56	43.2	43.45	1598000.0
2013-04-04	CL	Stock	58.77	58.865	58.37	58.54	2603000.0
2013-04-04	A	Stock	28.9986	29.6638	28.9986	29.6209	5478343.0
2013-04-04	AABA-DELISTED	Stock	23.49	23.715	23.36	23.51	12364197.0
2013-04-04	AACC-DELISTED	Stock	6.73	6.73	6.64	6.71	188447.0
2013-04-04	AAIC-DELISTED	Stock	25.5	25.83	25.5	25.83	387884.0
2013-04-04	AAMC-DELISTED	Stock	37.9412	38.2353	37.9412	38.0882	2380.0
2013-04-04	AAME	Stock	3.28	3.39	3.28	3.39	3800.0
2013-04-04	AAMRQ-DELISTED	Stock	3.36	3.63	3.28	3.56	5300375.0
2013-04-04	AAON	Stock	8.0296	8.0978	8.003	8.0948	175163.0
2013-04-04	AAP	Stock	82.2	82.97	81.93	82.2	819500.0
2013-04-04	AAT	Stock	32.62	33.24	32.62	33.18	161000.0
2013-04-04	AAU-DELISTED	Stock	1.81	1.951	1.7976	1.9	137167.0
2013-04-04	AAUAF-DELISTED	Stock	1.76	1.9	1.75	1.9	141074.0
2013-04-04	AAV-DELISTED	Stock	3.58	3.58	3.52	3.53	239503.0
2013-04-04	AAWW-DELISTED	Stock	39.46	39.46	38.946	39.09	231275.0
2013-04-04	AAXJ	Stock	57.94	58.1	57.65	58.03	667438.0
2013-04-04	AAXN-DELISTED	Stock	7.37	7.62	7.31	7.52	458102.0
2013-04-04	AB	Stock	21.01	21.34	20.96	21.24	115000.0
2013-04-04	ABAX-DELISTED	Stock	45.94	47.727	45.5727	47.6	146501.0
2013-04-04	ABB-DELISTED	Stock	22.12	22.415	22.07	22.41	2046050.0
2013-04-04	ABBNY-DELISTED	Stock	22.12	22.415	22.07	22.4	2190409.0
2013-04-04	ABBV	Stock	40.77	41.78	40.62	41.6	20687600.0
2013-04-04	ABC-DELISTED	Stock	51.69	52.83	51.67	51.83	2788036.0
2013-04-04	ABCB	Stock	13.99	14.14	13.94	14.08	23000.0
2013-04-04	ABCD-DELISTED	Stock	1.0399	1.07	1.0	1.07	4989.0
2013-04-04	ABCO-DELISTED	Stock	50.5	51.21	49.79	51.11	120711.0
2013-04-04	ABCW-DELISTED	Stock	0.63	0.63	0.63	0.63	2000.0
2013-04-04	ABE-DELISTED	Stock	20.57	20.6599	20.49	20.6124	3703.0
2013-04-04	ABEO	Stock	637.5	687.5	600.0	637.5	12.0
2013-04-04	ABFS-DELISTED	Stock	11.12	11.1875	10.775	10.87	213454.0
2013-04-04	ABG	Stock	34.57	35.14	34.2	35.11	307800.0
2013-04-04	ABM	Stock	21.56	21.62	21.43	21.52	132200.0
2013-04-04	ABMD-DELISTED	Stock	17.27	17.29	17.05	17.1	266619.0
2013-04-04	ABR	Stock	7.8	7.89	7.78	7.88	320500.0
2013-04-04	ABR.A-DELISTED	Stock	25.82	25.82	25.79	25.79	2500.0
2013-04-04	ABT	Stock	36.52	36.89	36.45	36.65	7713000.0
2013-04-04	ABTL-DELISTED	Stock	4.19	4.36	4.19	4.28	8907.0
2013-04-04	ABUS	Stock	4.44	4.58	4.39	4.55	99900.0
2013-04-04	ABV-DELISTED	Stock	41.14	41.59	40.76	41.37	1714362.0
2013-04-04	ABX-DELISTED	Stock	26.5	27.43	26.15	27.0	15535640.0
2013-04-04	ACAD	Stock	7.55	7.75	7.53	7.69	914800.0
2013-04-04	ACAS-DELISTED	Stock	14.19	14.31	13.88	14.21	2621388.0

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

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