PREVIEW / etf_daily / 2009-04-09

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-09.parquet
  size:    28 KB
  rows:    646

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-04-09	SPY	ETF	84.67	85.82	84.33	85.81	269653500.0
2009-04-09	QQQ	ETF	32.53	33.01	32.43	32.94	131871447.0
2009-04-09	IWM	ETF	45.28	46.71	45.1	46.64	66699400.0
2009-04-09	DIA	ETF	80.01	80.92	79.76	80.89	19287700.0
2009-04-09	GLD	ETF	86.33	86.88	86.1	86.31	9607100.0
2009-04-09	TLT	ETF	102.47	103.18	101.98	102.35	1088800.0
2009-04-09	AAXJ	ETF	36.89	37.02	36.21	36.84	63200.0
2009-04-09	ACWI	ETF	30.58	30.75	30.44	30.75	55100.0
2009-04-09	ACWX	ETF	28.8	28.98	28.59	28.98	71281.0
2009-04-09	ADRE	ETF	30.2	30.75	30.08	30.75	285623.0
2009-04-09	AFK	ETF	20.52	20.5414	20.5124	20.5414	535.0
2009-04-09	AGG	ETF	100.28	100.71	100.21	100.42	564100.0
2009-04-09	AGQ	ETF	69.12	71.26	68.64	70.04	66650.0
2009-04-09	AGZ	ETF	107.8	107.88	107.6	107.87	4366.0
2009-04-09	AIA	ETF	27.41	27.82	27.41	27.71	33446.0
2009-04-09	AIQ	ETF	37.8	39.65	37.75	38.75	40228.0
2009-04-09	AIS	ETF	0.44	0.44	0.405	0.43	67260.0
2009-04-09	AIVI	ETF	30.77	30.77	30.37	30.66	4800.0
2009-04-09	AMJ	ETF	19.82	19.87	19.76	19.78	15800.0
2009-04-09	AOA	ETF	23.07	23.25	23.01	23.25	5500.0
2009-04-09	AOK	ETF	25.0794	25.2	24.18	25.2	3000.0
2009-04-09	AOM	ETF	24.48	24.68	24.4039	24.68	3091.0
2009-04-09	AOR	ETF	23.8694	24.03	23.838	24.03	18430.0
2009-04-09	ARB	ETF	16.55	17.06	16.38	17.02	245601.0
2009-04-09	BAL	ETF	28.15	28.15	27.5	27.5	1625.0
2009-04-09	BBH	ETF	30.4167	30.6667	29.9967	30.31	386400.0
2009-04-09	BIL	ETF	91.72	91.72	91.68	91.68	542500.0
2009-04-09	BITS	ETF	18.4004	18.8	17.52	18.72	1806.0
2009-04-09	BIV	ETF	75.93	76.18	75.75	75.9	54300.0
2009-04-09	BJK	ETF	17.3	17.89	17.21	17.41	3200.0
2009-04-09	BKF	ETF	28.76	29.01	28.39	29.01	79430.0
2009-04-09	BLV	ETF	71.97	72.74	71.92	72.22	28500.0
2009-04-09	BMVP	ETF	10.303	10.433	10.29	10.431	22374.0
2009-04-09	BND	ETF	76.83	77.08	76.69	76.97	495100.0
2009-04-09	BNE	ETF	3.49	4.05	3.33	3.96	482410.0
2009-04-09	BOSS	ETF	11.58	11.6	11.58	11.6	500.0
2009-04-09	BSV	ETF	78.54	78.62	78.41	78.5	198700.0
2009-04-09	BTF	ETF	44.74999999999999	48.75	44.74999999999999	46.25	31347.600000000002
2009-04-09	BWX	ETF	25.55	25.55	25.325	25.325	118738.0
2009-04-09	BWZ	ETF	32.97	32.97	32.97	32.97	100.0
2009-04-09	CBON	ETF	2.44	2.44	2.03	2.37	44865.0
2009-04-09	CEF	ETF	10.87	11.04	10.83	11.0	1836600.0
2009-04-09	CGO	ETF	9.34	9.5	9.21	9.4	35978.0
2009-04-09	CGW	ETF	12.64	13.08	12.55	13.03	42117.0
2009-04-09	CHB	ETF	0.53	0.5398	0.5	0.51	523944.0
2009-04-09	CHI	ETF	8.85	8.91	8.78	8.85	122475.0
2009-04-09	CHIC	ETF	10.65	10.7193	9.86	10.4	867838.0
2009-04-09	CHW	ETF	5.82	5.99	5.8	5.94	190435.0
2009-04-09	CHY	ETF	8.6	8.95	8.52	8.95	228128.0
2009-04-09	CMF	ETF	51.91	52.0	51.781	52.0	17992.0

> showing 50 of 646 rows — these rows as CSV

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