PREVIEW / etf_daily / 2010-06-10

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-10.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-10	SPY	ETF	107.86	109.28	106.04	109.15	317890600.0
2010-06-10	QQQ	ETF	44.39	45.12	44.24	45.07	76892297.0
2010-06-10	IWM	ETF	63.03	64.08	62.8	64.07	75497300.0
2010-06-10	DIA	ETF	100.6	101.98	100.6	101.88	13825600.0
2010-06-10	GLD	ETF	119.36	120.04	118.83	118.97	13687900.0
2010-06-10	TLT	ETF	97.2	97.29	96.09	96.19	6075100.0
2010-06-10	AAXJ	ETF	51.29	52.57	51.29	52.49	158100.0
2010-06-10	ACWI	ETF	38.94	39.65	38.94	39.62	126500.0
2010-06-10	ACWX	ETF	36.34	36.85	36.24	36.82	608560.0
2010-06-10	ADRE	ETF	39.99	40.75	39.99	40.69	63779.0
2010-06-10	AFK	ETF	28.04	28.355	27.85	28.07	4278.0
2010-06-10	AGG	ETF	105.76	105.83	105.55	105.6	649200.0
2010-06-10	AGQ	ETF	118.14	124.02	118.0	121.28	143050.0
2010-06-10	AGZ	ETF	109.41	109.5	109.197	109.33	12053.0
2010-06-10	AIA	ETF	36.71	37.32	36.71	37.32	23768.0
2010-06-10	AIQ	ETF	24.4	25.85	24.25	25.85	20258.0
2010-06-10	AIS	ETF	1.84	1.85	1.68	1.68	765844.0
2010-06-10	AIVI	ETF	37.6	38.13	37.49	38.13	15100.0
2010-06-10	AMJ	ETF	29.74	30.15	29.53	29.77	455095.0
2010-06-10	AOA	ETF	29.07	29.23	28.9	29.23	1400.0
2010-06-10	AOK	ETF	27.42	27.421	27.381	27.421	2776.0
2010-06-10	AOM	ETF	27.89	27.915	27.801	27.8965	4722.0
2010-06-10	AOR	ETF	28.3825	28.48	28.32	28.48	3320.0
2010-06-10	ARB	ETF	28.44	28.8	27.85	28.7	182294.0
2010-06-10	BAB	ETF	25.97	26.0	25.7201	25.74	334226.0
2010-06-10	BAL	ETF	38.47	38.77	38.47	38.6	6035.0
2010-06-10	BALT	ETF	12.14	12.25	11.58	12.03	295554.0
2010-06-10	BBH	ETF	28.9	29.4033	28.9	29.3833	81600.0
2010-06-10	BIB	ETF	5.4262	5.5925	5.4262	5.5625	15440.0
2010-06-10	BICK	ETF	26.92	27.12	26.92	27.11	3600.0
2010-06-10	BIL	ETF	91.72	91.74	91.72	91.74	100750.0
2010-06-10	BIS	ETF	12380.8	12380.8	12006.4	12006.4	8.75
2010-06-10	BITS	ETF	27.4	27.84	27.2	27.84	1288.0
2010-06-10	BIV	ETF	82.01	82.07	81.65	81.75	201300.0
2010-06-10	BJK	ETF	23.72	24.09	23.72	24.09	8800.0
2010-06-10	BKF	ETF	41.62	42.15	41.27	42.02	78876.0
2010-06-10	BLV	ETF	79.69	79.71	78.96	78.96	47700.0
2010-06-10	BMVP	ETF	12.05	12.29	12.05	12.29	77217.0
2010-06-10	BND	ETF	80.36	80.45	80.2	80.23	845800.0
2010-06-10	BNE	ETF	11.2	11.2	11.09	11.15	861716.0
2010-06-10	BNO	ETF	25.7	25.875	25.625	25.875	21600.0
2010-06-10	BOSS	ETF	26.985	28.27	26.985	28.27	100.0
2010-06-10	BRF	ETF	42.71	43.774	42.71	43.5	286104.0
2010-06-10	BSCE	ETF	20.17	20.187	20.1667	20.1667	3320.0
2010-06-10	BSV	ETF	80.42	80.43	80.33	80.35	828000.0
2010-06-10	BTF	ETF	64.69999999999999	65.0	64.25	64.74999999999999	6163.400000000001
2010-06-10	BWX	ETF	26.5	26.62	26.33	26.43	413546.0
2010-06-10	BWZ	ETF	33.12	33.334	33.12	33.191	10633.0
2010-06-10	BZQ	ETF	4228.8	4230.4	4078.4	4108.8	1219.5
2010-06-10	CEF	ETF	14.8	14.92	14.71	14.88	810300.0

> showing 50 of 758 rows — these rows as CSV

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