PREVIEW / etf_daily / 2009-03-17

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-17.parquet
  size:    28 KB
  rows:    642

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-03-17	SPY	ETF	76.07	78.36	75.45	78.18	356814300.0
2009-03-17	QQQ	ETF	28.41	29.33	28.3	29.33	169852396.0
2009-03-17	IWM	ETF	38.73	40.45	38.43	40.45	64727100.0
2009-03-17	DIA	ETF	72.29	74.12	71.86	74.08	20439900.0
2009-03-17	GLD	ETF	90.26	90.59	89.75	90.04	10052400.0
2009-03-17	TLT	ETF	101.72	102.33	100.39	100.56	3076200.0
2009-03-17	AAXJ	ETF	31.27	31.67	31.0	31.67	75500.0
2009-03-17	ACWI	ETF	26.73	27.52	26.61	27.52	120400.0
2009-03-17	ACWX	ETF	24.87	25.64	24.81	25.64	58939.0
2009-03-17	ADRE	ETF	26.75	27.15	26.2	27.15	182733.0
2009-03-17	AFK	ETF	18.95	18.95	18.907	18.907	200.0
2009-03-17	AGG	ETF	100.52	100.6	100.03	100.06	644200.0
2009-03-17	AGQ	ETF	78.04	78.28	75.12	76.16	48000.0
2009-03-17	AGZ	ETF	107.2	107.5	106.74	106.96	5369.0
2009-03-17	AIA	ETF	24.03	24.4	23.8319	24.4	8436.0
2009-03-17	AIQ	ETF	34.65	34.9	34.15	34.25	57081.0
2009-03-17	AIS	ETF	0.3899	0.4	0.3899	0.4	16080.0
2009-03-17	AIVI	ETF	26.59	27.22	26.22	27.21	23200.0
2009-03-17	AOA	ETF	20.69	21.14	20.63	21.14	15600.0
2009-03-17	AOK	ETF	24.28	24.64	23.54	24.27	4815.0
2009-03-17	AOM	ETF	23.368	23.37	23.27	23.36	1975.0
2009-03-17	AOR	ETF	22.2	22.328	21.97	22.26	7120.0
2009-03-17	ARB	ETF	12.63	13.06	12.19	13.03	282220.0
2009-03-17	BAL	ETF	24.5	24.5	24.5	24.5	500.0
2009-03-17	BBH	ETF	57.1967	57.85	57.0667	57.8333	693600.0
2009-03-17	BIL	ETF	91.68	91.74	91.68	91.74	141750.0
2009-03-17	BITS	ETF	17.24	18.2	16.1	18.2	2074.0
2009-03-17	BIV	ETF	75.38	75.54	74.76	74.87	87700.0
2009-03-17	BJK	ETF	15.78	15.78	14.45	14.8	52200.0
2009-03-17	BKF	ETF	23.68	24.09	23.26	24.09	30377.0
2009-03-17	BLV	ETF	71.55	72.28	70.94	71.45	23700.0
2009-03-17	BMVP	ETF	9.3333	9.6142	9.3233	9.6142	30057.0
2009-03-17	BND	ETF	76.36	76.36	75.94	76.05	600000.0
2009-03-17	BNE	ETF	1.52	1.52	1.25	1.45	248962.0
2009-03-17	BOSS	ETF	9.7	10.64	9.7	10.64	1300.0
2009-03-17	BSV	ETF	78.09	78.2	77.8	77.96	165400.0
2009-03-17	BTF	ETF	37.55	38.25	36.949999999999996	38.25	7505.200000000001
2009-03-17	BWX	ETF	24.83	24.97	24.8	24.955	185952.0
2009-03-17	BWZ	ETF	32.17	32.17	31.968	31.98	1685.0
2009-03-17	CBON	ETF	1.15	1.16	1.03	1.09	13225.0
2009-03-17	CEF	ETF	11.7	11.74	11.46	11.54	842600.0
2009-03-17	CGO	ETF	8.82	9.0	8.65	8.85	67849.0
2009-03-17	CGW	ETF	11.19	11.7578	11.19	11.7345	116711.0
2009-03-17	CHB	ETF	0.17	0.17	0.15	0.17	507103.0
2009-03-17	CHI	ETF	8.11	8.29	8.03	8.29	189442.0
2009-03-17	CHIC	ETF	6.44	6.71	6.15	6.6	538701.0
2009-03-17	CHW	ETF	5.02	5.12	4.94	5.12	254716.0
2009-03-17	CHY	ETF	8.12	8.12	7.93	8.04	202796.0
2009-03-17	CMF	ETF	50.625	51.38	50.425	50.83	116594.0
2009-03-17	CNXT	ETF	0.54	0.59	0.52	0.561	342781.0

> showing 50 of 642 rows — these rows as CSV

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