PREVIEW / stock_daily / 2011-08-04

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-04.parquet
  size:    199 KB
  rows:    6,172
  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-08-04	AAPL	Stock	13.9075	13.9757	13.4768	13.4775	871407600.0
2011-08-04	MSFT	Stock	26.53	26.87	25.93	25.94	92949500.0
2011-08-04	NVDA	Stock	0.3635	0.3635	0.335	0.335	979732000.0
2011-08-04	AMZN	Stock	10.3365	10.4	10.0725	10.074	131590000.0
2011-08-04	TSLA	Stock	1.7673	1.7927	1.6447	1.65	45967500.0
2011-08-04	TLT	Stock	102.38	105.55	102.27	105.36	34077770.0
2011-08-04	ES	Stock	32.74	32.97	31.99	32.01	2823400.0
2011-08-04	CL	Stock	41.75	42.44	41.215	41.29	9213200.0
2011-08-04	A	Stock	27.7754	27.7754	26.3662	26.402	8617552.0
2011-08-04	AABA-DELISTED	Stock	12.83	12.86	11.99	11.99	39176917.0
2011-08-04	AACC-DELISTED	Stock	4.65	4.69	4.51	4.52	8646.0
2011-08-04	AACG	Stock	9.95	10.8	9.92	10.15	5300.0
2011-08-04	AAIC-DELISTED	Stock	27.2	27.35	25.131	25.27	129164.0
2011-08-04	AAME	Stock	1.88	1.98	1.77	1.91	11000.0
2011-08-04	AAON	Stock	6.563	6.563	5.3778	5.4548	625725.0
2011-08-04	AAP	Stock	53.76	53.94	52.73	52.74	1494000.0
2011-08-04	AAT	Stock	21.17	21.29	20.43	20.44	212000.0
2011-08-04	AATI-DELISTED	Stock	6.03	6.05	5.92	5.92	1158297.0
2011-08-04	AAU-DELISTED	Stock	3.5	3.51	3.05	3.14	568123.0
2011-08-04	AAUAF-DELISTED	Stock	3.5	3.51	3.05	3.14	568323.0
2011-08-04	AAV-DELISTED	Stock	6.73	6.73	6.225	6.34	695098.0
2011-08-04	AAWW-DELISTED	Stock	49.26	50.4539	45.52	45.61	810325.0
2011-08-04	AAXJ	Stock	59.2	59.43	57.92	58.05	774623.0
2011-08-04	AAXN-DELISTED	Stock	4.24	4.26	4.1	4.1	540536.0
2011-08-04	AB	Stock	16.1	16.46	15.13	15.21	1045800.0
2011-08-04	ABAC-DELISTED	Stock	2.55	2.5508	2.4	2.43	27360.0
2011-08-04	ABAX-DELISTED	Stock	22.13	22.56	21.57	21.57	259157.0
2011-08-04	ABB-DELISTED	Stock	22.16	22.24	21.02	21.06	8816814.0
2011-08-04	ABBC-DELISTED	Stock	9.74	9.77	9.16	9.16	72644.0
2011-08-04	ABBNY-DELISTED	Stock	22.16	22.24	21.02	21.05	8839444.0
2011-08-04	ABC-DELISTED	Stock	37.61	37.807	36.27	36.29	4358842.0
2011-08-04	ABCB	Stock	10.01	10.19	9.87	9.87	85700.0
2011-08-04	ABCD-DELISTED	Stock	3.17	3.24	3.08	3.1	33868.0
2011-08-04	ABCO-DELISTED	Stock	28.5	29.92	28.34	29.67	385750.0
2011-08-04	ABCW-DELISTED	Stock	0.64	0.65	0.62	0.62	22850.0
2011-08-04	ABD-DELISTED	Stock	7.955	8.235	7.515	7.525	434630.0
2011-08-04	ABE-DELISTED	Stock	18.79	18.9	18.25	18.37	11430.0
2011-08-04	ABEO	Stock	2800.0	2800.0	2550.0	2750.0	30.0
2011-08-04	ABFS-DELISTED	Stock	23.39	23.6958	22.47	22.48	457225.0
2011-08-04	ABG	Stock	21.11	21.12	19.6	19.62	834200.0
2011-08-04	ABH-DELISTED	Stock	17.54	17.54	16.68	16.7	946603.0
2011-08-04	ABM	Stock	20.93	21.25	20.48	20.48	694700.0
2011-08-04	ABMD-DELISTED	Stock	14.23	15.35	11.37	12.05	1157770.0
2011-08-04	ABR	Stock	4.35	4.48	4.2	4.25	58100.0
2011-08-04	ABT	Stock	23.9276	24.1435	23.3855	23.3998	33477282.0
2011-08-04	ABTL-DELISTED	Stock	4.8007	4.8007	4.3493	4.3493	46100.0
2011-08-04	ABUS	Stock	2.21	2.21	2.0	2.17	17100.0
2011-08-04	ABV-DELISTED	Stock	29.84	30.16	28.87	28.87	6229783.0
2011-08-04	ABVA-DELISTED	Stock	5.04	5.07	4.8728	5.0	18124.0
2011-08-04	ABVT-DELISTED	Stock	59.09	59.12	55.78	55.91	248646.0

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

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