PREVIEW / stock_daily / 2012-02-07

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-07.parquet
  size:    199 KB
  rows:    6,185
  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
2012-02-07	AAPL	Stock	16.6161	16.7768	16.5921	16.7439	316223600.0
2012-02-07	MSFT	Stock	30.15	30.49	30.05	30.35	39242400.0
2012-02-07	NVDA	Stock	0.393	0.3958	0.3865	0.3935	410296000.0
2012-02-07	AMZN	Stock	9.1325	9.247	9.103	9.2095	102078000.0
2012-02-07	TSLA	Stock	2.12	2.12	2.0547	2.1067	15324000.0
2012-02-07	TLT	Stock	116.62	116.88	115.77	116.27	8803036.0
2012-02-07	ES	Stock	35.15	35.62	34.96	35.49	889800.0
2012-02-07	CL	Stock	45.515	45.89	45.505	45.77	2961200.0
2012-02-07	A	Stock	32.0172	32.103	31.6309	31.9027	3561265.0
2012-02-07	AABA-DELISTED	Stock	15.85	15.89	15.735	15.83	13471274.0
2012-02-07	AACC-DELISTED	Stock	4.66	4.74	4.55	4.58	16981.0
2012-02-07	AAIC-DELISTED	Stock	23.46	23.65	23.32	23.5	31061.0
2012-02-07	AAME	Stock	2.05	2.05	2.05	2.05	200.0
2012-02-07	AAMRQ-DELISTED	Stock	0.6205	0.699	0.6205	0.65	8961110.0
2012-02-07	AAON	Stock	6.3496	6.3585	6.2015	6.2104	162675.0
2012-02-07	AAP	Stock	76.56	77.35	76.56	77.23	1009300.0
2012-02-07	AAT	Stock	22.71	23.11	22.63	22.81	95500.0
2012-02-07	AAU-DELISTED	Stock	2.56	2.6798	2.51	2.62	191213.0
2012-02-07	AAUAF-DELISTED	Stock	2.56	2.6798	2.51	2.61	192313.0
2012-02-07	AAV-DELISTED	Stock	3.94	3.94	3.75	3.76	319383.0
2012-02-07	AAWW-DELISTED	Stock	51.31	52.44	50.45	52.13	373845.0
2012-02-07	AAXJ	Stock	56.39	56.65	56.06	56.54	288778.0
2012-02-07	AAXN-DELISTED	Stock	4.89	4.95	4.8	4.81	179920.0
2012-02-07	AB	Stock	16.25	16.42	16.11	16.35	282400.0
2012-02-07	ABAC-DELISTED	Stock	1.6	1.6	1.55	1.55	15392.0
2012-02-07	ABAX-DELISTED	Stock	28.67	29.0091	28.36	28.88	63177.0
2012-02-07	ABB-DELISTED	Stock	21.36	21.6	21.26	21.53	1748624.0
2012-02-07	ABBNY-DELISTED	Stock	21.36	21.6	21.26	21.53	1749724.0
2012-02-07	ABC-DELISTED	Stock	38.85	38.97	38.46	38.86	1957950.0
2012-02-07	ABCB	Stock	11.18	11.3	11.04	11.14	41400.0
2012-02-07	ABCD-DELISTED	Stock	3.25	3.29	3.19	3.1925	29186.0
2012-02-07	ABCO-DELISTED	Stock	36.84	36.88	36.33	36.53	286947.0
2012-02-07	ABCW-DELISTED	Stock	0.3514	0.502	0.3514	0.3715	29890.0
2012-02-07	ABD-DELISTED	Stock	11.08	11.2	10.95	11.16	292020.0
2012-02-07	ABE-DELISTED	Stock	19.15	19.34	19.15	19.34	4001.0
2012-02-07	ABEO	Stock	1687.5	1750.0	1687.5	1750.0	25.0
2012-02-07	ABFS-DELISTED	Stock	18.79	18.9	18.66	18.7	209876.0
2012-02-07	ABG	Stock	24.57	24.8	24.43	24.6	317500.0
2012-02-07	ABH-DELISTED	Stock	15.87	16.07	15.75	15.97	255016.0
2012-02-07	ABM	Stock	22.96	23.25	22.75	22.78	135600.0
2012-02-07	ABMD-DELISTED	Stock	22.34	23.5	20.64	22.67	2416976.0
2012-02-07	ABR	Stock	4.4	4.54	4.4	4.49	68000.0
2012-02-07	ABT	Stock	26.5042	26.8016	26.4802	26.7297	12350563.0
2012-02-07	ABTL-DELISTED	Stock	4.7412	4.8149	4.65	4.65	7020.0
2012-02-07	ABUS	Stock	2.02	2.1	2.0	2.0	6900.0
2012-02-07	ABV-DELISTED	Stock	37.75	37.82	37.22	37.3	1893596.0
2012-02-07	ABVA-DELISTED	Stock	3.43	3.43	3.4	3.43	6500.0
2012-02-07	ABVT-DELISTED	Stock	67.7	70.04	67.18	69.29	173569.0
2012-02-07	ABX-DELISTED	Stock	49.24	49.97	48.49	49.25	6739868.0
2012-02-07	ACAD	Stock	1.85	1.87	1.72	1.78	335100.0

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

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