PREVIEW / etf_daily / 2010-01-21

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-21.parquet
  size:    31 KB
  rows:    720

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-01-21	SPY	ETF	113.92	114.27	111.56	111.7	344859600.0
2010-01-21	QQQ	ETF	46.06	46.35	45.3	45.49	204939540.0
2010-01-21	IWM	ETF	63.96	64.48	62.64	62.86	98323100.0
2010-01-21	DIA	ETF	105.97	106.11	103.71	103.71	22253800.0
2010-01-21	GLD	ETF	108.48	108.78	106.61	107.37	25748400.0
2010-01-21	TLT	ETF	91.55	92.39	91.46	92.16	4363100.0
2010-01-21	AAXJ	ETF	56.21	56.27	54.89	55.02	503300.0
2010-01-21	ACWI	ETF	42.73	43.0	41.95	42.06	243400.0
2010-01-21	ACWX	ETF	41.43	41.43	40.42	40.49	47125.0
2010-01-21	ADRE	ETF	43.47	43.48	41.96	41.96	449422.0
2010-01-21	AFK	ETF	29.97	30.0	28.9	29.175	54560.0
2010-01-21	AGG	ETF	104.37	104.65	104.27	104.4	540200.0
2010-01-21	AGQ	ETF	124.3	125.98	117.8	118.68	367850.0
2010-01-21	AGZ	ETF	108.16	108.68	108.16	108.53	15108.0
2010-01-21	AIA	ETF	40.15	40.15	39.1	39.24	74557.0
2010-01-21	AIQ	ETF	26.35	26.65	26.05	26.25	59405.0
2010-01-21	AIS	ETF	1.21	1.25	1.19	1.22	240490.0
2010-01-21	AIVI	ETF	43.35	43.62	42.15	42.58	29700.0
2010-01-21	AMJ	ETF	30.02	30.05	29.42	29.74	254654.0
2010-01-21	AOA	ETF	30.55	30.57	29.96	30.05	22800.0
2010-01-21	AOK	ETF	27.59	27.63	27.5108	27.554	6697.0
2010-01-21	AOM	ETF	28.55	28.55	28.27	28.32	12142.0
2010-01-21	AOR	ETF	29.43	29.43	29.04	29.06	19740.0
2010-01-21	ARB	ETF	25.49	26.0	25.44	25.81	281318.0
2010-01-21	BAB	ETF	24.81	24.92	24.8	24.91	74814.0
2010-01-21	BAL	ETF	34.93	35.34	34.74	35.15	9076.0
2010-01-21	BBH	ETF	33.7433	33.7433	32.9567	33.1967	288600.0
2010-01-21	BIL	ETF	91.7	91.72	91.7	91.7	188900.0
2010-01-21	BITS	ETF	31.24	31.88	31.2	31.88	2480.0
2010-01-21	BIV	ETF	80.45	80.75	80.33	80.65	103000.0
2010-01-21	BJK	ETF	25.29	25.29	24.63	24.63	9100.0
2010-01-21	BKF	ETF	45.46	45.88	43.9	43.9	391808.0
2010-01-21	BLV	ETF	77.8	78.14	77.34	77.99	25500.0
2010-01-21	BMVP	ETF	12.97	13.0	12.71	12.71	21487.0
2010-01-21	BND	ETF	79.49	79.62	79.43	79.53	647300.0
2010-01-21	BNE	ETF	6.75	6.85	6.5	6.55	149756.0
2010-01-21	BOSS	ETF	19.81	19.81	19.59	19.59	100.0
2010-01-21	BRF	ETF	47.96	48.05	45.56	45.58	1296861.0
2010-01-21	BSV	ETF	80.13	80.26	80.07	80.26	396400.0
2010-01-21	BTF	ETF	65.7	66.75	65.5	66.145	20115.4
2010-01-21	BWX	ETF	28.435	28.51	28.255	28.465	384640.0
2010-01-21	BWZ	ETF	36.37	36.5	36.18	36.4892	35791.0
2010-01-21	BZQ	ETF	3958.4	4262.4	3918.4	4262.4	942.0
2010-01-21	CEF	ETF	13.91	14.05	13.68	13.74	1276200.0
2010-01-21	CEW	ETF	22.09	22.15	21.98	22.0	122959.0
2010-01-21	CGO	ETF	15.11	15.15	14.55	14.61	36313.0
2010-01-21	CGW	ETF	18.57	18.699	18.23	18.3	109671.0
2010-01-21	CHI	ETF	12.65	12.6825	12.5	12.5	165815.0
2010-01-21	CHIE	ETF	14.55	14.55	14.2	14.24	35920.0
2010-01-21	CHII	ETF	15.8	15.8	15.2401	15.28	17103.0

> showing 50 of 720 rows — these rows as CSV

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