PREVIEW / etf_daily / 2010-07-15

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-15.parquet
  size:    33 KB
  rows:    759

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-07-15	SPY	ETF	109.61	110.06	108.17	109.68	232337900.0
2010-07-15	QQQ	ETF	45.46	45.74	44.99	45.6	95992414.0
2010-07-15	IWM	ETF	64.1	64.1	62.61	63.38	71044000.0
2010-07-15	DIA	ETF	103.72	103.88	102.49	103.7	11495700.0
2010-07-15	GLD	ETF	118.59	118.7	117.73	118.23	8586900.0
2010-07-15	TLT	ETF	99.74	100.59	99.7	100.31	6996100.0
2010-07-15	AAXJ	ETF	54.73	54.73	54.06	54.62	298100.0
2010-07-15	ACWI	ETF	40.5	40.59	39.97	40.5	265800.0
2010-07-15	ACWX	ETF	38.07	38.17	37.692	38.14	26495.0
2010-07-15	ADRE	ETF	40.8	41.01	40.44	40.87	334335.0
2010-07-15	AFK	ETF	29.0	29.44	28.9015	29.22	10870.0
2010-07-15	AGG	ETF	107.06	107.24	106.97	107.1	1254100.0
2010-07-15	AGQ	ETF	122.2	122.32	118.9	120.52	164050.0
2010-07-15	AGZ	ETF	110.27	110.39	110.17	110.29	11130.0
2010-07-15	AIA	ETF	38.6	38.66	38.24	38.65	26061.0
2010-07-15	AIQ	ETF	20.55	21.2	20.35	21.0	36846.0
2010-07-15	AIS	ETF	1.61	1.66	1.58	1.61	312913.0
2010-07-15	AIVI	ETF	39.68	39.91	39.39	39.91	5600.0
2010-07-15	AMJ	ETF	32.57	32.57	32.061	32.48	405596.0
2010-07-15	AOA	ETF	29.78	29.78	29.4	29.56	41700.0
2010-07-15	AOK	ETF	27.72	27.72	27.61	27.71	18845.0
2010-07-15	AOM	ETF	28.17	28.23	28.06	28.23	15308.0
2010-07-15	AOR	ETF	28.7615	28.83	28.6099	28.83	18334.0
2010-07-15	ARB	ETF	27.73	27.86	26.59	27.12	166560.0
2010-07-15	BAB	ETF	25.88	26.04	25.84	26.0	157025.0
2010-07-15	BAL	ETF	35.9664	36.04	35.64	35.649	3340.0
2010-07-15	BALT	ETF	10.82	10.92	10.5	10.9	169426.0
2010-07-15	BBH	ETF	30.1967	30.2933	29.9433	30.17	193800.0
2010-07-15	BIB	ETF	5.5825	5.64	5.49	5.5725	13600.0
2010-07-15	BICK	ETF	28.0	28.095	27.7216	27.78	17941.0
2010-07-15	BIL	ETF	91.7	91.72	91.7	91.72	122100.0
2010-07-15	BIS	ETF	11923.2	11923.2	11920.0	11923.2	3.125
2010-07-15	BITS	ETF	27.72	27.88	26.554	27.76	1701.0
2010-07-15	BIV	ETF	83.5	83.86	83.5	83.77	165200.0
2010-07-15	BJK	ETF	24.39	24.39	23.83	24.1	12600.0
2010-07-15	BKF	ETF	43.16	43.21	42.38	42.78	91249.0
2010-07-15	BLV	ETF	81.54	82.07	81.54	81.84	101700.0
2010-07-15	BMVP	ETF	12.34	12.35	12.2	12.35	7082.0
2010-07-15	BND	ETF	81.24	81.4	81.17	81.27	2924400.0
2010-07-15	BNE	ETF	11.28	11.3	11.27	11.28	246834.0
2010-07-15	BNO	ETF	25.965	25.965	25.435	25.65	15800.0
2010-07-15	BRF	ETF	46.68	46.84	46.07	46.5	317414.0
2010-07-15	BSCE	ETF	20.5	20.55	20.4999	20.5266	12932.0
2010-07-15	BSV	ETF	81.05	81.08	80.95	81.05	719900.0
2010-07-15	BTF	ETF	69.0	69.05	68.25	69.05	2319.0
2010-07-15	BWX	ETF	27.645	27.87	27.645	27.865	285416.0
2010-07-15	BWZ	ETF	34.6	34.8313	34.6	34.8313	29198.0
2010-07-15	BZQ	ETF	3824.0	3960.0	3824.0	3836.8	612.5
2010-07-15	CEF	ETF	14.92	14.97	14.78	14.86	394200.0
2010-07-15	CEW	ETF	21.73	21.73	21.59	21.66	86165.0

> showing 50 of 759 rows — these rows as CSV

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