PREVIEW / etf_daily / 2012-10-16

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-16.parquet
  size:    39 KB
  rows:    940

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-16	SPY	ETF	144.76	145.64	144.66	145.54	108815500.0
2012-10-16	QQQ	ETF	67.29	68.2	67.25	68.12	33960299.0
2012-10-16	IWM	ETF	83.08	83.36	82.88	83.25	29234800.0
2012-10-16	DIA	ETF	134.65	135.36	134.57	135.3	5454400.0
2012-10-16	GLD	ETF	168.87	169.45	168.67	169.42	6204000.0
2012-10-16	TLT	ETF	122.9	122.94	121.94	121.98	5398700.0
2012-10-16	AAXJ	ETF	56.76	57.07	56.67	57.01	285900.0
2012-10-16	ACTV	ETF	10.67	10.67	10.27	10.34	683045.0
2012-10-16	ACWI	ETF	47.38	47.54	47.25	47.51	622400.0
2012-10-16	ACWV	ETF	57.08	57.12	56.96	57.12	6500.0
2012-10-16	ACWX	ETF	39.95	40.2499	39.95	40.18	317511.0
2012-10-16	ADRE	ETF	39.48	39.7398	39.48	39.62	26196.0
2012-10-16	AFK	ETF	31.37	31.72	31.34	31.654	50520.0
2012-10-16	AGEM	ETF	22.77	22.84	22.61	22.75	3026.0
2012-10-16	AGG	ETF	112.31	112.36	112.17	112.2	978500.0
2012-10-16	AGQ	ETF	211.04	212.92	209.4	211.72	255300.0
2012-10-16	AGZ	ETF	113.88	113.8934	113.7617	113.84	15309.0
2012-10-16	AIA	ETF	44.89	45.18	44.8648	45.112	9940.0
2012-10-16	AIQ	ETF	7.0	7.0	6.9	6.9	643.0
2012-10-16	AIVI	ETF	40.66	40.97	40.66	40.97	12700.0
2012-10-16	AMJ	ETF	40.82	41.2	40.81	41.15	441051.0
2012-10-16	AMLP	ETF	83.65	84.0	83.5	83.95	338800.0
2012-10-16	ANGL	ETF	26.91	26.92	26.74	26.85	1800.0
2012-10-16	AOA	ETF	36.91	37.08	36.85	37.08	12600.0
2012-10-16	AOK	ETF	30.6	30.62	30.56	30.57	8438.0
2012-10-16	AOM	ETF	31.7399	31.7783	31.7021	31.76	17104.0
2012-10-16	AOR	ETF	33.8	33.9583	33.8	33.95	12494.0
2012-10-16	ARB	ETF	38.53	38.62	37.95	38.01	65066.0
2012-10-16	ARGT	ETF	17.66	17.86	17.66	17.84	1150.0
2012-10-16	ASEA	ETF	16.82	16.95	16.82	16.93	9700.0
2012-10-16	AWAY	ETF	26.75	26.75	25.84	26.5	295141.0
2012-10-16	BAB	ETF	30.02	30.02	29.75	29.77	768818.0
2012-10-16	BAL	ETF	48.9	49.5508	48.7	49.27	20403.0
2012-10-16	BALT	ETF	3.3	3.32	3.25	3.28	51976.0
2012-10-16	BBH	ETF	54.45	55.0	54.3	55.0	24700.0
2012-10-16	BCM	ETF	45.55	45.55	45.4583	45.46	1133.0
2012-10-16	BIB	ETF	16.0125	16.1197	15.8575	16.1197	49360.0
2012-10-16	BICK	ETF	23.8	23.98	23.8	23.96	3213.0
2012-10-16	BIL	ETF	91.62	91.64	91.62	91.62	134800.0
2012-10-16	BIS	ETF	2559.2	2559.2	2485.6	2485.6	32.5
2012-10-16	BIV	ETF	90.3	90.3	90.16	90.19	148500.0
2012-10-16	BJK	ETF	34.42	34.42	34.36	34.36	1200.0
2012-10-16	BKF	ETF	38.67	38.85	38.6	38.72	145290.0
2012-10-16	BKLN	ETF	24.93	24.94	24.92	24.93	659100.0
2012-10-16	BLV	ETF	96.65	96.65	96.24	96.26	39200.0
2012-10-16	BMVP	ETF	16.0922	16.1733	16.0922	16.1533	3562.0
2012-10-16	BND	ETF	84.94	84.94	84.8	84.8	1308000.0
2012-10-16	BNO	ETF	41.375	41.525	41.32	41.38	64800.0
2012-10-16	BOIL	ETF	1099600.0	1103800.0	1079800.0	1101800.0	6.4
2012-10-16	BOND	ETF	109.26	109.29	109.14	109.16	596045.0

> showing 50 of 940 rows — these rows as CSV

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