PREVIEW / etf_daily / 2013-01-15

all etf daily files

  file:    by_date/etf_daily/2013/2013-01-15.parquet
  size:    40 KB
  rows:    966

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-15	SPY	ETF	146.29	147.21	146.2	147.07	93172600.0
2013-01-15	QQQ	ETF	66.63	66.729	66.3321	66.63	31675276.0
2013-01-15	IWM	ETF	86.83	87.89	86.77	87.77	34704100.0
2013-01-15	DIA	ETF	134.29	135.26	134.24	135.08	2966100.0
2013-01-15	GLD	ETF	162.8	163.17	162.35	162.56	10077800.0
2013-01-15	TLT	ETF	120.61	120.7	119.97	120.07	5357800.0
2013-01-15	AADR	ETF	32.08	33.43	31.77	32.17	6800.0
2013-01-15	AAXJ	ETF	60.73	60.82	60.58	60.81	379100.0
2013-01-15	ACTV	ETF	6.08	6.087	5.6	5.9	1032742.0
2013-01-15	ACWI	ETF	49.0	49.27	49.0	49.24	280900.0
2013-01-15	ACWV	ETF	57.06	57.22	56.87	57.11	30300.0
2013-01-15	ACWX	ETF	42.56	42.73	42.48	42.72	369153.0
2013-01-15	ADRE	ETF	40.95	41.08	40.92	41.06	17889.0
2013-01-15	AFK	ETF	31.2	31.23	31.12	31.2265	16685.0
2013-01-15	AGEM	ETF	23.6425	23.7199	23.6425	23.6825	15153.0
2013-01-15	AGG	ETF	111.01	111.07	110.95	110.98	2561100.0
2013-01-15	AGQ	ETF	185.72	189.96	184.36	187.52	273700.0
2013-01-15	AGZ	ETF	113.49	113.49	113.386	113.41	15165.0
2013-01-15	AIA	ETF	48.02	48.02	47.79	47.93	58163.0
2013-01-15	AIQ	ETF	6.66	6.75	6.652	6.75	5372.0
2013-01-15	AIVI	ETF	42.58	42.83	42.55	42.8	19600.0
2013-01-15	ALTL	ETF	27.02	27.02	26.94	26.94	600.0
2013-01-15	AMJ	ETF	41.32	41.441	41.13	41.37	2938152.0
2013-01-15	AMLP	ETF	83.65	83.8	83.35	83.75	663160.0
2013-01-15	ANGL	ETF	27.22	27.22	27.22	27.22	200.0
2013-01-15	AOA	ETF	37.97	38.15	37.9	38.13	25300.0
2013-01-15	AOK	ETF	30.78	30.83	30.72	30.83	35288.0
2013-01-15	AOM	ETF	32.05	32.097	31.9801	32.08	27274.0
2013-01-15	AOR	ETF	34.46	34.57	34.45	34.57	59792.0
2013-01-15	ARB	ETF	46.76	46.85	46.75	46.78	583078.0
2013-01-15	ARGT	ETF	18.22	18.22	18.06	18.06	2550.0
2013-01-15	ASEA	ETF	16.89	16.97	16.85	16.92	19000.0
2013-01-15	AWAY	ETF	22.17	23.07	21.65	23.0	699899.0
2013-01-15	BAB	ETF	30.1	30.12	30.02	30.02	279206.0
2013-01-15	BAL	ETF	49.38	49.79	49.38	49.79	13649.0
2013-01-15	BALT	ETF	3.25	3.339	3.19	3.28	30357.0
2013-01-15	BBH	ETF	56.72	57.05	56.43	56.89	21500.0
2013-01-15	BCM	ETF	44.1713	44.34	44.1713	44.1898	3444.0
2013-01-15	BIB	ETF	16.2775	16.5	16.0545	16.475	458096.0
2013-01-15	BICK	ETF	25.93	25.93	25.7002	25.815	10872.0
2013-01-15	BIL	ETF	91.6	91.62	91.6	91.6	72400.0
2013-01-15	BIS	ETF	2360.8	2369.2	2334.8	2334.8	48.75
2013-01-15	BIV	ETF	88.2	88.23	88.08	88.11	285800.0
2013-01-15	BJK	ETF	37.64	37.81	37.64	37.77	3400.0
2013-01-15	BKF	ETF	41.58	41.66	41.47	41.65	77676.0
2013-01-15	BKLN	ETF	25.11	25.13	25.1	25.11	1707000.0
2013-01-15	BLV	ETF	93.38	93.68	93.33	93.37	58300.0
2013-01-15	BMVP	ETF	16.9067	17.0251	16.86	17.0251	5115.0
2013-01-15	BND	ETF	83.93	84.0	83.91	83.94	1283200.0
2013-01-15	BNO	ETF	41.26	41.265	40.84	40.885	107600.0

> showing 50 of 966 rows — these rows as CSV

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