PREVIEW / etf_daily / 2010-12-09

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-09.parquet
  size:    35 KB
  rows:    814

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-09	SPY	ETF	123.97	124.02	123.15	123.76	123705100.0
2010-12-09	QQQ	ETF	54.41	54.44	53.95	54.135	51679728.0
2010-12-09	IWM	ETF	77.08	77.08	76.48	76.79	49384000.0
2010-12-09	DIA	ETF	114.35	114.39	113.51	113.92	5237500.0
2010-12-09	GLD	ETF	135.69	136.16	134.88	135.37	14157600.0
2010-12-09	TLT	ETF	93.6	94.27	92.73	93.72	17477100.0
2010-12-09	AADR	ETF	29.19	29.19	29.19	29.19	400.0
2010-12-09	AAXJ	ETF	63.04	63.23	62.86	63.01	1354700.0
2010-12-09	ACWI	ETF	46.24	46.24	45.82	46.08	269200.0
2010-12-09	ACWX	ETF	43.59	43.59	43.14	43.44	97897.0
2010-12-09	ADRE	ETF	46.64	46.64	45.981	46.19	40250.0
2010-12-09	AFK	ETF	34.25	34.369	34.12	34.2	29895.0
2010-12-09	AGG	ETF	105.48	105.63	105.27	105.5	805800.0
2010-12-09	AGQ	ETF	277.1	281.98	272.0	275.06	538900.0
2010-12-09	AGZ	ETF	109.97	110.04	109.69	109.69	14571.0
2010-12-09	AIA	ETF	46.0	46.0	45.73	45.86	40676.0
2010-12-09	AIQ	ETF	19.25	19.35	18.95	19.0	21324.0
2010-12-09	AIS	ETF	1.52	1.5701	1.49	1.55	452281.0
2010-12-09	AIVI	ETF	43.28	43.34	43.02	43.34	13900.0
2010-12-09	AMJ	ETF	35.65	35.72	35.58	35.67	576613.0
2010-12-09	AMLP	ETF	79.3	79.35	79.2	79.25	135560.0
2010-12-09	AOA	ETF	33.91	33.91	33.67	33.8	4600.0
2010-12-09	AOK	ETF	28.55	28.62	28.51	28.53	28624.0
2010-12-09	AOM	ETF	29.79	29.79	29.668	29.7199	14312.0
2010-12-09	AOR	ETF	31.31	31.31	31.1	31.18	18158.0
2010-12-09	ARB	ETF	34.12	38.02	33.92	37.22	2330055.0
2010-12-09	BAB	ETF	25.09	25.09	24.95	25.0	206453.0
2010-12-09	BAL	ETF	68.93	70.0	68.54	69.99	63925.0
2010-12-09	BALT	ETF	11.39	11.4	11.01	11.05	127839.0
2010-12-09	BBH	ETF	32.7767	32.8	32.69	32.75	29100.0
2010-12-09	BIB	ETF	6.9488	6.9488	6.9488	6.9488	800.0
2010-12-09	BICK	ETF	32.31	32.31	31.83	31.86	23518.0
2010-12-09	BIL	ETF	91.7	91.72	91.7	91.72	185250.0
2010-12-09	BITS	ETF	28.76	28.92	28.6	28.72	1050.0
2010-12-09	BIV	ETF	83.23	83.4	82.96	83.25	293200.0
2010-12-09	BJK	ETF	31.86	31.88	31.71	31.82	15900.0
2010-12-09	BKF	ETF	48.92	48.99	48.17	48.28	134753.0
2010-12-09	BLV	ETF	79.2	79.69	78.75	79.35	71600.0
2010-12-09	BMVP	ETF	14.75	14.75	14.61	14.62	71946.0
2010-12-09	BND	ETF	80.64	80.72	80.45	80.58	791900.0
2010-12-09	BNO	ETF	30.24	30.4	30.235	30.395	3800.0
2010-12-09	BOSS	ETF	44.575	44.575	44.095	44.095	200.0
2010-12-09	BRF	ETF	59.19	59.2	57.46	57.8	769821.0
2010-12-09	BSCE	ETF	20.67	20.68	20.61	20.66	24599.0
2010-12-09	BSV	ETF	80.77	80.79	80.69	80.71	481400.0
2010-12-09	BTF	ETF	78.05	78.05	77.5	78.0	1371.0
2010-12-09	BWX	ETF	28.555	28.6928	28.43	28.635	196658.0
2010-12-09	BWZ	ETF	36.2	36.42	36.15	36.185	8856.0
2010-12-09	BZQ	ETF	2694.4	2801.6	2688.0	2768.0	767.0
2010-12-09	CEF	ETF	19.82	19.93	19.66	19.75	1097900.0

> showing 50 of 814 rows — these rows as CSV

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