PREVIEW / etf_daily / 2009-10-19

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-19.parquet
  size:    30 KB
  rows:    673

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-10-19	SPY	ETF	109.07	110.13	108.73	109.79	159530400.0
2009-10-19	QQQ	ETF	42.81	43.27	42.59	43.21	83511942.0
2009-10-19	IWM	ETF	61.88	62.52	61.38	62.19	38229600.0
2009-10-19	DIA	ETF	100.11	101.17	99.93	100.86	9772400.0
2009-10-19	GLD	ETF	103.16	104.26	102.75	104.23	13936600.0
2009-10-19	TLT	ETF	95.59	96.21	95.38	96.2	3163800.0
2009-10-19	AAXJ	ETF	54.81	55.46	54.58	55.46	388100.0
2009-10-19	ACWI	ETF	42.31	42.57	42.07	42.49	125400.0
2009-10-19	ACWX	ETF	41.5	41.857	41.315	41.73	88002.0
2009-10-19	ADRE	ETF	43.99	44.534	43.742	44.43	176528.0
2009-10-19	AFK	ETF	30.37	30.7	30.36	30.68	16657.0
2009-10-19	AGG	ETF	104.31	104.45	104.03	104.45	455500.0
2009-10-19	AGQ	ETF	124.62	128.9	123.18	128.7	200050.0
2009-10-19	AGZ	ETF	108.47	108.5284	108.2319	108.32	23377.0
2009-10-19	AIA	ETF	39.34	39.83	39.271	39.81	25276.0
2009-10-19	AIQ	ETF	31.25	32.35	31.1	31.65	60060.0
2009-10-19	AIS	ETF	1.3	1.3	1.19	1.27	1096297.0
2009-10-19	AIVI	ETF	43.95	44.31	43.72	44.24	20800.0
2009-10-19	AMJ	ETF	26.32	26.53	26.0	26.43	268936.0
2009-10-19	AOA	ETF	29.87	29.99	29.73	29.96	5400.0
2009-10-19	AOK	ETF	27.22	27.41	27.1	27.4	14611.0
2009-10-19	AOM	ETF	28.44	28.44	28.06	28.24	13833.0
2009-10-19	AOR	ETF	29.0	29.07	28.85	29.0	8106.0
2009-10-19	ARB	ETF	24.01	24.09	23.23	23.37	483301.0
2009-10-19	BAL	ETF	35.58	35.772	34.53	34.5899	8573.0
2009-10-19	BBH	ETF	33.79	34.0433	33.6667	33.9033	130200.0
2009-10-19	BIL	ETF	91.72	91.74	91.7	91.72	100550.0
2009-10-19	BITS	ETF	25.12	25.96	22.32	25.44	4459.0
2009-10-19	BIV	ETF	79.98	80.08	79.84	80.08	85900.0
2009-10-19	BJK	ETF	26.62	26.72	26.26	26.69	15600.0
2009-10-19	BKF	ETF	45.8	46.4	45.6	46.29	321422.0
2009-10-19	BLV	ETF	78.19	78.34	77.81	78.22	116800.0
2009-10-19	BMVP	ETF	12.39	12.54	12.37	12.52	34828.0
2009-10-19	BND	ETF	79.16	79.18	78.91	79.16	973400.0
2009-10-19	BNE	ETF	8.03	8.2	7.75	7.99	151517.0
2009-10-19	BOSS	ETF	22.13	22.29	22.13	22.13	100.0
2009-10-19	BRF	ETF	45.94	46.18	45.518	45.85	881263.0
2009-10-19	BSV	ETF	79.81	79.87	79.69	79.87	435200.0
2009-10-19	BTF	ETF	61.3	62.154999999999994	61.3	62.105	4513.6
2009-10-19	BWX	ETF	29.445	29.55	29.37	29.55	341282.0
2009-10-19	BWZ	ETF	37.69	37.75	37.484	37.6999	78837.0
2009-10-19	BZQ	ETF	4211.2	4236.8	4052.8	4123.2	126.0
2009-10-19	CEF	ETF	13.63	13.94	13.56	13.93	601800.0
2009-10-19	CEW	ETF	22.12	23.18	22.098	22.16	80665.0
2009-10-19	CGO	ETF	14.2	14.3	14.1499	14.2555	32554.0
2009-10-19	CGW	ETF	17.98	18.14	17.95	18.1	70965.0
2009-10-19	CHB	ETF	0.34	0.34	0.32	0.33	1815124.0
2009-10-19	CHI	ETF	11.9	12.0	11.85	11.88	146955.0
2009-10-19	CHW	ETF	7.96	8.1	7.94	8.03	229243.0
2009-10-19	CHY	ETF	11.56	11.7	11.51	11.59	138491.0

> showing 50 of 673 rows — these rows as CSV

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