PREVIEW / etf_daily / 2011-01-12

all etf daily files

  file:    by_date/etf_daily/2011/2011-01-12.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
2011-01-12	SPY	ETF	128.21	128.72	127.46	128.58	107929200.0
2011-01-12	QQQ	ETF	56.42	56.56	56.2	56.555	51978975.0
2011-01-12	IWM	ETF	79.94	80.13	79.51	79.97	38442600.0
2011-01-12	DIA	ETF	117.15	117.65	117.01	117.4	5255800.0
2011-01-12	GLD	ETF	134.79	135.58	134.35	135.46	10785100.0
2011-01-12	TLT	ETF	91.74	92.17	91.45	91.61	9522900.0
2011-01-12	AAXJ	ETF	64.16	64.51	64.06	64.41	231900.0
2011-01-12	ACWI	ETF	47.14	47.47	47.07	47.44	329700.0
2011-01-12	ACWX	ETF	44.1	44.51	44.09	44.51	121233.0
2011-01-12	ADRE	ETF	48.39	48.754	48.34	48.74	51516.0
2011-01-12	AFK	ETF	35.84	36.29	35.7599	36.14	95180.0
2011-01-12	AGG	ETF	105.49	105.6	105.31	105.57	562400.0
2011-01-12	AGQ	ETF	290.82	291.82	285.6	291.48	342750.0
2011-01-12	AGZ	ETF	109.41	109.729	109.41	109.66	21894.0
2011-01-12	AIA	ETF	48.24	48.46	48.1219	48.37	26695.0
2011-01-12	AIQ	ETF	21.35	21.45	20.95	21.0	24643.0
2011-01-12	AIS	ETF	1.77	1.77	1.72	1.73	245792.0
2011-01-12	AIVI	ETF	43.44	43.94	43.31	43.86	405900.0
2011-01-12	AMJ	ETF	36.99	37.07	36.81	37.06	410709.0
2011-01-12	AMLP	ETF	81.2	81.25	80.85	81.1	115880.0
2011-01-12	AOA	ETF	34.81	34.92	34.73	34.91	31000.0
2011-01-12	AOK	ETF	28.89	28.93	28.85	28.88	14188.0
2011-01-12	AOM	ETF	30.08	30.13	30.02	30.1099	53478.0
2011-01-12	AOR	ETF	31.75	31.83	31.7296	31.79	44901.0
2011-01-12	ARB	ETF	42.29	42.37	41.95	42.14	165344.0
2011-01-12	BAB	ETF	25.03	25.17	24.99	25.1	259311.0
2011-01-12	BAL	ETF	76.85	77.87	75.1501	76.45	57815.0
2011-01-12	BALT	ETF	10.82	10.82	10.58	10.65	138436.0
2011-01-12	BBH	ETF	34.0667	34.3367	34.04	34.3367	25200.0
2011-01-12	BIB	ETF	7.825	7.8925	7.825	7.8925	11200.0
2011-01-12	BICK	ETF	33.07	33.446	33.07	33.42	18553.0
2011-01-12	BIL	ETF	91.7	91.72	91.7	91.7	69400.0
2011-01-12	BITS	ETF	28.52	28.84	28.52	28.68	3905.0
2011-01-12	BIV	ETF	82.48	82.75	82.33	82.62	131900.0
2011-01-12	BJK	ETF	33.24	33.24	32.98	33.17	25500.0
2011-01-12	BKF	ETF	49.98	50.39	49.74	50.33	149767.0
2011-01-12	BLV	ETF	78.19	78.54	78.0	78.18	16800.0
2011-01-12	BMVP	ETF	14.82	14.87	14.81	14.82	40880.0
2011-01-12	BND	ETF	80.1	80.25	80.0	80.18	517500.0
2011-01-12	BNO	ETF	32.585	32.665	32.45	32.45	9200.0
2011-01-12	BRF	ETF	58.03	58.79	57.96	58.79	792558.0
2011-01-12	BSCE	ETF	20.85	20.85	20.76	20.78	6339.0
2011-01-12	BSV	ETF	80.48	80.55	80.35	80.47	486600.0
2011-01-12	BTF	ETF	78.55	79.0	78.3685	78.89999999999999	4984.0
2011-01-12	BWX	ETF	28.555	28.745	28.529	28.685	289712.0
2011-01-12	BWZ	ETF	36.55	36.7	36.352	36.581	10780.0
2011-01-12	BZQ	ETF	2393.6	2393.6	2308.8	2323.2	436.0
2011-01-12	CEF	ETF	19.73	19.95	19.61	19.94	992000.0
2011-01-12	CEW	ETF	22.4	22.48	22.36	22.46	98994.0
2011-01-12	CGO	ETF	14.69	14.8	14.69	14.78	18644.0

> showing 50 of 820 rows — these rows as CSV

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