PREVIEW / stock_daily / 2012-07-30

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-30.parquet
  size:    198 KB
  rows:    6,145
  symbols: 3,514

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-07-30	AAPL	Stock	21.1043	21.4086	20.9936	21.2511	379142400.0
2012-07-30	MSFT	Stock	29.75	29.82	29.46	29.64	28905000.0
2012-07-30	NVDA	Stock	0.337	0.3413	0.3305	0.3333	363552000.0
2012-07-30	AMZN	Stock	11.85	12.037	11.7035	11.8045	74728000.0
2012-07-30	META	Stock	24.0	24.04	23.03	23.15	29285900.0
2012-07-30	TSLA	Stock	1.9673	2.0167	1.814	1.8233	30978000.0
2012-07-30	TLT	Stock	128.39	129.48	128.25	129.44	6025442.0
2012-07-30	ES	Stock	39.99	40.86	39.96	40.57	1839300.0
2012-07-30	CL	Stock	53.635	54.25	53.58	53.735	3473400.0
2012-07-30	A	Stock	27.1245	27.3963	26.9599	27.3104	4587257.0
2012-07-30	AABA-DELISTED	Stock	16.14	16.15	15.9	15.98	10109361.0
2012-07-30	AACC-DELISTED	Stock	6.11	6.11	5.75	6.0	74004.0
2012-07-30	AACG	Stock	3.71	4.01	3.71	4.01	5100.0
2012-07-30	AAIC-DELISTED	Stock	22.5	22.8	22.5	22.7	60107.0
2012-07-30	AAMRQ-DELISTED	Stock	0.502	0.52	0.502	0.51	593948.0
2012-07-30	AAON	Stock	5.603	5.6207	5.4933	5.523	92475.0
2012-07-30	AAP	Stock	69.5	70.69	69.11	70.4	944800.0
2012-07-30	AAT	Stock	25.99	26.68	25.98	26.48	229400.0
2012-07-30	AAU-DELISTED	Stock	2.1	2.11	2.0652	2.09	51554.0
2012-07-30	AAUAF-DELISTED	Stock	2.1	2.12	2.0701	2.08	51835.0
2012-07-30	AAV-DELISTED	Stock	3.74	3.95	3.67	3.93	359417.0
2012-07-30	AAWW-DELISTED	Stock	45.5	46.11	44.51	45.08	79467.0
2012-07-30	AAXJ	Stock	52.77	52.96	52.59	52.69	192378.0
2012-07-30	AAXN-DELISTED	Stock	5.4	5.5	5.39	5.45	764747.0
2012-07-30	AB	Stock	12.26	12.33	12.11	12.13	174400.0
2012-07-30	ABAC-DELISTED	Stock	1.0	1.073	0.96	1.01	14900.0
2012-07-30	ABAX-DELISTED	Stock	36.55	36.73	35.99	36.21	161811.0
2012-07-30	ABB-DELISTED	Stock	17.36	17.49	17.3	17.35	2351062.0
2012-07-30	ABBNY-DELISTED	Stock	17.36	17.49	17.3	17.35	2435726.0
2012-07-30	ABC-DELISTED	Stock	38.72	38.76	38.29	38.54	2185152.0
2012-07-30	ABCB	Stock	12.25	12.37	12.06	12.13	14900.0
2012-07-30	ABCD-DELISTED	Stock	1.23	1.23	1.11	1.18	14984.0
2012-07-30	ABCO-DELISTED	Stock	45.3	46.31	45.23	45.32	316034.0
2012-07-30	ABCW-DELISTED	Stock	0.38	0.52	0.37	0.45	90878.0
2012-07-30	ABE-DELISTED	Stock	19.13	19.33	19.13	19.31	27522.0
2012-07-30	ABEO	Stock	725.0	725.0	637.5	700.0	18.0
2012-07-30	ABFS-DELISTED	Stock	11.81	12.47	11.81	12.23	674601.0
2012-07-30	ABG	Stock	26.47	26.68	26.0	26.21	250200.0
2012-07-30	ABM	Stock	18.89	19.08	18.59	18.74	246700.0
2012-07-30	ABMD-DELISTED	Stock	22.17	22.47	21.87	22.43	271671.0
2012-07-30	ABR	Stock	5.43	5.43	5.35	5.4	30700.0
2012-07-30	ABT	Stock	31.7436	31.9835	31.6764	31.9547	11190496.0
2012-07-30	ABTL-DELISTED	Stock	3.65	3.74	3.6005	3.7	25610.0
2012-07-30	ABUS	Stock	3.26	3.4	3.13	3.37	17900.0
2012-07-30	ABV-DELISTED	Stock	38.85	39.53	38.81	39.33	2180192.0
2012-07-30	ABVA-DELISTED	Stock	4.34	4.41	4.34	4.4	9136.0
2012-07-30	ABX-DELISTED	Stock	32.51	33.13	32.28	33.0	8339593.0
2012-07-30	ACAD	Stock	1.62	1.67	1.62	1.65	399900.0
2012-07-30	ACAS-DELISTED	Stock	9.8	9.93	9.71	9.84	2834194.0
2012-07-30	ACAT-DELISTED	Stock	44.69	45.69	43.45	43.57	171319.0

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

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