PREVIEW / stock_daily / 2013-02-20

all stock daily files

  file:    by_date/stock_daily/2013/2013-02-20.parquet
  size:    208 KB
  rows:    6,299
  symbols: 3,515

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-02-20	AAPL	Stock	16.3461	16.3461	16.0286	16.0304	476302400.0
2013-02-20	MSFT	Stock	28.13	28.2	27.83	27.87	44110200.0
2013-02-20	NVDA	Stock	0.315	0.32	0.3085	0.3095	713012000.0
2013-02-20	AMZN	Stock	13.51	13.715	13.3185	13.3205	70578000.0
2013-02-20	META	Stock	28.92	29.05	28.33	28.46	42098200.0
2013-02-20	TSLA	Stock	2.62	2.6433	2.564	2.5693	46830000.0
2013-02-20	TLT	Stock	115.69	116.37	115.57	116.27	9603842.0
2013-02-20	ES	Stock	41.03	41.65	41.03	41.15	1577200.0
2013-02-20	CL	Stock	56.0	56.5	55.975	56.055	3273800.0
2013-02-20	A	Stock	30.6438	30.6509	30.2003	30.2146	5410260.0
2013-02-20	AABA-DELISTED	Stock	21.34	21.45	20.9	20.92	14361667.0
2013-02-20	AACC-DELISTED	Stock	5.57	5.67	5.3	5.34	25940.0
2013-02-20	AACG	Stock	4.13	4.13	4.13	4.13	100.0
2013-02-20	AAIC-DELISTED	Stock	26.88	26.97	25.5	25.65	466357.0
2013-02-20	AAMC-DELISTED	Stock	35.0029	35.0029	33.8235	33.8235	57895.0
2013-02-20	AAME	Stock	3.19	3.24	3.11	3.23	2200.0
2013-02-20	AAMRQ-DELISTED	Stock	2.845	2.89	2.39	2.51	23874840.0
2013-02-20	AAON	Stock	7.1704	7.2444	7.0341	7.043	349988.0
2013-02-20	AAP	Stock	80.42	80.94	79.39	79.5	648700.0
2013-02-20	AAT	Stock	30.0	30.57	29.82	30.05	224800.0
2013-02-20	AAU-DELISTED	Stock	2.27	2.28	2.11	2.13	152760.0
2013-02-20	AAUAF-DELISTED	Stock	2.27	2.28	2.11	2.15	154010.0
2013-02-20	AAV-DELISTED	Stock	3.02	3.02	2.87	2.9	415837.0
2013-02-20	AAWW-DELISTED	Stock	47.0	47.14	46.38	46.71	419286.0
2013-02-20	AAXJ	Stock	61.05	61.05	60.38	60.41	1659131.0
2013-02-20	AAXN-DELISTED	Stock	8.51	8.78	8.37	8.6	1252602.0
2013-02-20	AB	Stock	22.64	22.69	21.85	21.98	805600.0
2013-02-20	ABAX-DELISTED	Stock	43.4	43.53	42.12	42.34	162747.0
2013-02-20	ABB-DELISTED	Stock	23.34	23.37	22.93	22.95	2061420.0
2013-02-20	ABBNY-DELISTED	Stock	23.34	23.37	22.93	22.93	2101169.0
2013-02-20	ABBV	Stock	38.16	39.13	37.61	38.61	8096400.0
2013-02-20	ABC-DELISTED	Stock	47.22	47.39	46.59	46.62	1934079.0
2013-02-20	ABCB	Stock	14.16	14.16	13.85	13.85	63400.0
2013-02-20	ABCD-DELISTED	Stock	1.28	1.29	1.23	1.23	5534.0
2013-02-20	ABCO-DELISTED	Stock	50.16	50.59	49.95	49.97	336981.0
2013-02-20	ABCW-DELISTED	Stock	0.6	0.63	0.6	0.6	7415.0
2013-02-20	ABE-DELISTED	Stock	21.3	21.37	21.3	21.32	17341.0
2013-02-20	ABEO	Stock	625.0	625.0	562.5	625.0	1.0
2013-02-20	ABFS-DELISTED	Stock	11.51	11.75	11.36	11.385	297596.0
2013-02-20	ABG	Stock	34.54	35.52	34.54	34.97	530500.0
2013-02-20	ABM	Stock	23.41	23.48	23.0	23.01	299400.0
2013-02-20	ABMD-DELISTED	Stock	14.4	14.46	14.115	14.12	402357.0
2013-02-20	ABR	Stock	7.92	8.12	7.9	8.02	235000.0
2013-02-20	ABR.A-DELISTED	Stock	25.28	25.39	25.21	25.28	22217.0
2013-02-20	ABT	Stock	34.7	34.87	34.51	34.52	7814000.0
2013-02-20	ABTL-DELISTED	Stock	4.365	4.39	4.13	4.27	32333.0
2013-02-20	ABUS	Stock	4.59	4.62	4.52	4.52	13900.0
2013-02-20	ABV-DELISTED	Stock	46.8	47.12	46.53	46.7	3320900.0
2013-02-20	ABX-DELISTED	Stock	31.01	31.32	30.23	30.28	16533987.0
2013-02-20	ACAD	Stock	6.24	6.29	6.04	6.09	1173300.0

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

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