PREVIEW / stock_daily / 2013-04-09

all stock daily files

  file:    by_date/stock_daily/2013/2013-04-09.parquet
  size:    207 KB
  rows:    6,284
  symbols: 3,504

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-09	AAPL	Stock	15.2271	15.3036	15.0982	15.2493	306614000.0
2013-04-09	MSFT	Stock	28.73	29.82	28.68	29.61	77733800.0
2013-04-09	NVDA	Stock	0.311	0.318	0.3088	0.3158	380584000.0
2013-04-09	AMZN	Stock	12.9425	13.1305	12.85	13.057	43132000.0
2013-04-09	META	Stock	26.58	26.89	26.42	26.59	21311100.0
2013-04-09	TSLA	Stock	2.7867	2.7887	2.6887	2.7	25441500.0
2013-04-09	TLT	Stock	122.03	122.24	121.3799	121.58	7176656.0
2013-04-09	ES	Stock	43.91	43.95	43.52	43.68	1181500.0
2013-04-09	CL	Stock	59.0	59.04	58.315	58.625	2649400.0
2013-04-09	A	Stock	29.8498	30.1359	29.7067	29.7926	2319981.0
2013-04-09	AABA-DELISTED	Stock	23.56	24.0	23.44	23.83	13937950.0
2013-04-09	AACC-DELISTED	Stock	6.7	6.7	6.605	6.63	35225.0
2013-04-09	AACG	Stock	4.01	4.01	3.97	3.97	1100.0
2013-04-09	AAIC-DELISTED	Stock	26.53	26.989	26.27	26.71	361302.0
2013-04-09	AAMC-DELISTED	Stock	37.9412	39.8529	37.9412	38.8971	4444.0
2013-04-09	AAME	Stock	3.36	3.39	3.26	3.39	3200.0
2013-04-09	AAMRQ-DELISTED	Stock	3.51	3.65	3.51	3.58	3304150.0
2013-04-09	AAON	Stock	8.1333	8.1333	8.0119	8.0119	270000.0
2013-04-09	AAP	Stock	79.97	79.97	78.5	78.71	1462900.0
2013-04-09	AAT	Stock	33.16	33.29	32.54	32.57	163300.0
2013-04-09	AAU-DELISTED	Stock	2.02	2.1312	1.96	2.0	128484.0
2013-04-09	AAUAF-DELISTED	Stock	2.0	2.11	1.94	2.0	150532.0
2013-04-09	AAV-DELISTED	Stock	3.72	3.8	3.67	3.79	524430.0
2013-04-09	AAWW-DELISTED	Stock	39.54	39.71	39.13	39.23	260168.0
2013-04-09	AAXJ	Stock	57.27	57.93	57.2	57.69	497936.0
2013-04-09	AAXN-DELISTED	Stock	7.73	7.74	7.52	7.69	545468.0
2013-04-09	AB	Stock	21.75	22.1	21.62	21.76	213900.0
2013-04-09	ABAC-DELISTED	Stock	0.681	0.72	0.671	0.7	23300.0
2013-04-09	ABAX-DELISTED	Stock	47.91	49.45	47.8628	48.67	178917.0
2013-04-09	ABB-DELISTED	Stock	22.05	22.255	21.88	22.14	1184600.0
2013-04-09	ABBNY-DELISTED	Stock	22.05	22.255	21.88	22.14	1204517.0
2013-04-09	ABBV	Stock	41.96	43.56	41.8	42.55	8673900.0
2013-04-09	ABC-DELISTED	Stock	52.75	53.15	52.49	52.93	3012147.0
2013-04-09	ABCB	Stock	14.23	14.23	13.75	13.77	14900.0
2013-04-09	ABCD-DELISTED	Stock	1.0299	1.0299	1.0163	1.0163	700.0
2013-04-09	ABCO-DELISTED	Stock	50.98	51.19	50.42	50.56	109958.0
2013-04-09	ABCW-DELISTED	Stock	0.61	0.66	0.61	0.66	4189.0
2013-04-09	ABE-DELISTED	Stock	20.75	20.8899	20.45	20.8899	2191.0
2013-04-09	ABEO	Stock	562.5	575.0	537.5	575.0	38.0
2013-04-09	ABFS-DELISTED	Stock	11.29	11.48	11.04	11.04	162095.0
2013-04-09	ABG	Stock	35.31	35.42	34.85	34.97	124400.0
2013-04-09	ABM	Stock	21.29	21.58	21.27	21.35	219900.0
2013-04-09	ABMD-DELISTED	Stock	16.36	16.92	16.13	16.51	580117.0
2013-04-09	ABR	Stock	8.0	8.08	7.94	7.94	111600.0
2013-04-09	ABR.A-DELISTED	Stock	25.73	25.8	25.72	25.8	3092.0
2013-04-09	ABT	Stock	36.56	36.75	36.4	36.66	5444700.0
2013-04-09	ABTL-DELISTED	Stock	4.31	4.31	4.18	4.22	5581.0
2013-04-09	ABUS	Stock	4.96	4.96	4.45	4.58	283000.0
2013-04-09	ABV-DELISTED	Stock	41.59	41.62	41.19	41.5	1164876.0
2013-04-09	ABX-DELISTED	Stock	26.43	27.25	26.36	26.69	11893992.0

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

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