PREVIEW / etf_daily / 2009-09-25

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-25.parquet
  size:    30 KB
  rows:    670

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-09-25	SPY	ETF	104.78	105.36	104.09	104.45	204059000.0
2009-09-25	QQQ	ETF	41.78	42.09	41.58	41.7	109215947.0
2009-09-25	IWM	ETF	59.91	60.34	59.51	59.83	51804400.0
2009-09-25	DIA	ETF	96.88	97.35	96.38	96.74	13350100.0
2009-09-25	GLD	ETF	97.07	97.5	96.77	97.0	10724500.0
2009-09-25	TLT	ETF	97.36	98.06	96.77	97.98	3854500.0
2009-09-25	AAXJ	ETF	51.93	52.01	51.29	51.79	69800.0
2009-09-25	ACWI	ETF	40.34	40.56	40.14	40.25	41300.0
2009-09-25	ACWX	ETF	39.33	39.54	39.11	39.26	44614.0
2009-09-25	ADRE	ETF	39.97	40.2132	39.706	40.0	123339.0
2009-09-25	AFK	ETF	28.8	28.8299	28.294	28.541	14639.0
2009-09-25	AGG	ETF	104.56	104.79	104.47	104.79	512100.0
2009-09-25	AGQ	ETF	106.6	108.98	105.9	106.32	206950.0
2009-09-25	AGZ	ETF	108.82	108.82	108.245	108.55	10978.0
2009-09-25	AIA	ETF	37.81	38.01	37.6197	37.8	16733.0
2009-09-25	AIQ	ETF	27.4	27.4	25.75	26.75	48137.0
2009-09-25	AIS	ETF	1.13	1.13	1.1	1.1	286170.0
2009-09-25	AIVI	ETF	41.89	42.19	41.62	41.71	16100.0
2009-09-25	AMJ	ETF	24.78	24.909	24.7	24.8	449502.0
2009-09-25	AOA	ETF	28.74	28.77	28.54	28.54	20000.0
2009-09-25	AOK	ETF	27.18	27.18	26.98	27.06	5558.0
2009-09-25	AOM	ETF	27.5202	27.63	27.434	27.434	16709.0
2009-09-25	AOR	ETF	28.22	28.22	28.04	28.06	7959.0
2009-09-25	ARB	ETF	19.38	20.02	19.23	19.85	353010.0
2009-09-25	BAL	ETF	33.71	33.96	32.2	32.31	51310.0
2009-09-25	BBH	ETF	33.6133	34.08	33.5333	33.7967	122100.0
2009-09-25	BIL	ETF	91.72	91.74	91.7	91.74	80550.0
2009-09-25	BITS	ETF	22.0	22.08	21.0356	22.0	3280.0
2009-09-25	BIV	ETF	80.24	80.43	80.03	80.42	267400.0
2009-09-25	BJK	ETF	25.95	26.0	24.83	25.82	16900.0
2009-09-25	BKF	ETF	40.64	41.15	40.5101	41.0	78033.0
2009-09-25	BLV	ETF	79.5	79.78	79.12	79.75	71100.0
2009-09-25	BMVP	ETF	11.87	11.94	11.82	11.84	10173.0
2009-09-25	BND	ETF	79.28	79.5	79.21	79.46	440400.0
2009-09-25	BNE	ETF	7.08	7.2	7.02	7.15	138053.0
2009-09-25	BRF	ETF	38.7	39.27	38.7	39.1999	147884.0
2009-09-25	BSV	ETF	80.07	80.07	79.84	79.97	328400.0
2009-09-25	BTF	ETF	60.199999999999996	60.8	59.74999999999999	60.25	6634.6
2009-09-25	BWX	ETF	29.14	29.24	29.009	29.105	308282.0
2009-09-25	BWZ	ETF	37.23	37.26	37.168	37.24	19302.0
2009-09-25	BZQ	ETF	5824.0	5825.6	5712.0	5724.8	14.5
2009-09-25	CEF	ETF	12.66	12.71	12.43	12.68	769400.0
2009-09-25	CEW	ETF	21.71	21.874	21.6501	21.6501	75340.0
2009-09-25	CGO	ETF	13.82	13.93	13.8	13.8	18438.0
2009-09-25	CGW	ETF	17.51	17.7	17.48	17.53	73701.0
2009-09-25	CHB	ETF	0.5	0.53	0.495	0.51	1271731.0
2009-09-25	CHI	ETF	11.53	11.65	11.53	11.61	148285.0
2009-09-25	CHIC	ETF	17.47	17.49	17.46	17.49	498056.0
2009-09-25	CHW	ETF	7.68	7.726	7.6	7.6	117927.0
2009-09-25	CHY	ETF	11.2	11.32	11.17	11.2949	184139.0

> showing 50 of 670 rows — these rows as CSV

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