PREVIEW / etf_daily / 2009-07-17

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-17.parquet
  size:    29 KB
  rows:    668

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-07-17	SPY	ETF	94.06	94.32	93.54	94.13	138561700.0
2009-07-17	QQQ	ETF	37.36	37.57	37.17	37.56	104906405.0
2009-07-17	IWM	ETF	52.25	52.27	51.73	51.9	35682600.0
2009-07-17	DIA	ETF	87.22	87.54	86.72	87.46	9075000.0
2009-07-17	GLD	ETF	92.15	92.3	91.84	91.93	8748400.0
2009-07-17	TLT	ETF	91.9	92.36	91.24	91.24	3845700.0
2009-07-17	AAXJ	ETF	46.8	46.8	45.94	46.56	66400.0
2009-07-17	ACWI	ETF	35.37	35.53	35.26	35.44	59600.0
2009-07-17	ACWX	ETF	34.06	34.26	33.9	34.14	49420.0
2009-07-17	ADRE	ETF	35.53	35.8821	35.39	35.76	88889.0
2009-07-17	AFK	ETF	26.2	26.2501	26.08	26.08	2715.0
2009-07-17	AGG	ETF	102.01	102.27	101.98	102.17	437300.0
2009-07-17	AGQ	ETF	78.28	79.14	77.88	78.06	114850.0
2009-07-17	AGZ	ETF	107.4	107.59	106.9	107.04	14975.0
2009-07-17	AIA	ETF	33.7578	33.9873	33.7578	33.96	11955.0
2009-07-17	AIQ	ETF	33.1	33.35	32.45	32.45	60755.0
2009-07-17	AIS	ETF	0.75	0.77	0.75	0.76	214673.0
2009-07-17	AIVI	ETF	35.9	36.13	35.8	36.11	22400.0
2009-07-17	AMJ	ETF	23.66	23.9	23.6081	23.83	127546.0
2009-07-17	AOA	ETF	25.5	25.63	25.5	25.62	4100.0
2009-07-17	AOK	ETF	25.8185	25.82	25.7682	25.7682	1683.0
2009-07-17	AOM	ETF	25.76	26.12	25.76	25.78	1036.0
2009-07-17	AOR	ETF	25.7494	25.8	25.7494	25.8	1566.0
2009-07-17	ARB	ETF	17.38	17.86	17.27	17.55	262530.0
2009-07-17	BAL	ETF	33.1	33.34	32.99	33.25	11195.0
2009-07-17	BBH	ETF	32.4133	32.5533	32.22	32.3567	550200.0
2009-07-17	BIL	ETF	91.72	91.76	91.72	91.76	122750.0
2009-07-17	BITS	ETF	21.56	22.56	21.2	22.52	2596.0
2009-07-17	BIV	ETF	77.21	77.33	77.05	77.16	66000.0
2009-07-17	BJK	ETF	21.51	21.51	21.01	21.26	10300.0
2009-07-17	BKF	ETF	35.75	36.11	35.6136	35.99	103149.0
2009-07-17	BLV	ETF	73.72	73.88	73.5	73.54	16200.0
2009-07-17	BMVP	ETF	11.18	11.19	11.11	11.15	82589.0
2009-07-17	BND	ETF	77.58	77.61	77.39	77.48	575800.0
2009-07-17	BNE	ETF	7.08	7.14	6.75	7.14	148182.0
2009-07-17	BOSS	ETF	16.8	16.8	16.66	16.66	100.0
2009-07-17	BRF	ETF	30.06	30.17	29.76	29.9	366822.0
2009-07-17	BSV	ETF	79.06	79.27	79.06	79.26	261400.0
2009-07-17	BTF	ETF	49.24999999999999	49.955	49.24999999999999	49.5	6572.8
2009-07-17	BWX	ETF	27.59	27.595	27.475	27.525	216368.0
2009-07-17	BWZ	ETF	35.5	35.51	35.33	35.39	9840.0
2009-07-17	BZQ	ETF	8705.6	8872.0	8705.6	8750.4	18.25
2009-07-17	CBON	ETF	0.84	0.85	0.7	0.7	12682.0
2009-07-17	CEF	ETF	11.68	11.79	11.63	11.68	482400.0
2009-07-17	CEW	ETF	20.92	20.97	20.83	20.932	8153.0
2009-07-17	CGO	ETF	11.87	12.0	11.8	11.88	21448.0
2009-07-17	CGW	ETF	15.7	15.74	15.55	15.67	59721.0
2009-07-17	CHB	ETF	0.3	0.31	0.28	0.3	453852.0
2009-07-17	CHI	ETF	10.5	10.648	10.482	10.57	97041.0
2009-07-17	CHIC	ETF	12.74	12.79	12.23	12.72	427318.0

> showing 50 of 668 rows — these rows as CSV

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