PREVIEW / etf_daily / 2013-02-15

all etf daily files

  file:    by_date/etf_daily/2013/2013-02-15.parquet
  size:    40 KB
  rows:    971

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-02-15	SPY	ETF	152.43	152.59	151.55	152.11	215226500.0
2013-02-15	QQQ	ETF	67.95	68.11	67.56	67.75	25334049.0
2013-02-15	IWM	ETF	91.67	92.03	91.47	91.74	29339100.0
2013-02-15	DIA	ETF	139.51	139.71	138.75	139.45	6111300.0
2013-02-15	GLD	ETF	156.42	156.58	154.56	155.76	23374100.0
2013-02-15	TLT	ETF	116.66	116.74	116.07	116.5	5861800.0
2013-02-15	AAXJ	ETF	60.91	60.91	60.54	60.63	392000.0
2013-02-15	ACTV	ETF	5.04	5.44	5.0	5.37	2159993.0
2013-02-15	ACWI	ETF	50.26	50.26	49.94	50.1	856800.0
2013-02-15	ACWV	ETF	58.56	58.65	58.36	58.53	10300.0
2013-02-15	ACWX	ETF	43.01	43.02	42.72	42.86	130959.0
2013-02-15	ADRE	ETF	40.06	40.14	40.0	40.05	10282.0
2013-02-15	AFK	ETF	31.65	31.7	31.16	31.21	10249.0
2013-02-15	AGEM	ETF	23.49	23.49	23.3453	23.3453	1539.0
2013-02-15	AGG	ETF	110.19	110.25	110.06	110.25	1864700.0
2013-02-15	AGQ	ETF	170.68	171.72	166.64	168.32	710125.0
2013-02-15	AGZ	ETF	113.03	113.06	112.91	113.02	16792.0
2013-02-15	AIA	ETF	47.88	47.89	47.6201	47.65	22992.0
2013-02-15	AIQ	ETF	7.0	7.09	6.6901	6.96	4550.0
2013-02-15	AIVI	ETF	42.22	42.28	41.94	42.05	20100.0
2013-02-15	AMJ	ETF	44.18	44.18	43.48	43.52	1886779.0
2013-02-15	AMLP	ETF	86.25	86.55	85.5	85.7	518640.0
2013-02-15	ANGL	ETF	26.69	26.79	26.68	26.79	2400.0
2013-02-15	AOA	ETF	39.05	39.06	38.88	38.96	12800.0
2013-02-15	AOK	ETF	30.96	30.96	30.882	30.89	15860.0
2013-02-15	AOM	ETF	32.42	32.42	32.336	32.39	12881.0
2013-02-15	AOR	ETF	35.16	35.16	35.024	35.1	69742.0
2013-02-15	ARB	ETF	47.12	47.17	46.9	46.9	457907.0
2013-02-15	ARGT	ETF	17.56	17.7	17.56	17.68	950.0
2013-02-15	ASEA	ETF	17.15	17.23	17.09	17.16	19700.0
2013-02-15	AWAY	ETF	25.24	25.56	24.52	24.77	1472476.0
2013-02-15	BAB	ETF	30.09	30.15	30.01	30.01	155469.0
2013-02-15	BAL	ETF	53.5255	54.08	53.49	53.67	34458.0
2013-02-15	BALT	ETF	3.37	3.45	3.31	3.36	63058.0
2013-02-15	BBH	ETF	58.14	58.2	57.88	58.0	19600.0
2013-02-15	BCM	ETF	44.4	44.48	44.31	44.48	24851.0
2013-02-15	BIB	ETF	16.29	16.29	16.1403	16.2805	38724.0
2013-02-15	BICK	ETF	25.46	25.4715	25.3128	25.373	8015.0
2013-02-15	BIL	ETF	91.62	91.62	91.6	91.6	51900.0
2013-02-15	BIS	ETF	2349.6	2349.6	2346.8	2346.8	25.0
2013-02-15	BIV	ETF	87.35	87.36	87.21	87.33	166200.0
2013-02-15	BIZD	ETF	20.54	20.54	20.3	20.33	12500.0
2013-02-15	BJK	ETF	39.27	39.3	39.07	39.13	15100.0
2013-02-15	BKF	ETF	41.21	41.29	41.05	41.14	43316.0
2013-02-15	BKLN	ETF	24.95	24.96	24.93	24.93	4732600.0
2013-02-15	BLV	ETF	91.21	91.23	90.87	91.2	31700.0
2013-02-15	BMVP	ETF	17.96	17.96	17.894	17.894	1481.0
2013-02-15	BND	ETF	83.27	83.32	83.19	83.25	2579400.0
2013-02-15	BNO	ETF	43.8	44.265	43.73	44.255	162000.0
2013-02-15	BOIL	ETF	689200.0	691600.0	671800.0	680600.0	14.2

> showing 50 of 971 rows — these rows as CSV

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