PREVIEW / stock_daily / 2011-08-22

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-22.parquet
  size:    194 KB
  rows:    6,130
  symbols: 3,556

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-22	AAPL	Stock	13.0182	13.0314	12.6818	12.73	535315200.0
2011-08-22	MSFT	Stock	24.42	24.49	23.79	23.98	54721000.0
2011-08-22	NVDA	Stock	0.3015	0.305	0.2952	0.2985	611876000.0
2011-08-22	AMZN	Stock	9.1415	9.21	8.855	8.877	106274000.0
2011-08-22	TSLA	Stock	1.5407	1.5867	1.4453	1.4633	14791500.0
2011-08-22	TLT	Stock	110.46	111.26	110.39	110.92	13160193.0
2011-08-22	ES	Stock	32.71	32.75	32.05	32.21	1672100.0
2011-08-22	CL	Stock	43.03	43.095	42.405	42.6	4744600.0
2011-08-22	A	Stock	22.8827	23.0329	21.7597	21.8169	9511712.0
2011-08-22	AABA-DELISTED	Stock	13.17	13.23	12.77	12.83	14113236.0
2011-08-22	AACC-DELISTED	Stock	4.02	4.02	3.76	3.88	14765.0
2011-08-22	AACG	Stock	9.07	9.07	8.01	8.4	14600.0
2011-08-22	AAIC-DELISTED	Stock	24.79	24.79	23.72	23.86	54452.0
2011-08-22	AAME	Stock	1.77	1.92	1.77	1.87	2400.0
2011-08-22	AAON	Stock	4.8622	4.9896	4.6844	4.7111	412425.0
2011-08-22	AAP	Stock	58.68	58.72	56.92	57.33	1979500.0
2011-08-22	AAT	Stock	18.58	18.58	18.17	18.36	136600.0
2011-08-22	AATI-DELISTED	Stock	5.89	5.89	5.78	5.8	205906.0
2011-08-22	AAU-DELISTED	Stock	3.15	3.2848	3.03	3.16	370761.0
2011-08-22	AAUAF-DELISTED	Stock	3.15	3.29	3.03	3.16	374078.0
2011-08-22	AAV-DELISTED	Stock	5.55	5.55	5.15	5.19	719282.0
2011-08-22	AAWW-DELISTED	Stock	43.02	43.32	40.98	41.23	237786.0
2011-08-22	AAXJ	Stock	53.34	53.43	52.36	52.6	251574.0
2011-08-22	AAXN-DELISTED	Stock	3.86	3.94	3.76	3.79	331077.0
2011-08-22	AB	Stock	14.89	15.01	14.4	14.59	309200.0
2011-08-22	ABAC-DELISTED	Stock	2.25	2.34	2.1	2.32	50665.0
2011-08-22	ABAX-DELISTED	Stock	22.87	23.42	22.231	22.45	229501.0
2011-08-22	ABB-DELISTED	Stock	20.13	20.14	19.44	19.47	2848994.0
2011-08-22	ABBC-DELISTED	Stock	7.89	8.09	7.59	7.63	27148.0
2011-08-22	ABBNY-DELISTED	Stock	20.11	20.13	19.44	19.46	2860922.0
2011-08-22	ABC-DELISTED	Stock	38.22	38.24	37.27	37.37	3961806.0
2011-08-22	ABCB	Stock	9.26	9.27	8.75	8.89	85700.0
2011-08-22	ABCD-DELISTED	Stock	2.91	2.95	2.68	2.82	14872.0
2011-08-22	ABCO-DELISTED	Stock	28.99	29.37	28.19	28.21	207388.0
2011-08-22	ABCW-DELISTED	Stock	0.61	0.64	0.61	0.63	34600.0
2011-08-22	ABD-DELISTED	Stock	5.91	5.96	5.51	5.66	156180.0
2011-08-22	ABE-DELISTED	Stock	17.75	17.75	17.51	17.7	26079.0
2011-08-22	ABEO	Stock	2687.5	2750.0	2500.0	2675.0	2.0
2011-08-22	ABFS-DELISTED	Stock	18.96	18.96	18.15	18.45	190177.0
2011-08-22	ABG	Stock	16.88	16.92	16.08	16.18	443200.0
2011-08-22	ABH-DELISTED	Stock	16.39	16.55	15.55	15.9	347033.0
2011-08-22	ABM	Stock	18.99	19.02	18.37	18.66	170600.0
2011-08-22	ABMD-DELISTED	Stock	11.95	12.17	11.29	11.36	128266.0
2011-08-22	ABR	Stock	3.67	3.72	3.65	3.71	62700.0
2011-08-22	ABT	Stock	23.9324	23.99	23.6349	23.6925	15758233.0
2011-08-22	ABTL-DELISTED	Stock	4.25	4.4525	4.0505	4.3	24604.0
2011-08-22	ABUS	Stock	1.95	1.95	1.9	1.95	1500.0
2011-08-22	ABV-DELISTED	Stock	33.46	33.6	32.76	32.85	2772711.0
2011-08-22	ABVT-DELISTED	Stock	56.25	56.34	54.15	54.52	113180.0
2011-08-22	ABX-DELISTED	Stock	51.34	52.78	51.22	52.05	13411909.0

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

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