PREVIEW / etf_daily / 2009-05-08

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-08.parquet
  size:    29 KB
  rows:    653

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-08	SPY	ETF	92.03	93.22	91.44	92.98	299081700.0
2009-05-08	QQQ	ETF	34.35	34.74	33.88	34.23	183507282.0
2009-05-08	IWM	ETF	50.15	51.16	49.64	51.01	63463900.0
2009-05-08	DIA	ETF	85.14	85.97	84.61	85.72	18463400.0
2009-05-08	GLD	ETF	89.71	90.09	88.91	89.98	10939800.0
2009-05-08	TLT	ETF	95.02	95.39	94.64	94.94	2193400.0
2009-05-08	AAXJ	ETF	42.05	42.89	41.95	42.87	374700.0
2009-05-08	ACWI	ETF	34.16	34.77	33.86	34.63	365900.0
2009-05-08	ACWX	ETF	32.72	33.35	32.56	33.32	49702.0
2009-05-08	ADRE	ETF	34.14	34.39	33.6	34.35	199711.0
2009-05-08	AFK	ETF	27.0	27.0	23.046	24.61	4160.0
2009-05-08	AGG	ETF	101.08	101.42	100.84	101.18	706000.0
2009-05-08	AGQ	ETF	87.9	88.56	86.02	88.48	115150.0
2009-05-08	AGZ	ETF	107.41	108.21	107.41	108.04	48618.0
2009-05-08	AIA	ETF	31.73	32.63	31.73	32.55	132861.0
2009-05-08	AIQ	ETF	39.0	40.2	39.0	39.8	21362.0
2009-05-08	AIS	ETF	0.549	0.57	0.529	0.5699	166915.0
2009-05-08	AIVI	ETF	34.39	35.17	34.25	35.17	7000.0
2009-05-08	AMJ	ETF	22.03	22.22	21.94	22.16	26697.0
2009-05-08	AOA	ETF	24.96	25.26	24.96	25.26	6100.0
2009-05-08	AOK	ETF	26.19	26.49	25.59	26.49	6322.0
2009-05-08	AOM	ETF	25.69	25.83	25.448	25.67	15487.0
2009-05-08	AOR	ETF	25.31	25.47	25.2	25.47	6638.0
2009-05-08	ARB	ETF	20.7	21.0	20.25	20.68	198275.0
2009-05-08	BAL	ETF	33.56	33.68	33.38	33.5488	6565.0
2009-05-08	BBH	ETF	29.32	29.72	28.99	29.2833	725400.0
2009-05-08	BIL	ETF	91.68	91.7	91.66	91.68	187700.0
2009-05-08	BITS	ETF	18.44	18.84	18.2	18.42	7249.0
2009-05-08	BIV	ETF	76.52	76.7	76.33	76.6	102200.0
2009-05-08	BJK	ETF	22.1	22.2	21.6	22.09	2694900.0
2009-05-08	BKF	ETF	33.0	33.43	32.4916	33.38	144634.0
2009-05-08	BLV	ETF	72.32	72.5	71.52	71.64	9400.0
2009-05-08	BMVP	ETF	10.713	10.887	10.713	10.843	15558.0
2009-05-08	BND	ETF	77.13	77.19	76.9	77.13	429100.0
2009-05-08	BNE	ETF	5.34	5.98	5.25	5.81	185625.0
2009-05-08	BOSS	ETF	16.4	17.7	16.4	17.7	400.0
2009-05-08	BSV	ETF	79.0	81.59	78.8	78.85	269700.0
2009-05-08	BTF	ETF	48.15	49.199	47.949999999999996	49.0	17107.4
2009-05-08	BWX	ETF	26.215	26.425	26.105	26.425	181934.0
2009-05-08	BWZ	ETF	33.83	34.09	33.83	33.95	6246.0
2009-05-08	CBON	ETF	1.6	1.62	1.42	1.57	72781.0
2009-05-08	CEF	ETF	11.62	11.77	11.48	11.65	757600.0
2009-05-08	CEW	ETF	20.4	20.59	20.37	20.58	119790.0
2009-05-08	CGO	ETF	10.3	10.5	10.27	10.5	22029.0
2009-05-08	CGW	ETF	14.77	15.0	14.64	14.92	38811.0
2009-05-08	CHB	ETF	0.56	0.6	0.5513	0.6	566823.0
2009-05-08	CHI	ETF	10.2	10.213	9.93	10.1	170908.0
2009-05-08	CHIC	ETF	12.1	12.43	11.64	12.18	394832.0
2009-05-08	CHW	ETF	6.62	6.74	6.6	6.65	230244.0
2009-05-08	CHY	ETF	9.64	9.71	9.58	9.71	213520.0

> showing 50 of 653 rows — these rows as CSV

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