PREVIEW / etf_daily / 2009-07-16

all etf daily files

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

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-16	SPY	ETF	93.0	94.51	92.82	93.11	231174500.0
2009-07-16	QQQ	ETF	36.74	37.44	36.72	37.36	120142434.0
2009-07-16	IWM	ETF	51.28	52.37	51.14	52.1	38353400.0
2009-07-16	DIA	ETF	86.11	87.5	86.03	87.23	11805400.0
2009-07-16	GLD	ETF	92.0	92.12	91.55	91.98	4604600.0
2009-07-16	TLT	ETF	92.81	93.18	92.5	92.67	4225200.0
2009-07-16	AAXJ	ETF	45.58	46.16	45.31	46.12	141400.0
2009-07-16	ACWI	ETF	35.1	35.59	34.99	35.44	311100.0
2009-07-16	ACWX	ETF	33.92	34.3094	33.8	34.18	53538.0
2009-07-16	ADRE	ETF	35.07	35.71	34.91	35.53	342728.0
2009-07-16	AFK	ETF	26.31	26.344	26.0	26.2	5722.0
2009-07-16	AGG	ETF	102.01	102.36	102.01	102.17	410800.0
2009-07-16	AGQ	ETF	76.08	77.5	75.88	77.14	106150.0
2009-07-16	AGZ	ETF	108.05	108.05	107.3	107.31	23299.0
2009-07-16	AIA	ETF	33.46	33.9	33.37	33.79	33126.0
2009-07-16	AIQ	ETF	33.15	33.15	32.3	33.05	33663.0
2009-07-16	AIS	ETF	0.77	0.81	0.77	0.8	112206.0
2009-07-16	AIVI	ETF	35.51	36.17	35.51	36.17	96000.0
2009-07-16	AMJ	ETF	23.4	23.68	23.1987	23.63	131592.0
2009-07-16	AOA	ETF	25.66	25.75	25.61	25.66	2500.0
2009-07-16	AOK	ETF	25.24	25.8	25.24	25.8	6079.0
2009-07-16	AOM	ETF	25.16	25.85	25.16	25.85	12074.0
2009-07-16	AOR	ETF	25.69	25.83	25.6401	25.83	5073.0
2009-07-16	ARB	ETF	16.49	17.42	16.47	17.33	279509.0
2009-07-16	BAL	ETF	32.59	33.03	32.59	33.03	7110.0
2009-07-16	BBH	ETF	32.0567	32.5033	31.7733	32.22	710700.0
2009-07-16	BIL	ETF	91.72	91.76	91.72	91.76	204950.0
2009-07-16	BITS	ETF	21.6	22.8	21.0	21.96	2270.0
2009-07-16	BIV	ETF	77.14	77.5	76.96	77.43	89400.0
2009-07-16	BJK	ETF	20.74	21.29	20.31	21.22	11300.0
2009-07-16	BKF	ETF	35.19	35.69	34.77	35.55	163409.0
2009-07-16	BLV	ETF	74.19	74.41	73.77	73.79	32500.0
2009-07-16	BMVP	ETF	11.04	11.19	11.03	11.16	22610.0
2009-07-16	BND	ETF	77.75	77.75	77.46	77.68	529400.0
2009-07-16	BNE	ETF	7.03	7.13	6.8	7.07	121680.0
2009-07-16	BOSS	ETF	15.61	16.45	15.61	16.45	100.0
2009-07-16	BRF	ETF	29.64	30.08	29.432	29.91	272500.0
2009-07-16	BSV	ETF	79.22	79.24	79.06	79.2	333800.0
2009-07-16	BTF	ETF	49.65	49.800000000000004	49.3	49.599999999999994	17225.0
2009-07-16	BWX	ETF	27.605	27.675	27.52	27.605	595352.0
2009-07-16	BWZ	ETF	35.49	35.54	35.4525	35.52	4556.0
2009-07-16	BZQ	ETF	9208.0	9208.0	8732.8	8840.0	106.0
2009-07-16	CBON	ETF	0.93	0.93	0.8003	0.84	8165.0
2009-07-16	CEF	ETF	11.7	11.76	11.63	11.69	458400.0
2009-07-16	CEW	ETF	20.86	20.9	20.81	20.9	3339.0
2009-07-16	CGO	ETF	11.75	12.16	11.7	11.99	26588.0
2009-07-16	CGW	ETF	15.49	15.915	15.46	15.85	49310.0
2009-07-16	CHB	ETF	0.3	0.31	0.3	0.3	475122.0
2009-07-16	CHI	ETF	10.49	10.51	10.36	10.48	94656.0
2009-07-16	CHIC	ETF	12.38	12.75	12.295	12.7	153774.0

> showing 50 of 667 rows — these rows as CSV

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