PREVIEW / etf_daily / 2009-06-09

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-09.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-06-09	SPY	ETF	94.69	95.14	94.02	94.64	225125500.0
2009-06-09	QQQ	ETF	36.84	37.17	36.67	36.95	109187759.0
2009-06-09	IWM	ETF	52.84	53.27	52.56	52.81	35033700.0
2009-06-09	DIA	ETF	87.97	88.23	87.44	87.74	22428400.0
2009-06-09	GLD	ETF	94.27	94.39	93.44	93.83	9477700.0
2009-06-09	TLT	ETF	90.19	90.31	89.25	89.6	6046300.0
2009-06-09	AAXJ	ETF	44.94	45.25	44.62	45.02	419900.0
2009-06-09	ACWI	ETF	35.78	35.9	35.45	35.86	432100.0
2009-06-09	ACWX	ETF	34.52	34.79	34.4	34.67	58802.0
2009-06-09	ADRE	ETF	36.32	36.35	35.82	36.15	85986.0
2009-06-09	AFK	ETF	27.78	29.0	27.6	27.99	19850.0
2009-06-09	AGG	ETF	100.14	100.37	99.98	100.25	442300.0
2009-06-09	AGQ	ETF	103.28	103.62	100.88	103.26	101400.0
2009-06-09	AGZ	ETF	106.27	106.545	105.96	106.185	17543.0
2009-06-09	AIA	ETF	32.28	32.74	32.19	32.42	246698.0
2009-06-09	AIQ	ETF	36.4	36.75	35.5	36.0	17954.0
2009-06-09	AIS	ETF	0.71	0.75	0.6796	0.7	146598.0
2009-06-09	AIVI	ETF	36.29	36.52	36.1	36.32	28500.0
2009-06-09	AMJ	ETF	23.04	23.04	22.7685	22.82	93470.0
2009-06-09	AOA	ETF	25.79	25.88	25.79	25.85	1300.0
2009-06-09	AOK	ETF	25.7	25.7985	25.45	25.72	3706.0
2009-06-09	AOM	ETF	26.19	26.19	25.58	25.82	9294.0
2009-06-09	AOR	ETF	26.0	26.02	25.78	26.02	3447.0
2009-06-09	ARB	ETF	20.76	20.86	20.28	20.42	122436.0
2009-06-09	BAL	ETF	31.5901	31.61	31.097	31.097	2945.0
2009-06-09	BBH	ETF	30.7267	30.9167	30.6167	30.75	495600.0
2009-06-09	BIL	ETF	91.68	91.72	91.68	91.7	101650.0
2009-06-09	BITS	ETF	19.96	20.16	18.64	20.16	3478.0
2009-06-09	BIV	ETF	75.59	75.59	73.6	75.19	252200.0
2009-06-09	BJK	ETF	21.58	21.99	21.31	21.69	9400.0
2009-06-09	BKF	ETF	36.93	37.28	36.36	36.83	249661.0
2009-06-09	BLV	ETF	71.62	72.05	71.26	71.57	31200.0
2009-06-09	BMVP	ETF	11.1667	11.1867	11.0952	11.14	15475.0
2009-06-09	BND	ETF	76.0	76.43	76.0	76.29	458900.0
2009-06-09	BNE	ETF	6.75	6.79	6.5	6.66	82180.0
2009-06-09	BOSS	ETF	15.83	16.37	15.83	15.83	100.0
2009-06-09	BRF	ETF	28.46	28.46	27.9	28.21	162495.0
2009-06-09	BSV	ETF	78.23	78.53	78.12	78.46	221000.0
2009-06-09	BTF	ETF	48.89999999999999	49.15	48.550000000000004	49.15	7257.8
2009-06-09	BWX	ETF	26.82	26.935	26.705	26.9	306454.0
2009-06-09	BWZ	ETF	34.88	34.892	34.88	34.892	891.0
2009-06-09	CBON	ETF	1.79	1.85	1.59	1.61	16052.0
2009-06-09	CEF	ETF	12.05	12.27	11.99	12.26	1018200.0
2009-06-09	CEW	ETF	20.68	20.68	20.58	20.66	37882.0
2009-06-09	CGO	ETF	11.64	11.79	11.63	11.76	25179.0
2009-06-09	CGW	ETF	15.69	15.84	15.55	15.77	71492.0
2009-06-09	CHB	ETF	0.46	0.5	0.45	0.46	507615.0
2009-06-09	CHI	ETF	10.84	10.85	10.6521	10.75	208352.0
2009-06-09	CHIC	ETF	11.56	11.82	11.56	11.71	107182.0
2009-06-09	CHW	ETF	7.63	7.6524	7.4	7.5	153002.0

> showing 50 of 656 rows — these rows as CSV

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