PREVIEW / etf_daily / 2010-01-13

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-13.parquet
  size:    31 KB
  rows:    709

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-13	SPY	ETF	113.95	114.94	113.37	114.62	161822000.0
2010-01-13	QQQ	ETF	45.93	46.49	45.61	46.35	100660957.0
2010-01-13	IWM	ETF	63.78	64.51	63.23	64.38	39501900.0
2010-01-13	DIA	ETF	106.33	106.99	106.04	106.75	8619100.0
2010-01-13	GLD	ETF	110.92	111.57	109.57	111.54	20014000.0
2010-01-13	TLT	ETF	89.93	90.28	89.22	89.27	4755000.0
2010-01-13	AAXJ	ETF	57.21	57.5	56.75	57.24	248300.0
2010-01-13	ACWI	ETF	43.36	43.73	43.19	43.66	211000.0
2010-01-13	ACWX	ETF	42.37	42.6	42.07	42.53	112186.0
2010-01-13	ADRE	ETF	45.23	45.23	44.6	45.04	123627.0
2010-01-13	AFK	ETF	29.76	29.99	29.66	29.82	27202.0
2010-01-13	AGG	ETF	104.09	104.17	103.79	103.8	530900.0
2010-01-13	AGQ	ETF	133.0	136.24	130.18	136.12	181600.0
2010-01-13	AGZ	ETF	108.21	108.22	107.89	108.01	20218.0
2010-01-13	AIA	ETF	40.49	40.6094	40.15	40.47	37100.0
2010-01-13	AIQ	ETF	26.15	26.45	25.85	25.95	23986.0
2010-01-13	AIS	ETF	1.28	1.28	1.21	1.24	379246.0
2010-01-13	AIVI	ETF	44.53	44.91	44.31	44.84	9600.0
2010-01-13	AMJ	ETF	29.28	29.28	28.8	29.21	339516.0
2010-01-13	AOA	ETF	30.69	30.82	30.45	30.82	10500.0
2010-01-13	AOK	ETF	27.66	27.67	27.59	27.67	7483.0
2010-01-13	AOM	ETF	28.59	28.6282	28.54	28.6282	16232.0
2010-01-13	AOR	ETF	29.53	29.63	29.4075	29.6	48166.0
2010-01-13	ARB	ETF	24.19	25.085	24.1	24.58	377169.0
2010-01-13	BAB	ETF	24.48	24.54	24.35	24.37	277450.0
2010-01-13	BAL	ETF	35.13	36.2799	35.13	35.96	3370.0
2010-01-13	BBH	ETF	33.1233	33.4533	33.0433	33.32	251100.0
2010-01-13	BIL	ETF	91.7	91.72	91.68	91.72	133300.0
2010-01-13	BITS	ETF	32.56	32.56	32.2	32.44	2268.0
2010-01-13	BIV	ETF	80.04	80.39	79.8	79.87	94700.0
2010-01-13	BJK	ETF	25.18	25.32	24.82	25.32	20000.0
2010-01-13	BKF	ETF	47.28	47.42	46.61	47.01	615716.0
2010-01-13	BLV	ETF	76.72	77.12	76.07	76.13	30600.0
2010-01-13	BMVP	ETF	12.9333	13.0113	12.8586	13.0113	25442.0
2010-01-13	BND	ETF	79.15	79.24	78.98	79.05	460500.0
2010-01-13	BNE	ETF	7.17	7.27	7.03	7.25	127891.0
2010-01-13	BOSS	ETF	20.07	20.07	19.41	19.535	200.0
2010-01-13	BRF	ETF	50.36	50.49	49.65	49.78	532856.0
2010-01-13	BSV	ETF	79.97	80.11	79.92	79.94	331700.0
2010-01-13	BTF	ETF	64.1	64.35	64.05	64.19	2101.8
2010-01-13	BWX	ETF	28.855	28.905	28.765	28.89	348234.0
2010-01-13	BWZ	ETF	37.09	37.102	37.0	37.08	19377.0
2010-01-13	BZQ	ETF	3472.0	3633.6	3472.0	3577.6	111.0
2010-01-13	CEF	ETF	14.35	14.55	14.2	14.54	1206400.0
2010-01-13	CEW	ETF	22.42	22.42	22.3	22.32	102566.0
2010-01-13	CGO	ETF	15.0	15.0	14.7592	14.93	23150.0
2010-01-13	CGW	ETF	18.95	18.95	18.73	18.89	90532.0
2010-01-13	CHI	ETF	12.66	12.78	12.62	12.74	185436.0
2010-01-13	CHIE	ETF	15.85	15.85	15.48	15.68	22195.0
2010-01-13	CHII	ETF	16.24	16.24	15.97	16.11	23595.0

> showing 50 of 709 rows — these rows as CSV

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