PREVIEW / etf_daily / 2009-04-17

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-17.parquet
  size:    28 KB
  rows:    649

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
2009-04-17	SPY	ETF	86.83	87.65	86.14	87.08	262649000.0
2009-04-17	QQQ	ETF	33.16	33.5	32.93	33.31	129835395.0
2009-04-17	IWM	ETF	47.43	48.27	46.92	47.75	51981400.0
2009-04-17	DIA	ETF	81.44	81.85	80.82	81.31	16835600.0
2009-04-17	GLD	ETF	85.75	86.37	84.92	85.22	22332700.0
2009-04-17	TLT	ETF	102.47	102.71	101.37	101.7	2582800.0
2009-04-17	AAXJ	ETF	37.78	38.0	37.41	37.61	111100.0
2009-04-17	ACWI	ETF	31.41	31.62	31.2	31.32	224200.0
2009-04-17	ACWX	ETF	29.55	29.6076	29.276	29.47	77380.0
2009-04-17	ADRE	ETF	30.75	30.75	30.36	30.44	248616.0
2009-04-17	AFK	ETF	21.01	21.01	20.9388	20.9388	600.0
2009-04-17	AGG	ETF	101.05	101.11	100.67	100.67	486900.0
2009-04-17	AGQ	ETF	66.38	66.6	64.02	64.4	106700.0
2009-04-17	AGZ	ETF	108.07	108.07	107.55	107.74	6900.0
2009-04-17	AIA	ETF	28.49	28.674	28.3101	28.6492	16039.0
2009-04-17	AIQ	ETF	41.5	44.3	41.275	43.7	96000.0
2009-04-17	AIS	ETF	0.46	0.47	0.45	0.45	10675.0
2009-04-17	AIVI	ETF	31.62	31.7	31.45	31.58	8700.0
2009-04-17	AMJ	ETF	20.55	20.55	20.44	20.54	1929.0
2009-04-17	AOA	ETF	23.38	23.53	23.38	23.53	2000.0
2009-04-17	AOK	ETF	25.3	25.6212	25.2744	25.3	2976.0
2009-04-17	AOM	ETF	24.8	24.97	24.54	24.8361	7242.0
2009-04-17	AOR	ETF	24.52	24.52	24.2168	24.29	3784.0
2009-04-17	ARB	ETF	19.15	19.72	18.68	19.63	472433.0
2009-04-17	BAL	ETF	28.35	28.74	28.19	28.74	8250.0
2009-04-17	BBH	ETF	29.56	29.9067	28.7067	29.21	614700.0
2009-04-17	BIL	ETF	91.76	91.76	91.66	91.66	467950.0
2009-04-17	BITS	ETF	17.77	17.8	17.24	17.76	3000.0
2009-04-17	BIV	ETF	76.66	76.76	75.91	76.42	147300.0
2009-04-17	BJK	ETF	18.48	18.71	18.06	18.31	5900.0
2009-04-17	BKF	ETF	29.21	29.38	29.0	29.23	269395.0
2009-04-17	BLV	ETF	73.42	73.47	72.43	72.67	11400.0
2009-04-17	BMVP	ETF	10.5367	10.6337	10.5133	10.5867	28219.0
2009-04-17	BND	ETF	77.17	77.26	76.69	76.84	609300.0
2009-04-17	BNE	ETF	4.86	5.12	4.73	4.87	257501.0
2009-04-17	BSV	ETF	78.6	78.8	78.4	78.49	173400.0
2009-04-17	BTF	ETF	46.449999999999996	46.8	45.949999999999996	46.74999999999999	6293.200000000001
2009-04-17	BWX	ETF	25.305	25.55	25.305	25.375	395864.0
2009-04-17	BWZ	ETF	32.9	32.95	32.9	32.925	5000.0
2009-04-17	CBON	ETF	2.49	2.5	2.32	2.5	16460.0
2009-04-17	CEF	ETF	10.56	10.63	10.45	10.62	1140200.0
2009-04-17	CGO	ETF	9.55	9.71	9.51	9.65	48918.0
2009-04-17	CGW	ETF	13.42	13.49	13.23	13.35	44381.0
2009-04-17	CHB	ETF	0.64	0.65	0.61	0.63	533636.0
2009-04-17	CHI	ETF	9.46	9.5	9.3	9.42	181779.0
2009-04-17	CHIC	ETF	12.57	12.92	12.02	12.18	1314223.0
2009-04-17	CHW	ETF	5.97	6.2	5.96	6.02	238361.0
2009-04-17	CHY	ETF	8.96	9.11	8.93	9.09	235604.0
2009-04-17	CMF	ETF	52.095	52.095	52.0	52.095	2796.0
2009-04-17	CNXT	ETF	0.726	1.41	0.726	1.27	2154199.0

> showing 50 of 649 rows — these rows as CSV

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