PREVIEW / etf_daily / 2010-01-05

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-05.parquet
  size:    31 KB
  rows:    714

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-05	SPY	ETF	113.26	113.68	112.85	113.63	111579900.0
2010-01-05	QQQ	ETF	46.38	46.5	46.16	46.42	62935591.0
2010-01-05	IWM	ETF	63.88	64.18	63.49	63.76	55523100.0
2010-01-05	DIA	ETF	105.61	105.67	104.97	105.49	6549200.0
2010-01-05	GLD	ETF	109.88	110.39	109.26	109.7	14213100.0
2010-01-05	TLT	ETF	90.05	90.63	90.0	90.39	2841600.0
2010-01-05	AAXJ	ETF	57.34	57.83	57.33	57.81	309400.0
2010-01-05	ACWI	ETF	43.34	43.52	43.08	43.52	171200.0
2010-01-05	ACWX	ETF	42.25	42.35	42.0	42.21	90046.0
2010-01-05	ADRE	ETF	45.57	45.75	45.22	45.57	129539.0
2010-01-05	AFK	ETF	29.15	29.15	28.93	29.09	6445.0
2010-01-05	AGG	ETF	103.62	103.82	103.52	103.78	500500.0
2010-01-05	AGQ	ETF	121.78	126.0	121.04	125.32	189650.0
2010-01-05	AGZ	ETF	107.865	107.99	107.72	107.99	8786.0
2010-01-05	AIA	ETF	41.11	41.21	40.85	41.08	57664.0
2010-01-05	AIQ	ETF	28.3	28.4	27.65	27.8	44547.0
2010-01-05	AIS	ETF	1.17	1.17	1.14	1.17	255015.0
2010-01-05	AIVI	ETF	44.81	44.81	44.51	44.6	31200.0
2010-01-05	AMJ	ETF	29.21	29.6	29.14	29.6	301602.0
2010-01-05	AOA	ETF	30.37	30.56	30.37	30.54	9400.0
2010-01-05	AOK	ETF	27.59	27.59	27.5	27.57	62800.0
2010-01-05	AOM	ETF	28.45	28.52	28.4481	28.52	23048.0
2010-01-05	AOR	ETF	29.4	29.4	29.33	29.4	10349.0
2010-01-05	ARB	ETF	25.34	26.6	25.2	25.93	521957.0
2010-01-05	BAB	ETF	24.25	24.37	24.21	24.33	47269.0
2010-01-05	BAL	ETF	37.28	37.28	35.72	35.855	54477.0
2010-01-05	BBH	ETF	32.84	32.87	32.2967	32.67	227400.0
2010-01-05	BIL	ETF	91.7	91.72	91.68	91.68	105600.0
2010-01-05	BITS	ETF	31.0	31.8	30.764	31.76	5736.0
2010-01-05	BIV	ETF	79.7	79.87	79.54	79.81	96200.0
2010-01-05	BJK	ETF	24.43	25.04	24.43	24.82	17300.0
2010-01-05	BKF	ETF	47.77	47.99	47.44	47.8	348667.0
2010-01-05	BLV	ETF	76.31	76.72	76.3	76.5	54600.0
2010-01-05	BMVP	ETF	12.93	12.9653	12.8863	12.94	10503.0
2010-01-05	BND	ETF	78.89	79.0	78.79	78.91	814600.0
2010-01-05	BNE	ETF	7.15	7.22	7.01	7.16	224517.0
2010-01-05	BRF	ETF	50.52	50.57	49.52	50.05	753158.0
2010-01-05	BSV	ETF	79.69	79.83	79.65	79.81	471500.0
2010-01-05	BTF	ETF	63.949999999999996	64.19999999999999	63.75	64.19999999999999	4893.6
2010-01-05	BWX	ETF	28.65	28.695	28.5054	28.63	573748.0
2010-01-05	BWZ	ETF	36.56	36.81	36.56	36.6668	11163.0
2010-01-05	BZQ	ETF	3462.4	3507.2	3409.6	3456.0	123.0
2010-01-05	CEF	ETF	14.02	14.21	13.99	14.17	1125200.0
2010-01-05	CEW	ETF	22.2	22.34	22.15	22.21	171015.0
2010-01-05	CGO	ETF	14.54	14.61	14.5001	14.6001	20836.0
2010-01-05	CGW	ETF	18.8	18.8	18.65	18.76	88354.0
2010-01-05	CHI	ETF	12.48	12.6	12.47	12.55	190460.0
2010-01-05	CHIE	ETF	15.55	15.94	15.42	15.94	24707.0
2010-01-05	CHII	ETF	16.0	16.15	15.9999	16.0799	40597.0
2010-01-05	CHIQ	ETF	17.52	17.52	17.29	17.44	111708.0

> showing 50 of 714 rows — these rows as CSV

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