PREVIEW / etf_daily / 2010-04-15

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-15.parquet
  size:    32 KB
  rows:    747

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
2010-04-15	SPY	ETF	120.99	121.57	120.95	121.29	144615300.0
2010-04-15	QQQ	ETF	49.88	50.19	49.87	50.13	72254152.0
2010-04-15	IWM	ETF	72.18	72.58	72.09	72.43	55141800.0
2010-04-15	DIA	ETF	111.08	111.62	111.04	111.56	8664000.0
2010-04-15	GLD	ETF	112.9	113.71	112.85	113.65	10952100.0
2010-04-15	TLT	ETF	88.85	89.5	88.68	89.21	3698000.0
2010-04-15	AAXJ	ETF	59.15	59.26	58.9	59.0	1403800.0
2010-04-15	ACWI	ETF	45.14	45.31	45.0	45.12	164500.0
2010-04-15	ACWX	ETF	43.19	43.3181	42.98	43.19	45239.0
2010-04-15	ADRE	ETF	45.76	45.9399	45.5119	45.58	107703.0
2010-04-15	AFK	ETF	32.77	32.85	32.34	32.84	27445.0
2010-04-15	AGG	ETF	104.04	104.27	103.89	104.26	837700.0
2010-04-15	AGQ	ETF	127.02	129.52	126.76	128.02	120600.0
2010-04-15	AGZ	ETF	108.08	108.225	107.929	108.2	11520.0
2010-04-15	AIA	ETF	42.39	42.53	42.29	42.41	34100.0
2010-04-15	AIQ	ETF	26.75	28.4	26.75	28.25	43423.0
2010-04-15	AIS	ETF	1.59	1.6	1.5599	1.6	277485.0
2010-04-15	AIVI	ETF	44.26	44.46	44.14	44.43	70900.0
2010-04-15	AMJ	ETF	31.37	31.4293	31.189	31.38	734853.0
2010-04-15	AOA	ETF	32.65	32.77	32.58	32.72	18600.0
2010-04-15	AOK	ETF	28.157	28.167	28.09	28.16	3526.0
2010-04-15	AOM	ETF	29.19	29.24	29.14	29.24	12859.0
2010-04-15	AOR	ETF	30.36	30.55	30.36	30.535	17734.0
2010-04-15	ARB	ETF	27.59	27.79	27.334	27.68	244872.0
2010-04-15	BAB	ETF	24.93	25.07	24.87	25.05	315388.0
2010-04-15	BAL	ETF	38.0	38.95	38.0	38.95	3990.0
2010-04-15	BALT	ETF	13.9	13.9	13.5	13.69	597276.0
2010-04-15	BBH	ETF	34.79	34.79	34.4267	34.4733	58200.0
2010-04-15	BIB	ETF	7.585	7.6175	7.585	7.6175	16800.0
2010-04-15	BICK	ETF	30.48	30.57	30.3813	30.4	13689.0
2010-04-15	BIL	ETF	91.68	91.7	91.68	91.68	116750.0
2010-04-15	BIS	ETF	9432.0	9456.0	9432.0	9456.0	12.65
2010-04-15	BITS	ETF	32.4	32.4	31.96	32.24	650.0
2010-04-15	BIV	ETF	80.2	80.45	80.12	80.31	71800.0
2010-04-15	BJK	ETF	27.05	27.29	26.96	27.09	15000.0
2010-04-15	BKF	ETF	48.18	48.41	47.9519	47.99	137496.0
2010-04-15	BLV	ETF	76.59	77.23	76.59	77.06	22500.0
2010-04-15	BMVP	ETF	13.66	13.74	13.65	13.74	18497.0
2010-04-15	BND	ETF	79.09	79.27	78.97	79.24	712200.0
2010-04-15	BNE	ETF	11.17	11.17	11.11	11.16	619170.0
2010-04-15	BRF	ETF	47.01	47.5	46.7	46.93	244662.0
2010-04-15	BSV	ETF	79.84	79.93	79.81	79.87	360400.0
2010-04-15	BTF	ETF	75.5	75.8	73.6	74.95	9186.6
2010-04-15	BWX	ETF	27.91	28.025	27.865	27.915	385192.0
2010-04-15	BWZ	ETF	35.7	35.91	35.7	35.9	54458.0
2010-04-15	BZQ	ETF	3393.6	3446.4	3336.0	3441.6	290.0
2010-04-15	CEF	ETF	14.65	14.7	14.59	14.62	729900.0
2010-04-15	CEW	ETF	22.47	22.53	22.46	22.51	221552.0
2010-04-15	CGO	ETF	15.03	15.03	14.75	14.95	42994.0
2010-04-15	CGW	ETF	19.06	19.1112	18.9506	19.05	41466.0

> showing 50 of 747 rows — these rows as CSV

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