PREVIEW / stock_daily / 2011-05-09

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-09.parquet
  size:    196 KB
  rows:    6,136
  symbols: 3,574

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-09	AAPL	Stock	12.4236	12.4714	12.3761	12.4143	204747200.0
2011-05-09	MSFT	Stock	25.8	25.96	25.67	25.83	38696400.0
2011-05-09	NVDA	Stock	0.4845	0.4963	0.4832	0.4938	706328000.0
2011-05-09	AMZN	Stock	9.917	10.118	9.839	10.04	116508000.0
2011-05-09	TSLA	Stock	1.8	1.8667	1.79	1.8607	13746000.0
2011-05-09	TLT	Stock	94.9	95.2	94.84	94.97	3735127.0
2011-05-09	ES	Stock	35.28	35.53	35.0	35.44	1029900.0
2011-05-09	CL	Stock	42.455	42.585	42.245	42.49	3274600.0
2011-05-09	A	Stock	35.6581	35.7868	35.3791	35.6795	2830810.0
2011-05-09	AABA-DELISTED	Stock	18.6	18.84	18.54	18.55	15514230.0
2011-05-09	AACC-DELISTED	Stock	5.0	5.15	5.0	5.0	25113.0
2011-05-09	AACG	Stock	8.23	8.66	8.23	8.46	25800.0
2011-05-09	AAIC-DELISTED	Stock	28.72	29.15	28.72	29.09	26975.0
2011-05-09	AAME	Stock	2.03	2.05	1.95	2.05	2100.0
2011-05-09	AAON	Stock	6.2933	6.3743	6.2222	6.3526	156937.0
2011-05-09	AAP	Stock	65.02	65.83	64.88	65.51	715400.0
2011-05-09	AAT	Stock	21.67	21.9	21.44	21.9	62000.0
2011-05-09	AATI-DELISTED	Stock	3.96	4.01	3.91	3.96	58971.0
2011-05-09	AAU-DELISTED	Stock	4.03	4.13	3.97	4.08	363256.0
2011-05-09	AAUAF-DELISTED	Stock	4.04	4.14	3.98	4.07	363201.0
2011-05-09	AAV-DELISTED	Stock	7.83	8.11	7.83	8.0	327152.0
2011-05-09	AAWW-DELISTED	Stock	64.26	64.26	62.89	63.41	390523.0
2011-05-09	AAXJ	Stock	63.7	63.9	63.37	63.71	468340.0
2011-05-09	AAXN-DELISTED	Stock	4.37	4.54	4.35	4.43	540008.0
2011-05-09	AB	Stock	22.3	22.4	22.03	22.39	315300.0
2011-05-09	ABAC-DELISTED	Stock	3.08	3.0914	2.53	2.87	175992.0
2011-05-09	ABAX-DELISTED	Stock	27.56	27.98	27.42	27.74	46270.0
2011-05-09	ABB-DELISTED	Stock	26.1	26.45	25.9982	26.39	1377589.0
2011-05-09	ABBC-DELISTED	Stock	11.82	11.84	11.67	11.8	16011.0
2011-05-09	ABBNY-DELISTED	Stock	26.1	26.45	25.9982	26.39	1404789.0
2011-05-09	ABC-DELISTED	Stock	41.45	42.46	41.37	42.21	2286262.0
2011-05-09	ABCB	Stock	9.2	9.26	9.1	9.24	22000.0
2011-05-09	ABCD-DELISTED	Stock	3.17	3.235	3.11	3.17	51557.0
2011-05-09	ABCO-DELISTED	Stock	25.29	25.44	25.2	25.22	150067.0
2011-05-09	ABCW-DELISTED	Stock	0.69	0.75	0.69	0.72	60930.0
2011-05-09	ABD-DELISTED	Stock	9.38	9.44	9.31	9.35	94810.0
2011-05-09	ABE-DELISTED	Stock	18.87	18.87	18.72	18.84	3680.0
2011-05-09	ABEO	Stock	2650.0	2812.5	2512.5	2687.5	20.0
2011-05-09	ABFS-DELISTED	Stock	24.26	24.5	23.91	24.14	302488.0
2011-05-09	ABG	Stock	16.56	16.83	16.47	16.75	217000.0
2011-05-09	ABH-DELISTED	Stock	26.43	26.64	25.96	26.61	239633.0
2011-05-09	ABM	Stock	23.93	24.04	23.78	23.95	203000.0
2011-05-09	ABMD-DELISTED	Stock	16.95	17.46	16.95	17.21	162240.0
2011-05-09	ABR	Stock	5.15	5.29	5.15	5.23	83000.0
2011-05-09	ABT	Stock	25.1943	25.3095	25.0743	25.2663	12066486.0
2011-05-09	ABTL-DELISTED	Stock	6.2	6.35	6.1	6.2	23113.0
2011-05-09	ABUS	Stock	2.71	2.97	2.71	2.94	6400.0
2011-05-09	ABV-DELISTED	Stock	32.81	33.24	32.25	32.35	2017417.0
2011-05-09	ABVA-DELISTED	Stock	6.65	6.68	6.606	6.606	8390.0
2011-05-09	ABVT-DELISTED	Stock	63.29	64.5	62.65	64.19	138973.0

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

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