PREVIEW / etf_daily / 2010-05-17

all etf daily files

  file:    by_date/etf_daily/2010/2010-05-17.parquet
  size:    33 KB
  rows:    760

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-05-17	SPY	ETF	114.2	114.52	111.77	113.95	325739800.0
2010-05-17	QQQ	ETF	47.04	47.27	46.07	47.08	120969513.0
2010-05-17	IWM	ETF	70.0	70.57	67.75	69.69	78565900.0
2010-05-17	DIA	ETF	106.69	106.92	104.66	106.52	17552200.0
2010-05-17	GLD	ETF	120.55	121.12	119.29	119.36	27898000.0
2010-05-17	TLT	ETF	94.72	95.71	94.47	94.53	6302200.0
2010-05-17	AAXJ	ETF	53.84	54.01	52.64	53.55	219700.0
2010-05-17	ACWI	ETF	40.96	41.18	40.16	40.97	200500.0
2010-05-17	ACWX	ETF	37.93	37.99	37.1544	37.81	100924.0
2010-05-17	ADRE	ETF	40.69	41.21	39.83	40.68	301730.0
2010-05-17	AFK	ETF	30.23	30.336	29.55	29.68	14196.0
2010-05-17	AGG	ETF	105.13	105.49	105.05	105.13	312900.0
2010-05-17	AGQ	ETF	138.32	138.66	129.6	131.82	293600.0
2010-05-17	AGZ	ETF	108.87	109.13	108.821	108.96	9743.0
2010-05-17	AIA	ETF	38.31	38.65	37.78	38.42	30118.0
2010-05-17	AIQ	ETF	27.35	28.9	26.9	28.75	39434.0
2010-05-17	AIS	ETF	1.69	1.69	1.59	1.69	788124.0
2010-05-17	AIVI	ETF	38.54	38.79	37.82	38.66	26400.0
2010-05-17	AMJ	ETF	30.36	30.38	29.35	29.76	1108300.0
2010-05-17	AOA	ETF	30.56	30.56	29.96	30.41	34700.0
2010-05-17	AOK	ETF	27.7601	27.7601	27.682	27.702	10526.0
2010-05-17	AOM	ETF	28.4	28.4	28.13	28.3305	15816.0
2010-05-17	AOR	ETF	29.26	29.26	28.9291	29.08	11086.0
2010-05-17	ARB	ETF	32.11	32.83	31.51	32.66	117194.0
2010-05-17	BAB	ETF	26.0	26.09	25.85	25.87	194005.0
2010-05-17	BAL	ETF	38.7	38.7	38.2801	38.2801	23266.0
2010-05-17	BALT	ETF	12.78	12.97	12.4	12.71	99836.0
2010-05-17	BBH	ETF	30.75	30.95	30.4167	30.89	174000.0
2010-05-17	BIB	ETF	6.4175	6.4175	6.1575	6.1575	16800.0
2010-05-17	BICK	ETF	27.84	28.06	27.27	27.69	17858.0
2010-05-17	BIL	ETF	91.72	91.72	91.7	91.72	140300.0
2010-05-17	BIS	ETF	10905.6	10905.6	10900.0	10900.0	1.25
2010-05-17	BITS	ETF	30.48	30.48	30.4	30.48	250.0
2010-05-17	BIV	ETF	81.67	81.91	81.45	81.54	105600.0
2010-05-17	BJK	ETF	24.95	25.01	24.27	24.76	13700.0
2010-05-17	BKF	ETF	42.06	42.4	41.06	42.1	267415.0
2010-05-17	BLV	ETF	79.45	80.01	79.13	79.13	27300.0
2010-05-17	BMVP	ETF	13.0	13.01	12.77	13.0	86364.0
2010-05-17	BND	ETF	80.22	80.38	80.07	80.13	380900.0
2010-05-17	BNE	ETF	11.1	11.14	11.05	11.14	888600.0
2010-05-17	BRF	ETF	42.53	42.53	40.64	42.1	371890.0
2010-05-17	BSV	ETF	80.42	80.49	80.3	80.39	454000.0
2010-05-17	BTF	ETF	68.75	68.89999999999999	67.85	68.05	5787.8
2010-05-17	BWX	ETF	26.4	26.51	26.34	26.39	504866.0
2010-05-17	BWZ	ETF	33.43	33.8	33.43	33.68	51278.0
2010-05-17	BZQ	ETF	4219.2	4536.0	4134.4	4296.0	1795.0
2010-05-17	CEF	ETF	15.23	15.3	14.88	14.94	2209600.0
2010-05-17	CEW	ETF	21.69	21.733	21.53	21.64	71074.0
2010-05-17	CGO	ETF	13.48	13.67	13.28	13.45	36491.0
2010-05-17	CGW	ETF	17.25	17.4	16.94	17.37	59721.0

> showing 50 of 760 rows — these rows as CSV

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