PREVIEW / etf_daily / 2009-11-19

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-19.parquet
  size:    30 KB
  rows:    689

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-11-19	SPY	ETF	110.51	111.31	109.13	109.82	208734600.0
2009-11-19	QQQ	ETF	44.06	44.08	43.35	43.66	114557942.0
2009-11-19	IWM	ETF	59.56	59.66	58.19	58.66	72350600.0
2009-11-19	DIA	ETF	104.04	104.07	102.87	103.65	12739500.0
2009-11-19	GLD	ETF	111.85	112.4	110.76	112.3	21249900.0
2009-11-19	TLT	ETF	95.24	95.82	94.91	95.14	2969800.0
2009-11-19	AAXJ	ETF	55.35	55.35	54.58	54.96	212200.0
2009-11-19	ACWI	ETF	42.34	42.34	41.71	42.02	50700.0
2009-11-19	ACWX	ETF	41.09	41.1	40.52	40.93	80995.0
2009-11-19	ADRE	ETF	44.47	44.47	43.661	44.18	130582.0
2009-11-19	AFK	ETF	28.01	28.4357	28.0	28.155	14900.0
2009-11-19	AGG	ETF	105.18	105.24	104.99	105.13	393600.0
2009-11-19	AGQ	ETF	137.78	138.9	132.9	138.76	235200.0
2009-11-19	AGZ	ETF	108.93	108.9689	108.7301	108.8	15450.0
2009-11-19	AIA	ETF	39.81	39.82	39.258	39.57	44111.0
2009-11-19	AIQ	ETF	28.5	28.5	26.9	27.7	58519.0
2009-11-19	AIS	ETF	1.07	1.15	1.07	1.15	198078.0
2009-11-19	AIVI	ETF	44.31	44.31	43.7	44.2	54500.0
2009-11-19	AMJ	ETF	26.92	26.92	26.61	26.75	291909.0
2009-11-19	AOA	ETF	29.67	29.67	29.33	29.41	2900.0
2009-11-19	AOK	ETF	27.54	27.54	27.4325	27.49	6368.0
2009-11-19	AOM	ETF	28.32	28.32	28.1379	28.22	12798.0
2009-11-19	AOR	ETF	28.95	28.95	28.671	28.79	14825.0
2009-11-19	ARB	ETF	22.25	22.465	21.9725	22.2	251703.0
2009-11-19	BAB	ETF	24.99	24.99	24.93	24.96	58092.0
2009-11-19	BAL	ETF	35.4575	35.96	35.42	35.911	5497.0
2009-11-19	BBH	ETF	32.1167	32.3167	31.93	32.2267	86700.0
2009-11-19	BIL	ETF	91.72	91.72	91.7	91.7	87400.0
2009-11-19	BITS	ETF	27.04	27.56	25.72	27.12	1896.0
2009-11-19	BIV	ETF	80.89	81.0	80.72	80.95	106900.0
2009-11-19	BJK	ETF	25.3	25.3	24.72	25.1	11300.0
2009-11-19	BKF	ETF	46.81	46.81	45.61	46.32	180137.0
2009-11-19	BLV	ETF	78.09	78.27	77.77	78.15	55100.0
2009-11-19	BMVP	ETF	12.34	12.34	12.173	12.215	9018.0
2009-11-19	BND	ETF	79.84	79.88	79.71	79.77	699900.0
2009-11-19	BNE	ETF	6.03	6.16	5.87	6.03	204688.0
2009-11-19	BRF	ETF	46.89	46.89	45.68	46.62	406975.0
2009-11-19	BSV	ETF	80.34	80.41	80.31	80.38	591800.0
2009-11-19	BTF	ETF	64.0	64.35	63.699999999999996	63.8	4628.400000000001
2009-11-19	BWX	ETF	29.735	29.77	29.6	29.77	307834.0
2009-11-19	BWZ	ETF	37.82	37.82	37.7101	37.8	15134.0
2009-11-19	BZQ	ETF	3910.4	4075.2	3902.4	3912.0	294.0
2009-11-19	CEF	ETF	14.15	14.51	14.04	14.37	1933300.0
2009-11-19	CEW	ETF	22.23	22.23	22.0999	22.17	241659.0
2009-11-19	CGO	ETF	14.14	14.14	13.56	13.7375	38641.0
2009-11-19	CGW	ETF	18.13	18.2	17.89	17.98	383556.0
2009-11-19	CHI	ETF	12.07	12.07	11.9	11.99	136093.0
2009-11-19	CHW	ETF	7.57	7.74	7.52	7.674	495188.0
2009-11-19	CHY	ETF	11.67	11.67	11.38	11.41	241990.0
2009-11-19	CMF	ETF	52.795	52.89	52.575	52.75	6702.0

> showing 50 of 689 rows — these rows as CSV

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