PREVIEW / etf_daily / 2012-09-28

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-28.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-09-28	SPY	ETF	144.09	144.56	143.46	143.97	150696100.0
2012-09-28	QQQ	ETF	68.92	69.12	68.51	68.57	30116097.0
2012-09-28	IWM	ETF	83.78	84.0	83.26	83.44	43944300.0
2012-09-28	DIA	ETF	133.92	134.48	133.36	134.05	4565400.0
2012-09-28	GLD	ETF	172.03	172.48	171.34	171.89	9681200.0
2012-09-28	TLT	ETF	124.75	125.24	123.81	124.22	7173400.0
2012-09-28	AAXJ	ETF	56.37	56.44	56.12	56.26	185500.0
2012-09-28	ACTV	ETF	12.62	12.82	12.53	12.53	257049.0
2012-09-28	ACWI	ETF	46.92	46.92	46.57	46.69	331400.0
2012-09-28	ACWV	ETF	56.9	56.9	56.55	56.71	149000.0
2012-09-28	ACWX	ETF	39.71	39.71	39.39	39.39	3175673.0
2012-09-28	ADRE	ETF	39.12	39.34	39.05	39.21	44415.0
2012-09-28	AFK	ETF	31.07	31.27	31.0	31.24	8573.0
2012-09-28	AGEM	ETF	22.19	22.48	22.19	22.44	1369.0
2012-09-28	AGG	ETF	112.39	112.46	112.25	112.45	2745500.0
2012-09-28	AGQ	ETF	235.04	236.44	230.12	233.4	354700.0
2012-09-28	AGZ	ETF	114.05	114.18	113.957	114.05	60246.0
2012-09-28	AIA	ETF	44.66	44.66	44.429	44.43	10536.0
2012-09-28	AIQ	ETF	7.05	7.15	6.75	7.05	3877.0
2012-09-28	AIVI	ETF	40.42	40.44	40.0	40.04	19100.0
2012-09-28	ALTL	ETF	25.88	25.88	25.88	25.88	624.0
2012-09-28	AMJ	ETF	40.3	40.47	40.05	40.4446	682924.0
2012-09-28	AMLP	ETF	82.65	82.95	82.35	82.85	364700.0
2012-09-28	ANGL	ETF	26.46	26.46	26.46	26.46	200.0
2012-09-28	AOA	ETF	36.6	36.77	36.57	36.65	10700.0
2012-09-28	AOK	ETF	30.5283	30.55	30.5	30.5316	13918.0
2012-09-28	AOM	ETF	31.61	31.61	31.5483	31.58	19896.0
2012-09-28	AOR	ETF	33.68	33.76	33.6483	33.71	23602.0
2012-09-28	ARB	ETF	37.87	38.25	37.76	37.9	98211.0
2012-09-28	ASEA	ETF	16.74	16.74	16.61	16.61	13200.0
2012-09-28	AWAY	ETF	23.14	23.45	23.1	23.4296	178868.0
2012-09-28	BAB	ETF	30.07	30.18	30.04	30.06	256674.0
2012-09-28	BAL	ETF	47.59	47.59	46.53	46.53	13456.0
2012-09-28	BALT	ETF	3.2	3.26	3.2	3.23	9345.0
2012-09-28	BBH	ETF	53.76	54.22	53.62	54.1	21300.0
2012-09-28	BCM	ETF	46.06	46.74	46.06	46.3	10929.0
2012-09-28	BIB	ETF	15.6263	15.8338	14.8875	15.7637	25816.0
2012-09-28	BICK	ETF	23.76	23.79	23.6544	23.79	3958.0
2012-09-28	BIL	ETF	91.64	91.64	91.62	91.62	165650.0
2012-09-28	BIS	ETF	2560.0	2604.544	2544.0	2545.6	30.1
2012-09-28	BIV	ETF	90.26	90.33	90.11	90.27	145300.0
2012-09-28	BJK	ETF	34.22	34.22	33.98	34.01	2800.0
2012-09-28	BKF	ETF	37.83	37.9099	37.57	37.74	62429.0
2012-09-28	BKLN	ETF	24.98	24.98	24.94	24.95	724400.0
2012-09-28	BLV	ETF	96.93	97.0	96.42	96.67	41200.0
2012-09-28	BMVP	ETF	16.09	16.123	16.054	16.123	2983.0
2012-09-28	BND	ETF	85.15	85.19	85.04	85.15	1426400.0
2012-09-28	BNO	ETF	40.635	40.665	40.315	40.505	91400.0
2012-09-28	BOIL	ETF	987000.0	1028000.0	981400.0	1021800.0	11.4
2012-09-28	BOND	ETF	108.87	108.88	108.7	108.77	848653.0

> showing 50 of 940 rows — these rows as CSV

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