PREVIEW / etf_daily / 2012-10-19

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-19.parquet
  size:    39 KB
  rows:    943

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-10-19	SPY	ETF	145.55	145.56	143.05	143.39	185645200.0
2012-10-19	QQQ	ETF	67.21	67.27	65.6	65.68	75362599.0
2012-10-19	IWM	ETF	82.85	82.88	81.47	81.85	53565500.0
2012-10-19	DIA	ETF	134.8	134.8	132.81	133.11	10437500.0
2012-10-19	GLD	ETF	168.42	168.45	166.23	166.97	13860400.0
2012-10-19	TLT	ETF	120.34	121.81	120.28	121.74	7616700.0
2012-10-19	AADR	ETF	29.95	29.95	29.95	29.95	200.0
2012-10-19	AAXJ	ETF	56.69	56.77	56.13	56.19	198000.0
2012-10-19	ACTV	ETF	10.04	10.12	9.88	9.95	535645.0
2012-10-19	ACWI	ETF	47.6	47.62	46.94	47.02	264400.0
2012-10-19	ACWV	ETF	57.1	57.1	56.4	56.4	9400.0
2012-10-19	ACWX	ETF	40.28	40.28	39.85	39.92	62624.0
2012-10-19	ADRE	ETF	39.67	39.67	39.26	39.35	55333.0
2012-10-19	AFK	ETF	31.78	31.78	31.4109	31.53	75459.0
2012-10-19	AGEM	ETF	22.57	22.63	22.57	22.63	647.0
2012-10-19	AGG	ETF	111.79	112.03	111.79	111.95	683700.0
2012-10-19	AGQ	ETF	206.48	206.84	198.68	200.56	426300.0
2012-10-19	AGZ	ETF	113.8	113.8	113.658	113.6601	20259.0
2012-10-19	AIA	ETF	44.77	44.77	44.29	44.34	22945.0
2012-10-19	AIQ	ETF	6.85	7.0	6.85	6.95	8344.0
2012-10-19	AIVI	ETF	41.24	41.24	40.7	40.81	13800.0
2012-10-19	AMJ	ETF	41.01	41.22	40.61	40.68	370553.0
2012-10-19	AMLP	ETF	83.95	84.25	83.05	83.2	401060.0
2012-10-19	ANGL	ETF	27.0	27.0	26.85	26.9	1800.0
2012-10-19	AOA	ETF	36.97	36.98	36.65	36.7	5000.0
2012-10-19	AOK	ETF	30.58	30.58	30.4501	30.46	23711.0
2012-10-19	AOM	ETF	31.69	31.71	31.5401	31.58	18428.0
2012-10-19	AOR	ETF	33.82	33.82	33.6448	33.68	12521.0
2012-10-19	ARB	ETF	37.23	37.345	36.44	36.61	116365.0
2012-10-19	ARGT	ETF	17.66	17.66	17.66	17.66	800.0
2012-10-19	ASEA	ETF	16.94	16.94	16.71	16.71	9900.0
2012-10-19	AWAY	ETF	26.05	26.05	24.97	25.34	345212.0
2012-10-19	BAB	ETF	29.61	29.83	29.61	29.82	204223.0
2012-10-19	BAL	ETF	51.1386	51.35	50.57	50.57	9669.0
2012-10-19	BALT	ETF	3.35	3.4	3.295	3.4	36478.0
2012-10-19	BBH	ETF	54.97	54.97	53.0	53.11	62800.0
2012-10-19	BCM	ETF	45.72	45.72	45.2083	45.21	4756.0
2012-10-19	BIB	ETF	16.0575	16.0575	15.0	15.1425	92136.0
2012-10-19	BICK	ETF	23.9	23.9399	23.85	23.85	2644.0
2012-10-19	BIL	ETF	91.64	91.64	91.62	91.62	199500.0
2012-10-19	BIS	ETF	2510.4	2652.72	2510.4	2652.72	98.0
2012-10-19	BIV	ETF	89.86	90.09	89.83	90.02	166500.0
2012-10-19	BJK	ETF	34.49	34.49	34.21	34.25	800.0
2012-10-19	BKF	ETF	39.01	39.03	38.55	38.58	121049.0
2012-10-19	BKLN	ETF	24.94	24.94	24.9	24.93	2245100.0
2012-10-19	BLV	ETF	95.25	96.25	95.25	96.1	38400.0
2012-10-19	BMVP	ETF	16.19	16.19	15.95	15.97	5326.0
2012-10-19	BND	ETF	84.52	84.74	84.52	84.68	1120200.0
2012-10-19	BNO	ETF	41.015	41.02	40.0	40.03	106800.0
2012-10-19	BOIL	ETF	1184800.0	1210000.0	1178400.0	1185000.0	14.6

> showing 50 of 943 rows — these rows as CSV

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