PREVIEW / etf_daily / 2010-03-17

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-17.parquet
  size:    32 KB
  rows:    730

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-03-17	SPY	ETF	116.76	117.48	116.42	117.1	177468100.0
2010-03-17	QQQ	ETF	47.6	47.9	47.53	47.67	75643457.0
2010-03-17	IWM	ETF	68.22	68.88	68.2	68.47	53589100.0
2010-03-17	DIA	ETF	107.31	107.87	107.23	107.52	6989400.0
2010-03-17	GLD	ETF	110.18	110.46	109.55	109.59	13784300.0
2010-03-17	TLT	ETF	91.31	91.47	91.07	91.47	3481200.0
2010-03-17	AAXJ	ETF	56.65	57.02	56.35	56.73	202600.0
2010-03-17	ACWI	ETF	43.63	43.81	43.5	43.68	175200.0
2010-03-17	ACWX	ETF	41.74	42.0	41.72	41.84	73958.0
2010-03-17	ADRE	ETF	44.15	44.43	44.03	44.14	102534.0
2010-03-17	AFK	ETF	30.69	31.06	30.4701	31.0184	8043.0
2010-03-17	AGG	ETF	104.8	104.97	104.8	104.92	662100.0
2010-03-17	AGQ	ETF	115.14	117.02	114.92	115.58	155000.0
2010-03-17	AGZ	ETF	108.29	108.57	108.29	108.44	17391.0
2010-03-17	AIA	ETF	40.29	40.56	40.18	40.53	22098.0
2010-03-17	AIQ	ETF	27.8	28.4	27.55	28.25	35306.0
2010-03-17	AIS	ETF	1.47	1.48	1.43	1.48	233510.0
2010-03-17	AIVI	ETF	42.9	43.24	42.88	43.04	19100.0
2010-03-17	AMJ	ETF	30.54	30.6	30.47	30.58	518349.0
2010-03-17	AOA	ETF	31.56	31.73	31.46	31.64	18200.0
2010-03-17	AOK	ETF	27.95	27.98	27.886	27.97	10256.0
2010-03-17	AOM	ETF	28.84	28.8999	28.77	28.829	18876.0
2010-03-17	AOR	ETF	29.87	29.9699	29.82	29.93	7919.0
2010-03-17	ARB	ETF	24.65	25.04	24.56	24.92	85488.0
2010-03-17	BAB	ETF	25.05	25.084	25.02	25.08	180008.0
2010-03-17	BAL	ETF	39.246	39.246	39.0201	39.125	809.0
2010-03-17	BALT	ETF	13.99	14.0	13.75	13.76	297931.0
2010-03-17	BBH	ETF	34.75	34.8733	34.62	34.7433	131100.0
2010-03-17	BIL	ETF	91.7	91.7	91.68	91.68	228250.0
2010-03-17	BITS	ETF	32.84	32.84	32.52	32.8	350.0
2010-03-17	BIV	ETF	80.95	81.01	80.88	81.01	110500.0
2010-03-17	BJK	ETF	25.05	25.35	24.99	25.04	27500.0
2010-03-17	BKF	ETF	46.69	46.77	46.36	46.56	286135.0
2010-03-17	BLV	ETF	77.88	78.07	77.75	77.98	11400.0
2010-03-17	BMVP	ETF	13.17	13.32	13.17	13.27	22322.0
2010-03-17	BND	ETF	79.59	79.62	79.55	79.62	380500.0
2010-03-17	BNE	ETF	11.28	11.3	11.26	11.29	933156.0
2010-03-17	BRF	ETF	47.28	47.32	46.36	46.66	448811.0
2010-03-17	BSV	ETF	80.24	80.24	80.17	80.24	344800.0
2010-03-17	BTF	ETF	74.5	74.64999999999999	74.3	74.6	7047.0
2010-03-17	BWX	ETF	28.255	28.61	28.255	28.51	539786.0
2010-03-17	BWZ	ETF	36.3	36.3	36.0501	36.27	14795.0
2010-03-17	BZQ	ETF	3516.8	3633.6	3502.4	3611.2	659.5
2010-03-17	CEF	ETF	14.21	14.23	14.14	14.16	674900.0
2010-03-17	CEW	ETF	22.25	22.27	22.21	22.25	121291.0
2010-03-17	CGO	ETF	14.57	14.672	14.57	14.65	29519.0
2010-03-17	CGW	ETF	18.34	18.4396	18.25	18.33	69961.0
2010-03-17	CHI	ETF	12.64	12.699	12.62	12.68	171822.0
2010-03-17	CHIE	ETF	14.49	14.52	14.45	14.46	3266.0
2010-03-17	CHII	ETF	15.28	15.37	15.24	15.27	5032.0

> showing 50 of 730 rows — these rows as CSV

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