PREVIEW / etf_daily / 2012-10-15

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-15.parquet
  size:    38 KB
  rows:    934

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-15	SPY	ETF	143.23	144.23	142.77	144.08	107689100.0
2012-10-15	QQQ	ETF	66.94	67.26	66.53	67.17	22220004.0
2012-10-15	IWM	ETF	82.34	82.64	81.76	82.64	34413700.0
2012-10-15	DIA	ETF	133.34	134.19	133.06	134.02	2641800.0
2012-10-15	GLD	ETF	169.01	169.1	167.53	168.35	10704900.0
2012-10-15	TLT	ETF	123.78	124.14	123.43	123.69	3036100.0
2012-10-15	AAXJ	ETF	56.3	56.55	56.08	56.48	83800.0
2012-10-15	ACTV	ETF	10.81	10.81	10.54	10.62	261660.0
2012-10-15	ACWI	ETF	46.83	46.98	46.63	46.94	1142000.0
2012-10-15	ACWV	ETF	56.48	56.62	56.27	56.57	2900.0
2012-10-15	ACWX	ETF	39.52	39.67	39.36	39.62	951102.0
2012-10-15	ADRE	ETF	39.12	39.3283	38.99	39.29	21365.0
2012-10-15	AFK	ETF	31.47	31.47	31.2618	31.47	28953.0
2012-10-15	AGEM	ETF	22.45	22.61	22.45	22.54	2359.0
2012-10-15	AGG	ETF	112.3	112.38	112.25	112.38	1646300.0
2012-10-15	AGQ	ETF	214.56	214.56	206.52	208.16	469275.0
2012-10-15	AGZ	ETF	113.9224	113.96	113.84	113.94	15297.0
2012-10-15	AIA	ETF	44.59	44.72	44.4782	44.719	13730.0
2012-10-15	AIQ	ETF	7.2	7.2	6.85	6.85	3386.0
2012-10-15	AIVI	ETF	40.21	40.34	40.0	40.3	21300.0
2012-10-15	AMJ	ETF	40.6	40.85	40.6	40.79	253521.0
2012-10-15	AMLP	ETF	83.5	83.5	83.15	83.5	233860.0
2012-10-15	ANGL	ETF	26.69	26.69	26.66	26.66	400.0
2012-10-15	AOA	ETF	36.59	36.72	36.52	36.72	11000.0
2012-10-15	AOK	ETF	30.4501	30.54	30.4501	30.54	22346.0
2012-10-15	AOM	ETF	31.53	31.62	31.5	31.62	23548.0
2012-10-15	AOR	ETF	33.74	33.74	33.5935	33.74	30751.0
2012-10-15	ARB	ETF	38.05	38.41	37.78	38.35	43796.0
2012-10-15	ARGT	ETF	17.56	17.56	17.32	17.42	350.0
2012-10-15	ASEA	ETF	16.8	16.81	16.71	16.81	4300.0
2012-10-15	AWAY	ETF	27.11	27.11	26.23	26.6	215411.0
2012-10-15	BAB	ETF	30.02	30.08	29.95	30.04	250977.0
2012-10-15	BAL	ETF	47.07	47.77	46.8604	47.61	15466.0
2012-10-15	BALT	ETF	3.28	3.3	3.15	3.27	49878.0
2012-10-15	BBH	ETF	54.04	54.37	53.68	54.15	24100.0
2012-10-15	BCM	ETF	45.4	45.43	45.4	45.43	1435.0
2012-10-15	BIB	ETF	15.5025	15.77	15.4525	15.7375	49348.0
2012-10-15	BICK	ETF	23.7	23.81	23.689	23.8	6097.0
2012-10-15	BIL	ETF	91.62	91.64	91.62	91.64	131800.0
2012-10-15	BIS	ETF	2560.0	2560.0	2551.6	2551.6	17.5
2012-10-15	BIV	ETF	90.37	90.43	90.27	90.42	312200.0
2012-10-15	BJK	ETF	33.63	33.92	33.63	33.84	2600.0
2012-10-15	BKF	ETF	38.34	38.53	38.12	38.52	62168.0
2012-10-15	BKLN	ETF	24.94	24.94	24.9	24.91	777100.0
2012-10-15	BLV	ETF	97.03	97.21	96.78	97.06	72100.0
2012-10-15	BMVP	ETF	15.87	16.0	15.86	16.0	7413.0
2012-10-15	BND	ETF	84.98	85.01	84.94	84.97	803000.0
2012-10-15	BNO	ETF	41.3	41.595	40.93	41.56	37200.0
2012-10-15	BOIL	ETF	1097600.0	1113600.0	1076200.0	1099800.0	17.2
2012-10-15	BOND	ETF	109.32	109.34	109.22	109.31	446372.0

> showing 50 of 934 rows — these rows as CSV

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