PREVIEW / stock_daily / 2011-04-29

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-29.parquet
  size:    198 KB
  rows:    6,134
  symbols: 3,584

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-04-29	AAPL	Stock	12.385	12.6411	12.3811	12.5046	1006345200.0
2011-04-29	MSFT	Stock	26.55	26.64	25.36	25.92	319317900.0
2011-04-29	NVDA	Stock	0.491	0.511	0.4902	0.5	836000000.0
2011-04-29	AMZN	Stock	9.719	9.8295	9.689	9.7905	132818000.0
2011-04-29	TSLA	Stock	1.846	1.858	1.828	1.84	10890000.0
2011-04-29	TLT	Stock	93.47	93.92	93.35	93.89	5905380.0
2011-04-29	ES	Stock	35.45	35.67	35.32	35.6	1339300.0
2011-04-29	CL	Stock	41.835	42.5	41.835	42.175	9857400.0
2011-04-29	A	Stock	35.98	36.2518	35.6438	35.701	3312561.0
2011-04-29	AABA-DELISTED	Stock	17.44	17.77	17.36	17.77	30543532.0
2011-04-29	AACC-DELISTED	Stock	5.87	5.87	5.561	5.66	19580.0
2011-04-29	AACG	Stock	8.0	8.57	7.98	8.18	133000.0
2011-04-29	AAI-DELISTED	Stock	7.52	7.58	7.47	7.5	2704094.0
2011-04-29	AAIC-DELISTED	Stock	30.72	30.73	30.47	30.5	64215.0
2011-04-29	AAME	Stock	1.99	2.2	1.99	2.15	1800.0
2011-04-29	AAON	Stock	6.5185	6.5205	6.4612	6.4889	126562.0
2011-04-29	AAP	Stock	66.03	66.03	64.99	65.46	991000.0
2011-04-29	AAT	Stock	22.09	22.18	21.87	22.08	137000.0
2011-04-29	AATI-DELISTED	Stock	4.27	4.3	4.24	4.25	72796.0
2011-04-29	AAU-DELISTED	Stock	4.83	5.07	4.77	4.88	1062312.0
2011-04-29	AAUAF-DELISTED	Stock	4.83	5.07	4.77	4.93	1065712.0
2011-04-29	AAV-DELISTED	Stock	8.43	8.5201	8.39	8.52	234853.0
2011-04-29	AAWW-DELISTED	Stock	68.0	69.87	67.468	68.86	170647.0
2011-04-29	AAXJ	Stock	64.59	64.88	64.46	64.84	473542.0
2011-04-29	AAXN-DELISTED	Stock	4.46	4.5	4.4	4.45	404673.0
2011-04-29	AB	Stock	22.15	22.25	21.9	22.2	450000.0
2011-04-29	ABAC-DELISTED	Stock	3.24	3.31	3.21	3.25	43915.0
2011-04-29	ABAX-DELISTED	Stock	28.44	29.5	27.98	29.03	269519.0
2011-04-29	ABB-DELISTED	Stock	27.46	27.58	27.443	27.51	2268770.0
2011-04-29	ABBC-DELISTED	Stock	12.29	12.29	12.0	12.12	45425.0
2011-04-29	ABBNY-DELISTED	Stock	27.46	27.58	27.443	27.49	2271222.0
2011-04-29	ABC-DELISTED	Stock	41.16	41.16	39.77	40.62	4481280.0
2011-04-29	ABCB	Stock	9.93	9.98	9.69	9.94	61000.0
2011-04-29	ABCD-DELISTED	Stock	3.43	3.45	3.42	3.43	15575.0
2011-04-29	ABCO-DELISTED	Stock	23.34	23.52	23.06	23.35	63484.0
2011-04-29	ABCW-DELISTED	Stock	0.85	0.85	0.81	0.84	41630.0
2011-04-29	ABD-DELISTED	Stock	9.84	9.85	9.68	9.71	221880.0
2011-04-29	ABE-DELISTED	Stock	19.09	19.31	19.09	19.31	7009.0
2011-04-29	ABEO	Stock	2750.0	2875.0	2625.0	2875.0	19.0
2011-04-29	ABFS-DELISTED	Stock	23.09	23.27	22.9	23.0	252873.0
2011-04-29	ABG	Stock	17.17	17.59	17.01	17.3	575000.0
2011-04-29	ABH-DELISTED	Stock	27.19	27.19	26.21	26.69	446915.0
2011-04-29	ABM	Stock	24.41	24.41	24.16	24.32	124000.0
2011-04-29	ABMD-DELISTED	Stock	17.16	17.52	17.09	17.39	377837.0
2011-04-29	ABR	Stock	5.35	5.35	5.22	5.26	37000.0
2011-04-29	ABT	Stock	25.1031	25.1319	24.9016	24.9688	11901000.0
2011-04-29	ABTL-DELISTED	Stock	7.425	7.524	7.225	7.275	22852.0
2011-04-29	ABUS	Stock	3.04	3.13	2.95	3.01	7500.0
2011-04-29	ABV-DELISTED	Stock	31.92	32.69	31.92	32.59	2585837.0
2011-04-29	ABVA-DELISTED	Stock	6.71	6.83	6.65	6.65	2845.0

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

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