PREVIEW / stock_daily / 2011-04-05

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-05.parquet
  size:    199 KB
  rows:    6,091
  symbols: 3,562

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-05	AAPL	Stock	12.0354	12.2232	12.0	12.1032	482731200.0
2011-04-05	MSFT	Stock	25.82	26.18	25.74	25.78	73651100.0
2011-04-05	NVDA	Stock	0.4452	0.4488	0.4385	0.4395	821076000.0
2011-04-05	AMZN	Stock	9.105	9.318	9.09	9.2645	111384000.0
2011-04-05	TSLA	Stock	1.7267	1.8	1.7127	1.78	47713500.0
2011-04-05	TLT	Stock	92.16	92.38	91.67	91.92	9952765.0
2011-04-05	ES	Stock	34.92	34.96	34.7	34.76	797600.0
2011-04-05	CL	Stock	40.415	40.555	40.13	40.42	3474000.0
2011-04-05	A	Stock	32.01	32.5465	31.9099	32.432	4385246.0
2011-04-05	AABA-DELISTED	Stock	16.82	17.29	16.79	17.11	17828161.0
2011-04-05	AACC-DELISTED	Stock	5.29	5.36	5.29	5.36	5728.0
2011-04-05	AACG	Stock	7.95	7.98	7.95	7.96	3600.0
2011-04-05	AAI-DELISTED	Stock	7.42	7.46	7.4	7.41	3000639.0
2011-04-05	AAIC-DELISTED	Stock	30.61	30.75	30.43	30.56	36209.0
2011-04-05	AAME	Stock	2.01	2.13	2.0	2.13	2600.0
2011-04-05	AAON	Stock	6.3309	6.4099	6.2914	6.3664	114919.0
2011-04-05	AAP	Stock	66.05	68.2	65.92	67.78	1085900.0
2011-04-05	AAT	Stock	21.74	21.81	21.67	21.75	164700.0
2011-04-05	AATI-DELISTED	Stock	3.81	3.92	3.75	3.79	223800.0
2011-04-05	AAU-DELISTED	Stock	4.02	4.93	4.0	4.87	2900708.0
2011-04-05	AAUAF-DELISTED	Stock	4.02	4.93	4.0	4.85	2900908.0
2011-04-05	AAV-DELISTED	Stock	8.81	9.0	8.79	8.97	561040.0
2011-04-05	AAWW-DELISTED	Stock	67.46	68.49	67.19	67.74	131794.0
2011-04-05	AAXJ	Stock	64.62	65.04	64.56	64.86	775138.0
2011-04-05	AAXN-DELISTED	Stock	4.05	4.2	4.0201	4.08	430335.0
2011-04-05	AB	Stock	22.44	22.45	22.24	22.34	298000.0
2011-04-05	ABAC-DELISTED	Stock	4.11	4.11	4.01	4.02	27079.0
2011-04-05	ABAX-DELISTED	Stock	28.88	29.09	28.78	29.0	113691.0
2011-04-05	ABB-DELISTED	Stock	23.99	24.38	23.95	24.28	2456829.0
2011-04-05	ABBC-DELISTED	Stock	12.49	12.58	12.4	12.48	39372.0
2011-04-05	ABBNY-DELISTED	Stock	23.99	24.38	23.95	24.29	2485669.0
2011-04-05	ABC-DELISTED	Stock	40.42	40.71	40.24	40.58	2204622.0
2011-04-05	ABCB	Stock	9.98	10.14	9.92	10.09	109700.0
2011-04-05	ABCD-DELISTED	Stock	3.31	3.38	3.26	3.36	28978.0
2011-04-05	ABCO-DELISTED	Stock	25.08	25.15	24.8	25.06	80838.0
2011-04-05	ABCW-DELISTED	Stock	0.95	0.95	0.89	0.89	184720.0
2011-04-05	ABD-DELISTED	Stock	9.75	10.36	9.72	10.1	514390.0
2011-04-05	ABE-DELISTED	Stock	18.88	19.06	18.8616	19.028	16989.0
2011-04-05	ABEO	Stock	2687.5	2750.0	2375.0	2612.5	13.0
2011-04-05	ABFS-DELISTED	Stock	26.05	26.3	25.8401	26.11	401073.0
2011-04-05	ABG	Stock	18.5	19.0	18.23	18.72	401000.0
2011-04-05	ABH-DELISTED	Stock	27.0	27.3	26.9425	27.01	4356585.0
2011-04-05	ABM	Stock	25.32	25.76	25.18	25.61	166100.0
2011-04-05	ABMD-DELISTED	Stock	14.82	15.08	14.59	15.01	126213.0
2011-04-05	ABR	Stock	5.69	5.71	5.57	5.57	33000.0
2011-04-05	ABT	Stock	24.1579	24.2203	23.9804	23.9852	14296582.0
2011-04-05	ABTL-DELISTED	Stock	7.025	7.075	6.724	6.9749	90806.0
2011-04-05	ABUS	Stock	3.12	3.16	3.07	3.12	4300.0
2011-04-05	ABV-DELISTED	Stock	29.2	29.45	29.13	29.4	2206629.0
2011-04-05	ABVA-DELISTED	Stock	5.15	5.221	5.15	5.221	400.0

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

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