PREVIEW / etf_daily / 2010-11-10

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-10.parquet
  size:    34 KB
  rows:    805

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
2010-11-10	SPY	ETF	121.58	122.16	120.66	122.1	221387400.0
2010-11-10	QQQ	ETF	53.53	53.77	53.1	53.715	83553612.0
2010-11-10	IWM	ETF	72.83	73.55	72.11	73.54	53667600.0
2010-11-10	DIA	ETF	113.62	113.89	112.76	113.73	9956900.0
2010-11-10	GLD	ETF	137.03	137.28	135.15	137.24	28484700.0
2010-11-10	TLT	ETF	96.35	96.74	95.0	96.38	18540400.0
2010-11-10	AADR	ETF	29.03	29.03	29.03	29.03	100.0
2010-11-10	AAXJ	ETF	65.22	65.32	64.56	65.25	478000.0
2010-11-10	ACWI	ETF	46.21	46.21	45.62	46.07	345300.0
2010-11-10	ACWX	ETF	44.15	44.23	43.577	44.2	40613.0
2010-11-10	ADRE	ETF	47.76	47.9688	47.1408	47.87	90649.0
2010-11-10	AFK	ETF	34.69	34.78	34.3101	34.744	70741.0
2010-11-10	AGG	ETF	108.03	108.14	107.62	107.95	910100.0
2010-11-10	AGQ	ETF	262.74	263.42	240.1	256.06	1633700.0
2010-11-10	AGZ	ETF	111.34	111.38	111.0201	111.32	23984.0
2010-11-10	AIA	ETF	46.44	46.54	45.98	46.54	64640.0
2010-11-10	AIQ	ETF	21.35	21.55	21.1	21.2	30338.0
2010-11-10	AIS	ETF	1.57	1.59	1.49	1.57	507492.0
2010-11-10	AIVI	ETF	45.71	45.77	45.01	45.75	69200.0
2010-11-10	AMJ	ETF	37.11	37.11	36.55	36.79	604729.0
2010-11-10	AMLP	ETF	80.75	80.75	79.85	80.25	90760.0
2010-11-10	AOA	ETF	33.4	33.53	33.21	33.53	5900.0
2010-11-10	AOK	ETF	28.82	28.8795	28.25	28.8795	39493.0
2010-11-10	AOM	ETF	29.8	29.94	29.79	29.91	11054.0
2010-11-10	AOR	ETF	31.2	31.23	31.013	31.21	11400.0
2010-11-10	ARB	ETF	26.16	26.36	25.8	26.24	395201.0
2010-11-10	BAB	ETF	25.71	25.86	25.6	25.79	293622.0
2010-11-10	BAL	ETF	75.3	75.87	70.12	74.22	227212.0
2010-11-10	BALT	ETF	12.32	12.54	12.25	12.31	310041.0
2010-11-10	BBH	ETF	33.1167	33.3267	32.8867	33.3033	304500.0
2010-11-10	BICK	ETF	33.88	34.04	33.56	34.04	28606.0
2010-11-10	BIL	ETF	91.7	91.72	91.7	91.7	243650.0
2010-11-10	BIS	ETF	9536.0	9539.2	9313.6	9313.6	7.5
2010-11-10	BITS	ETF	28.6	28.8	28.2	28.8	525.0
2010-11-10	BIV	ETF	86.56	86.89	86.2	86.77	158800.0
2010-11-10	BJK	ETF	32.28	32.31	31.76	32.2	14700.0
2010-11-10	BKF	ETF	51.12	51.2899	50.3605	51.16	126263.0
2010-11-10	BLV	ETF	81.42	81.68	80.5	81.46	161500.0
2010-11-10	BMVP	ETF	14.19	14.27	14.08	14.27	19827.0
2010-11-10	BND	ETF	82.2	82.27	81.86	82.18	884000.0
2010-11-10	BNE	ETF	11.4	11.46	11.4	11.45	794706.0
2010-11-10	BNO	ETF	29.71	29.83	29.71	29.79	2800.0
2010-11-10	BOSS	ETF	42.12	42.12	42.12	42.12	100.0
2010-11-10	BRF	ETF	60.96	61.13	59.5	60.16	640031.0
2010-11-10	BSCE	ETF	20.98	21.01	20.98	21.01	6000.0
2010-11-10	BSV	ETF	81.68	81.71	81.53	81.66	416200.0
2010-11-10	BTF	ETF	79.4	80.05	79.0	79.98	2890.4
2010-11-10	BWX	ETF	30.305	30.4492	30.13	30.285	434210.0
2010-11-10	BWZ	ETF	37.49	37.66	37.329	37.66	11978.0
2010-11-10	BZQ	ETF	2532.8	2616.0	2515.2	2553.6	482.5

> showing 50 of 805 rows — these rows as CSV

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