PREVIEW / etf_daily / 2009-12-08

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-08.parquet
  size:    30 KB
  rows:    703

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-12-08	SPY	ETF	110.04	110.77	109.27	109.61	169863700.0
2009-12-08	QQQ	ETF	43.68	44.0	43.36	43.642	86621378.0
2009-12-08	IWM	ETF	60.14	60.47	59.38	60.04	59576600.0
2009-12-08	DIA	ETF	103.42	103.44	101.75	102.94	10719700.0
2009-12-08	GLD	ETF	112.76	113.06	110.21	110.95	37655000.0
2009-12-08	TLT	ETF	94.05	94.37	93.37	93.6	2378600.0
2009-12-08	AAXJ	ETF	55.7	55.7	55.08	55.27	1636900.0
2009-12-08	ACWI	ETF	42.25	42.25	41.74	41.94	116700.0
2009-12-08	ACWX	ETF	41.08	41.08	40.54	40.62	71976.0
2009-12-08	ADRE	ETF	44.25	44.26	43.49	43.68	247608.0
2009-12-08	AFK	ETF	28.32	28.55	28.02	28.035	9191.0
2009-12-08	AGG	ETF	105.15	105.28	105.03	105.06	708300.0
2009-12-08	AGQ	ETF	128.56	129.42	122.66	123.62	457500.0
2009-12-08	AGZ	ETF	108.88	108.95	108.61	108.88	5160.0
2009-12-08	AIA	ETF	39.52	39.54	39.18	39.4	41172.0
2009-12-08	AIQ	ETF	29.4	30.45	29.0	29.9	20176.0
2009-12-08	AIS	ETF	1.1	1.12	1.09	1.1	215609.0
2009-12-08	AIVI	ETF	43.94	43.94	43.24	43.59	88300.0
2009-12-08	AMJ	ETF	27.18	27.18	26.7899	27.08	312305.0
2009-12-08	AOA	ETF	29.64	29.64	29.45	29.47	11500.0
2009-12-08	AOK	ETF	27.46	27.47	27.41	27.41	6557.0
2009-12-08	AOM	ETF	28.25	28.25	28.1605	28.17	3390.0
2009-12-08	AOR	ETF	28.94	28.94	28.8	28.83	9500.0
2009-12-08	ARB	ETF	22.02	22.18	21.57	21.99	134662.0
2009-12-08	BAB	ETF	24.83	24.85	24.776	24.8	29633.0
2009-12-08	BAL	ETF	36.54	36.55	36.375	36.38	4826.0
2009-12-08	BBH	ETF	32.29	32.5067	32.21	32.34	94800.0
2009-12-08	BIL	ETF	91.72	91.72	91.7	91.7	162700.0
2009-12-08	BITS	ETF	26.56	26.96	26.56	26.96	412.0
2009-12-08	BIV	ETF	81.0	81.16	80.73	81.04	128700.0
2009-12-08	BJK	ETF	24.59	24.59	23.98	24.06	8000.0
2009-12-08	BKF	ETF	46.27	46.27	45.3919	45.78	226158.0
2009-12-08	BLV	ETF	78.19	78.4	77.86	78.09	49500.0
2009-12-08	BMVP	ETF	12.33	12.33	12.2114	12.2233	7844.0
2009-12-08	BND	ETF	79.74	79.83	79.71	79.71	387300.0
2009-12-08	BNE	ETF	6.33	6.7	6.19	6.55	333445.0
2009-12-08	BOSS	ETF	19.94	19.94	19.5	19.5	100.0
2009-12-08	BRF	ETF	48.72	48.74	47.69	48.1	392192.0
2009-12-08	BSV	ETF	80.29	80.41	80.29	80.38	398700.0
2009-12-08	BTF	ETF	62.9	63.89999999999999	62.5	62.8	4733.0
2009-12-08	BWX	ETF	29.715	29.722	29.525	29.575	257386.0
2009-12-08	BWZ	ETF	37.6	37.6	37.4	37.43	14072.0
2009-12-08	BZQ	ETF	3766.4	3926.4	3758.4	3856.0	231.0
2009-12-08	CEF	ETF	14.24	14.36	13.9	14.03	1591000.0
2009-12-08	CEW	ETF	22.11	22.2	22.02	22.09	116851.0
2009-12-08	CGO	ETF	14.05	14.29	13.9	14.2	41036.0
2009-12-08	CGW	ETF	18.5	18.58	18.17	18.35	107349.0
2009-12-08	CHI	ETF	12.05	12.24	12.05	12.172	153112.0
2009-12-08	CHII	ETF	16.18	16.18	16.04	16.08	111377.0
2009-12-08	CHIQ	ETF	16.52	16.6	16.4	16.52	19467.0

> showing 50 of 703 rows — these rows as CSV

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