PREVIEW / etf_daily / 2009-11-17

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-17.parquet
  size:    30 KB
  rows:    683

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-17	SPY	ETF	110.92	111.39	110.5	111.34	147134100.0
2009-11-17	QQQ	ETF	44.34	44.6	44.25	44.6	81883998.0
2009-11-17	IWM	ETF	60.08	60.48	59.74	60.28	43026500.0
2009-11-17	DIA	ETF	104.09	104.64	103.86	104.59	8398000.0
2009-11-17	GLD	ETF	111.09	111.99	110.9	111.97	19831100.0
2009-11-17	TLT	ETF	94.99	95.8	94.81	95.53	3174400.0
2009-11-17	AAXJ	ETF	55.77	56.6	55.76	56.6	583800.0
2009-11-17	ACWI	ETF	42.8	42.89	42.45	42.88	78400.0
2009-11-17	ACWX	ETF	41.58	41.78	41.3781	41.775	25472.0
2009-11-17	ADRE	ETF	44.5	45.21	44.38	45.21	170811.0
2009-11-17	AFK	ETF	28.88	29.05	28.56	28.844	13224.0
2009-11-17	AGG	ETF	105.06	105.24	105.0	105.24	681400.0
2009-11-17	AGQ	ETF	134.36	137.02	133.48	137.02	193200.0
2009-11-17	AGZ	ETF	109.0	109.0	108.5701	108.84	9857.0
2009-11-17	AIA	ETF	40.1	40.11	39.8224	40.01	45169.0
2009-11-17	AIQ	ETF	26.55	28.05	26.4	27.95	41756.0
2009-11-17	AIS	ETF	1.12	1.14	1.11	1.14	245075.0
2009-11-17	AIVI	ETF	44.6	44.82	44.29	44.79	56500.0
2009-11-17	AMJ	ETF	26.83	26.94	26.7029	26.94	563856.0
2009-11-17	AOA	ETF	29.93	30.0	29.83	30.0	9400.0
2009-11-17	AOK	ETF	27.68	27.68	27.49	27.63	33495.0
2009-11-17	AOM	ETF	28.39	28.44	28.32	28.4001	24624.0
2009-11-17	AOR	ETF	29.12	29.16	29.04	29.16	16391.0
2009-11-17	ARB	ETF	22.49	22.63	22.21	22.38	196378.0
2009-11-17	BAB	ETF	24.92	24.99	24.9	24.96	274311.0
2009-11-17	BAL	ETF	35.4332	35.57	35.2901	35.2901	12808.0
2009-11-17	BBH	ETF	32.46	32.6333	32.4167	32.59	93600.0
2009-11-17	BIL	ETF	91.72	91.72	91.7	91.7	102100.0
2009-11-17	BITS	ETF	27.6	27.6	27.04	27.6	1039.0
2009-11-17	BIV	ETF	80.75	81.0	80.54	80.95	236200.0
2009-11-17	BJK	ETF	25.57	25.76	25.39	25.73	31800.0
2009-11-17	BKF	ETF	47.34	47.72	46.9308	47.65	166016.0
2009-11-17	BLV	ETF	78.53	78.53	78.02	78.19	82300.0
2009-11-17	BMVP	ETF	12.47	12.5	12.42	12.49	27377.0
2009-11-17	BND	ETF	79.73	79.77	79.6	79.69	729200.0
2009-11-17	BNE	ETF	6.52	6.81	6.41	6.71	81169.0
2009-11-17	BOSS	ETF	20.0	20.0	20.0	20.0	100.0
2009-11-17	BRF	ETF	47.43	47.66	46.8	47.62	288838.0
2009-11-17	BSV	ETF	80.29	80.29	80.15	80.21	446800.0
2009-11-17	BTF	ETF	64.0	64.25	63.449999999999996	63.849999999999994	2930.6000000000004
2009-11-17	BWX	ETF	29.785	29.785	29.645	29.755	414052.0
2009-11-17	BWZ	ETF	37.82	37.82	37.72	37.81	71209.0
2009-11-17	BZQ	ETF	3854.4	3947.2	3723.2	3729.6	229.5
2009-11-17	CEF	ETF	13.97	14.21	13.91	14.19	1641100.0
2009-11-17	CEW	ETF	22.26	22.335	22.23	22.31	77297.0
2009-11-17	CGO	ETF	13.94	14.12	13.9	14.04	46003.0
2009-11-17	CGW	ETF	18.41	18.46	18.24	18.4225	67131.0
2009-11-17	CHI	ETF	12.04	12.04	11.91	11.99	204304.0
2009-11-17	CHW	ETF	7.52	7.66	7.52	7.54	247225.0
2009-11-17	CHY	ETF	11.6	11.67	11.5	11.6	239444.0

> showing 50 of 683 rows — these rows as CSV

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