PREVIEW / etf_daily / 2009-03-16

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-16.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-16	SPY	ETF	76.96	77.97	75.81	75.86	360644900.0
2009-03-16	QQQ	ETF	28.9	28.98	28.19	28.26	190329439.0
2009-03-16	IWM	ETF	39.81	40.2	38.56	38.66	78042300.0
2009-03-16	DIA	ETF	72.97	74.07	72.2	72.31	24509000.0
2009-03-16	GLD	ETF	90.29	90.96	90.03	90.8	11782500.0
2009-03-16	TLT	ETF	100.82	101.45	100.5	101.11	3265600.0
2009-03-16	AAXJ	ETF	33.14	33.14	31.2	31.22	68300.0
2009-03-16	ACWI	ETF	27.15	27.4	26.71	26.71	59800.0
2009-03-16	ACWX	ETF	25.19	25.536	24.98	25.03	85546.0
2009-03-16	ADRE	ETF	27.12	27.28	26.5	26.54	184050.0
2009-03-16	AFK	ETF	19.12	19.12	18.94	18.94	601.0
2009-03-16	AGG	ETF	100.24	100.47	100.17	100.36	644000.0
2009-03-16	AGQ	ETF	78.94	78.94	76.94	78.7	71200.0
2009-03-16	AGZ	ETF	107.37	107.52	106.88	107.31	15838.0
2009-03-16	AIA	ETF	23.98	24.3	23.8013	23.8013	15805.0
2009-03-16	AIQ	ETF	35.3	35.8	34.5	34.6	53293.0
2009-03-16	AIS	ETF	0.37	0.4	0.37	0.4	167300.0
2009-03-16	AIVI	ETF	26.49	26.86	26.34	26.34	23700.0
2009-03-16	AOA	ETF	20.9	21.1	20.66	20.66	22600.0
2009-03-16	AOK	ETF	24.38	24.41	24.32	24.32	2448.0
2009-03-16	AOM	ETF	23.37	23.6277	23.3	23.3	3336.0
2009-03-16	AOR	ETF	22.2	22.36	22.2	22.21	2000.0
2009-03-16	ARB	ETF	13.02	13.21	12.63	12.67	190425.0
2009-03-16	BAL	ETF	24.76	24.76	24.6	24.6	1100.0
2009-03-16	BBH	ETF	58.0433	58.0433	56.9867	56.9867	419100.0
2009-03-16	BIL	ETF	91.68	91.72	91.66	91.68	258800.0
2009-03-16	BITS	ETF	16.6	16.92	15.68	16.92	1500.0
2009-03-16	BIV	ETF	74.87	75.37	74.73	75.34	151100.0
2009-03-16	BJK	ETF	14.89	15.43	14.56	15.0	406600.0
2009-03-16	BKF	ETF	24.07	24.33	23.57	23.57	79699.0
2009-03-16	BLV	ETF	71.54	71.99	71.35	71.46	22500.0
2009-03-16	BMVP	ETF	9.41	9.55	9.34	9.34	26242.0
2009-03-16	BND	ETF	76.15	76.38	76.04	76.22	422700.0
2009-03-16	BNE	ETF	1.83	1.96	1.52	1.57	338593.0
2009-03-16	BOSS	ETF	9.61	10.1	9.61	10.1	100.0
2009-03-16	BSV	ETF	78.09	78.15	77.87	78.06	160000.0
2009-03-16	BTF	ETF	37.099999999999994	38.62	37.099999999999994	37.5	14015.6
2009-03-16	BWX	ETF	25.02	25.035	24.905	24.93	202082.0
2009-03-16	CBON	ETF	1.14	1.5	1.13	1.13	28117.0
2009-03-16	CEF	ETF	11.74	11.83	11.56	11.71	710300.0
2009-03-16	CGO	ETF	8.66	8.91	8.66	8.72	31964.0
2009-03-16	CGW	ETF	11.48	11.66	11.2899	11.31	51177.0
2009-03-16	CHB	ETF	0.19	0.19	0.15	0.17	1675548.0
2009-03-16	CHI	ETF	8.24	8.25	8.0	8.0801	180182.0
2009-03-16	CHIC	ETF	6.6	6.7	6.15	6.17	111366.0
2009-03-16	CHW	ETF	5.43	5.43	4.82	4.93	239195.0
2009-03-16	CHY	ETF	8.26	8.26	7.8004	8.02	207039.0
2009-03-16	CMF	ETF	50.88	50.88	50.525	50.73	4940.0
2009-03-16	CNXT	ETF	0.5	0.55	0.49	0.54	238941.0
2009-03-16	COW	ETF	31.4102	31.45	31.2	31.2	5761.0

> showing 50 of 642 rows — these rows as CSV

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