PREVIEW / etf_daily / 2010-06-04

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-04.parquet
  size:    33 KB
  rows:    755

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-04	SPY	ETF	108.61	109.33	106.46	106.82	398475600.0
2010-06-04	QQQ	ETF	45.71	46.29	44.9375	45.0925	112849844.0
2010-06-04	IWM	ETF	65.11	65.7	63.37	63.56	105547200.0
2010-06-04	DIA	ETF	100.97	101.18	99.0	99.44	20047200.0
2010-06-04	GLD	ETF	117.96	119.39	117.05	119.19	16532500.0
2010-06-04	TLT	ETF	96.94	97.95	96.7	97.79	7479600.0
2010-06-04	AAXJ	ETF	52.49	52.49	51.21	51.4	303800.0
2010-06-04	ACWI	ETF	39.56	39.56	38.27	38.43	101500.0
2010-06-04	ACWX	ETF	36.47	38.24	35.47	35.47	56839.0
2010-06-04	ADRE	ETF	39.44	40.06	39.06	39.18	91614.0
2010-06-04	AFK	ETF	28.73	28.74	27.8901	27.8901	3206.0
2010-06-04	AGG	ETF	105.67	105.82	105.51	105.67	1365400.0
2010-06-04	AGQ	ETF	114.0	114.5	109.7	111.12	317600.0
2010-06-04	AGZ	ETF	109.34	109.35	108.87	109.35	22918.0
2010-06-04	AIA	ETF	36.64	36.888	36.2348	36.289	11347.0
2010-06-04	AIQ	ETF	26.75	27.05	25.55	25.65	25209.0
2010-06-04	AIS	ETF	1.61	1.72	1.59	1.67	1061950.0
2010-06-04	AIVI	ETF	37.32	37.35	36.41	36.41	47500.0
2010-06-04	AMJ	ETF	29.03	29.69	29.03	29.22	421200.0
2010-06-04	AOA	ETF	29.11	29.24	28.56	28.56	7900.0
2010-06-04	AOK	ETF	27.37	27.47	27.26	27.307	16191.0
2010-06-04	AOM	ETF	27.76	27.76	27.58	27.58	974.0
2010-06-04	AOR	ETF	28.4595	28.4595	28.0481	28.05	7954.0
2010-06-04	ARB	ETF	30.41	30.68	29.69	29.82	305458.0
2010-06-04	BAB	ETF	26.0	26.1	25.866	26.08	269604.0
2010-06-04	BAL	ETF	36.31	36.31	36.2	36.2	4231.0
2010-06-04	BALT	ETF	12.26	12.3	11.8	11.99	113056.0
2010-06-04	BBH	ETF	30.0667	30.0667	29.4533	29.4533	261900.0
2010-06-04	BIB	ETF	5.7275	5.7275	5.5888	5.5975	4888.0
2010-06-04	BICK	ETF	27.01	27.01	26.665	26.68	957.0
2010-06-04	BIL	ETF	91.7	91.74	91.7	91.74	495850.0
2010-06-04	BITS	ETF	28.8	28.8	27.4	28.04	850.0
2010-06-04	BIV	ETF	81.96	82.2	81.75	82.17	149700.0
2010-06-04	BJK	ETF	24.12	24.12	23.39	23.39	12300.0
2010-06-04	BKF	ETF	40.87	41.432	40.21	40.4736	210043.0
2010-06-04	BLV	ETF	79.71	80.0	79.51	79.89	47100.0
2010-06-04	BMVP	ETF	12.29	12.34	12.04	12.04	11200.0
2010-06-04	BND	ETF	80.32	80.47	80.24	80.34	2046300.0
2010-06-04	BNE	ETF	11.06	11.07	11.01	11.03	385330.0
2010-06-04	BNO	ETF	25.245	25.245	24.67	24.7	12000.0
2010-06-04	BRF	ETF	41.91	42.45	41.178	41.38	405319.0
2010-06-04	BSV	ETF	80.38	80.49	80.32	80.49	346900.0
2010-06-04	BTF	ETF	65.44999999999999	65.44999999999999	63.449999999999996	64.3	3832.8
2010-06-04	BWX	ETF	26.11	26.395	26.11	26.305	5069074.0
2010-06-04	BWZ	ETF	33.25	33.25	33.01	33.01	22284.0
2010-06-04	BZQ	ETF	4444.8	4616.0	4344.0	4572.8	958.0
2010-06-04	CEF	ETF	14.71	14.72	14.55	14.59	1829100.0
2010-06-04	CEW	ETF	21.12	21.17	20.98	20.98	89743.0
2010-06-04	CGO	ETF	13.09	13.18	12.92	12.96	13964.0
2010-06-04	CGW	ETF	16.61	16.694	16.24	16.3	190998.0

> showing 50 of 755 rows — these rows as CSV

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