PREVIEW / etf_daily / 2010-06-03

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-03.parquet
  size:    33 KB
  rows:    757

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-06-03	SPY	ETF	110.65	111.06	109.58	110.71	226618300.0
2010-06-03	QQQ	ETF	46.36	46.77	46.08	46.69	98928390.0
2010-06-03	IWM	ETF	66.2	67.09	65.87	66.92	74864100.0
2010-06-03	DIA	ETF	102.99	103.26	101.84	102.69	11856600.0
2010-06-03	GLD	ETF	119.16	119.39	117.48	117.96	13855200.0
2010-06-03	TLT	ETF	95.21	95.91	95.1	95.23	8499500.0
2010-06-03	AAXJ	ETF	53.22	53.22	52.36	52.92	599400.0
2010-06-03	ACWI	ETF	40.3	40.3	39.59	40.0	168900.0
2010-06-03	ACWX	ETF	37.38	37.38	36.64	36.97	40663.0
2010-06-03	ADRE	ETF	41.08	41.08	39.95	40.53	68892.0
2010-06-03	AFK	ETF	29.29	29.48	28.7301	28.7301	10950.0
2010-06-03	AGG	ETF	105.32	105.51	105.23	105.4	1231300.0
2010-06-03	AGQ	ETF	123.38	123.68	116.6	118.84	161050.0
2010-06-03	AGZ	ETF	108.78	109.09	108.78	108.92	16005.0
2010-06-03	AIA	ETF	37.35	37.5699	37.0	37.23	23961.0
2010-06-03	AIQ	ETF	27.3	28.05	26.9	27.45	25010.0
2010-06-03	AIS	ETF	1.68	1.69	1.62	1.65	331819.0
2010-06-03	AIVI	ETF	38.47	38.47	37.75	38.11	4800.0
2010-06-03	AMJ	ETF	29.34	29.8	29.11	29.78	933589.0
2010-06-03	AOA	ETF	29.57	29.6	29.48	29.48	800.0
2010-06-03	AOK	ETF	27.46	27.552	27.46	27.552	20997.0
2010-06-03	AOM	ETF	28.0101	28.0599	27.9813	28.0175	22943.0
2010-06-03	AOR	ETF	28.74	28.74	28.56	28.65	6802.0
2010-06-03	ARB	ETF	30.12	31.29	30.0	31.15	200884.0
2010-06-03	BAB	ETF	25.98	25.98	25.786	25.8	354452.0
2010-06-03	BAL	ETF	37.05	37.1199	36.72	36.95	16428.0
2010-06-03	BALT	ETF	12.36	12.51	12.07	12.42	101156.0
2010-06-03	BBH	ETF	30.3233	30.49	30.1667	30.4467	83100.0
2010-06-03	BIB	ETF	5.9463	6.0533	5.9463	6.0525	4928.0
2010-06-03	BICK	ETF	27.33	27.55	26.89	26.89	15985.0
2010-06-03	BIL	ETF	91.7	91.74	91.7	91.7	219900.0
2010-06-03	BIS	ETF	11400.0	11409.584	11278.4	11286.4	18.35
2010-06-03	BITS	ETF	28.12	29.24	28.04	28.6	1075.0
2010-06-03	BIV	ETF	81.44	81.61	81.22	81.5	173200.0
2010-06-03	BJK	ETF	24.67	24.68	24.12	24.51	20400.0
2010-06-03	BKF	ETF	42.11	42.31	41.34	41.86	418905.0
2010-06-03	BLV	ETF	79.9	79.9	78.65	78.93	37300.0
2010-06-03	BMVP	ETF	12.48	12.54	12.44	12.52	11336.0
2010-06-03	BND	ETF	80.0	80.19	80.0	80.12	1188600.0
2010-06-03	BNE	ETF	11.06	11.12	11.02	11.08	400008.0
2010-06-03	BNO	ETF	25.715	25.915	25.42	25.83	66800.0
2010-06-03	BRF	ETF	43.14	43.5	41.531	42.46	171096.0
2010-06-03	BSV	ETF	80.28	80.31	80.19	80.19	572900.0
2010-06-03	BTF	ETF	65.8	66.44999999999999	65.6	65.94999999999999	5026.8
2010-06-03	BWX	ETF	26.445	26.45	26.2151	26.295	282696.0
2010-06-03	BWZ	ETF	33.08	33.3801	33.08	33.134	34736.0
2010-06-03	BZQ	ETF	4144.0	4467.2	4097.6	4276.8	1131.0
2010-06-03	CEF	ETF	15.0	15.07	14.71	14.73	1055300.0
2010-06-03	CEW	ETF	21.33	21.41	21.19	21.22	177258.0
2010-06-03	CGO	ETF	13.41	13.41	13.1	13.23	9955.0

> showing 50 of 757 rows — these rows as CSV

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