PREVIEW / etf_daily / 2010-07-21

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-21.parquet
  size:    33 KB
  rows:    764

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-21	SPY	ETF	109.04	109.07	106.63	107.07	264527000.0
2010-07-21	QQQ	ETF	45.75	45.76	44.56	44.64	83576823.0
2010-07-21	IWM	ETF	62.85	62.97	61.1	61.24	68456600.0
2010-07-21	DIA	ETF	102.67	102.7	100.72	101.23	10812500.0
2010-07-21	GLD	ETF	116.8	117.0	115.71	115.85	9396200.0
2010-07-21	TLT	ETF	100.45	102.28	100.41	102.03	7894200.0
2010-07-21	AADR	ETF	25.1	25.1	24.7	24.7	42799.0
2010-07-21	AAXJ	ETF	54.94	54.94	53.99	54.2	1882000.0
2010-07-21	ACWI	ETF	40.19	40.19	39.25	39.34	458700.0
2010-07-21	ACWX	ETF	37.78	37.78	36.96	37.1	16532.0
2010-07-21	ADRE	ETF	41.42	41.54	40.74	40.88	119262.0
2010-07-21	AFK	ETF	29.3699	29.3699	28.89	28.9	3033.0
2010-07-21	AGG	ETF	107.26	107.75	107.26	107.72	518400.0
2010-07-21	AGQ	ETF	114.4	114.98	110.96	111.98	137500.0
2010-07-21	AGZ	ETF	110.49	110.6999	110.4	110.69	15017.0
2010-07-21	AIA	ETF	38.57	38.97	38.15	38.23	12114.0
2010-07-21	AIQ	ETF	19.35	19.6	18.8	18.8	20928.0
2010-07-21	AIS	ETF	1.53	1.56	1.48	1.49	246100.0
2010-07-21	AIVI	ETF	39.04	39.04	38.19	38.4	12300.0
2010-07-21	AMJ	ETF	33.34	33.63	32.801	33.03	492524.0
2010-07-21	AOA	ETF	29.48	29.48	28.96	29.02	16900.0
2010-07-21	AOK	ETF	27.6212	27.6212	27.538	27.538	1762.0
2010-07-21	AOM	ETF	28.14	28.14	27.92	27.92	15115.0
2010-07-21	AOR	ETF	28.62	28.62	28.332	28.3936	5702.0
2010-07-21	ARB	ETF	27.09	28.22	26.92	27.13	305960.0
2010-07-21	BAB	ETF	25.89	26.12	25.86	26.11	316202.0
2010-07-21	BAL	ETF	35.85	36.21	35.85	36.0601	2398.0
2010-07-21	BALT	ETF	11.14	11.2	10.92	10.97	92692.0
2010-07-21	BBH	ETF	29.7067	30.0067	29.3633	29.6533	114600.0
2010-07-21	BIB	ETF	5.2775	5.3375	5.21	5.21	28000.0
2010-07-21	BICK	ETF	27.9	28.035	27.72	27.8399	4613.0
2010-07-21	BIL	ETF	91.7	91.72	91.7	91.7	124400.0
2010-07-21	BIS	ETF	12342.4	12558.416	12219.2	12558.416	12.5
2010-07-21	BITS	ETF	26.44	27.24	25.92	26.0	3769.0
2010-07-21	BIV	ETF	84.13	84.51	84.09	84.49	180900.0
2010-07-21	BJK	ETF	24.16	24.16	23.61	23.74	16900.0
2010-07-21	BKF	ETF	43.78	43.78	42.85	43.17	84007.0
2010-07-21	BLV	ETF	82.31	83.3	82.2	83.16	82600.0
2010-07-21	BMVP	ETF	12.2767	12.2767	12.0533	12.0615	6115.0
2010-07-21	BND	ETF	81.49	81.79	81.49	81.73	791100.0
2010-07-21	BNE	ETF	11.31	11.33	11.29	11.32	532331.0
2010-07-21	BNO	ETF	25.71	25.71	25.44	25.575	33000.0
2010-07-21	BRF	ETF	46.93	47.328	46.56	46.95	349980.0
2010-07-21	BSCE	ETF	20.67	20.71	20.67	20.71	10381.0
2010-07-21	BSV	ETF	81.17	81.23	81.08	81.23	656800.0
2010-07-21	BTF	ETF	68.35	68.35	67.64999999999999	67.64999999999999	7860.8
2010-07-21	BWX	ETF	27.915	27.98	27.805	27.945	193810.0
2010-07-21	BWZ	ETF	34.8199	34.8199	34.58	34.58	2934.0
2010-07-21	BZQ	ETF	3648.0	3795.2	3616.0	3739.2	863.0
2010-07-21	CEF	ETF	14.51	14.52	14.24	14.33	653100.0

> showing 50 of 764 rows — these rows as CSV

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