PREVIEW / etf_daily / 2009-07-10

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-10.parquet
  size:    29 KB
  rows:    655

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-10	SPY	ETF	87.7	88.49	87.35	87.96	173520300.0
2009-07-10	QQQ	ETF	34.66	35.14	34.5626	34.92	108481909.0
2009-07-10	IWM	ETF	47.59	48.27	47.33	48.1	39883000.0
2009-07-10	DIA	ETF	81.41	81.94	81.02	81.44	16023500.0
2009-07-10	GLD	ETF	89.3	89.77	89.16	89.58	5040100.0
2009-07-10	TLT	ETF	95.62	96.33	95.43	96.23	3981900.0
2009-07-10	AAXJ	ETF	43.24	43.63	43.15	43.61	856400.0
2009-07-10	ACWI	ETF	32.89	33.26	32.86	33.11	51300.0
2009-07-10	ACWX	ETF	31.76	31.96	31.6	31.87	23016.0
2009-07-10	ADRE	ETF	33.12	33.25	32.7051	33.18	99907.0
2009-07-10	AFK	ETF	25.0685	25.14	25.0	25.09	1440.0
2009-07-10	AGG	ETF	102.72	103.0	102.63	102.88	504600.0
2009-07-10	AGQ	ETF	69.38	70.38	68.58	70.02	126450.0
2009-07-10	AGZ	ETF	108.41	108.66	107.92	108.4703	20098.0
2009-07-10	AIA	ETF	32.14	32.16	31.66	31.8386	19324.0
2009-07-10	AIQ	ETF	32.05	32.3	31.55	31.95	22071.0
2009-07-10	AIS	ETF	0.76	0.78	0.75	0.7788	193077.0
2009-07-10	AIVI	ETF	33.56	33.58	33.3	33.33	28300.0
2009-07-10	AMJ	ETF	22.36	22.57	22.344	22.57	64416.0
2009-07-10	AOA	ETF	24.22	24.25	24.05	24.25	9900.0
2009-07-10	AOK	ETF	25.73	25.73	25.1732	25.4358	3000.0
2009-07-10	AOM	ETF	25.1595	25.16	24.91	25.13	9260.0
2009-07-10	AOR	ETF	24.74	24.74	24.74	24.74	150.0
2009-07-10	ARB	ETF	15.79	16.4	15.75	16.31	260495.0
2009-07-10	BAL	ETF	31.42	32.4799	31.32	32.4799	8762.0
2009-07-10	BBH	ETF	31.1467	31.56	31.1	31.1767	446400.0
2009-07-10	BIL	ETF	91.74	91.76	91.74	91.74	246100.0
2009-07-10	BITS	ETF	21.96	22.56	21.56	22.12	2638.0
2009-07-10	BIV	ETF	77.9	78.35	77.62	77.83	137400.0
2009-07-10	BJK	ETF	19.8	19.8	19.54	19.58	2800.0
2009-07-10	BKF	ETF	33.04	33.06	32.49	32.95	552915.0
2009-07-10	BLV	ETF	75.03	75.9	74.74	75.89	6300.0
2009-07-10	BMVP	ETF	10.52	10.58	10.51	10.56	25266.0
2009-07-10	BND	ETF	77.79	78.09	77.79	78.09	440100.0
2009-07-10	BNE	ETF	6.35	6.51	6.265	6.4	198446.0
2009-07-10	BRF	ETF	26.94	27.56	26.69	27.33	92893.0
2009-07-10	BSV	ETF	79.46	79.64	79.28	79.5	255400.0
2009-07-10	BTF	ETF	46.8	46.8	46.25	46.6	1804.0
2009-07-10	BWX	ETF	27.435	27.52	27.35	27.52	437094.0
2009-07-10	BWZ	ETF	35.21	35.21	35.1798	35.19	756.0
2009-07-10	BZQ	ETF	10971.2	10998.4	10704.0	10704.0	38.75
2009-07-10	CBON	ETF	0.93	0.93	0.81	0.83	3458.0
2009-07-10	CEF	ETF	11.08	11.15	11.0	11.07	453600.0
2009-07-10	CEW	ETF	20.5	20.5491	20.448	20.54	26599.0
2009-07-10	CGO	ETF	10.85	11.036	10.768	10.96	9922.0
2009-07-10	CGW	ETF	14.55	14.8	14.55	14.8	68040.0
2009-07-10	CHB	ETF	0.31	0.32	0.3	0.3	429544.0
2009-07-10	CHI	ETF	9.7	9.88	9.69	9.79	255029.0
2009-07-10	CHIC	ETF	12.0	12.1	11.5	11.65	198659.0
2009-07-10	CHW	ETF	6.18	6.26	5.884	6.2478	162961.0

> showing 50 of 655 rows — these rows as CSV

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