PREVIEW / stock_daily / 2012-05-09

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-09.parquet
  size:    197 KB
  rows:    6,166
  symbols: 3,541

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-05-09	AAPL	Stock	20.1321	20.4993	20.0304	20.3279	480704000.0
2012-05-09	MSFT	Stock	30.19	30.83	30.1	30.76	50309300.0
2012-05-09	NVDA	Stock	0.306	0.3153	0.303	0.3128	520608000.0
2012-05-09	AMZN	Stock	11.0295	11.289	11.008	11.149	74240000.0
2012-05-09	TSLA	Stock	2.02	2.0513	1.984	2.004	29218500.0
2012-05-09	TLT	Stock	119.45	119.57	118.44	118.87	5828828.0
2012-05-09	ES	Stock	36.04	36.37	35.95	36.18	1535000.0
2012-05-09	CL	Stock	49.29	49.835	49.29	49.54	3820200.0
2012-05-09	A	Stock	28.3691	28.8841	28.2546	28.5622	6024961.0
2012-05-09	AABA-DELISTED	Stock	15.18	15.45	15.03	15.31	16336251.0
2012-05-09	AACC-DELISTED	Stock	5.61	5.9	5.6	5.73	28748.0
2012-05-09	AAIC-DELISTED	Stock	23.05	23.27	23.0	23.18	53561.0
2012-05-09	AAME	Stock	2.88	2.9	2.88	2.9	1700.0
2012-05-09	AAMRQ-DELISTED	Stock	0.525	0.535	0.502	0.508	1890783.0
2012-05-09	AAON	Stock	5.6533	5.76	5.6267	5.7096	300375.0
2012-05-09	AAP	Stock	88.37	89.29	87.67	88.61	720300.0
2012-05-09	AAT	Stock	23.8	24.27	23.78	23.87	115700.0
2012-05-09	AAU-DELISTED	Stock	1.98	2.09	1.93	2.02	256960.0
2012-05-09	AAUAF-DELISTED	Stock	1.98	2.09	1.93	2.04	257760.0
2012-05-09	AAV-DELISTED	Stock	3.11	3.28	3.06	3.25	261001.0
2012-05-09	AAWW-DELISTED	Stock	50.04	50.55	48.84	49.28	540014.0
2012-05-09	AAXJ	Stock	53.98	54.44	53.67	54.14	698848.0
2012-05-09	AAXN-DELISTED	Stock	4.96	5.06	4.76	5.04	538996.0
2012-05-09	AB	Stock	13.94	14.35	13.89	14.23	129800.0
2012-05-09	ABAC-DELISTED	Stock	1.65	1.73	1.64	1.64	11300.0
2012-05-09	ABAX-DELISTED	Stock	34.6	34.96	34.37	34.68	69793.0
2012-05-09	ABB-DELISTED	Stock	17.03	17.3198	16.99	17.22	3205504.0
2012-05-09	ABBNY-DELISTED	Stock	17.03	17.3198	16.99	17.2	3205309.0
2012-05-09	ABC-DELISTED	Stock	35.92	36.25	35.59	36.0	2477830.0
2012-05-09	ABCB	Stock	12.06	12.48	12.0	12.27	57000.0
2012-05-09	ABCD-DELISTED	Stock	2.03	2.04	1.9	1.95	27940.0
2012-05-09	ABCO-DELISTED	Stock	45.98	46.61	45.48	46.03	323607.0
2012-05-09	ABCW-DELISTED	Stock	0.5522	0.7028	0.5522	0.5623	2370.0
2012-05-09	ABE-DELISTED	Stock	19.0	19.12	19.0	19.11	6109.0
2012-05-09	ABEO	Stock	1150.0	1150.0	1075.0	1125.0	8.0
2012-05-09	ABFS-DELISTED	Stock	14.15	14.82	13.89	13.9	498661.0
2012-05-09	ABG	Stock	25.38	26.22	25.08	26.02	549300.0
2012-05-09	ABH-DELISTED	Stock	11.95	11.99	11.48	11.54	594043.0
2012-05-09	ABM	Stock	22.32	22.66	22.25	22.55	147000.0
2012-05-09	ABMD-DELISTED	Stock	22.79	23.71	22.748	23.52	359285.0
2012-05-09	ABR	Stock	6.22	6.27	6.05	6.18	63000.0
2012-05-09	ABT	Stock	29.786	29.8292	29.3446	29.3782	25997707.0
2012-05-09	ABTL-DELISTED	Stock	4.1409	4.1763	3.9389	4.1	4862.0
2012-05-09	ABUS	Stock	2.27	2.3	2.25	2.3	2000.0
2012-05-09	ABV-DELISTED	Stock	39.92	40.36	39.29	39.86	3282023.0
2012-05-09	ABVA-DELISTED	Stock	4.49	4.7299	4.49	4.52	17521.0
2012-05-09	ABVT-DELISTED	Stock	83.17	83.225	83.16	83.19	338884.0
2012-05-09	ABX-DELISTED	Stock	36.05	38.3	35.61	37.63	12477857.0
2012-05-09	ACAD	Stock	1.5	1.54	1.45	1.5	172300.0
2012-05-09	ACAS-DELISTED	Stock	9.53	9.75	9.36	9.67	3463291.0

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

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