PREVIEW / etf_daily / 2013-11-22

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-22.parquet
  size:    42 KB
  rows:    1,054

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-11-22	SPY	ETF	179.98	180.83	179.77	180.81	81296000.0
2013-11-22	QQQ	ETF	83.69	84.02	83.62	83.99	25361273.0
2013-11-22	IWM	ETF	111.29	111.97	111.1	111.85	28786400.0
2013-11-22	DIA	ETF	159.83	160.43	159.48	160.4	4466400.0
2013-11-22	GLD	ETF	120.24	120.4	119.82	119.92	6774400.0
2013-11-22	TLT	ETF	103.49	104.13	103.48	103.91	7950700.0
2013-11-22	AADR	ETF	36.55	36.79	36.55	36.79	200.0
2013-11-22	AAXJ	ETF	60.0	60.33	59.86	60.25	200000.0
2013-11-22	ACWI	ETF	56.55	56.91	56.55	56.89	1686700.0
2013-11-22	ACWV	ETF	64.46	64.47	64.17	64.47	7200.0
2013-11-22	ACWX	ETF	46.3	46.46	46.24	46.44	59351.0
2013-11-22	ADRE	ETF	38.0	38.12	37.88	38.02	20703.0
2013-11-22	AFK	ETF	31.22	31.59	31.18	31.59	36376.0
2013-11-22	AGG	ETF	107.13	107.27	107.12	107.24	919400.0
2013-11-22	AGQ	ETF	67.12	67.32	66.16	66.32	227450.0
2013-11-22	AGZ	ETF	111.46	111.79	111.43	111.44	13562.0
2013-11-22	AIA	ETF	48.33	48.79	48.32	48.78	24371.0
2013-11-22	AIQ	ETF	25.86	25.96	24.7	24.87	20931.0
2013-11-22	AIVI	ETF	49.96	49.96	46.75	47.21	49400.0
2013-11-22	ALTL	ETF	32.045	32.045	32.045	32.045	125.0
2013-11-22	AMJ	ETF	45.77	46.3	45.7201	46.08	358574.0
2013-11-22	AMLP	ETF	87.95	88.6	87.75	88.35	652180.0
2013-11-22	ANGL	ETF	27.06	27.06	26.9	26.94	14300.0
2013-11-22	AOA	ETF	43.82	43.97	43.79	43.97	16800.0
2013-11-22	AOK	ETF	31.8955	31.95	31.88	31.95	16748.0
2013-11-22	AOM	ETF	34.1014	34.18	34.0745	34.14	44646.0
2013-11-22	AOR	ETF	38.04	38.19	38.04	38.19	21573.0
2013-11-22	ARGT	ETF	19.85	20.13	19.85	20.13	5600.0
2013-11-22	ASEA	ETF	16.33	16.4	16.3	16.34	136700.0
2013-11-22	ASHR	ETF	25.25	25.42	25.2	25.41	313700.0
2013-11-22	ATMP	ETF	27.12	27.16	27.07	27.07	1900.0
2013-11-22	AVIV	ETF	25.75	25.97	25.26	25.8	120432.0
2013-11-22	AWAY	ETF	37.59	37.848	36.6	36.73	1162519.0
2013-11-22	BAB	ETF	27.47	27.554	27.47	27.53	89025.0
2013-11-22	BAL	ETF	48.25	48.459	47.99	48.3901	8998.0
2013-11-22	BALT	ETF	4.71	4.73	4.63	4.65	491643.0
2013-11-22	BBH	ETF	85.83	87.1	85.77	86.92	124200.0
2013-11-22	BFOR	ETF	7.2575	7.28	7.2225	7.2775	163200.0
2013-11-22	BIB	ETF	34.75	35.8699	34.75	35.7	270196.0
2013-11-22	BICK	ETF	24.39	24.57	24.39	24.57	1300.0
2013-11-22	BIL	ETF	91.56	91.58	91.56	91.56	385000.0
2013-11-22	BIS	ETF	912.0	912.0	880.0	881.6	1413.5
2013-11-22	BIV	ETF	83.47	83.63	83.47	83.56	274000.0
2013-11-22	BIZD	ETF	21.31	21.57	21.28	21.42	12000.0
2013-11-22	BJK	ETF	49.17	49.46	49.07	49.32	5300.0
2013-11-22	BKF	ETF	38.6	38.86	38.5101	38.78	50096.0
2013-11-22	BKLN	ETF	24.83	24.84	24.82	24.83	2196400.0
2013-11-22	BLV	ETF	82.34	82.67	82.31	82.48	140000.0
2013-11-22	BMVP	ETF	22.1667	22.2933	22.1611	22.2773	6924.0
2013-11-22	BND	ETF	80.78	80.9	80.77	80.9	1977800.0

> showing 50 of 1,054 rows — these rows as CSV

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