PREVIEW / etf_daily / 2009-07-29

all etf daily files

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

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-29	SPY	ETF	97.44	98.09	96.98	97.65	194399300.0
2009-07-29	QQQ	ETF	39.32	39.43	39.0	39.34	126538184.0
2009-07-29	IWM	ETF	54.82	55.13	54.54	54.84	47421300.0
2009-07-29	DIA	ETF	90.68	90.95	90.16	90.68	9063600.0
2009-07-29	GLD	ETF	91.67	91.75	90.81	91.2	9676100.0
2009-07-29	TLT	ETF	92.17	92.29	90.94	91.7	2910200.0
2009-07-29	AAXJ	ETF	49.0	49.0	48.33	48.68	121900.0
2009-07-29	ACWI	ETF	36.88	37.03	36.64	36.81	396500.0
2009-07-29	ACWX	ETF	35.81	35.81	35.4	35.6395	310235.0
2009-07-29	ADRE	ETF	37.53	37.53	36.7967	37.02	93582.0
2009-07-29	AFK	ETF	27.176	27.23	27.0	27.1199	4986.0
2009-07-29	AGG	ETF	102.56	102.68	102.16	102.45	451400.0
2009-07-29	AGQ	ETF	79.86	80.22	75.08	76.44	161400.0
2009-07-29	AGZ	ETF	107.1932	107.52	106.99	106.99	8832.0
2009-07-29	AIA	ETF	35.99	35.99	35.25	35.6	28986.0
2009-07-29	AIQ	ETF	35.5	35.75	34.9	35.45	77132.0
2009-07-29	AIS	ETF	0.86	0.88	0.85	0.86	150738.0
2009-07-29	AIVI	ETF	37.42	37.74	37.24	37.54	10000.0
2009-07-29	AMJ	ETF	25.03	25.03	24.177	24.42	241647.0
2009-07-29	AOA	ETF	26.57	26.61	26.4	26.59	7600.0
2009-07-29	AOK	ETF	26.05	26.13	26.05	26.13	1116.0
2009-07-29	AOM	ETF	26.3261	26.3516	26.244	26.26	3955.0
2009-07-29	AOR	ETF	26.6266	26.6266	26.13	26.4294	3266.0
2009-07-29	ARB	ETF	16.78	16.81	16.41	16.51	119790.0
2009-07-29	BAL	ETF	30.73	30.73	30.61	30.61	1390.0
2009-07-29	BBH	ETF	34.4633	34.6367	34.2733	34.6033	451800.0
2009-07-29	BIL	ETF	91.72	91.74	91.7	91.72	133950.0
2009-07-29	BITS	ETF	22.79	22.96	21.76	22.4	1762.0
2009-07-29	BIV	ETF	77.81	77.96	77.49	77.76	107200.0
2009-07-29	BJK	ETF	22.51	22.51	21.53	21.82	9000.0
2009-07-29	BKF	ETF	37.83	37.97	37.0	37.4	286944.0
2009-07-29	BLV	ETF	75.02	75.02	74.51	74.68	32600.0
2009-07-29	BMVP	ETF	11.44	11.46	11.42	11.45	16170.0
2009-07-29	BND	ETF	77.98	77.99	77.6	77.75	420200.0
2009-07-29	BNE	ETF	8.11	8.2	7.57	7.77	139777.0
2009-07-29	BOSS	ETF	16.1	16.71	16.1	16.71	100.0
2009-07-29	BRF	ETF	32.62	32.62	31.89	32.06	129503.0
2009-07-29	BSV	ETF	79.34	79.42	79.15	79.15	287200.0
2009-07-29	BTF	ETF	52.99999999999999	53.15	52.24999999999999	52.64999999999999	3911.0
2009-07-29	BWX	ETF	27.75	27.77	27.5121	27.66	389964.0
2009-07-29	BWZ	ETF	35.66	35.66	35.4	35.6	15824.0
2009-07-29	BZQ	ETF	8000.0	8163.2	8000.0	8163.2	3.25
2009-07-29	CBON	ETF	0.65	0.7	0.63	0.65	20976.0
2009-07-29	CEF	ETF	11.62	11.83	11.44	11.51	1097400.0
2009-07-29	CEW	ETF	21.3	21.3	21.05	21.08	38183.0
2009-07-29	CGO	ETF	12.42	12.7	12.35	12.37	20917.0
2009-07-29	CGW	ETF	16.18	16.3	16.02	16.17	69383.0
2009-07-29	CHB	ETF	0.512	0.55	0.4515	0.48	1573107.0
2009-07-29	CHI	ETF	10.89	10.92	10.66	10.73	184522.0
2009-07-29	CHIC	ETF	14.38	14.48	14.12	14.36	217251.0

> showing 50 of 664 rows — these rows as CSV

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