PREVIEW / etf_daily / 2010-12-10

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-10.parquet
  size:    35 KB
  rows:    820

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-10	SPY	ETF	124.14	124.6	123.73	124.48	117571700.0
2010-12-10	QQQ	ETF	54.29	54.55	54.09	54.495	44696150.0
2010-12-10	IWM	ETF	77.05	77.94	76.77	77.75	43303000.0
2010-12-10	DIA	ETF	114.1	114.34	113.77	114.29	8294000.0
2010-12-10	GLD	ETF	134.94	135.48	133.95	135.41	11937900.0
2010-12-10	TLT	ETF	93.29	93.86	93.14	93.15	7078500.0
2010-12-10	AADR	ETF	29.23	29.35	29.23	29.34	2100.0
2010-12-10	AAXJ	ETF	63.05	63.16	62.89	63.09	1074600.0
2010-12-10	ACWI	ETF	46.03	46.27	45.96	46.14	163200.0
2010-12-10	ACWX	ETF	43.4	43.62	43.22	43.59	79534.0
2010-12-10	ADRE	ETF	46.2	46.5092	46.111	46.48	42009.0
2010-12-10	AFK	ETF	34.28	34.45	34.0201	34.25	20423.0
2010-12-10	AGG	ETF	105.49	105.49	105.21	105.3	1217500.0
2010-12-10	AGQ	ETF	271.4	277.3	263.08	275.16	482950.0
2010-12-10	AGZ	ETF	109.5797	109.5996	109.375	109.41	20480.0
2010-12-10	AIA	ETF	45.82	46.1	45.82	46.04	30899.0
2010-12-10	AIQ	ETF	19.0	19.15	18.8	18.85	41794.0
2010-12-10	AIS	ETF	1.59	1.59	1.5	1.55	395149.0
2010-12-10	AIVI	ETF	43.33	43.44	43.13	43.42	27600.0
2010-12-10	AMJ	ETF	35.72	35.84	35.7	35.82	1354816.0
2010-12-10	AMLP	ETF	79.5	79.6	79.3	79.55	405240.0
2010-12-10	AOA	ETF	33.84	34.03	33.81	34.03	12600.0
2010-12-10	AOK	ETF	28.64	28.64	28.54	28.595	12187.0
2010-12-10	AOM	ETF	29.75	29.78	29.7295	29.78	3298.0
2010-12-10	AOR	ETF	31.18	31.27	31.18	31.27	1270.0
2010-12-10	ARB	ETF	37.27	38.57	36.6901	38.47	535448.0
2010-12-10	BAB	ETF	25.01	25.16	25.0	25.06	306632.0
2010-12-10	BAL	ETF	70.39	71.36	69.01	69.385	53778.0
2010-12-10	BALT	ETF	11.05	11.18	11.0	11.03	95756.0
2010-12-10	BBH	ETF	32.74	33.06	32.74	33.0	34800.0
2010-12-10	BIB	ETF	6.9912	7.14	6.9912	7.1162	6280.0
2010-12-10	BICK	ETF	31.95	32.18	31.82	32.16	56818.0
2010-12-10	BIL	ETF	91.7	91.72	91.7	91.72	164450.0
2010-12-10	BITS	ETF	28.72	29.56	28.72	28.9596	1075.0
2010-12-10	BIV	ETF	83.07	83.25	82.72	82.74	167900.0
2010-12-10	BJK	ETF	31.79	31.79	31.46	31.67	112400.0
2010-12-10	BKF	ETF	48.39	48.782	48.38	48.77	134268.0
2010-12-10	BLV	ETF	79.1	79.34	78.86	78.93	25700.0
2010-12-10	BMVP	ETF	14.6536	14.706	14.6234	14.6967	9641.0
2010-12-10	BND	ETF	80.52	80.55	80.32	80.32	934600.0
2010-12-10	BNO	ETF	30.405	30.405	30.0	30.205	7600.0
2010-12-10	BRF	ETF	57.98	58.21	57.5	58.21	289369.0
2010-12-10	BSCE	ETF	20.65	20.65	20.5	20.5	13945.0
2010-12-10	BSV	ETF	80.71	80.74	80.62	80.63	506000.0
2010-12-10	BTF	ETF	77.5	78.64999999999999	77.5	78.39999999999999	2048.0
2010-12-10	BWX	ETF	28.75	28.75	28.585	28.635	276014.0
2010-12-10	BWZ	ETF	36.35	36.37	36.1301	36.34	21946.0
2010-12-10	BZQ	ETF	2774.4	2792.0	2720.0	2723.2	527.5
2010-12-10	CEF	ETF	19.68	19.83	19.43	19.83	972900.0
2010-12-10	CEW	ETF	22.96	22.982	22.91	22.96	57017.0

> showing 50 of 820 rows — these rows as CSV

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