PREVIEW / etf_daily / 2013-01-24

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-24.parquet
  size:    40 KB
  rows:    975

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-24	SPY	ETF	149.15	150.14	149.01	149.41	146426400.0
2013-01-24	QQQ	ETF	66.69	67.28	66.56	66.66	42603381.0
2013-01-24	IWM	ETF	89.15	89.85	88.93	89.29	39814600.0
2013-01-24	DIA	ETF	137.59	138.49	137.57	138.02	6288000.0
2013-01-24	GLD	ETF	161.98	162.27	161.18	161.42	13188300.0
2013-01-24	TLT	ETF	119.87	119.97	119.26	119.67	4178900.0
2013-01-24	AADR	ETF	32.73	32.83	32.43	32.43	1400.0
2013-01-24	AAXJ	ETF	60.81	60.92	60.55	60.66	625600.0
2013-01-24	ACTV	ETF	5.47	5.61	5.42	5.52	361715.0
2013-01-24	ACWI	ETF	49.65	49.93	49.63	49.74	479200.0
2013-01-24	ACWV	ETF	57.65	57.83	57.36	57.46	114800.0
2013-01-24	ACWX	ETF	42.85	43.022	42.82	42.851	299368.0
2013-01-24	ADRE	ETF	41.08	41.39	41.005	41.09	18587.0
2013-01-24	AFK	ETF	30.9	31.11	30.9	31.0125	51094.0
2013-01-24	AGEM	ETF	23.73	23.95	23.72	23.8615	5458.0
2013-01-24	AGG	ETF	110.89	110.95	110.82	110.84	659800.0
2013-01-24	AGQ	ETF	192.0	194.16	189.76	190.76	462800.0
2013-01-24	AGZ	ETF	113.28	113.44	113.28	113.39	13897.0
2013-01-24	AIA	ETF	47.87	48.08	47.73	47.83	41344.0
2013-01-24	AIQ	ETF	6.6499	6.6499	6.28	6.46	87863.0
2013-01-24	AIVI	ETF	42.72	43.01	42.72	42.86	53300.0
2013-01-24	AMJ	ETF	42.39	42.52	41.95	41.95	2060019.0
2013-01-24	AMLP	ETF	85.0	85.2	84.4	84.5	578440.0
2013-01-24	ANGL	ETF	27.35	27.38	27.35	27.35	1200.0
2013-01-24	AOA	ETF	38.62	38.71	38.5	38.58	59800.0
2013-01-24	AOK	ETF	30.91	30.95	30.901	30.94	24000.0
2013-01-24	AOM	ETF	32.27	32.33	32.251	32.28	75206.0
2013-01-24	AOR	ETF	34.96	34.96	34.815	34.88	15943.0
2013-01-24	ARB	ETF	47.0	47.0	46.82	46.92	375404.0
2013-01-24	ARGT	ETF	18.42	18.48	18.24	18.3	1650.0
2013-01-24	ASEA	ETF	16.95	17.06	16.9	16.92	59700.0
2013-01-24	AWAY	ETF	23.44	23.66	22.86	22.98	287910.0
2013-01-24	BAB	ETF	30.22	30.3	30.1501	30.22	175705.0
2013-01-24	BAL	ETF	52.6598	54.7399	52.6598	53.9064	31922.0
2013-01-24	BALT	ETF	3.48	3.48	3.3	3.32	135529.0
2013-01-24	BBH	ETF	56.93	57.41	56.63	57.02	27200.0
2013-01-24	BCM	ETF	44.57	44.57	44.57	44.57	11708.0
2013-01-24	BIB	ETF	16.02	16.4025	15.95	16.06	69820.0
2013-01-24	BICK	ETF	25.79	25.92	25.69	25.775	15655.0
2013-01-24	BIL	ETF	91.6	91.62	91.6	91.62	2557850.0
2013-01-24	BIS	ETF	2334.0	2372.72	2334.0	2364.8	27.0
2013-01-24	BIV	ETF	88.07	88.09	87.93	88.04	218600.0
2013-01-24	BJK	ETF	38.19	38.39	38.19	38.27	163700.0
2013-01-24	BKF	ETF	41.92	42.17	41.76	41.88	86538.0
2013-01-24	BKLN	ETF	25.2	25.22	25.18	25.22	1585500.0
2013-01-24	BLV	ETF	93.4	93.45	92.98	93.35	120000.0
2013-01-24	BMVP	ETF	17.3667	17.5134	17.3667	17.4342	10447.0
2013-01-24	BND	ETF	83.89	83.92	83.83	83.85	1061700.0
2013-01-24	BNO	ETF	41.965	42.32	41.94	42.185	97000.0
2013-01-24	BOIL	ETF	868000.0	884000.0	813200.0	825400.0	15.4

> showing 50 of 975 rows — these rows as CSV

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