PREVIEW / etf_daily / 2011-09-20

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-20.parquet
  size:    36 KB
  rows:    860

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
2011-09-20	SPY	ETF	120.82	121.99	120.01	120.17	218932200.0
2011-09-20	QQQ	ETF	56.9	57.35	56.23	56.36	66570061.0
2011-09-20	IWM	ETF	70.49	71.29	69.11	69.15	63453200.0
2011-09-20	DIA	ETF	114.26	115.26	113.48	113.88	8070700.0
2011-09-20	GLD	ETF	173.18	176.37	172.84	175.78	12667600.0
2011-09-20	TLT	ETF	114.37	114.87	114.05	114.86	6360600.0
2011-09-20	AAXJ	ETF	52.23	52.66	51.77	51.79	247200.0
2011-09-20	ACTV	ETF	15.73	16.27	15.42	15.52	124205.0
2011-09-20	ACWI	ETF	41.95	42.31	41.6	41.71	289800.0
2011-09-20	ACWX	ETF	37.1	37.5	36.86	37.01	95734.0
2011-09-20	ADRE	ETF	39.55	39.889	39.3	39.32	33319.0
2011-09-20	AFK	ETF	28.48	28.6	28.17	28.2327	4708.0
2011-09-20	AGEM	ETF	21.85	21.95	21.77	21.95	6230.0
2011-09-20	AGG	ETF	110.25	110.3	110.08	110.3	701600.0
2011-09-20	AGQ	ETF	399.96	419.7	397.38	410.44	412900.0
2011-09-20	AGZ	ETF	112.68	112.96	112.68	112.956	5126.0
2011-09-20	AIA	ETF	40.08	40.3012	39.74	39.77	28806.0
2011-09-20	AIQ	ETF	6.5	6.5	6.25	6.25	28473.0
2011-09-20	AIS	ETF	2.36	2.42	2.3	2.3	617824.0
2011-09-20	AIVI	ETF	39.75	40.22	39.52	39.77	826200.0
2011-09-20	AMJ	ETF	35.63	36.09	35.57	35.79	5591071.0
2011-09-20	AMLP	ETF	78.95	78.95	77.8	78.35	320760.0
2011-09-20	AOA	ETF	32.32	32.53	32.32	32.35	1500.0
2011-09-20	AOK	ETF	29.1	29.15	29.1	29.1	14450.0
2011-09-20	AOM	ETF	29.73	29.78	29.6348	29.66	22172.0
2011-09-20	AOR	ETF	30.67	30.8271	30.61	30.66	5428.0
2011-09-20	ARB	ETF	36.2	37.51	35.89	35.95	174155.0
2011-09-20	ARGT	ETF	23.38	23.38	23.34	23.34	300.0
2011-09-20	ASEA	ETF	14.78	14.98	14.78	14.91	2400.0
2011-09-20	AWAY	ETF	42.11	42.11	38.56	39.01	124161.0
2011-09-20	BAB	ETF	28.32	28.467	28.2	28.4548	663562.0
2011-09-20	BAL	ETF	65.84	66.46	64.23	64.74	93288.0
2011-09-20	BALT	ETF	5.06	5.06	4.85	4.85	112194.0
2011-09-20	BBH	ETF	33.8733	34.41	33.86	34.13	17700.0
2011-09-20	BCM	ETF	46.22	46.51	46.06	46.06	2700.0
2011-09-20	BIB	ETF	7.8975	8.0425	7.8738	7.8738	16800.0
2011-09-20	BICK	ETF	25.2	25.33	24.923	24.98	7284.0
2011-09-20	BIL	ETF	91.68	91.7	91.68	91.7	373000.0
2011-09-20	BITS	ETF	21.2	22.6	20.16	22.08	3834.0
2011-09-20	BIV	ETF	88.25	88.29	88.06	88.29	96400.0
2011-09-20	BJK	ETF	32.24	32.63	31.72	31.72	25600.0
2011-09-20	BKF	ETF	38.41	38.66	38.123	38.13	162857.0
2011-09-20	BKLN	ETF	23.39	23.43	23.35	23.42	79400.0
2011-09-20	BLNG	ETF	56.22	56.22	56.22	56.22	200.0
2011-09-20	BLV	ETF	89.95	90.23	89.62	90.23	41600.0
2011-09-20	BMVP	ETF	13.473	13.507	13.327	13.327	4779.0
2011-09-20	BND	ETF	83.89	83.94	83.8	83.9	705500.0
2011-09-20	BNO	ETF	37.115	37.58	36.935	37.155	85800.0
2011-09-20	BRF	ETF	45.23	45.23	43.89	44.0	727825.0
2011-09-20	BSCE	ETF	21.0	21.079	20.95	21.01	69918.0

> showing 50 of 860 rows — these rows as CSV

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