PREVIEW / stock_daily / 2011-08-19

all stock daily files

  file:    by_date/stock_daily/2011/2011-08-19.parquet
  size:    195 KB
  rows:    6,130
  symbols: 3,552

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-19	AAPL	Stock	12.9346	13.1071	12.7143	12.7154	775888400.0
2011-08-19	MSFT	Stock	24.41	24.62	23.91	24.05	77397900.0
2011-08-19	NVDA	Stock	0.2935	0.3098	0.2912	0.2932	761332000.0
2011-08-19	AMZN	Stock	9.0145	9.5	8.8775	8.9465	144884000.0
2011-08-19	TSLA	Stock	1.5907	1.6147	1.4667	1.4867	20629500.0
2011-08-19	TLT	Stock	110.65	111.41	110.23	111.2	15708896.0
2011-08-19	ES	Stock	32.23	32.74	32.17	32.22	1962100.0
2011-08-19	CL	Stock	42.15	42.93	42.03	42.495	8272200.0
2011-08-19	A	Stock	22.7039	23.4335	22.196	22.2318	8476493.0
2011-08-19	AABA-DELISTED	Stock	12.75	13.08	12.72	12.92	25777177.0
2011-08-19	AACC-DELISTED	Stock	4.07	4.16	3.92	4.05	2790.0
2011-08-19	AACG	Stock	8.74	9.02	8.67	9.0	9400.0
2011-08-19	AAIC-DELISTED	Stock	24.45	24.909	23.76	24.07	77251.0
2011-08-19	AAME	Stock	1.78	1.98	1.76	1.81	4100.0
2011-08-19	AAON	Stock	4.797	4.957	4.72	4.7378	396563.0
2011-08-19	AAP	Stock	56.01	58.33	55.8	57.95	2229300.0
2011-08-19	AAT	Stock	18.27	19.09	17.89	18.27	103500.0
2011-08-19	AATI-DELISTED	Stock	5.74	5.91	5.74	5.76	410718.0
2011-08-19	AAU-DELISTED	Stock	3.07	3.21	3.02	3.075	184681.0
2011-08-19	AAUAF-DELISTED	Stock	3.07	3.22	3.02	3.07	184694.0
2011-08-19	AAV-DELISTED	Stock	5.4	5.69	5.38	5.41	662476.0
2011-08-19	AAWW-DELISTED	Stock	39.66	42.4	39.66	41.53	331762.0
2011-08-19	AAXJ	Stock	52.74	53.89	52.67	52.72	398045.0
2011-08-19	AAXN-DELISTED	Stock	3.77	3.92	3.73	3.77	621360.0
2011-08-19	AB	Stock	14.69	14.7	14.23	14.5	341800.0
2011-08-19	ABAC-DELISTED	Stock	2.33	2.46	2.24	2.43	18157.0
2011-08-19	ABAX-DELISTED	Stock	21.78	23.27	21.66	22.26	163703.0
2011-08-19	ABB-DELISTED	Stock	19.61	20.2	19.43	19.49	3832078.0
2011-08-19	ABBC-DELISTED	Stock	7.76	8.07	7.67	7.76	46074.0
2011-08-19	ABBNY-DELISTED	Stock	19.61	20.2	19.43	19.49	3831790.0
2011-08-19	ABC-DELISTED	Stock	37.3	37.95	37.1	37.53	3876283.0
2011-08-19	ABCB	Stock	9.0	9.16	8.94	9.03	170900.0
2011-08-19	ABCD-DELISTED	Stock	2.82	2.9	2.78	2.83	45163.0
2011-08-19	ABCO-DELISTED	Stock	28.09	28.95	27.79	28.49	196182.0
2011-08-19	ABCW-DELISTED	Stock	0.61	0.67	0.61	0.62	11210.0
2011-08-19	ABD-DELISTED	Stock	5.86	6.11	5.6674	5.72	210760.0
2011-08-19	ABE-DELISTED	Stock	17.44	17.8	17.32	17.381	6645.0
2011-08-19	ABEO	Stock	2687.5	2750.0	2575.0	2687.5	3.0
2011-08-19	ABFS-DELISTED	Stock	18.72	19.3	18.33	18.39	229885.0
2011-08-19	ABG	Stock	16.04	17.4	15.99	16.39	821100.0
2011-08-19	ABH-DELISTED	Stock	16.16	16.38	16.0	16.07	225543.0
2011-08-19	ABM	Stock	18.38	19.1	18.37	18.56	230400.0
2011-08-19	ABMD-DELISTED	Stock	11.55	11.99	11.21	11.62	200806.0
2011-08-19	ABR	Stock	3.75	3.8	3.65	3.66	144400.0
2011-08-19	ABT	Stock	23.2895	23.7693	23.2703	23.5486	19531263.0
2011-08-19	ABTL-DELISTED	Stock	4.2967	4.3467	4.1983	4.2533	11956.0
2011-08-19	ABUS	Stock	1.96	1.99	1.96	1.96	4400.0
2011-08-19	ABV-DELISTED	Stock	32.25	33.85	32.1	33.13	5433744.0
2011-08-19	ABVA-DELISTED	Stock	4.78	4.8	4.69	4.7	2445.0
2011-08-19	ABVT-DELISTED	Stock	54.68	57.06	54.68	55.01	155334.0

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

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