PREVIEW / etf_daily / 2009-03-20

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-20.parquet
  size:    28 KB
  rows:    637

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-20	SPY	ETF	78.76	78.91	76.53	76.71	371078200.0
2009-03-20	QQQ	ETF	29.66	30.03	28.98	29.18	149437356.0
2009-03-20	IWM	ETF	41.8	41.92	39.95	39.98	68436500.0
2009-03-20	DIA	ETF	74.43	74.56	72.53	72.74	22996500.0
2009-03-20	GLD	ETF	93.48	94.37	93.13	93.59	18072300.0
2009-03-20	TLT	ETF	104.62	105.0	103.78	103.92	3479700.0
2009-03-20	AAXJ	ETF	32.13	32.13	31.04	31.14	43800.0
2009-03-20	ACWI	ETF	28.0	28.08	27.46	27.49	175900.0
2009-03-20	ACWX	ETF	26.3	26.32	25.83	25.91	24863.0
2009-03-20	ADRE	ETF	27.5	27.52	26.806	26.91	132779.0
2009-03-20	AFK	ETF	20.04	20.04	19.59	19.59	300.0
2009-03-20	AGG	ETF	101.89	102.03	101.26	101.33	513100.0
2009-03-20	AGQ	ETF	85.78	89.84	85.3	88.6	107150.0
2009-03-20	AGZ	ETF	108.35	108.404	107.85	108.188	9723.0
2009-03-20	AIA	ETF	24.5	24.5	23.88	23.88	9971.0
2009-03-20	AIQ	ETF	33.95	34.1	32.4	33.0	75183.0
2009-03-20	AIS	ETF	0.39	0.4	0.39	0.4	6825.0
2009-03-20	AIVI	ETF	28.19	28.37	27.71	27.8	7200.0
2009-03-20	AOA	ETF	21.59	21.69	21.1	21.22	29800.0
2009-03-20	AOK	ETF	24.76	26.4	24.6	24.66	46112.0
2009-03-20	AOM	ETF	23.74	24.62	23.59	24.62	29126.0
2009-03-20	AOR	ETF	22.8294	24.61	22.52	22.59	59124.0
2009-03-20	ARB	ETF	13.03	13.52	12.66	12.66	313760.0
2009-03-20	BAL	ETF	24.7	25.391	24.7	25.391	15800.0
2009-03-20	BBH	ETF	57.1467	57.3133	56.7	56.7	1029300.0
2009-03-20	BIL	ETF	91.76	91.76	91.72	91.74	198550.0
2009-03-20	BITS	ETF	16.8	18.6	16.04	18.6	3466.0
2009-03-20	BIV	ETF	76.91	77.1	76.46	76.64	84100.0
2009-03-20	BJK	ETF	15.77	16.21	15.46	15.97	72600.0
2009-03-20	BKF	ETF	24.4	24.47	23.96	24.0708	169344.0
2009-03-20	BLV	ETF	72.38	73.71	72.38	72.88	16100.0
2009-03-20	BMVP	ETF	9.76	9.76	9.51	9.53	19487.0
2009-03-20	BND	ETF	77.16	77.39	76.86	77.0	495800.0
2009-03-20	BNE	ETF	2.09	2.79	2.01	2.79	837371.0
2009-03-20	BSV	ETF	78.67	78.77	78.36	78.63	186900.0
2009-03-20	BTF	ETF	39.05	39.3	37.65	38.3	7322.200000000001
2009-03-20	BWX	ETF	26.045	26.155	25.965	25.995	315418.0
2009-03-20	BWZ	ETF	33.36	33.38	33.317	33.35	12372.0
2009-03-20	CBON	ETF	1.01	1.25	0.98	1.25	62105.0
2009-03-20	CEF	ETF	12.41	12.58	12.3	12.56	1201200.0
2009-03-20	CGO	ETF	8.56	8.71	8.55	8.7044	15376.0
2009-03-20	CGW	ETF	11.82	12.11	11.72	11.84	56003.0
2009-03-20	CHB	ETF	0.193	0.22	0.16	0.22	1868453.0
2009-03-20	CHI	ETF	8.35	8.35	8.03	8.19	125986.0
2009-03-20	CHIC	ETF	6.84	7.2	6.6	6.71	359906.0
2009-03-20	CHW	ETF	5.17	5.26	5.01	5.14	146076.0
2009-03-20	CHY	ETF	7.91	8.03	7.75	7.884	105716.0
2009-03-20	CMF	ETF	51.25	51.95	51.25	51.765	6870.0
2009-03-20	CNXT	ETF	0.72	0.73	0.65	0.7	380628.0
2009-03-20	COW	ETF	31.76	31.82	31.4601	31.523	18827.0

> showing 50 of 637 rows — these rows as CSV

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