PREVIEW / etf_daily / 2010-06-22

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-22.parquet
  size:    33 KB
  rows:    757

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-22	SPY	ETF	111.41	111.9	109.41	109.57	239355400.0
2010-06-22	QQQ	ETF	46.79	47.14	46.15	46.24	94493346.0
2010-06-22	IWM	ETF	66.36	67.1	64.67	64.75	70827400.0
2010-06-22	DIA	ETF	104.5	104.94	102.84	102.93	11915600.0
2010-06-22	GLD	ETF	121.16	121.59	120.87	121.45	12940900.0
2010-06-22	TLT	ETF	97.68	98.6	97.42	98.57	5658900.0
2010-06-22	AAXJ	ETF	55.57	55.79	54.73	54.75	674300.0
2010-06-22	ACWI	ETF	40.81	41.04	40.27	40.37	514300.0
2010-06-22	ACWX	ETF	38.2	38.39	37.57	37.62	289009.0
2010-06-22	ADRE	ETF	42.26	42.4	41.46	41.47	46087.0
2010-06-22	AFK	ETF	29.28	29.28	29.0	29.0	5265.0
2010-06-22	AGG	ETF	106.28	106.46	106.13	106.39	560100.0
2010-06-22	AGQ	ETF	129.94	130.8	127.6	128.44	127150.0
2010-06-22	AGZ	ETF	109.64	109.76	109.586	109.76	14588.0
2010-06-22	AIA	ETF	38.88	38.88	38.34	38.34	15587.0
2010-06-22	AIQ	ETF	24.5	24.8	23.8	23.8	8200.0
2010-06-22	AIS	ETF	1.84	1.85	1.75	1.75	763661.0
2010-06-22	AIVI	ETF	39.56	39.56	38.85	38.89	17200.0
2010-06-22	AMJ	ETF	30.74	30.74	30.26	30.43	499551.0
2010-06-22	AOA	ETF	30.17	30.19	29.64	29.67	3500.0
2010-06-22	AOK	ETF	27.75	27.81	27.671	27.7	7409.0
2010-06-22	AOM	ETF	28.33	28.4	28.175	28.2	35298.0
2010-06-22	AOR	ETF	29.02	29.06	29.02	29.05	5761.0
2010-06-22	ARB	ETF	28.23	29.85	28.23	28.72	234997.0
2010-06-22	BAB	ETF	25.88	25.99	25.78	25.96	174018.0
2010-06-22	BAL	ETF	38.79	38.79	38.79	38.79	450.0
2010-06-22	BALT	ETF	12.3	12.38	11.77	11.92	259017.0
2010-06-22	BBH	ETF	30.8133	31.2867	30.6867	30.6867	152400.0
2010-06-22	BIB	ETF	5.8625	5.8712	5.7125	5.7125	12800.0
2010-06-22	BICK	ETF	29.06	29.06	28.49	28.49	1633.0
2010-06-22	BIL	ETF	91.7	91.72	91.7	91.72	140500.0
2010-06-22	BIS	ETF	11438.4	11707.2	11438.4	11704.0	3.125
2010-06-22	BITS	ETF	28.04	28.2	27.6	27.6	1037.0
2010-06-22	BIV	ETF	82.33	82.56	82.2	82.56	145200.0
2010-06-22	BJK	ETF	25.15	25.21	24.61	24.61	8900.0
2010-06-22	BKF	ETF	44.35	44.55	43.47	43.58	275461.0
2010-06-22	BLV	ETF	80.38	80.74	80.28	80.74	35500.0
2010-06-22	BMVP	ETF	12.65	12.66	12.42	12.43	8611.0
2010-06-22	BND	ETF	80.7	80.87	80.64	80.83	496900.0
2010-06-22	BNE	ETF	11.23	11.25	11.21	11.21	636814.0
2010-06-22	BNO	ETF	26.7	26.86	26.45	26.45	33200.0
2010-06-22	BRF	ETF	45.9	46.6299	45.4	45.51	280576.0
2010-06-22	BSCE	ETF	20.1854	20.21	20.1854	20.21	4300.0
2010-06-22	BSV	ETF	80.61	80.69	80.56	80.67	324200.0
2010-06-22	BTF	ETF	68.0	68.2	66.98	67.1	5933.0
2010-06-22	BWX	ETF	26.655	26.985	26.63	26.895	217548.0
2010-06-22	BWZ	ETF	33.68	33.8	33.68	33.787	10850.0
2010-06-22	BZQ	ETF	3723.2	3889.6	3656.0	3888.0	1055.0
2010-06-22	CEF	ETF	15.17	15.26	15.11	15.26	994200.0
2010-06-22	CEW	ETF	21.68	21.69	21.62	21.63	283805.0

> showing 50 of 757 rows — these rows as CSV

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