PREVIEW / stock_daily / 2011-08-31

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-31.parquet
  size:    197 KB
  rows:    6,144
  symbols: 3,558

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-31	AAPL	Stock	13.9489	14.0029	13.6379	13.7439	522586400.0
2011-08-31	MSFT	Stock	26.29	26.71	26.26	26.6	59300800.0
2011-08-31	NVDA	Stock	0.3445	0.348	0.33	0.3328	705808000.0
2011-08-31	AMZN	Stock	10.6135	10.8085	10.5675	10.7615	148100000.0
2011-08-31	TSLA	Stock	1.6533	1.7	1.6187	1.6493	12357000.0
2011-08-31	TLT	Stock	108.81	108.96	107.03	107.03	12186520.0
2011-08-31	ES	Stock	34.69	34.86	34.5	34.7	1399600.0
2011-08-31	CL	Stock	45.325	45.495	44.82	44.985	6008400.0
2011-08-31	A	Stock	26.2947	27.2246	26.073	26.3734	7548641.0
2011-08-31	AABA-DELISTED	Stock	13.91	13.94	13.54	13.605	25173058.0
2011-08-31	AACC-DELISTED	Stock	4.0	4.06	4.0	4.05	30325.0
2011-08-31	AACG	Stock	8.91	9.55	8.78	9.52	11600.0
2011-08-31	AAIC-DELISTED	Stock	26.32	26.3299	25.7	25.8	24694.0
2011-08-31	AAME	Stock	1.98	1.98	1.98	1.98	100.0
2011-08-31	AAON	Stock	5.1941	5.2681	5.1052	5.1881	270675.0
2011-08-31	AAP	Stock	60.65	61.25	60.25	60.72	1242100.0
2011-08-31	AAT	Stock	19.85	20.37	19.85	20.12	202700.0
2011-08-31	AATI-DELISTED	Stock	6.01	6.02	5.92	6.01	251563.0
2011-08-31	AAU-DELISTED	Stock	3.28	3.28	3.1	3.2	112274.0
2011-08-31	AAUAF-DELISTED	Stock	3.28	3.28	3.1	3.21	112874.0
2011-08-31	AAV-DELISTED	Stock	5.9	5.961	5.81	5.83	352732.0
2011-08-31	AAWW-DELISTED	Stock	48.86	50.3	48.3759	49.08	318545.0
2011-08-31	AAXJ	Stock	56.3	56.62	55.86	56.16	475859.0
2011-08-31	AAXN-DELISTED	Stock	4.52	4.6	4.39	4.45	591458.0
2011-08-31	AB	Stock	17.0	17.28	16.61	16.95	431300.0
2011-08-31	ABAC-DELISTED	Stock	2.35	2.35	2.25	2.34	24086.0
2011-08-31	ABAX-DELISTED	Stock	25.53	25.58	24.56	24.87	172988.0
2011-08-31	ABB-DELISTED	Stock	21.37	21.58	21.11	21.25	5566796.0
2011-08-31	ABBC-DELISTED	Stock	8.73	8.88	8.62	8.75	41229.0
2011-08-31	ABBNY-DELISTED	Stock	21.37	21.58	21.11	21.27	6866796.0
2011-08-31	ABC-DELISTED	Stock	39.67	40.0	39.28	39.55	2533454.0
2011-08-31	ABCB	Stock	9.32	9.32	9.04	9.2	75100.0
2011-08-31	ABCD-DELISTED	Stock	3.05	3.09	2.99	2.99	73835.0
2011-08-31	ABCO-DELISTED	Stock	31.82	31.9	30.93	31.09	180698.0
2011-08-31	ABCW-DELISTED	Stock	0.64	0.67	0.61	0.61	12540.0
2011-08-31	ABD-DELISTED	Stock	6.76	6.94	6.63	6.82	283210.0
2011-08-31	ABE-DELISTED	Stock	18.5	18.82	18.47	18.5	3150.0
2011-08-31	ABEO	Stock	2312.5	2475.0	2312.5	2475.0	17.0
2011-08-31	ABFS-DELISTED	Stock	21.11	21.26	20.31	20.65	252004.0
2011-08-31	ABG	Stock	18.77	19.45	18.59	18.81	336600.0
2011-08-31	ABH-DELISTED	Stock	17.25	17.33	16.95	16.98	128728.0
2011-08-31	ABM	Stock	20.29	20.68	20.09	20.44	333300.0
2011-08-31	ABMD-DELISTED	Stock	12.21	12.61	11.86	12.43	162418.0
2011-08-31	ABR	Stock	4.08	4.27	4.08	4.09	35900.0
2011-08-31	ABT	Stock	24.9496	25.2471	24.8488	25.1943	22035431.0
2011-08-31	ABTL-DELISTED	Stock	4.4532	4.6	4.3661	4.6	12114.0
2011-08-31	ABUS	Stock	1.9	1.95	1.9	1.91	6800.0
2011-08-31	ABV-DELISTED	Stock	34.85	35.81	34.69	35.64	4851199.0
2011-08-31	ABVA-DELISTED	Stock	4.85	4.85	4.6	4.6	1800.0
2011-08-31	ABVT-DELISTED	Stock	60.77	61.49	60.47	61.47	195520.0

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

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