PREVIEW / etf_daily / 2010-08-20

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-20.parquet
  size:    33 KB
  rows:    769

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
2010-08-20	SPY	ETF	107.56	107.94	106.75	107.53	209714200.0
2010-08-20	QQQ	ETF	44.79	45.03	44.54	44.92	66806607.0
2010-08-20	IWM	ETF	60.87	61.19	60.14	61.15	64085700.0
2010-08-20	DIA	ETF	102.43	102.48	101.47	102.14	8548600.0
2010-08-20	GLD	ETF	119.97	120.07	119.45	119.97	10682100.0
2010-08-20	TLT	ETF	106.41	106.83	105.84	106.04	7040300.0
2010-08-20	AADR	ETF	25.31	25.31	25.29	25.3	1200.0
2010-08-20	AAXJ	ETF	55.67	55.67	55.23	55.59	122800.0
2010-08-20	ACWI	ETF	40.16	40.16	39.78	40.03	81200.0
2010-08-20	ACWX	ETF	38.03	38.07	37.788	38.07	31618.0
2010-08-20	ADRE	ETF	41.93	42.03	41.61	41.99	162361.0
2010-08-20	AFK	ETF	30.19	30.25	29.79	30.0	12957.0
2010-08-20	AGG	ETF	108.41	108.43	108.19	108.3	665300.0
2010-08-20	AGQ	ETF	116.54	116.64	113.4	115.1	184700.0
2010-08-20	AGZ	ETF	111.16	111.34	111.0535	111.09	11033.0
2010-08-20	AIA	ETF	39.35	39.47	39.27	39.4101	13473.0
2010-08-20	AIQ	ETF	23.3	23.6	23.15	23.35	18814.0
2010-08-20	AIS	ETF	1.55	1.61	1.52	1.6	577540.0
2010-08-20	AIVI	ETF	39.31	39.36	39.1	39.28	8200.0
2010-08-20	AMJ	ETF	32.41	32.68	32.31	32.67	952211.0
2010-08-20	AOA	ETF	29.25	29.32	29.12	29.32	17800.0
2010-08-20	AOK	ETF	27.78	27.78	27.698	27.76	14325.0
2010-08-20	AOM	ETF	28.13	28.17	28.11	28.17	11007.0
2010-08-20	AOR	ETF	28.58	28.64	28.5299	28.59	13627.0
2010-08-20	ARB	ETF	25.24	25.58	24.97	25.39	328221.0
2010-08-20	BAB	ETF	26.74	26.77	26.6712	26.71	178628.0
2010-08-20	BAL	ETF	40.7901	40.822	40.6101	40.6101	31793.0
2010-08-20	BALT	ETF	11.01	11.2	10.97	11.18	124369.0
2010-08-20	BBH	ETF	30.2733	30.3367	30.03	30.2433	71400.0
2010-08-20	BIB	ETF	5.5575	5.5888	5.555	5.5838	16000.0
2010-08-20	BICK	ETF	29.31	29.31	28.785	28.9805	7494.0
2010-08-20	BIL	ETF	91.72	91.72	91.7	91.72	84800.0
2010-08-20	BIS	ETF	11630.4	11632.0	11630.4	11632.0	1.25
2010-08-20	BITS	ETF	23.2796	24.44	22.8	24.32	12783.0
2010-08-20	BIV	ETF	86.19	86.2	85.92	85.95	138400.0
2010-08-20	BJK	ETF	25.44	25.62	25.37	25.61	3800.0
2010-08-20	BKF	ETF	44.12	44.38	43.894	44.3	42754.0
2010-08-20	BLV	ETF	86.68	86.89	86.15	86.34	42800.0
2010-08-20	BMVP	ETF	12.18	12.18	12.06	12.18	45930.0
2010-08-20	BND	ETF	82.59	82.6	82.44	82.46	626400.0
2010-08-20	BNE	ETF	11.11	11.16	11.09	11.15	511321.0
2010-08-20	BNO	ETF	25.2	25.2	25.03	25.06	14600.0
2010-08-20	BRF	ETF	50.91	51.34	50.59	51.16	536346.0
2010-08-20	BSCE	ETF	20.87	20.87	20.86	20.86	16050.0
2010-08-20	BSV	ETF	81.57	81.62	81.53	81.58	506600.0
2010-08-20	BTF	ETF	68.0	69.19999999999999	68.0	69.05	6466.6
2010-08-20	BWX	ETF	28.68	28.755	28.465	28.53	201364.0
2010-08-20	BWZ	ETF	35.14	35.14	34.97	35.0	7428.0
2010-08-20	BZQ	ETF	3424.0	3494.4	3414.4	3424.0	980.0
2010-08-20	CEF	ETF	14.94	14.97	14.8	14.91	582800.0

> showing 50 of 769 rows — these rows as CSV

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