PREVIEW / etf_daily / 2010-12-31

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-31.parquet
  size:    34 KB
  rows:    813

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-31	SPY	ETF	125.53	125.87	125.33	125.75	91218900.0
2010-12-31	QQQ	ETF	54.6	54.62	54.21	54.46	38565923.0
2010-12-31	IWM	ETF	78.67	78.88	78.17	78.24	33323500.0
2010-12-31	DIA	ETF	115.32	115.73	115.04	115.63	3725200.0
2010-12-31	GLD	ETF	137.78	138.77	137.72	138.72	9219800.0
2010-12-31	TLT	ETF	93.51	94.7	93.44	94.12	8516000.0
2010-12-31	AADR	ETF	29.73	29.91	29.63	29.84	17300.0
2010-12-31	AAXJ	ETF	63.78	63.82	63.58	63.7	676500.0
2010-12-31	ACWI	ETF	46.73	46.84	46.57	46.81	307000.0
2010-12-31	ACWX	ETF	43.91	44.24	43.8	44.04	144649.0
2010-12-31	ADRE	ETF	47.86	48.22	47.81	48.15	72211.0
2010-12-31	AFK	ETF	35.15	35.47	34.938	35.18	23181.0
2010-12-31	AGG	ETF	105.38	105.75	105.37	105.75	551600.0
2010-12-31	AGQ	ETF	312.26	318.68	311.62	317.18	294450.0
2010-12-31	AGZ	ETF	109.35	109.636	109.35	109.52	10567.0
2010-12-31	AIA	ETF	46.74	47.07	46.74	46.9462	13657.0
2010-12-31	AIQ	ETF	21.5	21.75	21.2	21.2	35969.0
2010-12-31	AIS	ETF	1.7	1.72	1.7	1.7	174710.0
2010-12-31	AIVI	ETF	43.71	44.18	43.71	44.16	64700.0
2010-12-31	AMJ	ETF	36.25	36.435	36.25	36.35	740236.0
2010-12-31	AMLP	ETF	80.3	80.5	80.2	80.35	122400.0
2010-12-31	AOA	ETF	34.34	34.48	34.31	34.37	16000.0
2010-12-31	AOK	ETF	28.74	28.81	28.74	28.792	3355.0
2010-12-31	AOM	ETF	29.88	29.97	29.8717	29.915	21271.0
2010-12-31	AOR	ETF	31.46	31.58	31.45	31.54	8107.0
2010-12-31	ARB	ETF	41.52	42.36	41.38	41.52	216369.0
2010-12-31	BAB	ETF	24.94	25.09	24.896	25.08	230771.0
2010-12-31	BAL	ETF	74.24	74.865	72.6501	73.05	48789.0
2010-12-31	BALT	ETF	10.24	10.39	10.14	10.21	430215.0
2010-12-31	BBH	ETF	33.3	33.3467	33.2	33.2133	38400.0
2010-12-31	BIB	ETF	7.5	7.52	7.1288	7.52	27000.0
2010-12-31	BICK	ETF	32.86	32.91	32.7	32.86	35273.0
2010-12-31	BIL	ETF	91.7	91.72	91.7	91.7	119650.0
2010-12-31	BIS	ETF	8128.0	8128.0	8128.0	8128.0	2.03
2010-12-31	BITS	ETF	28.88	28.96	28.48	28.96	1178.0
2010-12-31	BIV	ETF	82.26	82.59	82.24	82.49	103500.0
2010-12-31	BJK	ETF	31.08	31.59	31.08	31.49	12200.0
2010-12-31	BKF	ETF	48.87	49.19	48.78	49.131	64903.0
2010-12-31	BLV	ETF	78.91	79.6	78.82	79.09	18900.0
2010-12-31	BMVP	ETF	14.67	14.71	14.65	14.67	7913.0
2010-12-31	BND	ETF	80.0	80.31	80.0	80.27	534500.0
2010-12-31	BNO	ETF	30.755	31.555	30.755	31.225	4200.0
2010-12-31	BRF	ETF	57.16	57.77	57.03	57.68	262893.0
2010-12-31	BSV	ETF	80.32	80.48	80.28	80.46	362500.0
2010-12-31	BTF	ETF	77.5	78.0	77.3	77.6	4892.8
2010-12-31	BWX	ETF	29.075	29.31	28.89	29.23	189332.0
2010-12-31	BWZ	ETF	36.84	37.2035	36.84	37.0	5676.0
2010-12-31	BZQ	ETF	2446.4	2454.4	2390.4	2409.6	201.0
2010-12-31	CEF	ETF	20.79	20.9	20.73	20.73	1083600.0
2010-12-31	CEW	ETF	22.54	22.6	22.51	22.56	115907.0

> showing 50 of 813 rows — these rows as CSV

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