PREVIEW / etf_daily / 2013-08-21

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-21.parquet
  size:    41 KB
  rows:    1,013

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-08-21	SPY	ETF	165.12	166.03	164.19	164.56	159530500.0
2013-08-21	QQQ	ETF	75.46	76.09	75.14	75.42	30705085.0
2013-08-21	IWM	ETF	101.69	102.5	101.01	101.48	41452900.0
2013-08-21	DIA	ETF	149.44	149.92	148.5	148.64	9497100.0
2013-08-21	GLD	ETF	131.74	133.23	131.51	132.07	10720200.0
2013-08-21	TLT	ETF	102.77	103.2	102.11	102.13	13248800.0
2013-08-21	AADR	ETF	33.45	34.16	33.45	33.51	1100.0
2013-08-21	AAXJ	ETF	54.19	54.34	53.61	53.78	577800.0
2013-08-21	ACTV	ETF	9.35	9.515	9.32	9.35	298277.0
2013-08-21	ACWI	ETF	51.77	52.0	51.41	51.56	730100.0
2013-08-21	ACWV	ETF	60.48	60.53	60.13	60.21	175800.0
2013-08-21	ACWX	ETF	42.58	42.724	42.25	42.35	315945.0
2013-08-21	ADRE	ETF	34.77	34.8	34.42	34.42	22960.0
2013-08-21	AFK	ETF	29.29	29.29	28.92	29.04	47966.0
2013-08-21	AGG	ETF	105.71	105.85	105.42	105.42	656300.0
2013-08-21	AGQ	ETF	91.76	95.2	90.8	91.84	628600.0
2013-08-21	AGZ	ETF	110.4	110.5976	110.17	110.29	9084.0
2013-08-21	AIA	ETF	43.53	43.53	43.0	43.21	38682.0
2013-08-21	AIQ	ETF	22.77	23.62	22.77	23.39	49173.0
2013-08-21	AIVI	ETF	42.7	42.94	42.52	42.69	31000.0
2013-08-21	AMJ	ETF	45.84	45.84	45.02	45.48	853768.0
2013-08-21	AMLP	ETF	87.0	87.5	86.9	87.1	512700.0
2013-08-21	ANGL	ETF	26.28	26.35	26.28	26.34	800.0
2013-08-21	AOA	ETF	40.82	40.93	40.63	40.64	13600.0
2013-08-21	AOK	ETF	30.87	30.88	30.74	30.74	56649.0
2013-08-21	AOM	ETF	32.57	32.642	32.518	32.52	12481.0
2013-08-21	AOR	ETF	36.0	36.0364	35.8	35.8	13051.0
2013-08-21	ARB	ETF	46.28	46.84	45.73	46.82	1133954.0
2013-08-21	ARGT	ETF	18.77	18.98	18.77	18.8	8300.0
2013-08-21	ASEA	ETF	15.73	15.76	15.56	15.56	24200.0
2013-08-21	ATMP	ETF	26.18	26.18	26.07	26.15	8900.0
2013-08-21	AVIV	ETF	23.11	23.4899	23.01	23.01	75587.0
2013-08-21	AWAY	ETF	28.15	29.69	28.15	29.25	2161981.0
2013-08-21	BAB	ETF	27.02	27.16	26.93	26.93	169785.0
2013-08-21	BAL	ETF	56.25	56.25	53.81	53.86	31812.0
2013-08-21	BALT	ETF	4.42	4.6	4.37	4.48	296719.0
2013-08-21	BBH	ETF	75.77	77.5	75.77	76.57	73300.0
2013-08-21	BFOR	ETF	6.53	6.56	6.49	6.51	258400.0
2013-08-21	BIB	ETF	26.74	27.97	26.74	27.2525	73768.0
2013-08-21	BICK	ETF	21.31	21.31	21.12	21.12	2746.0
2013-08-21	BIL	ETF	91.58	91.6	91.58	91.6	244300.0
2013-08-21	BIS	ETF	1248.8	1264.0	1210.8	1210.8	95.0
2013-08-21	BIV	ETF	82.1	82.24	81.8	81.86	396700.0
2013-08-21	BIZD	ETF	19.85	19.91	19.8	19.9	9500.0
2013-08-21	BJK	ETF	42.75	42.75	42.39	42.54	2400.0
2013-08-21	BKF	ETF	34.1	34.1065	33.62	33.71	87460.0
2013-08-21	BKLN	ETF	24.68	24.71	24.64	24.64	1504100.0
2013-08-21	BLV	ETF	80.73	81.11	80.49	80.49	161800.0
2013-08-21	BMVP	ETF	19.6	19.7766	19.5403	19.6868	4713.0
2013-08-21	BND	ETF	79.89	79.96	79.68	79.68	737300.0

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

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