PREVIEW / etf_daily / 2011-04-07

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-07.parquet
  size:    36 KB
  rows:    837

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-04-07	SPY	ETF	133.42	133.98	132.66	133.32	170731500.0
2011-04-07	QQQ	ETF	57.23	57.6	56.81	57.22	60705865.0
2011-04-07	IWM	ETF	85.46	85.78	84.62	84.87	69434400.0
2011-04-07	DIA	ETF	124.04	124.25	123.11	123.91	6542200.0
2011-04-07	GLD	ETF	142.23	142.89	141.8	142.51	9486800.0
2011-04-07	TLT	ETF	90.53	90.76	90.13	90.36	9265100.0
2011-04-07	AADR	ETF	31.21	31.21	30.93	30.98	10600.0
2011-04-07	AAXJ	ETF	64.92	65.04	64.44	64.67	336300.0
2011-04-07	ACWI	ETF	49.14	49.23	48.8	48.97	190000.0
2011-04-07	ACWX	ETF	46.22	46.34	45.89	46.109	109671.0
2011-04-07	ADRE	ETF	49.46	49.776	49.296	49.47	75017.0
2011-04-07	AFK	ETF	34.58	34.67	34.16	34.294	25410.0
2011-04-07	AGG	ETF	104.69	104.92	104.66	104.76	681700.0
2011-04-07	AGQ	ETF	492.5	497.9	488.96	497.5	403300.0
2011-04-07	AGZ	ETF	109.22	109.22	109.0216	109.07	7184.0
2011-04-07	AIA	ETF	49.07	49.16	48.69	48.88	30184.0
2011-04-07	AIQ	ETF	22.5	22.6	21.8	21.85	12297.0
2011-04-07	AIS	ETF	1.66	1.71	1.66	1.69	304004.0
2011-04-07	AIVI	ETF	48.01	48.17	47.72	47.98	16800.0
2011-04-07	AMJ	ETF	38.11	38.33	38.1	38.25	382856.0
2011-04-07	AMLP	ETF	82.3	82.4	82.05	82.35	293460.0
2011-04-07	AOA	ETF	36.36	36.45	36.22	36.27	17800.0
2011-04-07	AOK	ETF	29.22	29.25	29.2	29.2036	22954.0
2011-04-07	AOM	ETF	30.635	30.7	30.5801	30.64	46302.0
2011-04-07	AOR	ETF	32.78	32.84	32.6596	32.72	60989.0
2011-04-07	ARB	ETF	39.57	39.61	38.7	38.78	95351.0
2011-04-07	ARGT	ETF	31.28	31.28	31.02	31.06	4350.0
2011-04-07	ASEA	ETF	16.34	16.34	16.26	16.27	7400.0
2011-04-07	BAB	ETF	25.26	25.26	25.14	25.16	72673.0
2011-04-07	BAL	ETF	110.0	111.579	106.7601	107.51	290149.0
2011-04-07	BALT	ETF	9.25	9.37	9.1	9.1	110381.0
2011-04-07	BBH	ETF	35.42	35.5467	35.2867	35.3333	51300.0
2011-04-07	BIB	ETF	9.0312	9.0437	8.8125	8.9135	853944.0
2011-04-07	BICK	ETF	34.4	34.5302	34.264	34.355	7668.0
2011-04-07	BIL	ETF	91.7	91.72	91.7	91.72	129450.0
2011-04-07	BITS	ETF	25.44	25.44	24.04	25.2	2459.0
2011-04-07	BIV	ETF	81.51	81.76	81.45	81.63	70700.0
2011-04-07	BJK	ETF	33.35	33.54	33.15	33.27	11200.0
2011-04-07	BKF	ETF	51.71	52.0	51.51	51.89	146169.0
2011-04-07	BKLN	ETF	25.28	25.3	25.24	25.28	128800.0
2011-04-07	BLV	ETF	77.55	77.67	77.2	77.25	19200.0
2011-04-07	BMVP	ETF	15.8015	15.8415	15.7344	15.76	12287.0
2011-04-07	BND	ETF	79.73	79.78	79.6	79.67	679700.0
2011-04-07	BNO	ETF	40.365	40.685	40.275	40.63	44800.0
2011-04-07	BRF	ETF	58.47	59.25	58.07	58.07	467712.0
2011-04-07	BSCE	ETF	20.91	20.91	20.857	20.9	13044.0
2011-04-07	BSV	ETF	80.01	80.08	79.97	80.03	264800.0
2011-04-07	BTF	ETF	83.45	83.55	82.79999999999998	83.0	3970.6000000000004
2011-04-07	BWX	ETF	29.98	29.98	29.795	29.895	619624.0
2011-04-07	BWZ	ETF	38.42	38.55	38.2605	38.42	182664.0

> showing 50 of 837 rows — these rows as CSV

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