PREVIEW / etf_daily / 2009-07-08

all etf daily files

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

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-08	SPY	ETF	88.59	88.8	87.0	88.0	248050500.0
2009-07-08	QQQ	ETF	34.73	34.87	34.3	34.71	152776358.0
2009-07-08	IWM	ETF	48.62	48.78	47.27	48.07	65594900.0
2009-07-08	DIA	ETF	81.93	82.28	80.96	81.93	17902700.0
2009-07-08	GLD	ETF	90.11	91.04	88.82	89.27	21958200.0
2009-07-08	TLT	ETF	95.12	96.81	94.89	96.5	7912900.0
2009-07-08	AAXJ	ETF	43.3	43.3	42.0	42.45	142700.0
2009-07-08	ACWI	ETF	33.12	33.34	32.65	33.1	50900.0
2009-07-08	ACWX	ETF	32.05	32.09	31.41	31.78	84076.0
2009-07-08	ADRE	ETF	33.09	33.21	32.1201	32.74	154765.0
2009-07-08	AFK	ETF	25.5	25.5	24.5	24.9	35074.0
2009-07-08	AGG	ETF	102.23	102.82	102.23	102.82	790000.0
2009-07-08	AGQ	ETF	73.26	73.7	71.14	72.46	121800.0
2009-07-08	AGZ	ETF	108.18	108.49	107.982	108.49	12708.0
2009-07-08	AIA	ETF	31.616	31.7501	31.02	31.39	37643.0
2009-07-08	AIQ	ETF	32.9	33.0	32.35	32.75	27016.0
2009-07-08	AIS	ETF	0.81	0.84	0.75	0.78	957973.0
2009-07-08	AIVI	ETF	33.75	33.83	33.04	33.43	18600.0
2009-07-08	AMJ	ETF	22.09	22.1	21.88	22.04	57860.0
2009-07-08	AOA	ETF	24.23	24.23	24.01	24.03	7200.0
2009-07-08	AOK	ETF	25.69	25.69	25.11	25.55	10968.0
2009-07-08	AOM	ETF	25.1	25.23	24.81	25.1195	6758.0
2009-07-08	AOR	ETF	24.8	24.83	24.6794	24.83	7127.0
2009-07-08	ARB	ETF	15.84	15.97	15.6412	15.9	187225.0
2009-07-08	BAL	ETF	30.83	30.88	30.46	30.68	670.0
2009-07-08	BBH	ETF	31.9667	32.2267	31.66	31.72	2047800.0
2009-07-08	BIL	ETF	91.76	91.76	91.74	91.76	170500.0
2009-07-08	BITS	ETF	20.6	20.6	20.16	20.56	800.0
2009-07-08	BIV	ETF	77.49	78.12	77.36	78.02	83500.0
2009-07-08	BJK	ETF	19.46	19.86	18.96	19.37	57100.0
2009-07-08	BKF	ETF	33.13	33.52	32.25	32.93	607198.0
2009-07-08	BLV	ETF	74.79	75.87	74.79	75.55	50700.0
2009-07-08	BMVP	ETF	10.6167	10.63	10.4861	10.5833	20978.0
2009-07-08	BND	ETF	77.69	78.08	77.55	78.04	337200.0
2009-07-08	BNE	ETF	6.43	6.55	6.24	6.51	167497.0
2009-07-08	BRF	ETF	27.4	27.57	26.64	27.14	41450.0
2009-07-08	BSV	ETF	79.18	79.29	79.07	79.16	173000.0
2009-07-08	BTF	ETF	47.5	47.5	46.25	46.849999999999994	7404.6
2009-07-08	BWX	ETF	27.32	27.375	27.22	27.33	225142.0
2009-07-08	BWZ	ETF	35.0	35.01	34.98	35.004	7218.0
2009-07-08	BZQ	ETF	10899.2	11224.0	10694.4	10801.6	9.5
2009-07-08	CBON	ETF	0.93	0.93	0.8	0.8	3751.0
2009-07-08	CEF	ETF	11.32	11.32	11.03	11.2	844500.0
2009-07-08	CEW	ETF	20.65	20.65	20.46	20.53	26949.0
2009-07-08	CGO	ETF	11.22	11.23	10.8	10.89	34438.0
2009-07-08	CGW	ETF	14.84	14.84	14.49	14.66	54973.0
2009-07-08	CHB	ETF	0.32	0.34	0.3	0.31	507786.0
2009-07-08	CHI	ETF	10.3	10.3	9.66	9.88	188906.0
2009-07-08	CHIC	ETF	12.49	12.52	12.0	12.05	275992.0
2009-07-08	CHW	ETF	6.43	6.44	6.14	6.1827	274290.0

> showing 50 of 662 rows — these rows as CSV

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