PREVIEW / etf_daily / 2009-09-14

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-14.parquet
  size:    29 KB
  rows:    665

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-09-14	SPY	ETF	103.88	105.46	103.15	105.28	149593800.0
2009-09-14	QQQ	ETF	41.23	41.71	41.21	41.68	90560527.0
2009-09-14	IWM	ETF	58.98	60.11	58.87	60.05	37896000.0
2009-09-14	DIA	ETF	95.44	96.45	95.4	96.32	8417900.0
2009-09-14	GLD	ETF	98.16	98.43	97.73	97.96	9631500.0
2009-09-14	TLT	ETF	96.02	96.67	95.65	95.74	2119500.0
2009-09-14	AAXJ	ETF	51.33	51.77	51.02	51.7	648700.0
2009-09-14	ACWI	ETF	39.82	40.48	39.69	40.42	61100.0
2009-09-14	ACWX	ETF	39.05	39.58	39.05	39.58	20289.0
2009-09-14	ADRE	ETF	39.6	40.21	38.59	40.14	232035.0
2009-09-14	AFK	ETF	28.08	28.2099	28.0	28.0408	8104.0
2009-09-14	AGG	ETF	104.0	104.38	104.0	104.09	375400.0
2009-09-14	AGQ	ETF	114.7	116.02	113.56	114.52	189100.0
2009-09-14	AGZ	ETF	108.005	108.44	107.9501	107.9501	5743.0
2009-09-14	AIA	ETF	37.31	37.75	37.31	37.75	15661.0
2009-09-14	AIQ	ETF	27.75	27.8	27.2	27.8	40686.0
2009-09-14	AIS	ETF	1.16	1.16	1.05	1.09	805490.0
2009-09-14	AIVI	ETF	42.0	42.71	42.0	42.71	20100.0
2009-09-14	AMJ	ETF	24.55	24.7	24.46	24.7	89354.0
2009-09-14	AOA	ETF	28.74	28.82	28.68	28.68	2900.0
2009-09-14	AOK	ETF	27.05	27.05	26.8	27.0	975.0
2009-09-14	AOM	ETF	27.65	27.73	27.5794	27.73	15716.0
2009-09-14	AOR	ETF	28.04	28.24	28.0	28.2244	5401.0
2009-09-14	ARB	ETF	18.32	18.61	18.27	18.52	143720.0
2009-09-14	BAL	ETF	31.7	32.41	31.7	32.19	4060.0
2009-09-14	BBH	ETF	33.4133	33.9133	33.4133	33.8433	161400.0
2009-09-14	BIL	ETF	91.74	91.74	91.7	91.7	89550.0
2009-09-14	BITS	ETF	21.2	22.0	20.6	21.68	3493.0
2009-09-14	BIV	ETF	80.0	80.02	79.58	79.64	246100.0
2009-09-14	BJK	ETF	24.92	26.0	24.92	25.8	24500.0
2009-09-14	BKF	ETF	39.91	40.7376	39.9	40.57	143247.0
2009-09-14	BLV	ETF	78.55	78.91	78.26	78.26	33500.0
2009-09-14	BMVP	ETF	11.853	11.965	11.853	11.963	10839.0
2009-09-14	BND	ETF	79.13	79.13	78.83	78.88	429800.0
2009-09-14	BNE	ETF	6.97	7.33	6.87	7.3	152914.0
2009-09-14	BRF	ETF	39.33	39.33	38.0	39.02	344794.0
2009-09-14	BSV	ETF	79.93	79.93	79.76	79.86	442100.0
2009-09-14	BTF	ETF	57.64999999999999	58.000499999999995	57.55	58.000499999999995	2306.8
2009-09-14	BWX	ETF	28.985	29.11	28.84	29.065	475442.0
2009-09-14	BWZ	ETF	37.04	37.04	36.9117	37.02	40571.0
2009-09-14	BZQ	ETF	6416.0	6416.0	6152.0	6152.0	22.0
2009-09-14	CEF	ETF	13.05	13.37	13.02	13.1	814700.0
2009-09-14	CEW	ETF	21.49	21.5	21.4101	21.4678	27027.0
2009-09-14	CGO	ETF	13.58	13.78	13.58	13.71	19176.0
2009-09-14	CGW	ETF	17.61	17.83	17.5	17.83	63941.0
2009-09-14	CHB	ETF	0.46	0.48	0.445	0.47	2048364.0
2009-09-14	CHI	ETF	11.28	11.429	11.22	11.4125	138080.0
2009-09-14	CHIC	ETF	17.44	17.45	17.43	17.45	420690.0
2009-09-14	CHW	ETF	7.44	7.56	7.34	7.56	171249.0
2009-09-14	CHY	ETF	11.07	11.24	11.03	11.24	136167.0

> showing 50 of 665 rows — these rows as CSV

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