PREVIEW / etf_daily / 2011-01-21

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-21.parquet
  size:    35 KB
  rows:    821

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-01-21	SPY	ETF	128.88	129.17	128.23	128.37	151462900.0
2011-01-21	QQQ	ETF	56.39	56.49	55.65	55.68	59673278.0
2011-01-21	IWM	ETF	78.21	78.24	77.12	77.19	56676500.0
2011-01-21	DIA	ETF	118.71	118.8	117.97	118.46	9663000.0
2011-01-21	GLD	ETF	130.76	131.43	130.53	131.03	19488400.0
2011-01-21	TLT	ETF	90.69	91.52	90.51	91.52	9085600.0
2011-01-21	AADR	ETF	29.84	29.84	29.84	29.84	200.0
2011-01-21	AAXJ	ETF	63.07	63.13	62.17	62.27	1080600.0
2011-01-21	ACWI	ETF	47.4	47.56	47.25	47.34	209600.0
2011-01-21	ACWX	ETF	44.45	44.6	44.26	44.27	93433.0
2011-01-21	ADRE	ETF	47.67	47.7	47.0	47.09	44527.0
2011-01-21	AFK	ETF	34.93	35.34	34.8835	35.22	38360.0
2011-01-21	AGG	ETF	105.25	105.61	105.24	105.61	578200.0
2011-01-21	AGQ	ETF	244.22	250.72	243.04	248.5	470650.0
2011-01-21	AGZ	ETF	109.59	110.11	109.43	109.818	40573.0
2011-01-21	AIA	ETF	48.09	48.09	47.5501	47.56	29667.0
2011-01-21	AIQ	ETF	20.45	20.5	20.0	20.4	18609.0
2011-01-21	AIS	ETF	1.56	1.6	1.56	1.57	315665.0
2011-01-21	AIVI	ETF	45.45	45.59	45.28	45.53	12700.0
2011-01-21	AMJ	ETF	36.32	36.4	36.12	36.32	1094656.0
2011-01-21	AMLP	ETF	80.05	80.3	80.05	80.2	107440.0
2011-01-21	AOA	ETF	34.84	34.84	34.6	34.62	8300.0
2011-01-21	AOK	ETF	28.88	28.88	28.81	28.822	6482.0
2011-01-21	AOM	ETF	30.1	30.1	30.02	30.07	24769.0
2011-01-21	AOR	ETF	31.77	31.7794	31.71	31.74	12795.0
2011-01-21	ARB	ETF	40.56	41.18	40.38	40.58	171514.0
2011-01-21	BAB	ETF	24.9	25.07	24.87	25.07	184743.0
2011-01-21	BAL	ETF	79.71	81.12	79.71	80.86	50210.0
2011-01-21	BALT	ETF	10.21	10.26	9.92	9.96	172018.0
2011-01-21	BBH	ETF	34.2567	34.2967	34.1333	34.2067	17400.0
2011-01-21	BIB	ETF	7.8725	7.8725	7.6463	7.6638	18800.0
2011-01-21	BICK	ETF	32.35	32.55	32.09	32.15	39421.0
2011-01-21	BIL	ETF	91.7	91.72	91.7	91.7	55100.0
2011-01-21	BITS	ETF	29.04	29.04	28.32	28.8	2188.0
2011-01-21	BIV	ETF	82.41	82.62	82.31	82.59	107500.0
2011-01-21	BJK	ETF	32.74	32.74	32.37	32.38	16900.0
2011-01-21	BKF	ETF	49.23	49.3195	48.56	48.56	133147.0
2011-01-21	BLV	ETF	77.43	78.04	77.43	78.02	18100.0
2011-01-21	BMVP	ETF	14.86	14.86	14.76	14.76	7502.0
2011-01-21	BND	ETF	80.02	80.2	79.98	80.2	573300.0
2011-01-21	BNO	ETF	32.35	32.515	32.35	32.515	3000.0
2011-01-21	BRF	ETF	57.35	57.35	55.891	56.05	333684.0
2011-01-21	BSCE	ETF	20.79	20.81	20.75	20.8	7358.0
2011-01-21	BSV	ETF	80.45	80.52	80.43	80.52	359200.0
2011-01-21	BTF	ETF	78.5005	78.85	78.5005	78.7	400.0
2011-01-21	BWX	ETF	29.155	29.295	29.155	29.215	328002.0
2011-01-21	BWZ	ETF	37.06	37.28	37.06	37.22	13507.0
2011-01-21	BZQ	ETF	2452.8	2548.8	2451.2	2542.4	236.0
2011-01-21	CEF	ETF	18.33	18.58	18.19	18.33	2108900.0
2011-01-21	CEW	ETF	22.28	22.37	22.28	22.34	36928.0

> showing 50 of 821 rows — these rows as CSV

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