PREVIEW / etf_daily / 2013-01-25

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-25.parquet
  size:    40 KB
  rows:    974

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-25	SPY	ETF	149.88	150.25	149.37	150.25	147211600.0
2013-01-25	QQQ	ETF	66.89	67.19	66.74	67.0	39248726.0
2013-01-25	IWM	ETF	89.73	89.94	89.29	89.94	34620300.0
2013-01-25	DIA	ETF	138.39	138.63	138.04	138.62	4461000.0
2013-01-25	GLD	ETF	160.56	161.04	160.31	160.65	9037400.0
2013-01-25	TLT	ETF	118.42	118.6	117.77	118.03	8750700.0
2013-01-25	AADR	ETF	33.27	33.27	33.05	33.05	400.0
2013-01-25	AAXJ	ETF	60.4	60.4	59.91	60.25	647300.0
2013-01-25	ACTV	ETF	5.56	5.575	5.4	5.54	345801.0
2013-01-25	ACWI	ETF	49.93	50.05	49.82	50.05	594600.0
2013-01-25	ACWV	ETF	57.77	57.8	57.57	57.7	29100.0
2013-01-25	ACWX	ETF	43.15	43.19	42.97	43.18	247937.0
2013-01-25	ADRE	ETF	40.97	41.17	40.87	41.05	48776.0
2013-01-25	AFK	ETF	31.23	31.28	31.0001	31.2495	61388.0
2013-01-25	AGEM	ETF	23.8	23.9299	23.8	23.902	2822.0
2013-01-25	AGG	ETF	110.6	110.69	110.49	110.57	877800.0
2013-01-25	AGQ	ETF	188.12	188.88	184.0	185.12	412800.0
2013-01-25	AGZ	ETF	113.44	113.44	113.141	113.19	14498.0
2013-01-25	AIA	ETF	47.43	47.43	47.0482	47.2535	62710.0
2013-01-25	AIQ	ETF	6.43	6.47	6.33	6.46	34507.0
2013-01-25	AIVI	ETF	43.15	43.37	43.1	43.35	48700.0
2013-01-25	AMJ	ETF	42.16	42.42	41.88	42.31	1577571.0
2013-01-25	AMLP	ETF	84.7	85.0	84.35	84.8	739540.0
2013-01-25	ANGL	ETF	27.72	27.72	27.18	27.25	10800.0
2013-01-25	AOA	ETF	38.69	38.78	38.63	38.76	13700.0
2013-01-25	AOK	ETF	30.95	30.95	30.9	30.91	29706.0
2013-01-25	AOM	ETF	32.34	32.34	32.28	32.3	64436.0
2013-01-25	AOR	ETF	34.97	34.97	34.884	34.95	71149.0
2013-01-25	ARB	ETF	46.95	47.1	46.92	47.07	233847.0
2013-01-25	ARGT	ETF	18.32	18.34	18.32	18.34	900.0
2013-01-25	ASEA	ETF	16.98	16.98	16.86	16.95	46100.0
2013-01-25	AWAY	ETF	23.13	23.32	22.4	23.23	272540.0
2013-01-25	BAB	ETF	30.09	30.15	29.99	30.02	171989.0
2013-01-25	BAL	ETF	53.02	53.66	52.63	52.8236	23894.0
2013-01-25	BALT	ETF	3.5	3.55	3.32	3.4	71376.0
2013-01-25	BBH	ETF	57.36	57.73	56.97	57.73	59500.0
2013-01-25	BCM	ETF	44.45	44.51	44.43	44.5	5168.0
2013-01-25	BIB	ETF	16.16	16.4158	16.08	16.37	52696.0
2013-01-25	BICK	ETF	25.61	25.65	25.494	25.56	12757.0
2013-01-25	BIL	ETF	91.6	91.62	91.6	91.6	188800.0
2013-01-25	BIS	ETF	2367.6	2368.0	2322.4	2322.4	46.45
2013-01-25	BIV	ETF	87.76	87.83	87.57	87.66	325200.0
2013-01-25	BJK	ETF	38.32	38.32	38.1	38.28	21900.0
2013-01-25	BKF	ETF	41.93	41.95	41.65	41.89	123754.0
2013-01-25	BKLN	ETF	25.21	25.23	25.21	25.22	2486900.0
2013-01-25	BLV	ETF	92.57	92.88	92.28	92.42	125200.0
2013-01-25	BMVP	ETF	17.47	17.519	17.4167	17.5033	13394.0
2013-01-25	BND	ETF	83.67	83.71	83.56	83.58	1473000.0
2013-01-25	BNO	ETF	42.38	42.38	42.13	42.23	104000.0
2013-01-25	BOIL	ETF	825000.0	834800.0	807200.0	821600.0	5.8

> showing 50 of 974 rows — these rows as CSV

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