PREVIEW / etf_daily / 2012-09-05

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-05.parquet
  size:    39 KB
  rows:    943

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-05	SPY	ETF	141.09	141.47	140.63	140.91	100660300.0
2012-09-05	QQQ	ETF	68.04	68.35	67.84	68.02	26133787.0
2012-09-05	IWM	ETF	82.2	82.51	81.85	82.13	35103700.0
2012-09-05	DIA	ETF	130.37	130.83	130.04	130.37	2828800.0
2012-09-05	GLD	ETF	164.12	164.39	163.81	164.31	8401900.0
2012-09-05	TLT	ETF	126.82	127.19	126.55	126.72	3466700.0
2012-09-05	AAXJ	ETF	52.46	52.46	52.2	52.4	340200.0
2012-09-05	ACTV	ETF	11.88	12.08	11.78	11.97	341686.0
2012-09-05	ACWI	ETF	45.35	45.42	45.16	45.25	635200.0
2012-09-05	ACWV	ETF	55.56	55.94	55.56	55.7	4300.0
2012-09-05	ACWX	ETF	37.88	37.88	37.66	37.75	82086.0
2012-09-05	ADRE	ETF	37.22	37.38	37.15	37.32	19785.0
2012-09-05	AFK	ETF	29.79	29.94	29.7617	29.86	29879.0
2012-09-05	AGEM	ETF	21.0101	21.07	21.0101	21.07	776.0
2012-09-05	AGG	ETF	112.05	112.17	112.03	112.13	503000.0
2012-09-05	AGQ	ETF	206.52	207.36	204.08	206.12	253500.0
2012-09-05	AGZ	ETF	113.859	113.92	113.81	113.87	11460.0
2012-09-05	AIA	ETF	41.23	41.28	41.1	41.18	5277.0
2012-09-05	AIQ	ETF	6.7	6.9	6.35	6.65	10704.0
2012-09-05	AIVI	ETF	39.43	39.5	39.19	39.23	21200.0
2012-09-05	AMJ	ETF	39.77	39.8	39.41	39.64	519808.0
2012-09-05	AMLP	ETF	82.0	82.0	81.5	81.6	276320.0
2012-09-05	ANGL	ETF	26.4	26.4	26.38	26.4	3900.0
2012-09-05	AOA	ETF	36.03	36.06	35.96	36.01	22900.0
2012-09-05	AOK	ETF	30.24	30.25	30.2	30.24	18027.0
2012-09-05	AOM	ETF	31.29	31.29	31.2201	31.23	16544.0
2012-09-05	AOR	ETF	33.29	33.32	33.21	33.2317	29949.0
2012-09-05	ARB	ETF	35.71	36.84	35.53	36.65	103446.0
2012-09-05	ASEA	ETF	16.22	16.22	16.13	16.2	2800.0
2012-09-05	AWAY	ETF	22.5	22.76	22.1	22.73	212387.0
2012-09-05	BAB	ETF	30.37	30.43	30.3135	30.38	139019.0
2012-09-05	BAL	ETF	50.07	50.08	49.43	49.85	40400.0
2012-09-05	BALT	ETF	3.04	3.06	3.03	3.05	35959.0
2012-09-05	BBH	ETF	51.9	51.9	51.57	51.65	41700.0
2012-09-05	BCM	ETF	46.06	46.06	46.01	46.01	4000.0
2012-09-05	BIB	ETF	14.9838	14.9838	14.6875	14.745	35752.0
2012-09-05	BICK	ETF	21.85	22.0	21.8417	21.91	12042.0
2012-09-05	BIL	ETF	91.64	91.64	91.62	91.64	357800.0
2012-09-05	BIS	ETF	2745.6	2768.0	2744.0	2744.0	18.95
2012-09-05	BIV	ETF	89.71	89.89	89.66	89.77	287700.0
2012-09-05	BJK	ETF	31.89	32.0	31.87	31.89	1800.0
2012-09-05	BKF	ETF	35.24	35.28	35.0	35.28	155610.0
2012-09-05	BKLN	ETF	24.81	24.84	24.81	24.84	266800.0
2012-09-05	BLV	ETF	97.13	97.29	96.81	96.92	77000.0
2012-09-05	BMVP	ETF	16.01	16.0567	15.9567	15.98	1373.0
2012-09-05	BND	ETF	84.93	85.0	84.9	84.94	1049300.0
2012-09-05	BNO	ETF	41.005	41.01	40.64	40.765	44200.0
2012-09-05	BOIL	ETF	819200.0	832600.0	802000.0	812400.0	7.2
2012-09-05	BOND	ETF	107.59	107.72	107.56	107.59	282428.0
2012-09-05	BRF	ETF	38.98	38.98	38.65	38.88	441148.0

> showing 50 of 943 rows — these rows as CSV

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