PREVIEW / etf_daily / 2012-12-21

all etf daily files

  file:    by_date/etf_daily/2012/2012-12-21.parquet
  size:    40 KB
  rows:    964

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-12-21	SPY	ETF	142.17	144.09	141.94	142.79	245883800.0
2012-12-21	QQQ	ETF	64.89	65.28	64.6	65.2	51144552.0
2012-12-21	IWM	ETF	83.27	84.19	83.08	84.19	54923200.0
2012-12-21	DIA	ETF	131.06	132.02	130.83	131.79	11495800.0
2012-12-21	GLD	ETF	159.82	160.76	159.78	160.33	13445400.0
2012-12-21	TLT	ETF	122.31	122.43	121.95	122.25	6087700.0
2012-12-21	AAXJ	ETF	58.79	58.99	58.61	58.97	297700.0
2012-12-21	ACTV	ETF	4.8	4.88	4.715	4.74	1006210.0
2012-12-21	ACWI	ETF	47.61	47.93	47.61	47.91	1111500.0
2012-12-21	ACWV	ETF	55.82	56.12	55.79	56.04	38400.0
2012-12-21	ACWX	ETF	41.45	41.64	41.34	41.64	434352.0
2012-12-21	ADRE	ETF	39.44	39.82	39.12	39.71	59815.0
2012-12-21	AFK	ETF	31.86	31.984	31.66	31.86	16079.0
2012-12-21	AGEM	ETF	23.23	23.35	23.04	23.28	17412.0
2012-12-21	AGG	ETF	111.19	111.23	111.09	111.12	973700.0
2012-12-21	AGQ	ETF	171.92	176.0	171.44	172.56	419650.0
2012-12-21	AGZ	ETF	113.35	113.52	113.35	113.5	24986.0
2012-12-21	AIA	ETF	46.84	46.96	46.5801	46.78	45931.0
2012-12-21	AIQ	ETF	6.338	6.5	6.15	6.5	11592.0
2012-12-21	AIVI	ETF	41.79	41.97	41.72	41.94	88100.0
2012-12-21	AMJ	ETF	38.76	39.15	38.5056	38.81	1870112.0
2012-12-21	AMLP	ETF	80.3	80.65	79.85	80.2	753400.0
2012-12-21	ANGL	ETF	27.11	27.28	27.07	27.12	1500.0
2012-12-21	AOA	ETF	37.29	37.49	37.26	37.44	35000.0
2012-12-21	AOK	ETF	30.64	30.68	30.6	30.67	23663.0
2012-12-21	AOM	ETF	31.9	31.95	31.86	31.93	19646.0
2012-12-21	AOR	ETF	34.11	34.23	34.058	34.18	25808.0
2012-12-21	ARB	ETF	46.33	46.45	46.09	46.44	1977281.0
2012-12-21	ARGT	ETF	17.44	17.44	17.3	17.3	5550.0
2012-12-21	ASEA	ETF	17.09	17.15	17.0	17.09	28000.0
2012-12-21	AWAY	ETF	22.36	23.03	21.77	21.85	2296176.0
2012-12-21	BAB	ETF	30.35	30.36	30.2	30.3	252701.0
2012-12-21	BAL	ETF	49.36	49.73	49.34	49.73	7346.0
2012-12-21	BALT	ETF	3.09	3.19	3.0415	3.16	149447.0
2012-12-21	BBH	ETF	54.34	54.57	54.0	54.29	20600.0
2012-12-21	BCM	ETF	43.69	43.73	43.6599	43.7299	3764.0
2012-12-21	BIB	ETF	14.4775	14.782	14.0002	14.7271	112548.0
2012-12-21	BICK	ETF	24.86	24.951	24.76	24.87	14974.0
2012-12-21	BIL	ETF	91.62	91.64	91.62	91.62	153400.0
2012-12-21	BIS	ETF	2660.652	2660.652	2605.64	2619.12	44.0
2012-12-21	BIV	ETF	89.95	89.99	89.86	89.89	218400.0
2012-12-21	BJK	ETF	36.71	36.89	36.64	36.84	6900.0
2012-12-21	BKF	ETF	39.87	40.03	39.708	40.03	124032.0
2012-12-21	BKLN	ETF	24.9	24.92	24.89	24.91	583700.0
2012-12-21	BLV	ETF	95.3	95.41	95.18	95.28	31900.0
2012-12-21	BMVP	ETF	16.2567	16.2567	16.1933	16.2567	3101.0
2012-12-21	BND	ETF	84.52	84.57	84.49	84.52	1312800.0
2012-12-21	BNO	ETF	40.265	40.325	40.09	40.26	56800.0
2012-12-21	BOIL	ETF	857600.0	872000.0	832200.0	843600.0	9.8
2012-12-21	BOND	ETF	109.12	109.17	109.06	109.14	601083.0

> showing 50 of 964 rows — these rows as CSV

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