PREVIEW / stock_daily / 2011-01-26

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-26.parquet
  size:    196 KB
  rows:    6,080
  symbols: 3,542

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-01-26	AAPL	Stock	12.2486	12.3429	12.1964	12.2804	506875600.0
2011-01-26	MSFT	Stock	28.51	28.99	28.5	28.78	74628800.0
2011-01-26	NVDA	Stock	0.6055	0.625	0.6013	0.6135	1074660000.0
2011-01-26	AMZN	Stock	8.8755	8.8945	8.7315	8.7695	75244000.0
2011-01-26	TSLA	Stock	1.6473	1.6587	1.6067	1.65	16198500.0
2011-01-26	TLT	Stock	92.22	92.26	90.89	91.03	13324349.0
2011-01-26	ES	Stock	33.03	33.03	32.57	32.64	2536000.0
2011-01-26	CL	Stock	39.995	40.225	39.935	40.0	4402600.0
2011-01-26	A	Stock	30.6295	30.7368	30.0715	30.4506	5490505.0
2011-01-26	AABA-DELISTED	Stock	15.94	16.05	15.41	15.57	48570782.0
2011-01-26	AACC-DELISTED	Stock	6.17	6.52	6.15	6.52	18842.0
2011-01-26	AACG	Stock	4.2	4.2	4.18	4.19	2300.0
2011-01-26	AAI-DELISTED	Stock	7.48	7.5	7.43	7.43	2483647.0
2011-01-26	AAIC-DELISTED	Stock	24.33	24.6259	24.1988	24.36	29426.0
2011-01-26	AAME	Stock	2.17	2.19	2.13	2.14	2400.0
2011-01-26	AAON	Stock	5.3195	5.5269	5.2681	5.519	369562.0
2011-01-26	AAP	Stock	63.9	64.55	62.68	64.25	1129200.0
2011-01-26	AAT	Stock	21.29	21.36	21.21	21.27	346800.0
2011-01-26	AATI-DELISTED	Stock	4.12	4.235	4.1	4.2	93643.0
2011-01-26	AAU-DELISTED	Stock	3.6	3.8097	3.55	3.8097	408243.0
2011-01-26	AAUAF-DELISTED	Stock	3.61	3.82	3.56	3.8	407780.0
2011-01-26	AAV-DELISTED	Stock	7.1	7.36	7.08	7.29	802638.0
2011-01-26	AAWW-DELISTED	Stock	51.8	54.46	51.8	53.53	387550.0
2011-01-26	AAXJ	Stock	62.76	63.09	62.69	62.84	482672.0
2011-01-26	AAXN-DELISTED	Stock	4.2	4.34	4.14	4.16	1002106.0
2011-01-26	AB	Stock	21.18	21.28	21.05	21.1	563100.0
2011-01-26	ABAC-DELISTED	Stock	5.64	5.64	5.52	5.59	38679.0
2011-01-26	ABAX-DELISTED	Stock	26.76	28.0	26.76	27.52	173064.0
2011-01-26	ABB-DELISTED	Stock	23.86	23.99	23.8	23.98	2531623.0
2011-01-26	ABBC-DELISTED	Stock	11.46	11.62	11.38	11.61	35628.0
2011-01-26	ABBNY-DELISTED	Stock	23.86	23.99	23.8	23.99	2532815.0
2011-01-26	ABC-DELISTED	Stock	36.08	36.69	36.01	36.4	2775017.0
2011-01-26	ABCB	Stock	10.03	10.32	9.97	10.27	39700.0
2011-01-26	ABCD-DELISTED	Stock	3.22	3.33	3.2	3.31	28777.0
2011-01-26	ABCO-DELISTED	Stock	24.31	25.43	24.31	25.0	149924.0
2011-01-26	ABCW-DELISTED	Stock	1.34	1.44	1.34	1.38	112520.0
2011-01-26	ABD-DELISTED	Stock	8.33	8.79	8.33	8.59	253690.0
2011-01-26	ABE-DELISTED	Stock	18.79	19.04	18.7471	18.82	32684.0
2011-01-26	ABEO	Stock	3037.5	3250.0	3012.5	3237.5	26.0
2011-01-26	ABFS-DELISTED	Stock	26.22	26.96	26.05	26.67	147854.0
2011-01-26	ABG	Stock	18.36	19.12	18.16	18.99	175800.0
2011-01-26	ABH-DELISTED	Stock	29.2	29.5275	28.92	29.27	1493563.0
2011-01-26	ABM	Stock	25.38	26.12	25.28	26.11	257300.0
2011-01-26	ABMD-DELISTED	Stock	9.98	10.08	9.88	10.0	163431.0
2011-01-26	ABR	Stock	5.79	6.25	5.7	6.16	100500.0
2011-01-26	ABT	Stock	23.1024	23.1264	22.4306	22.4306	43138183.0
2011-01-26	ABTL-DELISTED	Stock	4.4353	4.5891	4.38	4.5647	1969.0
2011-01-26	ABUS	Stock	7.0	7.0	6.8	6.9	5500.0
2011-01-26	ABV-DELISTED	Stock	27.97	28.42	27.95	28.2667	4472613.0
2011-01-26	ABVA-DELISTED	Stock	4.87	5.0	4.7718	4.9	15117.0

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

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