PREVIEW / etf_daily / 2009-11-25

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-25.parquet
  size:    30 KB
  rows:    692

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-25	SPY	ETF	111.17	111.5	110.82	111.38	109564800.0
2009-11-25	QQQ	ETF	44.14	44.22	44.01	44.18	37630050.0
2009-11-25	IWM	ETF	59.69	59.82	59.26	59.33	47641700.0
2009-11-25	DIA	ETF	104.54	104.84	104.2	104.63	6489600.0
2009-11-25	GLD	ETF	115.69	116.88	115.53	116.62	24569900.0
2009-11-25	TLT	ETF	95.49	96.23	94.97	96.04	2789300.0
2009-11-25	AAXJ	ETF	56.04	56.1	55.69	56.07	360500.0
2009-11-25	ACWI	ETF	42.69	42.78	42.48	42.77	30600.0
2009-11-25	ACWX	ETF	41.35	41.76	41.35	41.76	33362.0
2009-11-25	ADRE	ETF	45.0	45.4	44.74	45.27	249586.0
2009-11-25	AFK	ETF	29.17	29.17	28.8101	29.07	5670.0
2009-11-25	AGG	ETF	105.41	105.56	105.29	105.56	418200.0
2009-11-25	AGQ	ETF	139.52	142.68	138.58	142.48	280800.0
2009-11-25	AGZ	ETF	108.82	109.1478	108.82	109.13	10519.0
2009-11-25	AIA	ETF	40.11	40.14	39.93	40.13	51369.0
2009-11-25	AIQ	ETF	30.2	30.5	29.85	29.95	22771.0
2009-11-25	AIS	ETF	1.13	1.14	1.11	1.14	92120.0
2009-11-25	AIVI	ETF	44.76	45.09	44.66	45.09	35300.0
2009-11-25	AMJ	ETF	26.6	26.85	26.54	26.84	248705.0
2009-11-25	AOA	ETF	29.8	29.85	29.67	29.82	8800.0
2009-11-25	AOK	ETF	27.55	27.55	27.54	27.55	822.0
2009-11-25	AOM	ETF	28.3293	28.42	28.326	28.42	3442.0
2009-11-25	AOR	ETF	29.08	29.11	29.034	29.11	11704.0
2009-11-25	ARB	ETF	22.56	22.81	22.21	22.26	109594.0
2009-11-25	BAB	ETF	25.0	25.08	24.978	25.08	40189.0
2009-11-25	BAL	ETF	37.0899	37.1003	36.63	37.02	10576.0
2009-11-25	BBH	ETF	32.71	33.0	32.71	32.88	143400.0
2009-11-25	BIL	ETF	91.7	91.72	91.7	91.7	59350.0
2009-11-25	BITS	ETF	28.2	28.2	27.4	28.0	3650.0
2009-11-25	BIV	ETF	81.19	81.33	80.89	81.25	229200.0
2009-11-25	BJK	ETF	25.14	25.32	25.02	25.18	11200.0
2009-11-25	BKF	ETF	46.88	47.11	46.5	46.99	298743.0
2009-11-25	BLV	ETF	78.45	78.86	78.04	78.71	50300.0
2009-11-25	BMVP	ETF	12.33	12.381	12.32	12.363	5396.0
2009-11-25	BND	ETF	79.93	80.15	79.9	80.15	579800.0
2009-11-25	BNE	ETF	6.15	6.18	6.0	6.01	109908.0
2009-11-25	BOSS	ETF	19.17	19.38	19.17	19.38	300.0
2009-11-25	BRF	ETF	47.68	48.0	47.23	47.85	278347.0
2009-11-25	BSV	ETF	80.5	80.52	80.37	80.51	399000.0
2009-11-25	BTF	ETF	64.19999999999999	64.64999999999999	64.05	64.64999999999999	2896.0
2009-11-25	BWX	ETF	30.03	30.165	29.975	30.115	1053128.0
2009-11-25	BWZ	ETF	38.19	38.38	38.007	38.3212	55923.0
2009-11-25	BZQ	ETF	3798.4	3840.0	3676.8	3712.0	232.0
2009-11-25	CEF	ETF	14.77	14.95	14.72	14.93	2083800.0
2009-11-25	CEW	ETF	22.44	22.44	22.3	22.43	147738.0
2009-11-25	CGO	ETF	13.66	13.72	13.6	13.72	22264.0
2009-11-25	CGW	ETF	18.3	18.41	18.26	18.39	102274.0
2009-11-25	CHI	ETF	12.05	12.05	11.96	12.0	184719.0
2009-11-25	CHW	ETF	7.72	7.81	7.68	7.81	210458.0
2009-11-25	CHY	ETF	11.33	11.38	11.28	11.33	152140.0

> showing 50 of 692 rows — these rows as CSV

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