PREVIEW / stock_daily / 2011-08-05

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-05.parquet
  size:    198 KB
  rows:    6,168
  symbols: 3,579

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-05	AAPL	Stock	13.5871	13.6964	12.9489	13.3436	1204590800.0
2011-08-05	MSFT	Stock	25.97	26.1	25.23	25.68	112071700.0
2011-08-05	NVDA	Stock	0.3428	0.347	0.315	0.3238	1270588000.0
2011-08-05	AMZN	Stock	10.2335	10.366	9.742	10.135	200480000.0
2011-08-05	TSLA	Stock	1.666	1.692	1.522	1.616	29466000.0
2011-08-05	TLT	Stock	103.44	105.5	102.28	102.32	41677899.0
2011-08-05	ES	Stock	32.39	32.45	31.5	32.24	4312600.0
2011-08-05	CL	Stock	41.655	42.415	40.935	42.075	9120800.0
2011-08-05	A	Stock	26.8956	27.1745	25.3004	26.1731	12583678.0
2011-08-05	AABA-DELISTED	Stock	12.1	12.12	11.41	11.74	45473803.0
2011-08-05	AACC-DELISTED	Stock	4.65	4.65	4.37	4.5	15706.0
2011-08-05	AACG	Stock	9.1	9.85	9.0	9.51	18100.0
2011-08-05	AAIC-DELISTED	Stock	25.45	27.14	24.06	25.73	175919.0
2011-08-05	AAME	Stock	1.81	1.95	1.8	1.93	2000.0
2011-08-05	AAON	Stock	5.5556	6.003	5.3185	5.6859	545063.0
2011-08-05	AAP	Stock	53.08	53.39	51.9	52.94	1887200.0
2011-08-05	AAT	Stock	20.82	20.9	19.83	20.0	391800.0
2011-08-05	AATI-DELISTED	Stock	5.96	6.0898	5.86	5.96	868908.0
2011-08-05	AAU-DELISTED	Stock	3.13	3.22	2.92	3.08	437582.0
2011-08-05	AAUAF-DELISTED	Stock	3.13	3.22	2.92	3.06	443582.0
2011-08-05	AAV-DELISTED	Stock	6.33	6.35	5.78	6.03	1047459.0
2011-08-05	AAWW-DELISTED	Stock	46.28	47.99	41.9	45.49	577912.0
2011-08-05	AAXJ	Stock	57.91	58.27	55.86	57.19	653305.0
2011-08-05	AAXN-DELISTED	Stock	4.13	4.16	3.98	4.0	540364.0
2011-08-05	AB	Stock	15.36	15.88	14.88	15.73	926000.0
2011-08-05	ABAC-DELISTED	Stock	2.49	2.49	2.33	2.33	12975.0
2011-08-05	ABAX-DELISTED	Stock	21.9	22.2	20.1	21.56	423890.0
2011-08-05	ABB-DELISTED	Stock	22.26	22.28	21.05	21.57	12868558.0
2011-08-05	ABBC-DELISTED	Stock	9.27	9.29	8.83	8.91	47227.0
2011-08-05	ABBNY-DELISTED	Stock	22.26	22.28	21.05	21.59	13052375.0
2011-08-05	ABC-DELISTED	Stock	36.86	37.28	35.65	36.82	4513656.0
2011-08-05	ABCB	Stock	9.97	10.14	9.71	9.89	53600.0
2011-08-05	ABCD-DELISTED	Stock	3.12	3.12	2.9	3.01	47122.0
2011-08-05	ABCO-DELISTED	Stock	29.93	30.13	28.67	29.25	641782.0
2011-08-05	ABCW-DELISTED	Stock	0.61	0.65	0.601	0.65	71200.0
2011-08-05	ABD-DELISTED	Stock	7.65	7.82	7.16	7.6	469820.0
2011-08-05	ABE-DELISTED	Stock	18.38	18.55	17.59	18.02	23869.0
2011-08-05	ABEO	Stock	2850.0	2850.0	2400.0	2812.5	27.0
2011-08-05	ABFS-DELISTED	Stock	22.68	22.82	21.52	21.9	656027.0
2011-08-05	ABG	Stock	20.01	20.48	18.86	19.68	713500.0
2011-08-05	ABH-DELISTED	Stock	16.95	17.57	15.745	16.69	2054971.0
2011-08-05	ABM	Stock	20.68	21.36	20.17	20.63	637500.0
2011-08-05	ABMD-DELISTED	Stock	12.2	12.27	11.1	11.53	315704.0
2011-08-05	ABR	Stock	4.04	4.23	3.95	4.06	273400.0
2011-08-05	ABT	Stock	23.6445	24.3403	23.2463	24.1004	35718633.0
2011-08-05	ABTL-DELISTED	Stock	4.7	4.8	4.5055	4.7	65814.0
2011-08-05	ABUS	Stock	2.18	2.21	1.81	2.07	13100.0
2011-08-05	ABV-DELISTED	Stock	29.01	30.1	28.33	29.68	6165149.0
2011-08-05	ABVA-DELISTED	Stock	5.07	5.15	4.7499	5.0	17776.0
2011-08-05	ABVT-DELISTED	Stock	57.47	58.97	56.77	57.96	690165.0

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

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