PREVIEW / stock_daily / 2011-05-19

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-19.parquet
  size:    198 KB
  rows:    6,115
  symbols: 3,566

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
2011-05-19	AAPL	Stock	12.2171	12.2289	12.0954	12.1618	261170000.0
2011-05-19	MSFT	Stock	24.85	24.88	24.5	24.72	37783600.0
2011-05-19	NVDA	Stock	0.4545	0.4548	0.4378	0.4445	650884000.0
2011-05-19	AMZN	Stock	9.9165	9.9975	9.8775	9.94	74024000.0
2011-05-19	TSLA	Stock	1.802	1.896	1.7733	1.88	39826500.0
2011-05-19	TLT	Stock	94.46	95.32	94.46	95.27	8067370.0
2011-05-19	ES	Stock	36.4	36.47	36.02	36.26	1141200.0
2011-05-19	CL	Stock	43.175	43.475	43.075	43.45	3589800.0
2011-05-19	A	Stock	37.1531	37.1817	36.5165	36.5951	7214659.0
2011-05-19	AABA-DELISTED	Stock	16.05	16.49	16.04	16.35	38113590.0
2011-05-19	AACC-DELISTED	Stock	4.57	4.62	4.07	4.49	37727.0
2011-05-19	AACG	Stock	10.45	10.77	10.3	10.37	25200.0
2011-05-19	AAIC-DELISTED	Stock	27.5	27.85	26.78	27.2	93414.0
2011-05-19	AAME	Stock	2.04	2.05	2.04	2.05	800.0
2011-05-19	AAON	Stock	6.4948	6.6489	6.4	6.4928	132637.0
2011-05-19	AAP	Stock	64.2	65.0	62.58	63.49	6039200.0
2011-05-19	AAT	Stock	21.95	22.21	21.84	21.95	318300.0
2011-05-19	AATI-DELISTED	Stock	3.8	3.89	3.79	3.81	146334.0
2011-05-19	AAU-DELISTED	Stock	3.67	3.73	3.55	3.62	317443.0
2011-05-19	AAUAF-DELISTED	Stock	3.67	3.73	3.55	3.63	317643.0
2011-05-19	AAV-DELISTED	Stock	8.05	8.15	7.98	8.03	268035.0
2011-05-19	AAWW-DELISTED	Stock	62.92	64.53	62.5	64.36	194670.0
2011-05-19	AAXJ	Stock	63.15	63.2	62.69	63.09	398796.0
2011-05-19	AAXN-DELISTED	Stock	4.56	4.56	4.45	4.51	177327.0
2011-05-19	AB	Stock	21.41	21.79	21.4	21.53	219300.0
2011-05-19	ABAC-DELISTED	Stock	2.84	2.8401	2.65	2.68	67825.0
2011-05-19	ABAX-DELISTED	Stock	28.65	31.62	28.65	31.41	422341.0
2011-05-19	ABB-DELISTED	Stock	26.41	26.56	26.24	26.49	3699163.0
2011-05-19	ABBC-DELISTED	Stock	11.49	11.69	11.41	11.68	49402.0
2011-05-19	ABBNY-DELISTED	Stock	26.41	26.56	26.24	26.48	3805272.0
2011-05-19	ABC-DELISTED	Stock	42.05	42.139	41.6	41.82	2644875.0
2011-05-19	ABCB	Stock	9.11	9.13	9.02	9.04	33900.0
2011-05-19	ABCD-DELISTED	Stock	3.09	3.105	3.04	3.09	6721.0
2011-05-19	ABCO-DELISTED	Stock	25.37	25.92	25.3	25.64	136246.0
2011-05-19	ABCW-DELISTED	Stock	0.78	0.798	0.71	0.75	21560.0
2011-05-19	ABD-DELISTED	Stock	8.93	8.99	8.68	8.78	240670.0
2011-05-19	ABE-DELISTED	Stock	18.73	18.85	18.72	18.73	6183.0
2011-05-19	ABEO	Stock	2687.5	2812.5	2575.0	2812.5	14.0
2011-05-19	ABFS-DELISTED	Stock	24.32	25.22	24.06	24.945	521312.0
2011-05-19	ABG	Stock	16.69	16.93	16.57	16.63	223800.0
2011-05-19	ABH-DELISTED	Stock	24.26	24.89	24.23	24.8	651255.0
2011-05-19	ABM	Stock	23.87	23.91	23.39	23.65	222200.0
2011-05-19	ABMD-DELISTED	Stock	17.85	18.149	17.49	17.77	406217.0
2011-05-19	ABR	Stock	4.98	5.05	4.95	5.01	21700.0
2011-05-19	ABT	Stock	25.8948	25.9092	25.487	25.6309	12759900.0
2011-05-19	ABTL-DELISTED	Stock	5.75	5.8	5.6	5.75	13321.0
2011-05-19	ABUS	Stock	2.78	2.86	2.78	2.86	1800.0
2011-05-19	ABV-DELISTED	Stock	31.45	31.5	31.14	31.33	2040940.0
2011-05-19	ABVA-DELISTED	Stock	6.19	6.412	6.01	6.0299	10091.0
2011-05-19	ABVT-DELISTED	Stock	64.58	64.97	64.0	64.13	76428.0

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

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