PREVIEW / stock_daily / 2013-04-17

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-17.parquet
  size:    206 KB
  rows:    6,281
  symbols: 3,501

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-17	AAPL	Stock	15.0096	15.0214	14.2182	14.3857	945056000.0
2013-04-17	MSFT	Stock	28.85	29.04	28.6	28.83	52840700.0
2013-04-17	NVDA	Stock	0.3215	0.3245	0.3178	0.3198	532948000.0
2013-04-17	AMZN	Stock	13.54	13.5425	13.2125	13.37	62702000.0
2013-04-17	META	Stock	26.65	27.2	26.39	26.63	26440600.0
2013-04-17	TSLA	Stock	3.0333	3.0633	2.9693	3.03	31777500.0
2013-04-17	TLT	Stock	122.3	123.525	122.3	122.79	9020829.0
2013-04-17	ES	Stock	44.5	44.55	43.83	43.9	1648600.0
2013-04-17	CL	Stock	59.505	59.585	58.63	58.925	3133000.0
2013-04-17	A	Stock	30.8155	30.8369	29.9928	30.1788	6281214.0
2013-04-17	AABA-DELISTED	Stock	23.45	24.1	23.13	23.69	44691573.0
2013-04-17	AACC-DELISTED	Stock	6.49	6.52	6.48	6.48	250533.0
2013-04-17	AACG	Stock	3.97	4.03	3.97	4.03	1100.0
2013-04-17	AAIC-DELISTED	Stock	25.75	25.97	25.01	25.18	303494.0
2013-04-17	AAMC-DELISTED	Stock	38.6765	38.9706	38.6765	38.9706	15181.0
2013-04-17	AAME	Stock	3.38	3.39	3.12	3.34	7400.0
2013-04-17	AAMRQ-DELISTED	Stock	3.92	4.0	3.75	3.97	7355848.0
2013-04-17	AAON	Stock	8.1719	8.2252	8.0356	8.1185	330413.0
2013-04-17	AAP	Stock	80.25	80.25	79.05	79.82	762800.0
2013-04-17	AAT	Stock	32.41	32.53	31.72	32.14	165800.0
2013-04-17	AAU-DELISTED	Stock	1.62	1.62	1.45	1.49	302867.0
2013-04-17	AAUAF-DELISTED	Stock	1.62	1.62	1.45	1.49	303642.0
2013-04-17	AAV-DELISTED	Stock	3.61	3.62	3.47	3.5	553781.0
2013-04-17	AAWW-DELISTED	Stock	38.5	39.1233	37.91	38.04	335370.0
2013-04-17	AAXJ	Stock	57.38	57.44	56.83	57.18	511354.0
2013-04-17	AAXN-DELISTED	Stock	7.9	7.97	7.69	7.93	477061.0
2013-04-17	AB	Stock	22.37	22.43	22.25	22.39	343900.0
2013-04-17	ABAC-DELISTED	Stock	0.8004	0.84	0.8	0.8	13744.0
2013-04-17	ABAX-DELISTED	Stock	45.28	45.52	43.7984	44.23	115157.0
2013-04-17	ABB-DELISTED	Stock	21.94	21.95	21.32	21.5175	3155849.0
2013-04-17	ABBNY-DELISTED	Stock	21.94	21.95	21.32	21.52	3171456.0
2013-04-17	ABBV	Stock	42.14	42.43	41.42	42.24	5046200.0
2013-04-17	ABC-DELISTED	Stock	54.78	55.19	54.45	55.07	3148070.0
2013-04-17	ABCB	Stock	13.42	13.42	13.12	13.29	45600.0
2013-04-17	ABCD-DELISTED	Stock	1.0	1.0026	0.95	0.95	17903.0
2013-04-17	ABCO-DELISTED	Stock	51.19	51.44	49.05	49.19	254895.0
2013-04-17	ABCW-DELISTED	Stock	0.62	0.62	0.62	0.62	200.0
2013-04-17	ABE-DELISTED	Stock	21.0	21.79	20.71	20.75	13279.0
2013-04-17	ABEO	Stock	550.0	550.0	512.5	550.0	5.0
2013-04-17	ABFS-DELISTED	Stock	10.54	10.79	10.07	10.16	292111.0
2013-04-17	ABG	Stock	35.27	35.45	34.22	34.85	407600.0
2013-04-17	ABM	Stock	20.72	20.9	20.56	20.59	310200.0
2013-04-17	ABMD-DELISTED	Stock	17.75	17.98	17.0	17.74	1281183.0
2013-04-17	ABR	Stock	7.43	7.47	7.21	7.31	252100.0
2013-04-17	ABR.A-DELISTED	Stock	25.89	25.9	25.785	25.8	7476.0
2013-04-17	ABT	Stock	36.84	37.48	36.46	37.28	14361800.0
2013-04-17	ABTL-DELISTED	Stock	4.1501	4.19	4.1	4.19	10700.0
2013-04-17	ABUS	Stock	4.55	4.6	4.49	4.59	87900.0
2013-04-17	ABV-DELISTED	Stock	39.7	39.92	39.18	39.35	3133542.0
2013-04-17	ABX-DELISTED	Stock	18.86	19.11	17.51	17.64	55187228.0

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

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