PREVIEW / etf_daily / 2009-08-20

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-20.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-08-20	SPY	ETF	100.09	101.22	99.87	100.99	174131300.0
2009-08-20	QQQ	ETF	39.28	39.84	39.2	39.76	81473477.0
2009-08-20	IWM	ETF	56.11	56.97	55.86	56.84	40013900.0
2009-08-20	DIA	ETF	93.15	93.95	92.93	93.79	8271000.0
2009-08-20	GLD	ETF	92.31	92.55	92.12	92.27	3973000.0
2009-08-20	TLT	ETF	95.38	95.87	94.78	95.74	3282700.0
2009-08-20	AAXJ	ETF	47.98	48.83	47.74	48.81	128100.0
2009-08-20	ACWI	ETF	38.04	38.51	38.04	38.37	67000.0
2009-08-20	ACWX	ETF	36.78	37.34	36.78	37.3199	19764.0
2009-08-20	ADRE	ETF	38.02	38.48	38.0	38.36	56400.0
2009-08-20	AFK	ETF	26.62	27.45	26.62	27.404	7365.0
2009-08-20	AGG	ETF	103.52	103.61	100.22	103.6	596600.0
2009-08-20	AGQ	ETF	81.32	82.6	81.12	82.08	70000.0
2009-08-20	AGZ	ETF	107.69	107.78	107.475	107.552	17638.0
2009-08-20	AIA	ETF	35.59	36.1	35.473	35.97	42304.0
2009-08-20	AIQ	ETF	26.0	26.2	25.65	25.9	112953.0
2009-08-20	AIS	ETF	0.96	0.97	0.942	0.96	150314.0
2009-08-20	AIVI	ETF	39.09	39.53	39.09	39.53	10800.0
2009-08-20	AMJ	ETF	24.32	24.41	24.228	24.41	169812.0
2009-08-20	AOA	ETF	27.4	27.56	27.38	27.56	3300.0
2009-08-20	AOK	ETF	26.4	26.512	26.4	26.512	749.0
2009-08-20	AOM	ETF	26.95	27.0	26.87	27.0	10724.0
2009-08-20	AOR	ETF	27.22	27.29	27.0994	27.29	10599.0
2009-08-20	ARB	ETF	16.66	17.43	16.55	17.41	325544.0
2009-08-20	BAL	ETF	30.77	30.77	30.54	30.6981	1600.0
2009-08-20	BBH	ETF	32.8667	33.5033	32.8667	33.3067	341100.0
2009-08-20	BIL	ETF	91.74	91.74	91.7	91.72	143100.0
2009-08-20	BITS	ETF	21.56	21.8	21.4	21.8	596.0
2009-08-20	BIV	ETF	79.04	79.12	78.64	78.97	87300.0
2009-08-20	BJK	ETF	23.13	23.25	23.0	23.14	5200.0
2009-08-20	BKF	ETF	37.75	38.35	37.7	38.27	173610.0
2009-08-20	BLV	ETF	77.41	77.44	76.89	77.4	17600.0
2009-08-20	BMVP	ETF	11.557	11.631	11.557	11.623	10937.0
2009-08-20	BND	ETF	78.33	78.67	78.33	78.67	487700.0
2009-08-20	BNE	ETF	6.0	6.1	5.67	6.03	325427.0
2009-08-20	BRF	ETF	35.78	36.33	35.74	36.31	292504.0
2009-08-20	BSV	ETF	79.59	79.68	79.53	79.68	413200.0
2009-08-20	BTF	ETF	57.449999999999996	57.949999999999996	57.058	57.75	6470.8
2009-08-20	BWX	ETF	28.19	28.205	28.0629	28.205	273032.0
2009-08-20	BWZ	ETF	36.9	36.9	35.887	36.05	14181.0
2009-08-20	BZQ	ETF	7032.0	7032.0	6867.2	6897.6	26.25
2009-08-20	CEF	ETF	11.85	12.01	11.85	11.94	744500.0
2009-08-20	CEW	ETF	21.25	21.33	21.202	21.32	24124.0
2009-08-20	CGO	ETF	13.0	13.07	12.65	12.95	46510.0
2009-08-20	CGW	ETF	16.25	16.58	16.25	16.53	142422.0
2009-08-20	CHB	ETF	0.42	0.42	0.39	0.41	932739.0
2009-08-20	CHI	ETF	11.02	11.2	11.0199	11.2	123968.0
2009-08-20	CHIC	ETF	13.92	14.1	13.7	14.0	66903.0
2009-08-20	CHW	ETF	7.24	7.36	7.24	7.35	182425.0
2009-08-20	CHY	ETF	10.62	10.79	10.62	10.79	131080.0

> showing 50 of 668 rows — these rows as CSV

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