PREVIEW / etf_daily / 2010-01-20

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-20.parquet
  size:    31 KB
  rows:    713

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-20	SPY	ETF	114.28	114.45	112.98	113.89	216490200.0
2010-01-20	QQQ	ETF	46.27	46.604	45.43	45.92	145679908.0
2010-01-20	IWM	ETF	64.39	64.4	63.19	63.91	62485000.0
2010-01-20	DIA	ETF	106.5	106.54	105.13	106.02	11896600.0
2010-01-20	GLD	ETF	109.97	110.05	108.46	108.94	17535000.0
2010-01-20	TLT	ETF	91.32	91.77	91.27	91.74	2800500.0
2010-01-20	AAXJ	ETF	56.77	57.56	56.41	56.75	270500.0
2010-01-20	ACWI	ETF	43.27	43.27	42.59	42.87	136800.0
2010-01-20	ACWX	ETF	41.75	41.75	41.09	41.46	65600.0
2010-01-20	ADRE	ETF	44.03	44.03	43.17	43.58	180008.0
2010-01-20	AFK	ETF	29.65	30.0	29.628	29.95	21167.0
2010-01-20	AGG	ETF	104.27	104.4	104.2	104.37	614200.0
2010-01-20	AGQ	ETF	131.42	131.76	124.18	125.92	488800.0
2010-01-20	AGZ	ETF	108.4	108.5	108.348	108.36	31569.0
2010-01-20	AIA	ETF	40.4	40.4	39.83	39.93	34379.0
2010-01-20	AIQ	ETF	27.15	27.5	26.3	26.4	35558.0
2010-01-20	AIS	ETF	1.2	1.24	1.18	1.23	142680.0
2010-01-20	AIVI	ETF	43.89	43.89	43.1	43.57	29700.0
2010-01-20	AMJ	ETF	29.88	29.93	29.64	29.93	347282.0
2010-01-20	AOA	ETF	30.68	30.68	30.35	30.55	27800.0
2010-01-20	AOK	ETF	27.64	27.64	27.638	27.638	3470.0
2010-01-20	AOM	ETF	28.5045	28.52	28.4356	28.4845	6130.0
2010-01-20	AOR	ETF	29.54	29.54	29.22	29.36	24054.0
2010-01-20	ARB	ETF	25.45	25.72	25.11	25.49	253877.0
2010-01-20	BAB	ETF	24.78	24.85	24.748	24.805	74371.0
2010-01-20	BAL	ETF	36.97	36.97	34.5	34.66	24956.0
2010-01-20	BBH	ETF	33.8233	33.8233	33.2433	33.6367	453000.0
2010-01-20	BIL	ETF	91.72	91.72	91.7	91.7	76500.0
2010-01-20	BITS	ETF	32.0	32.1932	31.08	31.36	1196.0
2010-01-20	BIV	ETF	80.28	80.45	80.24	80.37	125800.0
2010-01-20	BJK	ETF	25.43	25.43	24.81	24.95	6800.0
2010-01-20	BKF	ETF	46.34	46.41	45.4	45.94	435595.0
2010-01-20	BLV	ETF	77.26	77.7	77.08	77.51	25300.0
2010-01-20	BMVP	ETF	13.01	13.01	12.864	12.943	21859.0
2010-01-20	BND	ETF	79.43	79.47	79.37	79.44	417300.0
2010-01-20	BNE	ETF	6.94	6.94	6.59	6.75	139988.0
2010-01-20	BOSS	ETF	20.1	20.1	20.1	20.1	100.0
2010-01-20	BRF	ETF	48.4	48.61	47.3	48.06	686174.0
2010-01-20	BSV	ETF	80.13	80.2	80.11	80.15	585900.0
2010-01-20	BTF	ETF	64.89999999999999	65.7	63.65	65.6	17095.8
2010-01-20	BWX	ETF	28.605	28.755	28.275	28.33	808382.0
2010-01-20	BWZ	ETF	36.48	36.52	36.2	36.44	22594.0
2010-01-20	BZQ	ETF	3833.6	4020.8	3819.2	3902.4	426.0
2010-01-20	CEF	ETF	14.21	14.3	13.86	13.98	1148800.0
2010-01-20	CEW	ETF	22.19	22.2	22.068	22.11	178263.0
2010-01-20	CGO	ETF	15.07	15.13	14.94	15.0356	19409.0
2010-01-20	CGW	ETF	18.84	18.86	18.5	18.67	98640.0
2010-01-20	CHI	ETF	12.71	12.76	12.64	12.7	201941.0
2010-01-20	CHIE	ETF	15.45	15.75	14.54	14.8952	47580.0
2010-01-20	CHII	ETF	16.12	16.27	15.9	16.04	19185.0

> showing 50 of 713 rows — these rows as CSV

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