PREVIEW / etf_daily / 2010-05-03

all etf daily files

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

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-03	SPY	ETF	119.38	120.68	119.2	120.35	182747900.0
2010-05-03	QQQ	ETF	49.43	50.17	49.43	49.93	74169603.0
2010-05-03	IWM	ETF	72.1	73.31	72.06	73.26	53775400.0
2010-05-03	DIA	ETF	110.57	111.82	110.57	111.54	8324800.0
2010-05-03	GLD	ETF	115.91	116.28	115.53	115.73	13570800.0
2010-05-03	TLT	ETF	91.42	92.02	91.28	91.69	4211800.0
2010-05-03	AAXJ	ETF	56.79	57.44	56.79	57.24	125300.0
2010-05-03	ACWI	ETF	43.78	44.0	43.55	43.93	143100.0
2010-05-03	ACWX	ETF	40.94	41.21	40.79	41.07	145790.0
2010-05-03	ADRE	ETF	43.98	44.29	43.7	43.93	198675.0
2010-05-03	AFK	ETF	31.89	32.03	31.3	31.6001	6919.0
2010-05-03	AGG	ETF	104.4	104.49	104.25	104.38	638600.0
2010-05-03	AGQ	ETF	132.34	133.22	129.94	132.1	145300.0
2010-05-03	AGZ	ETF	108.19	108.24	108.06	108.06	7610.0
2010-05-03	AIA	ETF	40.45	40.9597	40.45	40.92	16559.0
2010-05-03	AIQ	ETF	26.95	28.3	26.7	28.25	32301.0
2010-05-03	AIS	ETF	1.59	1.59	1.54	1.58	408936.0
2010-05-03	AIVI	ETF	42.0	42.41	42.0	42.41	12500.0
2010-05-03	AMJ	ETF	31.47	31.59	31.21	31.52	236226.0
2010-05-03	AOA	ETF	32.03	32.28	32.0	32.16	20400.0
2010-05-03	AOK	ETF	28.14	28.2	28.1	28.1656	2299.0
2010-05-03	AOM	ETF	29.0	29.0454	28.9754	29.032	6488.0
2010-05-03	AOR	ETF	30.14	30.3	30.0901	30.27	7631.0
2010-05-03	ARB	ETF	30.88	33.35	30.7	33.06	220815.0
2010-05-03	BAB	ETF	25.61	25.67	25.5782	25.67	155997.0
2010-05-03	BAL	ETF	39.75	40.01	39.28	39.32	2211.0
2010-05-03	BALT	ETF	13.86	13.974	13.75	13.82	263013.0
2010-05-03	BBH	ETF	32.27	32.66	32.27	32.49	114600.0
2010-05-03	BIB	ETF	7.4037	7.5713	7.4	7.5388	18400.0
2010-05-03	BICK	ETF	29.75	29.89	29.61	29.83	10878.0
2010-05-03	BIL	ETF	91.7	91.7	91.68	91.7	228150.0
2010-05-03	BIS	ETF	9652.8	9652.8	9507.2	9507.2	8.1
2010-05-03	BITS	ETF	31.28	31.76	30.12	31.68	6532.0
2010-05-03	BIV	ETF	80.85	80.92	80.7	80.79	147600.0
2010-05-03	BJK	ETF	27.26	27.67	27.15	27.51	56000.0
2010-05-03	BKF	ETF	46.06	46.06	45.5	45.7	211520.0
2010-05-03	BLV	ETF	78.3	78.33	77.96	78.33	21900.0
2010-05-03	BMVP	ETF	13.5067	13.6851	13.5067	13.67	18914.0
2010-05-03	BND	ETF	79.45	79.53	79.37	79.52	533800.0
2010-05-03	BNE	ETF	11.23	11.26	11.18	11.26	538660.0
2010-05-03	BOSS	ETF	26.2	26.2	25.955	25.955	100.0
2010-05-03	BRF	ETF	47.04	47.53	46.74	47.46	413844.0
2010-05-03	BSV	ETF	80.06	80.13	79.95	80.02	341800.0
2010-05-03	BTF	ETF	73.89999999999999	74.92399999999999	73.89999999999999	74.69999999999999	4880.8
2010-05-03	BWX	ETF	27.46	27.46	27.327	27.36	172618.0
2010-05-03	BWZ	ETF	35.15	35.1507	34.9	35.139	31845.0
2010-05-03	BZQ	ETF	3603.2	3748.8	3579.2	3704.0	646.0
2010-05-03	CEF	ETF	15.11	15.24	15.06	15.11	1247100.0
2010-05-03	CEW	ETF	22.36	22.37	22.28	22.3	135249.0
2010-05-03	CGO	ETF	14.73	14.91	14.66	14.82	50383.0

> showing 50 of 755 rows — these rows as CSV

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