PREVIEW / etf_daily / 2009-11-12

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-12.parquet
  size:    30 KB
  rows:    680

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-12	SPY	ETF	110.0	110.57	108.75	109.03	157144500.0
2009-11-12	QQQ	ETF	43.92	44.16	43.55	43.65	92426053.0
2009-11-12	IWM	ETF	59.28	59.73	58.0	58.17	68550500.0
2009-11-12	DIA	ETF	102.96	103.41	101.9	102.17	11966800.0
2009-11-12	GLD	ETF	109.16	109.56	108.12	108.21	17859900.0
2009-11-12	TLT	ETF	93.24	93.59	92.45	93.49	3431300.0
2009-11-12	AAXJ	ETF	55.16	55.18	54.43	54.68	169600.0
2009-11-12	ACWI	ETF	42.08	42.46	41.77	41.88	80100.0
2009-11-12	ACWX	ETF	41.22	41.35	40.65	40.74	275455.0
2009-11-12	ADRE	ETF	44.17	44.4	43.276	43.44	163396.0
2009-11-12	AFK	ETF	29.13	29.13	28.43	28.6	5150.0
2009-11-12	AGG	ETF	104.52	104.79	104.34	104.79	507000.0
2009-11-12	AGQ	ETF	122.82	124.52	119.38	119.8	254200.0
2009-11-12	AGZ	ETF	108.27	108.63	108.27	108.56	6176.0
2009-11-12	AIA	ETF	39.3	39.442	38.9601	38.98	65532.0
2009-11-12	AIQ	ETF	27.05	27.5	26.65	26.7	21011.0
2009-11-12	AIS	ETF	1.13	1.13	1.07	1.1	257110.0
2009-11-12	AIVI	ETF	43.95	44.32	43.6	43.64	14300.0
2009-11-12	AMJ	ETF	26.43	26.48	26.0	26.48	118187.0
2009-11-12	AOA	ETF	29.66	29.68	29.35	29.35	8800.0
2009-11-12	AOK	ETF	27.43	27.43	27.32	27.36	14452.0
2009-11-12	AOM	ETF	28.25	28.25	28.0376	28.06	27690.0
2009-11-12	AOR	ETF	28.91	28.95	28.6	28.65	17563.0
2009-11-12	ARB	ETF	22.28	22.47	21.39	21.45	175298.0
2009-11-12	BAL	ETF	34.87	34.87	34.33	34.52	52880.0
2009-11-12	BBH	ETF	32.4167	32.6167	32.16	32.3233	153300.0
2009-11-12	BIL	ETF	91.74	91.74	91.7	91.7	95300.0
2009-11-12	BITS	ETF	27.64	28.06	27.2	27.4	719.0
2009-11-12	BIV	ETF	80.34	80.49	80.18	80.4	190900.0
2009-11-12	BJK	ETF	25.29	25.5	25.01	25.01	6600.0
2009-11-12	BKF	ETF	46.47	46.63	45.3719	45.58	305592.0
2009-11-12	BLV	ETF	77.19	77.4	76.62	77.15	52800.0
2009-11-12	BMVP	ETF	12.36	12.4	12.22	12.24	56525.0
2009-11-12	BND	ETF	79.34	79.58	79.27	79.56	480300.0
2009-11-12	BNE	ETF	6.73	6.95	6.33	6.34	227460.0
2009-11-12	BRF	ETF	46.19	46.5	44.87	45.17	342673.0
2009-11-12	BSV	ETF	80.18	80.18	80.02	80.12	500900.0
2009-11-12	BTF	ETF	62.64999999999999	63.3	62.64999999999999	62.75	2745.8
2009-11-12	BWX	ETF	29.69	29.69	29.435	29.435	556762.0
2009-11-12	BWZ	ETF	37.74	37.9	37.41	37.55	55953.0
2009-11-12	BZQ	ETF	3969.6	4225.6	3905.6	4185.6	290.0
2009-11-12	CEF	ETF	13.95	13.95	13.6	13.65	1909500.0
2009-11-12	CEW	ETF	22.27	22.84	22.06	22.14	101656.0
2009-11-12	CGO	ETF	13.7	13.91	13.47	13.54	398627.0
2009-11-12	CGW	ETF	18.22	18.25	17.94	18.0196	83854.0
2009-11-12	CHB	ETF	0.229	0.23	0.21	0.215	901155.0
2009-11-12	CHI	ETF	12.31	12.32	12.18	12.224	136281.0
2009-11-12	CHW	ETF	7.62	7.65	7.51	7.53	128667.0
2009-11-12	CHY	ETF	11.64	11.67	11.59	11.6	153102.0
2009-11-12	CMF	ETF	52.71	52.85	52.46	52.46	5722.0

> showing 50 of 680 rows — these rows as CSV

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