PREVIEW / etf_daily / 2009-07-01

all etf daily files

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

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-01	SPY	ETF	92.34	93.23	92.21	92.33	173041100.0
2009-07-01	QQQ	ETF	36.54	36.84	36.39	36.4	85975906.0
2009-07-01	IWM	ETF	51.35	52.25	51.31	51.87	46382900.0
2009-07-01	DIA	ETF	84.98	85.83	84.93	85.03	9144200.0
2009-07-01	GLD	ETF	92.31	93.0	92.0	92.39	10743200.0
2009-07-01	TLT	ETF	93.42	94.09	93.24	94.08	3379900.0
2009-07-01	AAXJ	ETF	44.57	45.25	44.57	44.97	112400.0
2009-07-01	ACWI	ETF	34.9	35.16	34.87	34.96	326900.0
2009-07-01	ACWX	ETF	33.68	34.05	33.65	33.75	64919.0
2009-07-01	ADRE	ETF	35.2	35.546	35.0785	35.09	94616.0
2009-07-01	AFK	ETF	26.946	27.45	26.946	27.1876	1600.0
2009-07-01	AGG	ETF	101.62	101.87	101.56	101.77	450600.0
2009-07-01	AGQ	ETF	83.56	84.36	82.22	83.06	107400.0
2009-07-01	AGZ	ETF	107.484	107.5884	106.93	107.01	45649.0
2009-07-01	AIA	ETF	32.68	32.9	32.52	32.76	17308.0
2009-07-01	AIQ	ETF	36.9	36.9	35.35	35.75	33653.0
2009-07-01	AIS	ETF	0.93	1.0	0.89	0.9	603099.0
2009-07-01	AIVI	ETF	35.5	36.01	35.44	35.6	12400.0
2009-07-01	AMJ	ETF	22.5	22.5	22.4	22.41	41740.0
2009-07-01	AOA	ETF	25.33	25.53	25.33	25.35	20000.0
2009-07-01	AOK	ETF	25.5	25.901	25.4801	25.901	970.0
2009-07-01	AOM	ETF	25.93	25.93	25.52	25.72	5259.0
2009-07-01	AOR	ETF	25.59	25.7025	25.59	25.61	9601.0
2009-07-01	ARB	ETF	16.03	16.65	16.03	16.57	285809.0
2009-07-01	BAL	ETF	30.59	31.57	30.59	31.57	10940.0
2009-07-01	BBH	ETF	31.0633	31.31	31.0033	31.0433	315300.0
2009-07-01	BIL	ETF	91.74	91.76	91.74	91.74	94400.0
2009-07-01	BITS	ETF	20.8	22.0	18.84	21.0	8122.0
2009-07-01	BIV	ETF	76.85	77.04	76.55	77.03	81500.0
2009-07-01	BJK	ETF	20.68	20.99	19.97	20.98	9900.0
2009-07-01	BKF	ETF	36.26	36.45	35.9601	36.1	227765.0
2009-07-01	BLV	ETF	74.21	74.5	73.8	73.91	24800.0
2009-07-01	BMVP	ETF	11.03	11.1298	11.03	11.0667	17117.0
2009-07-01	BND	ETF	77.22	77.51	77.14	77.38	430400.0
2009-07-01	BNE	ETF	6.6	7.33	6.6	7.1	119747.0
2009-07-01	BRF	ETF	28.43	28.55	28.26	28.39	69295.0
2009-07-01	BSV	ETF	78.82	79.01	78.7	78.88	595800.0
2009-07-01	BTF	ETF	47.300000000000004	48.05	47.15	47.99999999999999	5506.0
2009-07-01	BWX	ETF	27.41	27.51	27.39	27.455	367010.0
2009-07-01	BWZ	ETF	35.3	35.4	35.23	35.3499	6447.0
2009-07-01	BZQ	ETF	9004.8	9004.8	8782.4	8987.2	4.5
2009-07-01	CBON	ETF	0.94	0.94	0.93	0.94	14414.0
2009-07-01	CEF	ETF	11.87	11.95	11.81	11.88	365400.0
2009-07-01	CEW	ETF	20.98	21.07	20.98	21.06	7395.0
2009-07-01	CGO	ETF	11.53	11.94	11.53	11.8399	24417.0
2009-07-01	CGW	ETF	15.83	15.91	15.69	15.79	48143.0
2009-07-01	CHB	ETF	0.33	0.34	0.3111	0.33	260477.0
2009-07-01	CHI	ETF	10.41	10.58	10.41	10.53	119301.0
2009-07-01	CHIC	ETF	13.01	13.04	12.4	12.6	236653.0
2009-07-01	CHW	ETF	7.02	7.1	6.99	7.09	175566.0

> showing 50 of 656 rows — these rows as CSV

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