PREVIEW / etf_daily / 2012-10-08

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-08.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-08	SPY	ETF	145.6	146.12	145.31	145.64	78415400.0
2012-10-08	QQQ	ETF	68.58	68.72	68.19	68.35	30911410.0
2012-10-08	IWM	ETF	83.62	83.9	83.39	83.58	21062200.0
2012-10-08	DIA	ETF	135.4	135.86	135.32	135.65	2405000.0
2012-10-08	GLD	ETF	171.75	172.28	171.68	172.05	3749300.0
2012-10-08	TLT	ETF	121.98	122.27	121.69	122.17	1568400.0
2012-10-08	AAXJ	ETF	56.52	56.75	56.5	56.67	237500.0
2012-10-08	ACTV	ETF	11.34	11.34	10.84	10.99	2320872.0
2012-10-08	ACWI	ETF	47.21	47.32	47.15	47.26	879500.0
2012-10-08	ACWV	ETF	57.32	57.32	57.09	57.17	12000.0
2012-10-08	ACWX	ETF	39.91	39.94	38.3	39.76	4160450.0
2012-10-08	ADRE	ETF	39.01	39.4	39.0	39.35	16734.0
2012-10-08	AFK	ETF	31.15	31.15	30.89	30.92	26070.0
2012-10-08	AGEM	ETF	22.35	22.3865	22.35	22.3865	326.0
2012-10-08	AGG	ETF	111.9	112.05	111.9	112.03	524800.0
2012-10-08	AGQ	ETF	225.28	227.64	224.48	225.96	220150.0
2012-10-08	AGZ	ETF	114.02	114.02	113.6701	113.888	11380.0
2012-10-08	AIA	ETF	44.78	44.81	44.647	44.81	3964.0
2012-10-08	AIQ	ETF	7.05	7.05	6.75	6.9	62211.0
2012-10-08	AIVI	ETF	40.42	40.47	40.35	40.44	20900.0
2012-10-08	ALTL	ETF	26.1	26.1	26.1	26.1	800.0
2012-10-08	AMJ	ETF	41.32	41.4055	41.19	41.26	592258.0
2012-10-08	AMLP	ETF	84.0	84.15	83.9	84.05	268840.0
2012-10-08	ANGL	ETF	26.43	26.52	26.36	26.36	900.0
2012-10-08	AOA	ETF	36.96	37.0	36.92	36.99	7000.0
2012-10-08	AOK	ETF	30.64	30.64	30.55	30.58	5292.0
2012-10-08	AOM	ETF	31.67	31.73	31.6538	31.73	46808.0
2012-10-08	AOR	ETF	33.81	33.94	33.81	33.9	85827.0
2012-10-08	ARB	ETF	37.34	38.72	37.18	38.52	171314.0
2012-10-08	ASEA	ETF	16.83	16.84	16.76	16.81	2500.0
2012-10-08	AWAY	ETF	25.98	26.58	25.94	26.4	723889.0
2012-10-08	BAB	ETF	29.82	30.0	29.82	29.96	268860.0
2012-10-08	BAL	ETF	47.27	47.28	47.08	47.08	3306.0
2012-10-08	BALT	ETF	3.07	3.12	3.06	3.07	39023.0
2012-10-08	BBH	ETF	56.36	56.36	55.7	55.76	45900.0
2012-10-08	BCM	ETF	45.79	45.79	45.79	45.79	200.0
2012-10-08	BIB	ETF	16.9175	16.9175	16.4778	16.504	85400.0
2012-10-08	BICK	ETF	23.89	23.93	23.81	23.93	4600.0
2012-10-08	BIL	ETF	91.64	91.64	91.62	91.62	273800.0
2012-10-08	BIS	ETF	2352.0	2437.2	2352.0	2437.2	65.5
2012-10-08	BIV	ETF	90.09	90.17	90.0	90.13	221800.0
2012-10-08	BJK	ETF	33.76	33.88	33.76	33.83	5000.0
2012-10-08	BKF	ETF	38.02	38.232	37.9	38.2	143133.0
2012-10-08	BKLN	ETF	24.99	24.99	24.95	24.95	237200.0
2012-10-08	BLV	ETF	95.84	96.0	95.6	95.77	90200.0
2012-10-08	BMVP	ETF	16.29	16.3	16.28	16.3	8647.0
2012-10-08	BND	ETF	84.84	84.93	84.75	84.89	588800.0
2012-10-08	BNO	ETF	40.395	40.525	40.25	40.44	38600.0
2012-10-08	BOIL	ETF	1038400.0	1086000.0	1038400.0	1072200.0	7.4
2012-10-08	BOND	ETF	108.94	109.09	108.82	109.03	354554.0

> showing 50 of 934 rows — these rows as CSV

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