PREVIEW / stock_daily / 2012-08-27

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-27.parquet
  size:    198 KB
  rows:    6,125
  symbols: 3,474

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
2012-08-27	AAPL	Stock	24.2854	24.3168	24.055	24.1314	427008400.0
2012-08-27	MSFT	Stock	30.93	30.96	30.59	30.69	34691100.0
2012-08-27	NVDA	Stock	0.3648	0.3658	0.3585	0.3588	340944000.0
2012-08-27	AMZN	Stock	12.2895	12.375	12.156	12.196	58594000.0
2012-08-27	META	Stock	19.49	19.53	19.1	19.15	20704000.0
2012-08-27	TSLA	Stock	1.9713	1.98	1.878	1.888	20256000.0
2012-08-27	TLT	Stock	125.34	125.8	125.27	125.54	3906691.0
2012-08-27	ES	Stock	37.95	38.1	37.84	37.96	1018800.0
2012-08-27	CL	Stock	52.76	53.0	52.635	52.9	2283400.0
2012-08-27	A	Stock	27.0529	27.0529	26.6738	26.7811	4275224.0
2012-08-27	AABA-DELISTED	Stock	14.93	14.93	14.77	14.855	10024419.0
2012-08-27	AACC-DELISTED	Stock	6.52	6.59	6.38	6.42	9628.0
2012-08-27	AACG	Stock	4.44	4.46	4.36	4.36	1200.0
2012-08-27	AAIC-DELISTED	Stock	22.99	23.0	22.8	22.8	38507.0
2012-08-27	AAME	Stock	2.69	2.69	2.64	2.64	800.0
2012-08-27	AAMRQ-DELISTED	Stock	0.4801	0.486	0.4678	0.47	2759017.0
2012-08-27	AAON	Stock	5.3778	5.4815	5.3393	5.4074	135338.0
2012-08-27	AAP	Stock	72.35	72.35	71.34	71.4	701900.0
2012-08-27	AAT	Stock	27.24	27.24	26.96	27.17	80100.0
2012-08-27	AAU-DELISTED	Stock	2.45	2.81	2.43	2.65	1097424.0
2012-08-27	AAUAF-DELISTED	Stock	2.45	2.81	2.43	2.66	1114724.0
2012-08-27	AAV-DELISTED	Stock	3.67	3.69	3.54	3.55	156687.0
2012-08-27	AAWW-DELISTED	Stock	52.0	52.31	50.2	50.5	319166.0
2012-08-27	AAXJ	Stock	53.73	53.73	53.34	53.46	132407.0
2012-08-27	AAXN-DELISTED	Stock	5.29	5.515	5.29	5.45	434007.0
2012-08-27	AB	Stock	13.65	13.82	13.63	13.76	640300.0
2012-08-27	ABAC-DELISTED	Stock	1.12	1.12	1.03	1.09	1180.0
2012-08-27	ABAX-DELISTED	Stock	38.23	38.442	37.72	38.39	51125.0
2012-08-27	ABB-DELISTED	Stock	17.57	17.61	17.48	17.48	1077074.0
2012-08-27	ABBNY-DELISTED	Stock	17.58	17.61	17.48	17.48	1092072.0
2012-08-27	ABC-DELISTED	Stock	38.11	38.16	37.82	37.94	2290494.0
2012-08-27	ABCB	Stock	11.94	12.1	11.88	11.99	15200.0
2012-08-27	ABCD-DELISTED	Stock	0.97	1.04	0.96	1.0299	13665.0
2012-08-27	ABCO-DELISTED	Stock	42.89	43.27	42.54	42.66	228184.0
2012-08-27	ABCW-DELISTED	Stock	0.445	0.445	0.4	0.445	2100.0
2012-08-27	ABE-DELISTED	Stock	19.53	19.58	19.44	19.58	20773.0
2012-08-27	ABEO	Stock	812.5	812.5	662.5	762.5	11.0
2012-08-27	ABFS-DELISTED	Stock	9.79	9.85	9.32	9.4	303721.0
2012-08-27	ABG	Stock	26.56	26.87	26.0	26.78	241800.0
2012-08-27	ABM	Stock	20.59	20.65	20.34	20.4	182800.0
2012-08-27	ABMD-DELISTED	Stock	22.0	22.48	21.9	22.43	329619.0
2012-08-27	ABR	Stock	5.52	5.67	5.52	5.6	27700.0
2012-08-27	ABT	Stock	31.566	31.6572	31.4605	31.5325	6196540.0
2012-08-27	ABTL-DELISTED	Stock	3.88	3.88	3.75	3.75	2600.0
2012-08-27	ABUS	Stock	3.38	3.38	3.33	3.33	2300.0
2012-08-27	ABV-DELISTED	Stock	37.37	37.5	37.15	37.38	1676083.0
2012-08-27	ABX-DELISTED	Stock	37.81	37.97	37.37	37.47	4989282.0
2012-08-27	ACAD	Stock	1.8	1.83	1.78	1.81	549200.0
2012-08-27	ACAS-DELISTED	Stock	11.16	11.21	11.11	11.17	2018537.0
2012-08-27	ACAT-DELISTED	Stock	43.03	44.0	42.91	43.6	120896.0

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

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