PREVIEW / etf_daily / 2010-04-08

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-08.parquet
  size:    32 KB
  rows:    749

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-08	SPY	ETF	117.95	118.97	117.6	118.77	158704000.0
2010-04-08	QQQ	ETF	48.51	48.82	48.24	48.74	68323873.0
2010-04-08	IWM	ETF	69.7	70.2	69.16	69.83	54603600.0
2010-04-08	DIA	ETF	108.71	109.57	108.5	109.37	8764300.0
2010-04-08	GLD	ETF	112.47	112.98	112.13	112.65	12445400.0
2010-04-08	TLT	ETF	88.89	89.13	88.48	88.77	3797600.0
2010-04-08	AAXJ	ETF	58.1	58.61	57.85	58.61	129900.0
2010-04-08	ACWI	ETF	44.0	44.34	43.75	44.33	201800.0
2010-04-08	ACWX	ETF	41.97	42.31	41.77	42.28	32720.0
2010-04-08	ADRE	ETF	44.81	45.309	44.55	45.2592	57590.0
2010-04-08	AFK	ETF	32.38	32.95	32.01	32.79	64653.0
2010-04-08	AGG	ETF	103.91	103.94	103.64	103.67	406700.0
2010-04-08	AGQ	ETF	122.6	124.28	122.1	123.44	142700.0
2010-04-08	AGZ	ETF	107.9112	107.995	107.8311	107.89	17896.0
2010-04-08	AIA	ETF	41.37	41.89	41.33	41.86	129700.0
2010-04-08	AIQ	ETF	28.15	28.2	27.55	27.55	8893.0
2010-04-08	AIS	ETF	1.63	1.74	1.63	1.68	948195.0
2010-04-08	AIVI	ETF	42.54	43.0	42.47	43.0	12300.0
2010-04-08	AMJ	ETF	30.87	31.3	30.85	31.21	681951.0
2010-04-08	AOA	ETF	31.88	32.02	31.78	32.02	8400.0
2010-04-08	AOK	ETF	27.89	27.93	27.85	27.9015	23848.0
2010-04-08	AOM	ETF	28.84	28.91	28.84	28.869	8423.0
2010-04-08	AOR	ETF	29.93	30.03	29.86	30.0199	5624.0
2010-04-08	ARB	ETF	26.33	27.3	26.03	26.68	221524.0
2010-04-08	BAB	ETF	24.97	25.0	24.85	24.93	223680.0
2010-04-08	BAL	ETF	39.04	39.04	37.74	37.91	3432.0
2010-04-08	BALT	ETF	13.92	14.0	13.78	14.0	890758.0
2010-04-08	BBH	ETF	34.4633	34.72	34.29	34.6367	46800.0
2010-04-08	BIB	ETF	7.3875	7.5113	7.34	7.5113	29200.0
2010-04-08	BIL	ETF	91.68	91.7	91.68	91.68	130250.0
2010-04-08	BIS	ETF	9684.8	9816.0	9683.2	9737.6	30.6
2010-04-08	BITS	ETF	32.32	32.8	32.32	32.44	1584.0
2010-04-08	BIV	ETF	80.0	80.12	79.72	79.85	90200.0
2010-04-08	BJK	ETF	26.35	26.99	26.35	26.81	17200.0
2010-04-08	BKF	ETF	47.47	48.08	47.1601	47.87	130198.0
2010-04-08	BLV	ETF	76.52	76.62	76.22	76.26	23800.0
2010-04-08	BMVP	ETF	13.34	13.41	13.29	13.39	41795.0
2010-04-08	BND	ETF	78.97	78.98	78.77	78.79	669600.0
2010-04-08	BNE	ETF	11.12	11.2	11.12	11.18	1568274.0
2010-04-08	BRF	ETF	45.31	46.0	45.2	45.76	300048.0
2010-04-08	BSV	ETF	79.75	79.79	79.67	79.71	379100.0
2010-04-08	BTF	ETF	73.89999999999999	74.64999999999999	73.75	74.39949999999999	2026.8000000000002
2010-04-08	BWX	ETF	27.685	27.8141	27.685	27.75	246206.0
2010-04-08	BWZ	ETF	35.27	35.543	35.27	35.51	30535.0
2010-04-08	BZQ	ETF	3558.4	3572.8	3395.2	3408.0	346.0
2010-04-08	CEF	ETF	14.36	14.48	14.35	14.46	781000.0
2010-04-08	CEW	ETF	22.33	22.41	22.3	22.36	161093.0
2010-04-08	CGO	ETF	14.96	15.15	14.95	15.15	38192.0
2010-04-08	CGW	ETF	18.66	18.76	18.44	18.711	41476.0
2010-04-08	CHI	ETF	12.81	12.847	12.78	12.8	246304.0

> showing 50 of 749 rows — these rows as CSV

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