PREVIEW / stock_daily / 2011-03-15

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-15.parquet
  size:    197 KB
  rows:    6,091
  symbols: 3,547

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-03-15	AAPL	Stock	12.2179	12.4229	12.1464	12.3368	721081200.0
2011-03-15	MSFT	Stock	25.08	25.47	25.0	25.39	76067300.0
2011-03-15	NVDA	Stock	0.4328	0.449	0.4253	0.4415	1256280000.0
2011-03-15	AMZN	Stock	8.0695	8.344	8.038	8.254	98690000.0
2011-03-15	TSLA	Stock	1.48	1.5307	1.4533	1.53	19782000.0
2011-03-15	TLT	Stock	92.8	93.05	92.36	92.88	14895980.0
2011-03-15	ES	Stock	33.58	33.94	33.52	33.72	1257700.0
2011-03-15	CL	Stock	38.645	38.86	38.47	38.635	6373600.0
2011-03-15	A	Stock	31.0086	31.5951	30.4578	31.3448	9660599.0
2011-03-15	AABA-DELISTED	Stock	16.67	16.68	16.04	16.33	49956873.0
2011-03-15	AACC-DELISTED	Stock	5.33	5.49	5.33	5.45	16805.0
2011-03-15	AACG	Stock	7.65	7.7	7.5	7.69	33000.0
2011-03-15	AAI-DELISTED	Stock	7.38	7.42	7.35	7.4	1526480.0
2011-03-15	AAIC-DELISTED	Stock	27.1	27.78	26.18	27.63	67024.0
2011-03-15	AAME	Stock	2.06	2.12	2.06	2.1	1400.0
2011-03-15	AAON	Stock	5.5328	5.683	5.5328	5.6257	252619.0
2011-03-15	AAP	Stock	64.23	65.98	64.13	65.42	1032500.0
2011-03-15	AAT	Stock	20.74	20.95	20.6	20.95	160300.0
2011-03-15	AATI-DELISTED	Stock	3.73	3.78	3.68	3.71	75285.0
2011-03-15	AAU-DELISTED	Stock	3.49	3.52	3.33	3.49	561099.0
2011-03-15	AAUAF-DELISTED	Stock	3.49	3.52	3.33	3.49	571199.0
2011-03-15	AAV-DELISTED	Stock	7.67	8.0001	7.48	7.9	1194819.0
2011-03-15	AAWW-DELISTED	Stock	62.18	63.85	61.49	63.29	283727.0
2011-03-15	AAXJ	Stock	58.8	60.11	58.67	59.91	686971.0
2011-03-15	AAXN-DELISTED	Stock	3.99	4.0	3.85	3.96	504808.0
2011-03-15	AB	Stock	21.0	21.2	20.81	21.07	545300.0
2011-03-15	ABAC-DELISTED	Stock	4.14	4.6	4.11	4.46	112842.0
2011-03-15	ABAX-DELISTED	Stock	27.46	28.52	27.22	27.55	109474.0
2011-03-15	ABB-DELISTED	Stock	21.84	22.55	21.7313	22.45	4910926.0
2011-03-15	ABBC-DELISTED	Stock	11.57	11.81	11.45	11.72	50059.0
2011-03-15	ABBNY-DELISTED	Stock	21.84	22.55	21.7313	22.43	5296778.0
2011-03-15	ABC-DELISTED	Stock	36.16	36.71	35.98	36.43	3310605.0
2011-03-15	ABCB	Stock	9.22	9.47	9.15	9.32	61500.0
2011-03-15	ABCD-DELISTED	Stock	3.19	3.33	3.19	3.3	18073.0
2011-03-15	ABCO-DELISTED	Stock	23.81	24.26	23.78	23.95	106847.0
2011-03-15	ABCW-DELISTED	Stock	1.0	1.07	0.95	1.07	76930.0
2011-03-15	ABD-DELISTED	Stock	8.54	8.901	8.48	8.81	206800.0
2011-03-15	ABE-DELISTED	Stock	17.36	17.84	17.36	17.74	36612.0
2011-03-15	ABEO	Stock	2437.5	2487.5	2387.5	2487.5	6.0
2011-03-15	ABFS-DELISTED	Stock	23.31	24.03	23.31	23.86	203714.0
2011-03-15	ABG	Stock	16.85	17.64	16.38	17.39	574300.0
2011-03-15	ABH-DELISTED	Stock	26.55	27.07	26.01	26.875	437297.0
2011-03-15	ABM	Stock	24.05	24.88	23.93	24.69	371200.0
2011-03-15	ABMD-DELISTED	Stock	13.63	13.83	13.535	13.76	139936.0
2011-03-15	ABR	Stock	5.65	5.76	5.5	5.69	85600.0
2011-03-15	ABT	Stock	22.8097	22.9344	22.613	22.8625	26149646.0
2011-03-15	ABTL-DELISTED	Stock	5.3022	5.5996	4.7651	5.55	96762.0
2011-03-15	ABUS	Stock	4.6	4.6	4.57	4.57	2200.0
2011-03-15	ABV-DELISTED	Stock	26.72	27.36	26.72	27.23	2191772.0
2011-03-15	ABVA-DELISTED	Stock	4.84	4.9599	4.83	4.94	1280.0

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

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