PREVIEW / etf_daily / 2012-09-06

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-06.parquet
  size:    39 KB
  rows:    945

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-06	SPY	ETF	141.76	143.78	141.75	143.77	158272500.0
2012-09-06	QQQ	ETF	68.42	69.55	68.42	69.53	43099507.0
2012-09-06	IWM	ETF	82.58	83.94	82.52	83.64	46332500.0
2012-09-06	DIA	ETF	131.16	132.83	131.16	132.82	5559400.0
2012-09-06	GLD	ETF	165.16	165.78	164.8	164.89	12961100.0
2012-09-06	TLT	ETF	125.53	125.53	124.55	124.61	6505100.0
2012-09-06	AADR	ETF	29.55	29.55	29.55	29.55	100.0
2012-09-06	AAXJ	ETF	52.54	53.36	52.5	53.27	269700.0
2012-09-06	ACTV	ETF	12.0	12.36	12.0	12.34	372581.0
2012-09-06	ACWI	ETF	45.51	46.28	45.51	46.26	415600.0
2012-09-06	ACWV	ETF	56.22	56.36	56.17	56.33	227300.0
2012-09-06	ACWX	ETF	38.07	38.72	38.04	38.65	76449.0
2012-09-06	ADRE	ETF	37.54	38.21	37.54	38.17	45095.0
2012-09-06	AFK	ETF	29.96	30.59	29.96	30.59	14124.0
2012-09-06	AGEM	ETF	21.29	21.5035	21.29	21.5035	436.0
2012-09-06	AGG	ETF	111.89	111.89	111.76	111.87	1805200.0
2012-09-06	AGQ	ETF	211.04	215.0	208.8	211.4	491200.0
2012-09-06	AGZ	ETF	113.79	113.7909	113.5501	113.64	16722.0
2012-09-06	AIA	ETF	41.24	42.01	41.24	41.97	36259.0
2012-09-06	AIQ	ETF	6.6	6.85	6.5	6.8	5346.0
2012-09-06	AIVI	ETF	39.45	40.23	39.45	40.21	34000.0
2012-09-06	ALTL	ETF	25.3	25.3	25.3	25.3	2000.0
2012-09-06	AMJ	ETF	39.78	39.78	39.51	39.62	422768.0
2012-09-06	AMLP	ETF	81.85	81.95	81.55	81.75	487260.0
2012-09-06	ANGL	ETF	26.45	26.45	26.22	26.25	600.0
2012-09-06	AOA	ETF	36.25	36.61	36.25	36.61	12000.0
2012-09-06	AOK	ETF	30.27	30.37	30.27	30.34	18098.0
2012-09-06	AOM	ETF	31.33	31.51	31.33	31.47	34499.0
2012-09-06	AOR	ETF	33.39	33.64	33.39	33.61	17839.0
2012-09-06	ARB	ETF	36.8	37.985	36.8	37.86	106766.0
2012-09-06	ARGT	ETF	16.98	17.28	16.98	17.08	2100.0
2012-09-06	ASEA	ETF	16.17	16.33	16.17	16.31	10400.0
2012-09-06	AWAY	ETF	22.88	23.5	22.88	23.36	249477.0
2012-09-06	BAB	ETF	30.44	30.44	30.02	30.11	599817.0
2012-09-06	BAL	ETF	49.85	50.36	49.42	50.25	43159.0
2012-09-06	BALT	ETF	3.05	3.19	3.03	3.16	64733.0
2012-09-06	BBH	ETF	52.08	52.98	52.08	52.88	35300.0
2012-09-06	BCM	ETF	46.27	46.27	46.14	46.14	3000.0
2012-09-06	BIB	ETF	14.995	15.4238	14.995	15.3987	79400.0
2012-09-06	BICK	ETF	22.16	22.5199	22.16	22.478	20377.0
2012-09-06	BIL	ETF	91.62	91.64	91.62	91.64	133550.0
2012-09-06	BIS	ETF	2707.2	2707.2	2620.8	2620.8	35.3
2012-09-06	BIV	ETF	89.61	89.61	89.42	89.46	275600.0
2012-09-06	BJK	ETF	31.86	32.37	31.82	32.35	3300.0
2012-09-06	BKF	ETF	35.51	36.21	35.51	36.15	189715.0
2012-09-06	BKLN	ETF	24.84	24.89	24.84	24.88	200900.0
2012-09-06	BLV	ETF	96.47	96.47	95.75	95.84	67000.0
2012-09-06	BMVP	ETF	16.08	16.21	16.08	16.21	7860.0
2012-09-06	BND	ETF	84.8	84.8	84.64	84.74	2350400.0
2012-09-06	BNO	ETF	40.98	41.34	40.6	40.6	43000.0

> showing 50 of 945 rows — these rows as CSV

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