PREVIEW / etf_daily / 2010-12-06

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-06.parquet
  size:    34 KB
  rows:    811

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-12-06	SPY	ETF	122.63	123.04	122.5	122.76	103050500.0
2010-12-06	QQQ	ETF	53.86	53.95	53.68	53.845	39311533.0
2010-12-06	IWM	ETF	75.64	76.35	75.5	76.14	36177500.0
2010-12-06	DIA	ETF	113.78	114.05	113.63	113.74	6181100.0
2010-12-06	GLD	ETF	138.14	139.46	137.73	139.11	15640800.0
2010-12-06	TLT	ETF	95.52	96.25	95.31	96.23	7001800.0
2010-12-06	AADR	ETF	29.02	29.27	29.02	29.27	2200.0
2010-12-06	AAXJ	ETF	63.2	63.57	63.2	63.48	423200.0
2010-12-06	ACWI	ETF	45.82	46.01	45.71	45.92	115800.0
2010-12-06	ACWX	ETF	43.3	43.47	43.21	43.38	62141.0
2010-12-06	ADRE	ETF	47.05	47.16	46.9106	47.08	41657.0
2010-12-06	AFK	ETF	34.13	34.17	33.9601	34.15	15173.0
2010-12-06	AGG	ETF	106.45	106.65	106.4	106.65	2606200.0
2010-12-06	AGQ	ETF	296.32	309.2	294.0	306.8	753400.0
2010-12-06	AGZ	ETF	110.28	110.57	110.26	110.52	162404.0
2010-12-06	AIA	ETF	45.84	45.862	45.7	45.85	25023.0
2010-12-06	AIQ	ETF	18.8	19.0	18.65	18.8	19219.0
2010-12-06	AIS	ETF	1.46	1.46	1.44	1.46	122401.0
2010-12-06	AIVI	ETF	42.71	43.05	42.7	42.9	179400.0
2010-12-06	AMJ	ETF	35.55	35.83	35.55	35.79	979426.0
2010-12-06	AMLP	ETF	79.25	79.45	79.25	79.3	112660.0
2010-12-06	AOA	ETF	33.66	33.74	33.66	33.74	3600.0
2010-12-06	AOK	ETF	28.72	28.76	28.68	28.76	11919.0
2010-12-06	AOM	ETF	29.78	29.83	29.745	29.81	4791.0
2010-12-06	AOR	ETF	31.16	31.24	31.14	31.2	18309.0
2010-12-06	ARB	ETF	30.39	30.7	30.18	30.62	98915.0
2010-12-06	BAB	ETF	25.2	25.4	25.2	25.4	157574.0
2010-12-06	BAL	ETF	66.28	67.0299	65.18	66.04	83785.0
2010-12-06	BALT	ETF	11.65	11.7907	11.47	11.52	154522.0
2010-12-06	BBH	ETF	32.92	32.92	32.76	32.8133	58800.0
2010-12-06	BICK	ETF	32.65	32.65	32.51	32.64	18448.0
2010-12-06	BIL	ETF	91.7	91.72	91.7	91.7	141300.0
2010-12-06	BIS	ETF	8992.0	8992.0	8992.0	8992.0	0.625
2010-12-06	BITS	ETF	28.56	28.92	27.84	28.8	4888.0
2010-12-06	BIV	ETF	84.64	84.8	84.54	84.77	90800.0
2010-12-06	BJK	ETF	31.72	32.08	31.72	31.95	13900.0
2010-12-06	BKF	ETF	49.58	49.659	49.33	49.58	71380.0
2010-12-06	BLV	ETF	80.02	80.78	80.02	80.78	45300.0
2010-12-06	BMVP	ETF	14.62	14.62	14.55	14.58	29671.0
2010-12-06	BND	ETF	81.37	81.52	81.33	81.52	1060300.0
2010-12-06	BNO	ETF	30.48	30.48	30.48	30.48	200.0
2010-12-06	BRF	ETF	60.23	61.0798	60.05	60.67	333844.0
2010-12-06	BSCE	ETF	20.7966	20.82	20.7934	20.7934	955.0
2010-12-06	BSV	ETF	81.22	81.33	81.22	81.28	935700.0
2010-12-06	BTF	ETF	78.3	78.44999999999999	78.0	78.24	1263.2
2010-12-06	BWX	ETF	29.0	29.145	28.965	29.0745	146164.0
2010-12-06	BWZ	ETF	36.82	37.02	36.7095	36.8501	22276.0
2010-12-06	BZQ	ETF	2582.4	2595.2	2561.6	2561.6	66.0
2010-12-06	CEF	ETF	20.18	20.51	20.07	20.44	1642000.0
2010-12-06	CEW	ETF	22.99	23.07	22.95	23.07	131755.0

> showing 50 of 811 rows — these rows as CSV

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