PREVIEW / etf_daily / 2010-12-13

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-13.parquet
  size:    35 KB
  rows:    819

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-13	SPY	ETF	125.05	125.2	124.52	124.56	133812700.0
2010-12-13	QQQ	ETF	54.71	54.74	54.27	54.3	53110154.0
2010-12-13	IWM	ETF	78.06	78.19	77.32	77.35	43025600.0
2010-12-13	DIA	ETF	114.67	115.03	114.43	114.49	4756900.0
2010-12-13	GLD	ETF	136.26	136.64	135.86	136.05	13352400.0
2010-12-13	TLT	ETF	93.05	94.03	92.56	93.5	12399900.0
2010-12-13	AADR	ETF	29.44	29.64	29.44	29.53	5900.0
2010-12-13	AAXJ	ETF	63.67	63.85	63.45	63.46	248600.0
2010-12-13	ACWI	ETF	46.57	46.74	46.39	46.47	334400.0
2010-12-13	ACWX	ETF	43.95	44.16	43.8	43.96	74437.0
2010-12-13	ADRE	ETF	46.7	47.2	46.69	46.92	97580.0
2010-12-13	AFK	ETF	34.56	34.66	34.29	34.5	45219.0
2010-12-13	AGG	ETF	105.07	105.48	104.97	105.37	1813000.0
2010-12-13	AGQ	ETF	291.68	295.5	287.74	292.62	533450.0
2010-12-13	AGZ	ETF	109.5	109.68	109.3106	109.61	30473.0
2010-12-13	AIA	ETF	46.18	46.52	46.18	46.33	16906.0
2010-12-13	AIQ	ETF	18.95	19.0	18.5	18.55	73286.0
2010-12-13	AIS	ETF	1.55	1.56	1.5	1.5	220514.0
2010-12-13	AIVI	ETF	43.61	44.12	43.61	43.84	15800.0
2010-12-13	AMJ	ETF	35.98	36.04	35.9	35.99	794415.0
2010-12-13	AMLP	ETF	79.95	80.0	79.7	79.95	207280.0
2010-12-13	AOA	ETF	34.16	34.25	34.1	34.11	12700.0
2010-12-13	AOK	ETF	28.63	28.6999	28.5901	28.66	11862.0
2010-12-13	AOM	ETF	29.78	29.92	29.78	29.9199	23564.0
2010-12-13	AOR	ETF	31.38	31.46	31.3656	31.3656	7519.0
2010-12-13	ARB	ETF	38.4	38.66	37.93	38.16	467136.0
2010-12-13	BAB	ETF	25.06	25.2	25.0	25.12	251447.0
2010-12-13	BAL	ETF	71.27	72.54	71.26	72.419	59085.0
2010-12-13	BALT	ETF	11.1	11.3028	10.94	11.11	171946.0
2010-12-13	BBH	ETF	33.0567	33.0567	32.86	32.88	88200.0
2010-12-13	BIB	ETF	7.0975	7.0975	7.05	7.065	2400.0
2010-12-13	BICK	ETF	32.03	32.4705	32.03	32.36	30506.0
2010-12-13	BIL	ETF	91.7	91.72	91.7	91.72	130800.0
2010-12-13	BITS	ETF	29.12	29.12	28.6	28.96	584.0
2010-12-13	BIV	ETF	82.63	83.14	82.49	82.89	239200.0
2010-12-13	BJK	ETF	31.65	31.86	31.6	31.6	7300.0
2010-12-13	BKF	ETF	49.2	49.442	48.948	49.16	92593.0
2010-12-13	BLV	ETF	78.68	79.38	78.48	79.08	33500.0
2010-12-13	BMVP	ETF	14.75	14.78	14.72	14.72	29864.0
2010-12-13	BND	ETF	80.24	80.59	80.18	80.53	1026300.0
2010-12-13	BNO	ETF	30.705	30.74	30.32	30.45	22600.0
2010-12-13	BRF	ETF	58.34	59.07	58.34	58.86	355772.0
2010-12-13	BSCE	ETF	20.58	20.7	20.58	20.69	8610.0
2010-12-13	BSV	ETF	80.61	80.75	80.5	80.75	442200.0
2010-12-13	BTF	ETF	78.386	78.386	77.69999999999999	78.326	574.0
2010-12-13	BWX	ETF	28.805	28.966	28.715	28.96	290808.0
2010-12-13	BWZ	ETF	36.32	36.782	36.32	36.706	64254.0
2010-12-13	BZQ	ETF	2680.0	2694.4	2611.2	2638.4	848.0
2010-12-13	CEF	ETF	20.12	20.31	20.0	20.18	912300.0
2010-12-13	CEW	ETF	23.04	23.06	22.99	22.99	428348.0

> showing 50 of 819 rows — these rows as CSV

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