PREVIEW / etf_daily / 2010-09-24

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-24.parquet
  size:    34 KB
  rows:    790

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-09-24	SPY	ETF	113.75	114.9	113.65	114.82	209671800.0
2010-09-24	QQQ	ETF	49.22	49.69	49.15	49.66	79495879.0
2010-09-24	IWM	ETF	65.79	67.06	65.69	66.99	71675000.0
2010-09-24	DIA	ETF	107.77	108.66	107.67	108.57	5334900.0
2010-09-24	GLD	ETF	126.91	127.0	126.3	126.69	14945000.0
2010-09-24	TLT	ETF	103.96	104.11	103.5	103.5	8942500.0
2010-09-24	AADR	ETF	27.78	27.94	27.78	27.94	15500.0
2010-09-24	AAXJ	ETF	59.45	59.97	59.41	59.91	617700.0
2010-09-24	ACWI	ETF	43.13	43.33	42.88	43.32	57400.0
2010-09-24	ACWX	ETF	41.05	41.402	41.05	41.37	114388.0
2010-09-24	ADRE	ETF	43.86	44.2	43.86	44.0584	155251.0
2010-09-24	AFK	ETF	32.06	32.2099	31.96	32.1499	17491.0
2010-09-24	AGG	ETF	108.36	108.4	108.13	108.14	1116600.0
2010-09-24	AGQ	ETF	161.0	162.1	159.72	162.1	234050.0
2010-09-24	AGZ	ETF	111.36	111.36	111.174	111.27	8277.0
2010-09-24	AIA	ETF	41.78	42.27	41.78	42.27	15384.0
2010-09-24	AIQ	ETF	21.9	22.45	21.9	22.45	9962.0
2010-09-24	AIS	ETF	1.42	1.43	1.37	1.43	325608.0
2010-09-24	AIVI	ETF	43.02	43.34	42.83	43.31	12200.0
2010-09-24	AMJ	ETF	33.36	33.36	33.12	33.2	531089.0
2010-09-24	AMLP	ETF	76.95	77.0	76.4	76.4	195520.0
2010-09-24	AOA	ETF	31.34	31.56	31.34	31.56	4300.0
2010-09-24	AOK	ETF	28.35	28.38	28.33	28.3636	9953.0
2010-09-24	AOM	ETF	29.03	29.19	29.03	29.19	14612.0
2010-09-24	AOR	ETF	29.93	30.0694	29.93	30.05	4655.0
2010-09-24	ARB	ETF	26.99	27.2625	26.89	27.09	189931.0
2010-09-24	BAB	ETF	26.62	26.63	26.51	26.55	274199.0
2010-09-24	BAL	ETF	47.95	49.69	47.95	49.2	82562.0
2010-09-24	BALT	ETF	11.37	11.39	11.0701	11.38	141608.0
2010-09-24	BBH	ETF	32.2067	32.5767	32.1567	32.52	162300.0
2010-09-24	BIB	ETF	6.4825	6.5312	6.4475	6.5312	30400.0
2010-09-24	BICK	ETF	31.25	31.29	30.9	31.17	21872.0
2010-09-24	BIL	ETF	91.72	91.72	91.7	91.72	100300.0
2010-09-24	BITS	ETF	26.96	28.0	26.48	26.48	20700.0
2010-09-24	BIV	ETF	86.12	86.18	86.0	86.1	137900.0
2010-09-24	BJK	ETF	27.5	27.71	27.43	27.64	21400.0
2010-09-24	BKF	ETF	46.74	47.2545	46.74	47.02	114274.0
2010-09-24	BLV	ETF	85.02	85.07	84.67	84.71	25100.0
2010-09-24	BMVP	ETF	12.94	13.04	12.94	13.03	11978.0
2010-09-24	BND	ETF	82.41	82.41	82.24	82.26	563500.0
2010-09-24	BNE	ETF	10.99	11.01	10.81	10.98	904974.0
2010-09-24	BRF	ETF	55.52	55.77	54.96	55.25	343277.0
2010-09-24	BSCE	ETF	20.93	20.93	20.87	20.873	4675.0
2010-09-24	BSV	ETF	81.65	81.66	81.57	81.6	294400.0
2010-09-24	BTF	ETF	75.1	75.89999999999999	75.1	75.73599999999999	4179.8
2010-09-24	BWX	ETF	29.75	29.8175	29.63	29.7	131854.0
2010-09-24	BWZ	ETF	36.55	36.7899	36.55	36.65	8850.0
2010-09-24	BZQ	ETF	2900.8	2984.0	2860.8	2960.0	564.0
2010-09-24	CEF	ETF	16.56	16.59	16.37	16.51	906400.0
2010-09-24	CEW	ETF	22.75	22.8	22.7088	22.79	66300.0

> showing 50 of 790 rows — these rows as CSV

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