PREVIEW / etf_daily / 2013-10-18

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-18.parquet
  size:    42 KB
  rows:    1,038

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-10-18	SPY	ETF	173.86	174.51	173.51	174.39	138316000.0
2013-10-18	QQQ	ETF	81.56	82.18	81.35	82.15	39628221.0
2013-10-18	IWM	ETF	110.22	110.77	109.83	110.69	39496400.0
2013-10-18	DIA	ETF	153.66	153.8	152.89	153.6	7714400.0
2013-10-18	GLD	ETF	126.87	127.33	126.6	126.85	5350500.0
2013-10-18	TLT	ETF	107.11	107.48	106.98	107.04	9487800.0
2013-10-18	AADR	ETF	36.85	36.85	36.64	36.77	1400.0
2013-10-18	AAXJ	ETF	61.43	61.62	61.32	61.47	843800.0
2013-10-18	ACTV	ETF	14.37	14.38	14.36	14.38	1502023.0
2013-10-18	ACWI	ETF	55.95	56.08	55.76	56.03	797300.0
2013-10-18	ACWV	ETF	63.36	63.67	63.36	63.58	23100.0
2013-10-18	ACWX	ETF	46.61	46.644	46.4	46.62	313312.0
2013-10-18	ADRE	ETF	38.99	39.1364	38.99	39.09	16348.0
2013-10-18	AFK	ETF	31.4	31.66	31.38	31.48	16732.0
2013-10-18	AGG	ETF	107.75	107.82	107.68	107.76	632400.0
2013-10-18	AGQ	ETF	81.2	81.76	80.84	81.28	245600.0
2013-10-18	AGZ	ETF	111.62	111.63	111.2101	111.43	13633.0
2013-10-18	AIA	ETF	48.8	48.8	48.571	48.62	20155.0
2013-10-18	AIQ	ETF	31.03	32.85	30.29	31.02	43726.0
2013-10-18	AIVI	ETF	47.11	47.31	47.09	47.31	54200.0
2013-10-18	ALTL	ETF	31.14	31.199	31.045	31.178	2906.0
2013-10-18	AMJ	ETF	44.95	45.3	44.74	45.22	496072.0
2013-10-18	AMLP	ETF	88.2	88.75	87.85	88.4	548860.0
2013-10-18	ANGL	ETF	26.36	26.88	26.36	26.88	13000.0
2013-10-18	AOA	ETF	43.11	43.25	43.07	43.24	15800.0
2013-10-18	AOK	ETF	31.76	31.82	31.73	31.73	108284.0
2013-10-18	AOM	ETF	33.81	33.91	33.781	33.9	28407.0
2013-10-18	AOR	ETF	37.58	37.7	37.58	37.7	14677.0
2013-10-18	ARGT	ETF	21.04	21.29	20.99	21.25	12100.0
2013-10-18	ASEA	ETF	17.24	17.3	17.22	17.29	7900.0
2013-10-18	ATMP	ETF	26.31	26.49	26.31	26.48	34900.0
2013-10-18	AVIV	ETF	24.26	24.26	23.86	24.02	301011.0
2013-10-18	AWAY	ETF	28.54	28.72	27.8	28.24	906699.0
2013-10-18	BAB	ETF	27.47	27.699	27.47	27.63	335344.0
2013-10-18	BAL	ETF	53.57	53.57	52.9881	53.08	6236.0
2013-10-18	BALT	ETF	5.28	5.31	5.01	5.26	850022.0
2013-10-18	BBH	ETF	82.68	82.68	80.24	81.16	176300.0
2013-10-18	BFOR	ETF	7.05	7.13	7.0375	7.0825	442800.0
2013-10-18	BIB	ETF	32.8825	32.8825	30.975	31.6475	534096.0
2013-10-18	BICK	ETF	25.259	25.259	25.2557	25.2557	442.0
2013-10-18	BIL	ETF	91.56	91.58	91.56	91.58	197450.0
2013-10-18	BIS	ETF	1000.0	1044.8	998.0	1030.0	352.0
2013-10-18	BIV	ETF	84.06	84.06	83.93	84.02	141400.0
2013-10-18	BIZD	ETF	20.5	20.58	20.5	20.55	3900.0
2013-10-18	BJK	ETF	51.28	51.36	50.89	51.23	85200.0
2013-10-18	BKF	ETF	39.29	39.46	39.15	39.19	52937.0
2013-10-18	BKLN	ETF	24.72	24.72	24.67	24.71	2526500.0
2013-10-18	BLNG	ETF	37.99	37.99	37.8	37.8	3000.0
2013-10-18	BLV	ETF	84.2	84.35	84.09	84.16	24500.0
2013-10-18	BMVP	ETF	21.24	21.34	21.24	21.31	647.0

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

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