PREVIEW / etf_daily / 2012-10-04

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-04.parquet
  size:    38 KB
  rows:    937

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-04	SPY	ETF	145.64	146.34	145.44	146.13	124311600.0
2012-10-04	QQQ	ETF	69.24	69.54	69.0	69.35	26128544.0
2012-10-04	IWM	ETF	83.96	84.26	83.2	84.21	43327200.0
2012-10-04	DIA	ETF	135.15	135.71	134.96	135.52	3911800.0
2012-10-04	GLD	ETF	173.2	174.07	172.92	173.61	10376800.0
2012-10-04	TLT	ETF	123.46	123.8	122.57	122.74	6214800.0
2012-10-04	AAXJ	ETF	57.02	57.25	56.87	57.22	268300.0
2012-10-04	ACTV	ETF	11.79	11.82	11.49	11.6	633141.0
2012-10-04	ACWI	ETF	47.3	47.48	47.18	47.45	514800.0
2012-10-04	ACWV	ETF	57.22	57.35	57.12	57.35	11400.0
2012-10-04	ACWX	ETF	39.96	40.23	39.94	40.19	64076.0
2012-10-04	ADRE	ETF	39.25	39.55	39.18	39.52	15162.0
2012-10-04	AFK	ETF	31.25	31.54	31.25	31.5	17738.0
2012-10-04	AGEM	ETF	22.4623	22.4623	22.4623	22.4623	449.0
2012-10-04	AGG	ETF	112.16	112.25	112.07	112.09	459200.0
2012-10-04	AGQ	ETF	236.68	240.72	235.4	239.44	336950.0
2012-10-04	AGZ	ETF	114.01	114.08	113.84	114.01	10590.0
2012-10-04	AIA	ETF	44.82	45.09	44.78	45.09	14521.0
2012-10-04	AIQ	ETF	7.1	7.1	6.8	6.8	12866.0
2012-10-04	AIVI	ETF	40.52	40.73	40.45	40.66	36400.0
2012-10-04	AMJ	ETF	41.13	41.21	40.96	41.145	438386.0
2012-10-04	AMLP	ETF	83.85	84.05	83.65	83.95	406560.0
2012-10-04	ANGL	ETF	26.48	26.5	26.47	26.47	1700.0
2012-10-04	AOA	ETF	36.8	37.11	36.8	37.09	26800.0
2012-10-04	AOK	ETF	30.45	30.65	30.45	30.63	169431.0
2012-10-04	AOM	ETF	31.7	31.82	31.65	31.82	61146.0
2012-10-04	AOR	ETF	33.98	33.99	33.91	33.982	24847.0
2012-10-04	ARB	ETF	37.27	37.38	36.73	37.06	129697.0
2012-10-04	ARGT	ETF	17.92	18.1	17.92	18.1	1500.0
2012-10-04	ASEA	ETF	16.87	16.97	16.87	16.94	10000.0
2012-10-04	AWAY	ETF	25.39	26.36	25.39	26.3	715353.0
2012-10-04	BAB	ETF	30.04	30.093	29.94	29.98	164947.0
2012-10-04	BAL	ETF	47.69	47.81	47.37	47.42	16643.0
2012-10-04	BALT	ETF	3.16	3.16	3.05	3.12	74467.0
2012-10-04	BBH	ETF	56.24	56.32	55.85	55.98	65400.0
2012-10-04	BCM	ETF	46.13	46.13	46.13	46.13	294.0
2012-10-04	BIB	ETF	16.8038	16.965	16.625	16.7275	134552.0
2012-10-04	BICK	ETF	24.07	24.26	24.029	24.1144	2756.0
2012-10-04	BIL	ETF	91.62	91.64	91.62	91.62	738550.0
2012-10-04	BIS	ETF	2409.6	2414.4	2400.0	2411.072	21.95
2012-10-04	BIV	ETF	90.21	90.29	90.1	90.13	191900.0
2012-10-04	BJK	ETF	33.81	33.86	33.81	33.86	2400.0
2012-10-04	BKF	ETF	38.13	38.45	38.03	38.42	35893.0
2012-10-04	BKLN	ETF	24.98	24.98	24.96	24.97	697500.0
2012-10-04	BLV	ETF	96.29	96.62	96.0	96.0	45100.0
2012-10-04	BMVP	ETF	16.3167	16.3497	16.2993	16.3333	2372.0
2012-10-04	BND	ETF	84.98	85.02	84.87	84.87	666500.0
2012-10-04	BNO	ETF	39.56	40.665	39.445	40.58	117800.0
2012-10-04	BOIL	ETF	1083800.0	1107000.0	1041200.0	1076200.0	20.4
2012-10-04	BOND	ETF	109.1	109.18	109.08	109.1134	640210.0

> showing 50 of 937 rows — these rows as CSV

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