PREVIEW / etf_daily / 2009-05-22

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-22.parquet
  size:    29 KB
  rows:    651

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-22	SPY	ETF	89.46	90.0	88.68	89.02	166811900.0
2009-05-22	QQQ	ETF	33.78	33.97	33.32	33.54	83520293.0
2009-05-22	IWM	ETF	48.54	48.66	47.35	47.79	38440200.0
2009-05-22	DIA	ETF	83.42	83.74	82.66	82.87	10156800.0
2009-05-22	GLD	ETF	94.25	94.42	93.8	94.15	15407200.0
2009-05-22	TLT	ETF	93.82	94.49	93.35	93.53	4483400.0
2009-05-22	AAXJ	ETF	43.04	43.18	42.51	42.72	155300.0
2009-05-22	ACWI	ETF	34.15	34.24	33.86	34.01	73000.0
2009-05-22	ACWX	ETF	33.42	33.47	33.228	33.25	17867.0
2009-05-22	ADRE	ETF	34.25	34.59	33.996	34.36	189426.0
2009-05-22	AFK	ETF	25.6	25.97	24.78	25.91	13606.0
2009-05-22	AGG	ETF	101.89	101.96	101.6	101.7	433400.0
2009-05-22	AGQ	ETF	98.16	98.2	96.16	97.24	117750.0
2009-05-22	AGZ	ETF	107.57	107.64	107.2	107.46	12907.0
2009-05-22	AIA	ETF	31.45	31.9	31.45	31.69	9030.0
2009-05-22	AIQ	ETF	34.6	34.7	33.7505	34.25	24273.0
2009-05-22	AIS	ETF	0.5299	0.54	0.5	0.54	85900.0
2009-05-22	AIVI	ETF	35.27	35.44	35.21	35.21	4400.0
2009-05-22	AMJ	ETF	22.38	22.38	22.0322	22.12	45928.0
2009-05-22	AOA	ETF	24.65	24.7	24.54	24.57	13000.0
2009-05-22	AOK	ETF	25.52	26.19	25.5	26.19	3746.0
2009-05-22	AOM	ETF	25.43	25.49	25.23	25.45	9873.0
2009-05-22	AOR	ETF	25.18	25.98	25.18	25.98	2267.0
2009-05-22	ARB	ETF	20.16	20.57	19.7	20.07	318970.0
2009-05-22	BAL	ETF	32.2589	32.4	32.22	32.22	3425.0
2009-05-22	BBH	ETF	29.8233	29.87	29.5233	29.58	238200.0
2009-05-22	BIL	ETF	91.74	91.74	91.68	91.74	231500.0
2009-05-22	BITS	ETF	17.92	18.32	17.92	18.0	22675.0
2009-05-22	BIV	ETF	76.53	76.67	76.22	76.38	102800.0
2009-05-22	BJK	ETF	21.62	22.34	21.05	22.0	27200.0
2009-05-22	BKF	ETF	34.09	34.31	33.6	34.0	107916.0
2009-05-22	BLV	ETF	72.55	72.56	72.12	72.23	17200.0
2009-05-22	BMVP	ETF	10.54	10.6	10.485	10.53	17406.0
2009-05-22	BND	ETF	77.35	77.48	77.21	77.35	515000.0
2009-05-22	BNE	ETF	5.28	5.41	5.15	5.27	82306.0
2009-05-22	BOSS	ETF	16.55	16.59	15.95	15.95	800.0
2009-05-22	BRF	ETF	26.0	26.06	25.47	25.97	33608.0
2009-05-22	BSV	ETF	79.15	79.2	79.03	79.16	171000.0
2009-05-22	BTF	ETF	46.9	47.199999999999996	46.050000000000004	47.199999999999996	7583.200000000001
2009-05-22	BWX	ETF	27.1	27.17	27.0096	27.075	262124.0
2009-05-22	BWZ	ETF	35.15	35.187	35.15	35.187	1096.0
2009-05-22	CBON	ETF	1.28	1.28	1.22	1.22	18951.0
2009-05-22	CEF	ETF	12.29	12.42	12.1	12.32	1304400.0
2009-05-22	CEW	ETF	20.75	20.75	20.65	20.72	133249.0
2009-05-22	CGO	ETF	10.42	10.77	10.41	10.77	68931.0
2009-05-22	CGW	ETF	14.92	14.9736	14.7498	14.85	13318.0
2009-05-22	CHB	ETF	0.46	0.483	0.46	0.47	253644.0
2009-05-22	CHI	ETF	10.335	10.44	10.31	10.39	262843.0
2009-05-22	CHIC	ETF	9.8	10.15	9.6	10.12	192172.0
2009-05-22	CHW	ETF	6.73	6.86	6.65	6.68	242069.0

> showing 50 of 651 rows — these rows as CSV

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