PREVIEW / etf_daily / 2010-05-05

all etf daily files

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

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-05	SPY	ETF	116.56	117.8	115.97	116.82	328973200.0
2010-05-05	QQQ	ETF	47.98	48.5	47.64	48.18	128560164.0
2010-05-05	IWM	ETF	70.38	70.95	69.39	69.92	110340400.0
2010-05-05	DIA	ETF	108.55	109.56	108.25	108.8	18900400.0
2010-05-05	GLD	ETF	113.58	115.24	113.31	115.09	21616700.0
2010-05-05	TLT	ETF	94.06	94.85	93.35	93.89	12219100.0
2010-05-05	AAXJ	ETF	54.64	55.13	54.01	54.58	194500.0
2010-05-05	ACWI	ETF	41.64	42.19	41.52	41.66	667600.0
2010-05-05	ACWX	ETF	38.54	39.1746	38.524	38.68	257060.0
2010-05-05	ADRE	ETF	41.35	42.15	40.85	41.54	331325.0
2010-05-05	AFK	ETF	30.33	30.69	29.58	30.17	35068.0
2010-05-05	AGG	ETF	104.89	105.0	104.72	104.72	662400.0
2010-05-05	AGQ	ETF	110.64	115.76	108.6	113.36	525800.0
2010-05-05	AGZ	ETF	108.48	108.72	108.3601	108.5932	14934.0
2010-05-05	AIA	ETF	39.02	39.46	38.63	39.013	44957.0
2010-05-05	AIQ	ETF	27.05	27.75	26.5	26.95	33713.0
2010-05-05	AIS	ETF	1.62	1.66	1.54	1.66	1964377.0
2010-05-05	AIVI	ETF	39.54	40.0	39.31	39.44	65000.0
2010-05-05	AMJ	ETF	30.76	30.76	29.0	30.05	1479633.0
2010-05-05	AOA	ETF	31.05	31.22	30.75	30.97	13900.0
2010-05-05	AOK	ETF	27.91	27.93	27.72	27.922	13842.0
2010-05-05	AOM	ETF	28.6	28.6587	28.48	28.5666	9597.0
2010-05-05	AOR	ETF	29.5	29.7	29.41	29.53	8155.0
2010-05-05	ARB	ETF	31.88	32.08	31.09	31.27	493564.0
2010-05-05	BAB	ETF	26.0	26.21	25.95	26.04	124931.0
2010-05-05	BAL	ETF	37.89	38.9	37.87	38.81	4644.0
2010-05-05	BALT	ETF	13.25	13.43	12.81	13.17	304733.0
2010-05-05	BBH	ETF	31.57	32.15	31.57	32.1233	99600.0
2010-05-05	BIB	ETF	6.9375	6.9375	6.7712	6.9162	6720.0
2010-05-05	BICK	ETF	28.08	28.56	28.0	28.3	30331.0
2010-05-05	BIL	ETF	91.7	91.7	91.68	91.7	287000.0
2010-05-05	BIS	ETF	10355.2	10356.8	10230.24	10256.016	18.75
2010-05-05	BITS	ETF	31.7596	31.7596	31.0404	31.2	741.0
2010-05-05	BIV	ETF	81.22	81.53	81.03	81.31	89900.0
2010-05-05	BJK	ETF	25.92	26.23	25.26	25.59	54000.0
2010-05-05	BKF	ETF	42.88	43.6468	42.4	43.13	370789.0
2010-05-05	BLV	ETF	79.18	79.78	78.71	78.96	46400.0
2010-05-05	BMVP	ETF	13.19	13.35	13.1794	13.2167	20322.0
2010-05-05	BND	ETF	79.87	79.99	79.75	79.79	504900.0
2010-05-05	BNE	ETF	11.23	11.25	11.18	11.18	1119531.0
2010-05-05	BRF	ETF	44.28	44.892	43.13	44.34	830343.0
2010-05-05	BSV	ETF	80.14	80.29	80.14	80.14	338900.0
2010-05-05	BTF	ETF	72.39999999999999	72.39999999999999	70.89999999999999	71.3	12732.800000000001
2010-05-05	BWX	ETF	26.8	26.985	26.8	26.805	410294.0
2010-05-05	BWZ	ETF	34.38	34.48	34.17	34.414	35973.0
2010-05-05	BZQ	ETF	4249.6	4353.6	4027.2	4171.2	1471.0
2010-05-05	CEF	ETF	14.52	14.78	14.4	14.66	1235700.0
2010-05-05	CEW	ETF	21.81	21.9	21.74	21.75	131919.0
2010-05-05	CGO	ETF	14.39	14.44	13.95	14.2	60764.0
2010-05-05	CGW	ETF	17.91	17.98	17.73	17.78	86305.0

> showing 50 of 754 rows — these rows as CSV

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