PREVIEW / etf_daily / 2010-04-16

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-16.parquet
  size:    33 KB
  rows:    750

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-04-16	SPY	ETF	120.86	121.29	118.75	119.36	366786700.0
2010-04-16	QQQ	ETF	49.95	50.12	49.2	49.53	127387937.0
2010-04-16	IWM	ETF	72.24	72.47	70.94	71.46	93241600.0
2010-04-16	DIA	ETF	111.26	111.5	109.7	110.18	22103600.0
2010-04-16	GLD	ETF	112.5	113.07	110.54	111.24	24572600.0
2010-04-16	TLT	ETF	89.4	89.99	89.24	89.86	8303900.0
2010-04-16	AAXJ	ETF	58.37	58.39	57.28	57.59	180500.0
2010-04-16	ACWI	ETF	45.06	45.06	44.12	44.34	747400.0
2010-04-16	ACWX	ETF	42.86	42.92	42.056	42.24	65288.0
2010-04-16	ADRE	ETF	45.2	45.31	44.23	44.46	204878.0
2010-04-16	AFK	ETF	32.77	32.88	31.9701	32.38	37359.0
2010-04-16	AGG	ETF	104.3	104.5	104.22	104.42	479300.0
2010-04-16	AGQ	ETF	125.36	126.68	116.82	118.78	451350.0
2010-04-16	AGZ	ETF	108.29	108.385	108.165	108.31	9444.0
2010-04-16	AIA	ETF	41.97	42.01	41.089	41.372	15408.0
2010-04-16	AIQ	ETF	28.15	29.5	28.15	28.9	46511.0
2010-04-16	AIS	ETF	1.6	1.6	1.51	1.54	761792.0
2010-04-16	AIVI	ETF	44.14	44.3	43.53	43.79	26500.0
2010-04-16	AMJ	ETF	31.3	31.33	30.68	31.0	549121.0
2010-04-16	AOA	ETF	32.61	32.61	32.11	32.19	22100.0
2010-04-16	AOK	ETF	28.15	28.15	27.982	28.04	14425.0
2010-04-16	AOM	ETF	29.18	29.18	28.965	29.03	15379.0
2010-04-16	AOR	ETF	30.45	30.45	30.12	30.2174	21271.0
2010-04-16	ARB	ETF	27.59	27.96	27.15	27.21	147714.0
2010-04-16	BAB	ETF	25.1	25.2	25.016	25.18	338773.0
2010-04-16	BAL	ETF	38.25	38.63	38.23	38.62	2116.0
2010-04-16	BALT	ETF	13.78	13.78	13.5	13.63	183144.0
2010-04-16	BBH	ETF	34.4167	34.6333	34.2033	34.5367	105600.0
2010-04-16	BIB	ETF	7.475	7.475	7.4538	7.4538	4800.0
2010-04-16	BICK	ETF	30.04	30.14	29.38	29.45	38473.0
2010-04-16	BIL	ETF	91.68	91.7	91.68	91.68	263250.0
2010-04-16	BIS	ETF	9456.0	9612.8	9456.0	9552.0	6.25
2010-04-16	BITS	ETF	31.8	32.2	31.4	31.84	911.0
2010-04-16	BIV	ETF	80.39	80.7	80.38	80.7	134500.0
2010-04-16	BJK	ETF	27.12	27.12	26.25	26.43	17300.0
2010-04-16	BKF	ETF	47.36	47.57	46.21	46.61	285458.0
2010-04-16	BLV	ETF	77.29	77.44	77.18	77.42	16400.0
2010-04-16	BMVP	ETF	13.69	13.73	13.5	13.56	30324.0
2010-04-16	BND	ETF	79.31	79.42	79.25	79.41	481900.0
2010-04-16	BNE	ETF	11.14	11.16	11.13	11.14	847167.0
2010-04-16	BRF	ETF	46.71	46.9	45.69	46.15	538982.0
2010-04-16	BSV	ETF	80.0	80.14	79.93	80.11	369900.0
2010-04-16	BTF	ETF	74.45	75.0	73.79599999999999	74.06949999999999	6568.0
2010-04-16	BWX	ETF	28.0	28.0	27.86	27.86	367470.0
2010-04-16	BWZ	ETF	35.43	35.89	35.43	35.8499	34555.0
2010-04-16	BZQ	ETF	3473.6	3640.0	3456.0	3587.2	759.5
2010-04-16	CEF	ETF	14.53	14.58	14.14	14.3	1806600.0
2010-04-16	CEW	ETF	22.44	22.48	22.33	22.4	186181.0
2010-04-16	CGO	ETF	14.85	14.95	14.72	14.8399	26124.0
2010-04-16	CGW	ETF	18.97	18.98	18.669	18.75	52514.0

> showing 50 of 750 rows — these rows as CSV

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