PREVIEW / stock_daily / 2012-02-21

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-21.parquet
  size:    202 KB
  rows:    6,235
  symbols: 3,586

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-21	AAPL	Stock	18.1029	18.3875	18.0043	18.3875	605595200.0
2012-02-21	MSFT	Stock	31.18	31.61	31.15	31.44	50829900.0
2012-02-21	NVDA	Stock	0.396	0.408	0.3953	0.3982	518176000.0
2012-02-21	AMZN	Stock	9.1325	9.2375	9.029	9.113	135130000.0
2012-02-21	TSLA	Stock	2.3247	2.3247	2.254	2.3	17037000.0
2012-02-21	TLT	Stock	115.77	115.92	114.95	115.29	8341017.0
2012-02-21	ES	Stock	36.23	36.25	35.94	35.99	1411000.0
2012-02-21	CL	Stock	46.785	46.905	46.47	46.685	3421600.0
2012-02-21	A	Stock	30.9514	31.03	30.3433	30.4793	3963889.0
2012-02-21	AABA-DELISTED	Stock	15.035	15.07	14.75	14.76	26579827.0
2012-02-21	AACC-DELISTED	Stock	4.53	4.68	4.42	4.49	20534.0
2012-02-21	AACG	Stock	7.0	7.0	7.0	7.0	400.0
2012-02-21	AAIC-DELISTED	Stock	24.0	24.0	23.48	23.64	34471.0
2012-02-21	AAME	Stock	2.3	2.47	2.29	2.47	18500.0
2012-02-21	AAMRQ-DELISTED	Stock	0.55	0.558	0.525	0.5317	3154067.0
2012-02-21	AAON	Stock	5.7126	5.7422	5.5793	5.5852	98888.0
2012-02-21	AAP	Stock	84.76	86.23	84.49	85.39	1631400.0
2012-02-21	AAT	Stock	22.45	22.68	22.09	22.61	125800.0
2012-02-21	AAU-DELISTED	Stock	2.72	2.86	2.7101	2.73	208187.0
2012-02-21	AAUAF-DELISTED	Stock	2.75	2.86	2.7101	2.73	208287.0
2012-02-21	AAV-DELISTED	Stock	4.09	4.17	4.0	4.05	644726.0
2012-02-21	AAWW-DELISTED	Stock	46.18	46.18	44.9	45.29	587335.0
2012-02-21	AAXJ	Stock	57.79	57.98	57.49	57.67	199970.0
2012-02-21	AAXN-DELISTED	Stock	4.54	4.6	4.42	4.43	311185.0
2012-02-21	AB	Stock	13.58	13.63	13.15	13.32	668000.0
2012-02-21	ABAC-DELISTED	Stock	1.7	1.7	1.6	1.6	16962.0
2012-02-21	ABAX-DELISTED	Stock	26.23	26.35	25.89	26.19	103018.0
2012-02-21	ABB-DELISTED	Stock	20.87	20.98	20.74	20.84	3575239.0
2012-02-21	ABBNY-DELISTED	Stock	20.87	20.98	20.74	20.83	3582209.0
2012-02-21	ABC-DELISTED	Stock	36.7	36.76	36.11	36.21	3046972.0
2012-02-21	ABCB	Stock	11.24	11.41	11.12	11.17	35800.0
2012-02-21	ABCD-DELISTED	Stock	3.05	3.05	2.96	3.01	12404.0
2012-02-21	ABCO-DELISTED	Stock	38.2	38.75	38.01	38.43	188196.0
2012-02-21	ABCW-DELISTED	Stock	0.4016	0.4016	0.3213	0.3313	22410.0
2012-02-21	ABD-DELISTED	Stock	12.095	12.195	12.011	12.105	347510.0
2012-02-21	ABE-DELISTED	Stock	18.78	18.89	18.71	18.77	81137.0
2012-02-21	ABEO	Stock	1712.5	1712.5	1625.0	1650.0	29.0
2012-02-21	ABFS-DELISTED	Stock	19.25	19.44	18.5	18.78	188573.0
2012-02-21	ABG	Stock	26.09	26.09	24.74	25.12	416900.0
2012-02-21	ABH-DELISTED	Stock	15.5	15.51	15.39	15.4995	239507.0
2012-02-21	ABM	Stock	22.65	22.87	22.59	22.7	212200.0
2012-02-21	ABMD-DELISTED	Stock	22.5	22.51	21.25	21.65	907962.0
2012-02-21	ABR	Stock	4.72	4.75	4.58	4.68	27700.0
2012-02-21	ABT	Stock	27.0511	27.0607	26.8928	26.9456	14088995.0
2012-02-21	ABTL-DELISTED	Stock	5.512	5.512	5.2	5.2	38162.0
2012-02-21	ABUS	Stock	2.31	2.33	2.31	2.32	1900.0
2012-02-21	ABV-DELISTED	Stock	38.89	38.99	37.83	38.05	1552295.0
2012-02-21	ABVA-DELISTED	Stock	3.56	3.65	3.55	3.55	8600.0
2012-02-21	ABVT-DELISTED	Stock	70.27	71.05	70.2	70.3	90165.0
2012-02-21	ABX-DELISTED	Stock	47.81	48.54	47.53	48.46	6177325.0

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

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