PREVIEW / etf_daily / 2009-05-20

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-20.parquet
  size:    29 KB
  rows:    654

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
2009-05-20	SPY	ETF	91.95	92.8	90.41	90.51	285722200.0
2009-05-20	QQQ	ETF	34.54	35.04	34.18	34.28	131873676.0
2009-05-20	IWM	ETF	49.83	50.69	48.85	48.92	48021100.0
2009-05-20	DIA	ETF	85.34	85.97	84.1	84.19	18083800.0
2009-05-20	GLD	ETF	91.54	92.44	91.52	92.25	18272500.0
2009-05-20	TLT	ETF	95.93	97.16	95.83	97.02	2825700.0
2009-05-20	AAXJ	ETF	43.25	44.07	43.05	43.31	203000.0
2009-05-20	ACWI	ETF	34.61	35.02	34.32	34.36	200100.0
2009-05-20	ACWX	ETF	33.61	33.9	33.44	33.44	21378.0
2009-05-20	ADRE	ETF	35.05	35.5	34.5902	34.78	189352.0
2009-05-20	AFK	ETF	25.4899	25.56	25.14	25.29	9500.0
2009-05-20	AGG	ETF	101.95	102.5	101.92	102.29	543600.0
2009-05-20	AGQ	ETF	91.74	93.24	91.2	92.18	116050.0
2009-05-20	AGZ	ETF	108.004	108.03	107.8	108.02	15356.0
2009-05-20	AIA	ETF	32.4	32.67	32.01	32.06	47776.0
2009-05-20	AIQ	ETF	35.6	36.8	35.2	35.25	58483.0
2009-05-20	AIS	ETF	0.55	0.55	0.5205	0.5377	43300.0
2009-05-20	AIVI	ETF	35.5	35.82	35.18	35.18	7000.0
2009-05-20	AMJ	ETF	22.35	22.51	22.347	22.42	121631.0
2009-05-20	AOA	ETF	25.33	25.33	24.9	24.92	10800.0
2009-05-20	AOK	ETF	26.25	26.25	25.7564	25.7564	4864.0
2009-05-20	AOM	ETF	25.7538	25.92	25.66	25.661	3878.0
2009-05-20	AOR	ETF	25.6444	25.6599	25.3872	25.39	2286.0
2009-05-20	ARB	ETF	20.43	21.04	20.21	20.29	232662.0
2009-05-20	BAL	ETF	31.72	31.72	31.59	31.59	5000.0
2009-05-20	BBH	ETF	30.0	30.3133	29.8933	30.0267	612300.0
2009-05-20	BIL	ETF	91.7	91.72	91.66	91.66	484850.0
2009-05-20	BITS	ETF	17.72	18.3936	17.04	17.76	950.0
2009-05-20	BIV	ETF	77.22	77.6	77.01	77.45	66300.0
2009-05-20	BJK	ETF	21.52	21.78	21.38	21.46	13300.0
2009-05-20	BKF	ETF	34.8	35.1299	33.78	33.89	299645.0
2009-05-20	BLV	ETF	73.53	74.0	73.18	73.94	25900.0
2009-05-20	BMVP	ETF	10.76	10.89	10.64	10.64	20789.0
2009-05-20	BND	ETF	77.65	77.86	77.48	77.77	710600.0
2009-05-20	BNE	ETF	5.78	6.0	5.46	5.48	146963.0
2009-05-20	BOSS	ETF	16.82	17.01	16.63	16.82	300.0
2009-05-20	BRF	ETF	26.93	27.29	26.1001	26.204	133266.0
2009-05-20	BSV	ETF	79.16	79.4	79.03	79.31	280100.0
2009-05-20	BTF	ETF	47.55	48.4	47.0	47.35	6208.0
2009-05-20	BWX	ETF	26.66	26.915	26.66	26.86	188968.0
2009-05-20	BWZ	ETF	34.7377	34.884	34.731	34.79	1400.0
2009-05-20	CBON	ETF	1.38	1.4499	1.35	1.36	37361.0
2009-05-20	CEF	ETF	11.77	11.83	11.67	11.81	897600.0
2009-05-20	CEW	ETF	20.61	20.7	20.61	20.63	49263.0
2009-05-20	CGO	ETF	10.42	10.72	10.4	10.42	38347.0
2009-05-20	CGW	ETF	15.16	15.23	14.92	14.92	33076.0
2009-05-20	CHB	ETF	0.46	0.5	0.45	0.47	668861.0
2009-05-20	CHI	ETF	10.3	10.4299	10.02	10.3	247573.0
2009-05-20	CHIC	ETF	10.78	11.47	10.38	10.46	286074.0
2009-05-20	CHW	ETF	6.71	6.88	6.61	6.65	264799.0

> showing 50 of 654 rows — these rows as CSV

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