PREVIEW / etf_daily / 2010-08-03

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-03.parquet
  size:    33 KB
  rows:    760

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-08-03	SPY	ETF	112.48	112.77	111.85	112.22	146657300.0
2010-08-03	QQQ	ETF	46.63	46.7	46.25	46.47	60863373.0
2010-08-03	IWM	ETF	65.93	66.53	65.09	65.62	51145700.0
2010-08-03	DIA	ETF	106.48	106.83	106.06	106.39	5440100.0
2010-08-03	GLD	ETF	115.88	116.44	115.81	115.99	5579400.0
2010-08-03	TLT	ETF	99.2	99.66	98.93	99.32	4363500.0
2010-08-03	AADR	ETF	25.75	25.86	25.75	25.83	11200.0
2010-08-03	AAXJ	ETF	57.25	57.43	56.88	57.27	1637900.0
2010-08-03	ACWI	ETF	42.07	42.23	41.8	42.18	188400.0
2010-08-03	ACWX	ETF	39.97	40.1019	39.78	40.01	32044.0
2010-08-03	ADRE	ETF	43.29	43.61	43.12	43.39	180477.0
2010-08-03	AFK	ETF	31.05	31.41	30.92	31.0	34565.0
2010-08-03	AGG	ETF	107.56	107.63	107.42	107.48	1150000.0
2010-08-03	AGQ	ETF	121.52	123.62	120.76	120.96	124500.0
2010-08-03	AGZ	ETF	110.63	110.68	110.591	110.68	17706.0
2010-08-03	AIA	ETF	40.71	40.71	40.41	40.69	16981.0
2010-08-03	AIQ	ETF	21.1	22.8	21.1	22.35	88249.0
2010-08-03	AIS	ETF	1.62	1.62	1.56	1.59	465209.0
2010-08-03	AIVI	ETF	41.75	41.87	41.6	41.71	9000.0
2010-08-03	AMJ	ETF	33.4	33.49	33.26	33.43	2380693.0
2010-08-03	AOA	ETF	30.64	30.75	30.6	30.64	10300.0
2010-08-03	AOK	ETF	28.04	28.06	27.9735	28.04	9581.0
2010-08-03	AOM	ETF	28.72	28.75	28.7056	28.7056	4785.0
2010-08-03	AOR	ETF	29.42	29.47	29.34	29.462	12577.0
2010-08-03	ARB	ETF	29.51	29.66	28.81	29.17	355023.0
2010-08-03	BAB	ETF	26.05	26.1	26.0	26.05	158202.0
2010-08-03	BAL	ETF	38.72	38.72	38.688	38.688	600.0
2010-08-03	BALT	ETF	11.67	11.67	11.19	11.28	115978.0
2010-08-03	BBH	ETF	31.6533	31.7667	31.3967	31.5433	67200.0
2010-08-03	BIB	ETF	5.93	5.93	5.8775	5.8775	9600.0
2010-08-03	BICK	ETF	29.77	29.78	29.52	29.67	12338.0
2010-08-03	BIL	ETF	91.68	91.7	91.68	91.68	1342100.0
2010-08-03	BIS	ETF	11185.6	11185.6	10923.2	10923.2	14.65
2010-08-03	BITS	ETF	28.4	28.4	27.76	27.92	673.0
2010-08-03	BIV	ETF	84.54	84.68	84.42	84.51	427400.0
2010-08-03	BJK	ETF	25.87	26.07	25.76	25.95	14000.0
2010-08-03	BKF	ETF	45.74	46.04	45.5	45.72	136375.0
2010-08-03	BLV	ETF	82.4	82.67	82.16	82.4	390700.0
2010-08-03	BMVP	ETF	12.607	12.69	12.567	12.628	11187.0
2010-08-03	BND	ETF	81.75	81.83	81.6	81.82	1232500.0
2010-08-03	BNE	ETF	11.23	11.31	11.22	11.3	501334.0
2010-08-03	BRF	ETF	50.26	50.26	49.72	49.81	352279.0
2010-08-03	BSCE	ETF	20.74	20.74	20.7312	20.74	5855.0
2010-08-03	BSV	ETF	81.37	81.37	81.25	81.31	834300.0
2010-08-03	BTF	ETF	70.6	70.99999999999999	70.39999999999999	70.39999999999999	2797.8
2010-08-03	BWX	ETF	28.71	29.12	28.71	29.085	3063642.0
2010-08-03	BWZ	ETF	35.88	35.92	35.691	35.92	140175.0
2010-08-03	BZQ	ETF	3259.2	3304.0	3214.4	3272.0	758.0
2010-08-03	CEF	ETF	14.59	14.69	14.54	14.56	500300.0
2010-08-03	CEW	ETF	22.09	22.157	22.06	22.11	64298.0

> showing 50 of 760 rows — these rows as CSV

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