PREVIEW / etf_daily / 2013-01-22

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-22.parquet
  size:    40 KB
  rows:    978

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
2013-01-22	SPY	ETF	148.33	149.13	147.98	149.13	111797300.0
2013-01-22	QQQ	ETF	67.15	67.23	66.73	67.18	32123006.0
2013-01-22	IWM	ETF	88.64	89.26	88.38	89.21	31589000.0
2013-01-22	DIA	ETF	136.13	136.77	135.92	136.74	4544900.0
2013-01-22	GLD	ETF	163.48	164.22	163.37	163.67	8587900.0
2013-01-22	TLT	ETF	119.55	120.3	119.38	120.27	3874100.0
2013-01-22	AADR	ETF	32.26	32.53	32.26	32.53	1900.0
2013-01-22	AAXJ	ETF	61.19	61.19	60.92	61.11	849500.0
2013-01-22	ACTV	ETF	5.54	5.5599	5.37	5.42	436964.0
2013-01-22	ACWI	ETF	49.54	49.72	49.37	49.72	1289200.0
2013-01-22	ACWV	ETF	57.52	57.56	57.24	57.4	20600.0
2013-01-22	ACWX	ETF	42.73	42.92	42.63	42.92	431356.0
2013-01-22	ADRE	ETF	41.1	41.34	41.03	41.33	17757.0
2013-01-22	AFK	ETF	31.13	31.14	30.801	31.0	39324.0
2013-01-22	AGEM	ETF	23.68	23.93	23.68	23.87	3447.0
2013-01-22	AGG	ETF	110.75	110.95	110.75	110.87	1459000.0
2013-01-22	AGQ	ETF	194.0	199.2	193.68	197.04	318875.0
2013-01-22	AGZ	ETF	113.3	113.51	113.278	113.44	12281.0
2013-01-22	AIA	ETF	48.12	48.2601	48.02	48.18	62159.0
2013-01-22	AIQ	ETF	6.71	6.72	6.56	6.625	18401.0
2013-01-22	AIVI	ETF	42.73	42.9	42.64	42.87	33100.0
2013-01-22	AMJ	ETF	41.91	42.6	41.91	42.51	1159719.0
2013-01-22	AMLP	ETF	84.6	85.4	84.45	85.35	845780.0
2013-01-22	ANGL	ETF	27.2	27.45	27.2	27.32	7400.0
2013-01-22	AOA	ETF	38.34	38.49	38.29	38.49	37400.0
2013-01-22	AOK	ETF	30.86	30.91	30.8596	30.91	72856.0
2013-01-22	AOM	ETF	32.15	32.269	32.15	32.22	44929.0
2013-01-22	AOR	ETF	34.72	34.81	34.7	34.81	29894.0
2013-01-22	ARB	ETF	46.98	47.0	46.9	46.99	274472.0
2013-01-22	ARGT	ETF	18.4	18.52	18.2	18.52	9250.0
2013-01-22	ASEA	ETF	17.01	17.01	16.88	16.96	53400.0
2013-01-22	AWAY	ETF	22.72	22.86	22.36	22.82	333512.0
2013-01-22	BAB	ETF	30.21	30.2899	30.131	30.26	149983.0
2013-01-22	BAL	ETF	51.76	52.37	51.76	52.3	38312.0
2013-01-22	BALT	ETF	3.44	3.47	3.4	3.4	61836.0
2013-01-22	BBH	ETF	56.77	57.22	56.54	57.22	91600.0
2013-01-22	BCM	ETF	44.81	44.81	44.81	44.81	121.0
2013-01-22	BIB	ETF	16.1525	16.245	15.9355	16.245	90512.0
2013-01-22	BICK	ETF	25.97	26.01	25.87	26.01	1822.0
2013-01-22	BIL	ETF	91.6	91.62	91.6	91.6	139500.0
2013-01-22	BIS	ETF	2392.8	2392.8	2343.2	2343.2	98.0
2013-01-22	BIV	ETF	87.98	88.13	87.88	88.12	226300.0
2013-01-22	BJK	ETF	38.14	38.35	38.1	38.3	6000.0
2013-01-22	BKF	ETF	41.97	42.0425	41.86	42.01	140164.0
2013-01-22	BKLN	ETF	25.18	25.19	25.16	25.19	1390800.0
2013-01-22	BLV	ETF	93.1	93.49	93.1	93.48	70000.0
2013-01-22	BMVP	ETF	17.1567	17.3382	17.1567	17.3382	4016.0
2013-01-22	BND	ETF	83.79	83.91	83.78	83.84	2053700.0
2013-01-22	BNO	ETF	41.74	41.95	41.55	41.875	272600.0
2013-01-22	BOIL	ETF	872000.0	882000.0	839000.0	864000.0	20.4

> showing 50 of 978 rows — these rows as CSV

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