PREVIEW / stock_daily / 2012-02-22

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-22.parquet
  size:    200 KB
  rows:    6,184
  symbols: 3,560

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-22	AAPL	Stock	18.3243	18.4104	18.1811	18.3229	483302400.0
2012-02-22	MSFT	Stock	31.45	31.68	31.18	31.27	49253200.0
2012-02-22	NVDA	Stock	0.3962	0.406	0.395	0.3955	492432000.0
2012-02-22	AMZN	Stock	9.0975	9.1495	9.0145	9.029	115708000.0
2012-02-22	TSLA	Stock	2.3	2.3147	2.1667	2.2813	24819000.0
2012-02-22	TLT	Stock	115.89	116.76	115.81	116.742	7736910.0
2012-02-22	ES	Stock	36.06	36.33	35.72	35.94	1366700.0
2012-02-22	CL	Stock	46.54	46.74	46.205	46.57	2930400.0
2012-02-22	A	Stock	30.4363	30.9657	30.2861	30.5579	3457254.0
2012-02-22	AABA-DELISTED	Stock	14.7	14.75	14.43	14.49	25217013.0
2012-02-22	AACC-DELISTED	Stock	4.34	4.47	4.3	4.41	4423.0
2012-02-22	AACG	Stock	7.0	7.15	6.93	7.15	3200.0
2012-02-22	AAIC-DELISTED	Stock	23.6	23.858	23.47	23.47	22518.0
2012-02-22	AAME	Stock	2.5	2.5	2.3	2.35	21300.0
2012-02-22	AAMRQ-DELISTED	Stock	0.525	0.54	0.51	0.514	2803317.0
2012-02-22	AAON	Stock	5.5911	5.6326	5.5081	5.6296	145800.0
2012-02-22	AAP	Stock	85.35	86.0	85.0	85.08	1295500.0
2012-02-22	AAT	Stock	22.47	22.56	22.3	22.39	164500.0
2012-02-22	AAU-DELISTED	Stock	2.73	2.93	2.72	2.86	279686.0
2012-02-22	AAUAF-DELISTED	Stock	2.73	2.93	2.72	2.86	279886.0
2012-02-22	AAV-DELISTED	Stock	4.05	4.0898	4.0	4.04	394764.0
2012-02-22	AAWW-DELISTED	Stock	45.02	45.39	44.52	45.05	532621.0
2012-02-22	AAXJ	Stock	57.8	57.81	57.52	57.78	148193.0
2012-02-22	AAXN-DELISTED	Stock	4.48	4.56	4.42	4.5	500812.0
2012-02-22	AB	Stock	13.28	13.33	13.01	13.26	684600.0
2012-02-22	ABAC-DELISTED	Stock	1.62	1.65	1.58	1.6	8687.0
2012-02-22	ABAX-DELISTED	Stock	26.12	26.4	26.02	26.14	53503.0
2012-02-22	ABB-DELISTED	Stock	20.63	20.81	20.5	20.75	2713008.0
2012-02-22	ABBNY-DELISTED	Stock	20.63	20.81	20.5	20.76	2712345.0
2012-02-22	ABC-DELISTED	Stock	36.21	36.84	36.21	36.79	4171884.0
2012-02-22	ABCB	Stock	11.15	11.3	10.97	11.01	26200.0
2012-02-22	ABCD-DELISTED	Stock	3.0	3.03	2.93	2.96	30348.0
2012-02-22	ABCO-DELISTED	Stock	38.37	38.37	37.95	38.16	136092.0
2012-02-22	ABD-DELISTED	Stock	12.065	12.155	11.975	12.065	366980.0
2012-02-22	ABE-DELISTED	Stock	18.7	18.74	18.66	18.7	74548.0
2012-02-22	ABEO	Stock	1600.0	1650.0	1575.0	1600.0	15.0
2012-02-22	ABFS-DELISTED	Stock	18.75	18.86	18.4	18.52	186194.0
2012-02-22	ABG	Stock	25.0	25.36	24.59	25.25	309700.0
2012-02-22	ABH-DELISTED	Stock	15.52	15.52	15.41	15.47	305008.0
2012-02-22	ABM	Stock	22.68	22.94	22.61	22.66	179700.0
2012-02-22	ABMD-DELISTED	Stock	21.5	21.64	21.0	21.32	433490.0
2012-02-22	ABR	Stock	4.72	4.72	4.56	4.69	52800.0
2012-02-22	ABT	Stock	26.9072	27.0559	26.8544	26.9792	12921634.0
2012-02-22	ABTL-DELISTED	Stock	5.15	5.15	4.95	5.15	44921.0
2012-02-22	ABUS	Stock	2.33	2.45	2.33	2.45	500.0
2012-02-22	ABV-DELISTED	Stock	38.28	38.73	37.72	38.58	3545053.0
2012-02-22	ABVA-DELISTED	Stock	3.54	3.55	3.53	3.55	4400.0
2012-02-22	ABVT-DELISTED	Stock	70.39	70.99	69.765	70.0	57358.0
2012-02-22	ABX-DELISTED	Stock	48.4	49.65	47.91	49.49	8176125.0
2012-02-22	ACAD	Stock	1.72	1.75	1.6	1.65	1198100.0

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

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