PREVIEW / etf_daily / 2010-10-20

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-20.parquet
  size:    34 KB
  rows:    789

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-10-20	SPY	ETF	116.94	118.44	116.87	117.87	200051800.0
2010-10-20	QQQ	ETF	50.96	51.57	50.87	51.19	80861043.0
2010-10-20	IWM	ETF	69.84	70.63	69.43	70.21	54118800.0
2010-10-20	DIA	ETF	110.09	111.58	109.82	111.09	7394700.0
2010-10-20	GLD	ETF	130.36	131.65	130.32	131.32	12556600.0
2010-10-20	TLT	ETF	101.37	102.28	101.21	101.91	5515800.0
2010-10-20	AADR	ETF	28.58	28.7	28.58	28.7	600.0
2010-10-20	AAXJ	ETF	62.19	62.9	62.08	62.5	749600.0
2010-10-20	ACWI	ETF	44.43	44.97	44.33	44.84	159000.0
2010-10-20	ACWX	ETF	42.58	43.1999	42.58	43.04	30338.0
2010-10-20	ADRE	ETF	46.06	46.59	46.01	46.33	65917.0
2010-10-20	AFK	ETF	33.36	33.59	33.07	33.31	38490.0
2010-10-20	AGG	ETF	108.49	108.72	108.41	108.62	849500.0
2010-10-20	AGQ	ETF	192.66	199.52	192.24	197.38	304350.0
2010-10-20	AGZ	ETF	111.6501	111.772	111.6501	111.72	8866.0
2010-10-20	AIA	ETF	43.28	43.94	43.28	43.69	25071.0
2010-10-20	AIQ	ETF	22.0	22.2	21.25	21.75	20278.0
2010-10-20	AIS	ETF	1.53	1.53	1.48	1.49	350721.0
2010-10-20	AIVI	ETF	44.62	45.35	44.62	45.26	10400.0
2010-10-20	AMJ	ETF	34.75	35.0	34.67	34.945	718969.0
2010-10-20	AMLP	ETF	78.9	79.05	78.75	79.0	50280.0
2010-10-20	AOA	ETF	32.28	32.64	32.28	32.49	8000.0
2010-10-20	AOK	ETF	28.71	28.82	28.7	28.8	7297.0
2010-10-20	AOM	ETF	29.55	29.68	29.484	29.679	4705.0
2010-10-20	AOR	ETF	30.62	30.7396	30.604	30.7323	1576.0
2010-10-20	ARB	ETF	29.0	29.48	28.98	29.39	260622.0
2010-10-20	BAB	ETF	26.3	26.43	26.258	26.39	228142.0
2010-10-20	BAL	ETF	54.83	56.6499	54.71	56.61	68115.0
2010-10-20	BALT	ETF	11.04	11.16	10.9	11.15	100139.0
2010-10-20	BBH	ETF	32.9333	33.61	32.9333	33.29	71400.0
2010-10-20	BICK	ETF	32.61	32.81	32.48	32.52	34387.0
2010-10-20	BIL	ETF	91.72	91.72	91.7	91.7	633450.0
2010-10-20	BIS	ETF	9337.6	9337.6	9107.2	9236.8	19.75
2010-10-20	BITS	ETF	26.8	27.2	26.8	26.92	740.0
2010-10-20	BIV	ETF	87.16	87.4	87.01	87.21	131800.0
2010-10-20	BJK	ETF	29.16	29.75	29.16	29.58	16900.0
2010-10-20	BKF	ETF	49.36	49.7899	49.1	49.57	166494.0
2010-10-20	BLV	ETF	83.86	84.65	83.86	84.27	52500.0
2010-10-20	BMVP	ETF	13.41	13.6	13.41	13.55	10140.0
2010-10-20	BND	ETF	82.74	82.88	82.67	82.74	602700.0
2010-10-20	BNE	ETF	11.39	11.39	11.34	11.36	302363.0
2010-10-20	BRF	ETF	58.24	59.719	58.2	59.27	547376.0
2010-10-20	BSCE	ETF	21.11	21.11	21.03	21.09	5066.0
2010-10-20	BSV	ETF	81.96	82.0	81.9	81.97	345500.0
2010-10-20	BTF	ETF	77.05	77.85	77.05	77.64999999999999	1338.4
2010-10-20	BWX	ETF	30.28	30.685	30.28	30.575	178974.0
2010-10-20	BWZ	ETF	37.49	37.79	37.49	37.75	8866.0
2010-10-20	BZQ	ETF	2635.2	2635.2	2552.0	2600.0	1067.0
2010-10-20	CEF	ETF	17.36	17.63	17.35	17.62	1546700.0
2010-10-20	CEW	ETF	23.02	23.2	23.02	23.18	64724.0

> showing 50 of 789 rows — these rows as CSV

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