PREVIEW / stock_daily / 2012-02-06

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-06.parquet
  size:    200 KB
  rows:    6,189
  symbols: 3,569

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-02-06	AAPL	Stock	16.3707	16.6064	16.3643	16.5704	249412800.0
2012-02-06	MSFT	Stock	30.04	30.22	29.97	30.2	28039700.0
2012-02-06	NVDA	Stock	0.3935	0.394	0.389	0.3925	278868000.0
2012-02-06	AMZN	Stock	9.314	9.328	9.146	9.157	106200000.0
2012-02-06	TSLA	Stock	2.0733	2.1267	2.07	2.12	9781500.0
2012-02-06	TLT	Stock	116.69	117.8	116.34	117.73	6182944.0
2012-02-06	ES	Stock	35.18	35.38	35.1	35.27	656400.0
2012-02-06	CL	Stock	45.635	45.885	45.475	45.62	3161200.0
2012-02-06	A	Stock	32.0029	32.1316	31.6953	31.9456	4172611.0
2012-02-06	AABA-DELISTED	Stock	15.87	15.95	15.76	15.82	11185174.0
2012-02-06	AACC-DELISTED	Stock	4.67	4.67	4.6	4.6	1791.0
2012-02-06	AACG	Stock	6.93	7.15	6.93	7.15	8100.0
2012-02-06	AAIC-DELISTED	Stock	23.62	23.8371	23.37	23.58	29505.0
2012-02-06	AAMRQ-DELISTED	Stock	0.6545	0.6585	0.631	0.6375	5642957.0
2012-02-06	AAON	Stock	6.4385	6.4711	6.2963	6.3496	114075.0
2012-02-06	AAP	Stock	76.91	76.97	76.51	76.84	359100.0
2012-02-06	AAT	Stock	23.01	23.01	22.55	22.7	104900.0
2012-02-06	AAU-DELISTED	Stock	2.49	2.54	2.49	2.53	60984.0
2012-02-06	AAUAF-DELISTED	Stock	2.52	2.57	2.52	2.53	61370.0
2012-02-06	AAV-DELISTED	Stock	3.76	3.93	3.75	3.92	254220.0
2012-02-06	AAWW-DELISTED	Stock	50.31	51.465	50.01	51.37	180522.0
2012-02-06	AAXJ	Stock	56.47	56.66	56.32	56.6	256206.0
2012-02-06	AAXN-DELISTED	Stock	4.94	4.97	4.8	4.92	188867.0
2012-02-06	AB	Stock	16.45	16.54	15.98	16.37	290300.0
2012-02-06	ABAC-DELISTED	Stock	1.56	1.64	1.55	1.64	14473.0
2012-02-06	ABAX-DELISTED	Stock	28.34	28.8	28.28	28.8	44734.0
2012-02-06	ABB-DELISTED	Stock	21.51	21.74	21.49	21.67	1312349.0
2012-02-06	ABBNY-DELISTED	Stock	21.51	21.74	21.49	21.66	1313949.0
2012-02-06	ABC-DELISTED	Stock	39.1	39.32	38.85	38.97	2539686.0
2012-02-06	ABCB	Stock	11.31	11.42	11.21	11.27	23400.0
2012-02-06	ABCD-DELISTED	Stock	3.26	3.3	3.23	3.3	13384.0
2012-02-06	ABCO-DELISTED	Stock	37.54	37.97	36.59	37.0	221528.0
2012-02-06	ABCW-DELISTED	Stock	0.3113	0.3514	0.3012	0.3213	51370.0
2012-02-06	ABD-DELISTED	Stock	10.95	11.19	10.9	11.09	219790.0
2012-02-06	ABE-DELISTED	Stock	19.35	19.4	19.05	19.26	10424.0
2012-02-06	ABEO	Stock	1762.5	1787.5	1687.5	1762.5	14.0
2012-02-06	ABFS-DELISTED	Stock	18.75	19.04	18.72	18.89	304738.0
2012-02-06	ABG	Stock	24.3	24.66	24.24	24.53	357900.0
2012-02-06	ABH-DELISTED	Stock	15.83	15.92	15.68	15.89	210351.0
2012-02-06	ABM	Stock	23.04	23.24	22.98	23.06	205300.0
2012-02-06	ABMD-DELISTED	Stock	21.28	23.23	21.04	22.76	975309.0
2012-02-06	ABR	Stock	4.3	4.49	4.25	4.43	121500.0
2012-02-06	ABT	Stock	26.2643	26.6049	26.2307	26.5761	16874531.0
2012-02-06	ABTL-DELISTED	Stock	4.5	4.75	4.5	4.6	39138.0
2012-02-06	ABUS	Stock	1.97	2.08	1.96	2.08	11300.0
2012-02-06	ABV-DELISTED	Stock	37.81	37.9	37.27	37.4	2608433.0
2012-02-06	ABVA-DELISTED	Stock	3.45	3.496	3.37	3.46	14730.0
2012-02-06	ABVT-DELISTED	Stock	68.6	68.96	67.72	67.75	88673.0
2012-02-06	ABX-DELISTED	Stock	48.5	49.61	48.43	49.18	6003280.0
2012-02-06	ACAD	Stock	1.79	1.84	1.76	1.83	545700.0

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

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