PREVIEW / etf_daily / 2012-09-20

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-20.parquet
  size:    39 KB
  rows:    946

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-09-20	SPY	ETF	146.03	146.79	145.63	146.71	154009800.0
2012-09-20	QQQ	ETF	70.07	70.4	69.87	70.33	42523444.0
2012-09-20	IWM	ETF	85.14	85.4	84.61	85.19	34939800.0
2012-09-20	DIA	ETF	135.2	135.98	135.0	135.95	6949700.0
2012-09-20	GLD	ETF	171.03	171.69	170.23	171.47	8703000.0
2012-09-20	TLT	ETF	122.14	122.32	120.98	121.41	4604200.0
2012-09-20	AADR	ETF	30.01	30.15	29.99	30.15	4000.0
2012-09-20	AAXJ	ETF	55.96	56.26	55.8	56.18	182800.0
2012-09-20	ACTV	ETF	12.74	12.74	12.24	12.28	230972.0
2012-09-20	ACWI	ETF	47.38	47.62	47.2	47.58	515000.0
2012-09-20	ACWV	ETF	56.56	56.56	56.39	56.48	304200.0
2012-09-20	ACWX	ETF	40.22	40.4	40.03	40.4	56456.0
2012-09-20	ADRE	ETF	39.79	39.95	39.66	39.88	199461.0
2012-09-20	AFK	ETF	31.42	31.4499	31.21	31.32	13964.0
2012-09-20	AGEM	ETF	22.52	22.52	22.44	22.46	4700.0
2012-09-20	AGG	ETF	111.95	111.96	111.75	111.77	2518600.0
2012-09-20	AGQ	ETF	233.28	236.68	228.28	235.64	286750.0
2012-09-20	AGZ	ETF	113.71	113.94	113.71	113.75	23285.0
2012-09-20	AIA	ETF	44.38	44.5283	44.252	44.49	10379.0
2012-09-20	AIQ	ETF	7.0	7.3	6.75	7.05	27907.0
2012-09-20	AIVI	ETF	41.52	41.78	41.35	41.67	30500.0
2012-09-20	ALTL	ETF	25.99	25.99	25.99	25.99	400.0
2012-09-20	AMJ	ETF	40.18	40.3883	40.09	40.34	1449857.0
2012-09-20	AMLP	ETF	82.65	83.1	82.5	82.7	379960.0
2012-09-20	ANGL	ETF	27.0	27.0	26.7	26.74	4700.0
2012-09-20	AOA	ETF	37.17	37.29	37.08	37.26	11700.0
2012-09-20	AOK	ETF	30.59	30.62	30.57	30.62	10808.0
2012-09-20	AOM	ETF	31.85	31.8599	31.8017	31.83	22133.0
2012-09-20	AOR	ETF	34.08	34.11	34.0	34.11	10711.0
2012-09-20	ARB	ETF	37.88	38.13	37.735	38.0	90909.0
2012-09-20	ARGT	ETF	18.02	18.04	17.84	17.84	350.0
2012-09-20	ASEA	ETF	16.72	16.74	16.65	16.72	3400.0
2012-09-20	AWAY	ETF	24.78	25.148	24.65	25.1	834700.0
2012-09-20	BAB	ETF	29.87	29.91	29.78	29.84	475454.0
2012-09-20	BAL	ETF	50.2	50.23	49.55	49.55	7589.0
2012-09-20	BALT	ETF	3.46	3.48	3.351	3.43	47746.0
2012-09-20	BBH	ETF	54.11	54.32	53.92	54.32	16900.0
2012-09-20	BCM	ETF	46.1044	46.1044	46.1044	46.1044	116.0
2012-09-20	BIB	ETF	15.94	16.07	15.8151	16.0225	37312.0
2012-09-20	BICK	ETF	23.67	23.91	23.59	23.88	24503.0
2012-09-20	BIL	ETF	91.62	91.64	91.62	91.62	229500.0
2012-09-20	BIS	ETF	2534.4	2537.6	2523.2	2523.2	10.95
2012-09-20	BIV	ETF	89.79	89.82	89.52	89.63	202400.0
2012-09-20	BJK	ETF	33.91	34.14	33.91	34.14	2300.0
2012-09-20	BKF	ETF	37.9	38.0993	37.71	38.07	172983.0
2012-09-20	BKLN	ETF	25.04	25.05	25.02	25.04	930900.0
2012-09-20	BLV	ETF	95.53	95.69	94.81	94.82	109600.0
2012-09-20	BMVP	ETF	16.21	16.28	16.1977	16.2667	3496.0
2012-09-20	BND	ETF	84.75	84.76	84.58	84.63	948600.0
2012-09-20	BNO	ETF	39.255	39.915	39.22	39.91	142000.0

> showing 50 of 946 rows — these rows as CSV

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