PREVIEW / etf_daily / 2009-05-21

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-21.parquet
  size:    29 KB
  rows:    650

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-05-21	SPY	ETF	89.46	89.8	88.26	89.21	258988400.0
2009-05-21	QQQ	ETF	34.02	34.26	33.31	33.65	139253125.0
2009-05-21	IWM	ETF	48.27	48.7	47.45	48.29	49312200.0
2009-05-21	DIA	ETF	83.28	83.33	82.3	83.1	20038800.0
2009-05-21	GLD	ETF	92.35	93.86	91.93	93.85	21830200.0
2009-05-21	TLT	ETF	97.55	97.64	94.35	94.58	4771700.0
2009-05-21	AAXJ	ETF	42.58	42.66	42.04	42.58	388700.0
2009-05-21	ACWI	ETF	33.94	34.02	33.62	33.91	155500.0
2009-05-21	ACWX	ETF	32.98	33.08	32.74	33.05	268956.0
2009-05-21	ADRE	ETF	34.3	34.3	33.6501	34.15	85848.0
2009-05-21	AFK	ETF	25.25	26.4	24.78	25.0	29717.0
2009-05-21	AGG	ETF	102.3	102.44	101.75	101.97	393400.0
2009-05-21	AGQ	ETF	90.74	95.4	89.42	95.24	153200.0
2009-05-21	AGZ	ETF	108.02	108.02	107.502	107.502	5469.0
2009-05-21	AIA	ETF	31.4	31.48	31.0101	31.29	12192.0
2009-05-21	AIQ	ETF	35.35	35.7	34.1	34.5	30005.0
2009-05-21	AIS	ETF	0.55	0.55	0.5	0.52	176750.0
2009-05-21	AIVI	ETF	34.86	35.23	34.75	35.23	9400.0
2009-05-21	AMJ	ETF	22.42	22.42	21.92	22.16	141111.0
2009-05-21	AOA	ETF	24.99	25.49	24.4	24.55	16100.0
2009-05-21	AOK	ETF	25.57	26.19	25.09	26.122	21566.0
2009-05-21	AOM	ETF	25.4438	25.56	25.23	25.42	13858.0
2009-05-21	AOR	ETF	25.0868	25.14	25.07	25.13	1828.0
2009-05-21	ARB	ETF	20.11	20.27	19.51	20.13	271466.0
2009-05-21	BAL	ETF	31.71	32.26	31.7	31.976	5870.0
2009-05-21	BBH	ETF	29.8967	30.1233	29.3733	29.65	624600.0
2009-05-21	BIL	ETF	91.68	91.74	91.68	91.72	293850.0
2009-05-21	BITS	ETF	17.9976	18.0	17.92	17.92	100.0
2009-05-21	BIV	ETF	77.58	77.58	76.49	76.58	134400.0
2009-05-21	BJK	ETF	20.92	21.46	20.4	21.3	1299000.0
2009-05-21	BKF	ETF	33.34	33.7176	33.09	33.61	59012.0
2009-05-21	BLV	ETF	74.19	74.25	72.52	72.54	27100.0
2009-05-21	BMVP	ETF	10.537	10.587	10.417	10.49	38418.0
2009-05-21	BND	ETF	77.82	77.88	77.25	77.37	292700.0
2009-05-21	BNE	ETF	5.35	5.47	4.95	5.21	156749.0
2009-05-21	BRF	ETF	25.92	25.93	25.3	25.5	71884.0
2009-05-21	BSV	ETF	79.25	79.33	78.9	79.2	256000.0
2009-05-21	BTF	ETF	46.849999999999994	47.0	45.49999999999999	47.0	4707.2
2009-05-21	BWX	ETF	26.845	27.08	26.785	27.02	250356.0
2009-05-21	BWZ	ETF	34.8199	34.83	34.8199	34.82	1965.0
2009-05-21	CBON	ETF	1.29	1.2996	1.22	1.22	7546.0
2009-05-21	CEF	ETF	11.84	12.22	11.72	12.19	1291200.0
2009-05-21	CEW	ETF	20.56	20.7	20.54	20.65	37630.0
2009-05-21	CGO	ETF	10.33	10.42	10.26	10.41	33194.0
2009-05-21	CGW	ETF	14.89	14.89	14.6601	14.84	40276.0
2009-05-21	CHB	ETF	0.47	0.49	0.45	0.45	698359.0
2009-05-21	CHI	ETF	10.15	10.37	10.02	10.23	157762.0
2009-05-21	CHIC	ETF	10.36	10.61	9.51	9.71	432111.0
2009-05-21	CHW	ETF	6.65	6.72	6.55	6.66	215453.0
2009-05-21	CHY	ETF	9.8	9.85	9.5584	9.85	203849.0

> showing 50 of 650 rows — these rows as CSV

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