PREVIEW / etf_daily / 2010-06-07

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-07.parquet
  size:    33 KB
  rows:    758

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-07	SPY	ETF	107.2	107.61	105.41	105.49	264609100.0
2010-06-07	QQQ	ETF	45.34	45.46	44.22	44.27	88436587.0
2010-06-07	IWM	ETF	63.84	64.11	61.86	61.92	88434200.0
2010-06-07	DIA	ETF	99.66	99.92	98.2	98.27	13694600.0
2010-06-07	GLD	ETF	118.73	121.8	118.62	121.49	20238600.0
2010-06-07	TLT	ETF	97.52	98.59	97.33	98.54	5288200.0
2010-06-07	AAXJ	ETF	51.75	51.75	50.53	50.53	365700.0
2010-06-07	ACWI	ETF	38.77	38.77	37.9	37.9	103300.0
2010-06-07	ACWX	ETF	35.76	35.8	35.05	35.05	20326.0
2010-06-07	ADRE	ETF	39.38	39.422	38.54	38.54	126314.0
2010-06-07	AFK	ETF	28.11	28.13	27.591	27.706	4498.0
2010-06-07	AGG	ETF	105.57	105.99	105.57	105.98	417100.0
2010-06-07	AGQ	ETF	109.98	122.26	109.86	121.04	397400.0
2010-06-07	AGZ	ETF	109.39	109.6	109.362	109.485	9050.0
2010-06-07	AIA	ETF	36.17	36.4799	35.8	35.8	22185.0
2010-06-07	AIQ	ETF	25.55	25.8	24.75	24.85	23262.0
2010-06-07	AIS	ETF	1.67	1.75	1.61	1.65	1121566.0
2010-06-07	AIVI	ETF	36.61	36.79	36.44	36.44	19200.0
2010-06-07	AMJ	ETF	29.21	29.57	28.87	28.94	1035687.0
2010-06-07	AOA	ETF	28.66	28.73	28.23	28.23	26200.0
2010-06-07	AOK	ETF	27.34	27.34	27.268	27.268	5940.0
2010-06-07	AOM	ETF	27.62	27.6799	27.54	27.54	3660.0
2010-06-07	AOR	ETF	28.09	28.16	27.8301	27.88	15139.0
2010-06-07	ARB	ETF	29.92	30.07	28.16	28.22	158313.0
2010-06-07	BAB	ETF	26.03	26.06	25.9237	26.06	207635.0
2010-06-07	BAL	ETF	36.09	36.5	35.84	36.372	2409.0
2010-06-07	BALT	ETF	11.96	12.31	11.86	11.86	277894.0
2010-06-07	BBH	ETF	29.6	29.6	29.1967	29.2	157200.0
2010-06-07	BIB	ETF	5.645	5.645	5.445	5.445	6400.0
2010-06-07	BICK	ETF	26.81	26.81	26.3	26.3	4853.0
2010-06-07	BIL	ETF	91.72	91.74	91.7	91.72	158800.0
2010-06-07	BIS	ETF	12296.0	12435.2	12129.6	12435.2	20.0
2010-06-07	BITS	ETF	27.92	28.0	27.6	27.76	888.0
2010-06-07	BIV	ETF	82.3	82.39	82.01	82.38	144500.0
2010-06-07	BJK	ETF	23.46	23.59	22.78	22.78	10500.0
2010-06-07	BKF	ETF	40.46	40.71	39.75	39.75	124969.0
2010-06-07	BLV	ETF	80.17	80.57	79.83	80.49	64900.0
2010-06-07	BMVP	ETF	12.067	12.097	11.873	11.899	17810.0
2010-06-07	BND	ETF	80.31	80.61	80.31	80.59	472900.0
2010-06-07	BNE	ETF	11.06	11.06	11.02	11.03	316013.0
2010-06-07	BNO	ETF	24.8	24.985	24.565	24.795	29000.0
2010-06-07	BRF	ETF	41.61	41.79	40.83	40.9	213753.0
2010-06-07	BSCE	ETF	20.12	20.17	20.12	20.17	4650.0
2010-06-07	BSV	ETF	80.53	80.54	80.42	80.54	721500.0
2010-06-07	BTF	ETF	64.0	64.64999999999999	62.99999999999999	62.99999999999999	2663.8
2010-06-07	BWX	ETF	26.26	26.26	26.1287	26.1287	279412.0
2010-06-07	BWZ	ETF	33.02	33.02	32.87	32.87	11251.0
2010-06-07	BZQ	ETF	4558.4	4750.4	4496.0	4736.0	997.5
2010-06-07	CEF	ETF	14.55	15.03	14.53	15.03	1552000.0
2010-06-07	CEW	ETF	20.94	21.05	20.89	20.89	56528.0

> showing 50 of 758 rows — these rows as CSV

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