PREVIEW / etf_daily / 2009-02-13

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-13.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-02-13	SPY	ETF	83.55	84.24	82.74	82.76	293998400.0
2009-02-13	QQQ	ETF	30.46	30.78	30.29	30.43	145060587.0
2009-02-13	IWM	ETF	45.08	45.7	44.58	44.67	58901500.0
2009-02-13	DIA	ETF	79.48	79.95	78.47	78.55	23850300.0
2009-02-13	GLD	ETF	92.5	92.77	91.69	92.55	14715500.0
2009-02-13	TLT	ETF	103.95	103.95	102.23	102.41	2466800.0
2009-02-13	AAXJ	ETF	31.57	31.79	31.23	31.6	28400.0
2009-02-13	ACWI	ETF	29.27	29.34	28.94	28.98	102100.0
2009-02-13	ACWX	ETF	27.12	27.168	26.78	26.78	86587.0
2009-02-13	ADRE	ETF	27.49	27.78	27.29	27.62	208571.0
2009-02-13	AFK	ETF	18.86	18.86	18.86	18.86	100.0
2009-02-13	AGG	ETF	101.39	102.03	101.39	101.79	851900.0
2009-02-13	AGQ	ETF	85.52	89.7	84.5	89.64	30350.0
2009-02-13	AGZ	ETF	107.6	107.77	106.96	107.49	86708.0
2009-02-13	AIA	ETF	24.07	24.45	24.07	24.42	13813.0
2009-02-13	AIQ	ETF	47.2	48.8	46.85	48.45	32924.0
2009-02-13	AIS	ETF	0.4	0.41	0.4	0.41	41800.0
2009-02-13	AIVI	ETF	29.03	29.16	28.84	28.84	11300.0
2009-02-13	AOA	ETF	22.49	22.49	22.11	22.34	299800.0
2009-02-13	AOK	ETF	25.09	25.09	25.09	25.09	200.0
2009-02-13	AOM	ETF	24.45	24.45	24.28	24.28	4007.0
2009-02-13	AOR	ETF	23.21	23.55	23.21	23.52	11866.0
2009-02-13	ARB	ETF	13.82	14.15	13.49	13.61	141876.0
2009-02-13	BAL	ETF	26.38	26.446	26.38	26.446	200.0
2009-02-13	BBH	ETF	58.7367	58.8833	58.3933	58.56	205200.0
2009-02-13	BIL	ETF	91.68	91.76	91.66	91.76	1087600.0
2009-02-13	BITS	ETF	19.0	19.4	18.8	19.4	499.0
2009-02-13	BIV	ETF	77.44	77.64	77.16	77.55	57600.0
2009-02-13	BJK	ETF	15.45	15.67	15.37	15.37	300.0
2009-02-13	BKF	ETF	24.5	24.68	24.3	24.65	18803.0
2009-02-13	BLV	ETF	74.37	74.37	73.82	73.82	9600.0
2009-02-13	BMVP	ETF	10.35	10.46	10.32	10.37	72745.0
2009-02-13	BND	ETF	77.1	77.24	76.96	76.96	300700.0
2009-02-13	BNE	ETF	2.99	3.16	2.84	2.9	107421.0
2009-02-13	BOSS	ETF	12.21	12.21	12.21	12.21	100.0
2009-02-13	BSV	ETF	79.62	79.62	78.4	79.26	220600.0
2009-02-13	BTF	ETF	46.9	47.0	45.49999999999999	46.15	12429.6
2009-02-13	BWX	ETF	25.16	25.345	25.16	25.305	131438.0
2009-02-13	BWZ	ETF	32.6	32.6	32.55	32.55	1904.0
2009-02-13	CBON	ETF	1.81	1.85	1.75	1.84	51580.0
2009-02-13	CDL	ETF	0.15	0.17	0.15	0.16	360943.0
2009-02-13	CEF	ETF	11.85	11.96	11.63	11.92	1320100.0
2009-02-13	CGO	ETF	10.28	10.28	10.0456	10.05	19932.0
2009-02-13	CGW	ETF	13.26	13.43	13.1271	13.15	137258.0
2009-02-13	CHB	ETF	0.39	0.43	0.39	0.43	269919.0
2009-02-13	CHI	ETF	8.6	8.77	8.6	8.77	141300.0
2009-02-13	CHIC	ETF	5.41	5.63	5.25	5.26	195547.0
2009-02-13	CHW	ETF	6.52	6.52	6.3	6.32	132717.0
2009-02-13	CHY	ETF	9.06	9.09	8.71	8.74	313489.0
2009-02-13	CMF	ETF	51.398	51.494	51.175	51.2175	8470.0

> showing 50 of 642 rows — these rows as CSV

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