PREVIEW / etf_daily / 2011-08-09

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-09.parquet
  size:    37 KB
  rows:    876

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-08-09	SPY	ETF	114.07	117.64	110.27	117.48	717828700.0
2011-08-09	QQQ	ETF	51.31	53.08	49.93	53.03	193707082.0
2011-08-09	IWM	ETF	66.92	69.62	63.76	69.46	207867000.0
2011-08-09	DIA	ETF	109.66	112.38	105.94	112.37	32097800.0
2011-08-09	GLD	ETF	169.93	173.15	167.48	168.61	55765800.0
2011-08-09	TLT	ETF	105.01	109.37	103.0	105.87	39881400.0
2011-08-09	AADR	ETF	27.77	28.25	27.6	28.25	400.0
2011-08-09	AAXJ	ETF	54.32	55.65	52.92	55.65	607500.0
2011-08-09	ACTV	ETF	14.99	15.5	13.79	15.5	823808.0
2011-08-09	ACWI	ETF	41.43	42.6	40.15	42.49	2545300.0
2011-08-09	ACWX	ETF	38.23	39.28	37.26	39.27	1294442.0
2011-08-09	ADRE	ETF	38.61	40.07	38.0	40.02	441357.0
2011-08-09	AFK	ETF	27.52	27.8	26.77	27.76	46443.0
2011-08-09	AGEM	ETF	22.14	22.55	21.8635	22.54	13430.0
2011-08-09	AGG	ETF	108.6	109.97	108.45	109.24	1642600.0
2011-08-09	AGQ	ETF	383.02	392.46	363.0	369.36	1131950.0
2011-08-09	AGZ	ETF	111.6	112.2999	111.41	112.15	20473.0
2011-08-09	AIA	ETF	39.94	40.85	38.91	40.85	123323.0
2011-08-09	AIQ	ETF	11.45	11.6	5.85	6.2	488084.0
2011-08-09	AIS	ETF	1.95	2.04	1.8	2.04	1688602.0
2011-08-09	AIVI	ETF	40.05	41.1	38.93	41.09	103500.0
2011-08-09	AMJ	ETF	32.46	34.79	32.17	34.79	2819311.0
2011-08-09	AMLP	ETF	70.95	76.3	70.95	75.9	262620.0
2011-08-09	AOA	ETF	31.01	31.3	30.38	30.69	12500.0
2011-08-09	AOK	ETF	28.68	28.89	28.51	28.89	33048.0
2011-08-09	AOM	ETF	29.18	29.5	28.9	29.46	27181.0
2011-08-09	AOR	ETF	29.88	30.43	29.35	30.43	13482.0
2011-08-09	ARB	ETF	34.24	35.28	31.64	35.28	283280.0
2011-08-09	ARGT	ETF	24.88	24.94	24.52	24.52	2150.0
2011-08-09	ASEA	ETF	15.71	16.1	15.57	16.1	14200.0
2011-08-09	AWAY	ETF	32.0	34.79	31.63	34.58	251804.0
2011-08-09	BAB	ETF	25.98	27.18	25.78	27.18	1214792.0
2011-08-09	BAL	ETF	61.51	61.9867	58.11	59.69	111445.0
2011-08-09	BALT	ETF	4.19	4.4	4.015	4.4	418200.0
2011-08-09	BBH	ETF	30.53	31.08	29.59	31.04	100500.0
2011-08-09	BCM	ETF	45.42	45.64	44.89	45.21	4247.0
2011-08-09	BIB	ETF	6.0475	6.6363	5.84	6.6363	347576.0
2011-08-09	BICK	ETF	25.97	26.6	25.46	26.5948	21810.0
2011-08-09	BIL	ETF	91.72	91.72	91.7	91.72	658450.0
2011-08-09	BIS	ETF	8785.6	9030.4	8003.2	8003.2	28.7
2011-08-09	BITS	ETF	20.08	20.44	19.6	19.8	3050.0
2011-08-09	BIV	ETF	86.59	88.25	86.39	87.1	240000.0
2011-08-09	BJK	ETF	31.02	31.86	29.93	31.83	102200.0
2011-08-09	BKF	ETF	39.5	40.67	38.38	40.56	445718.0
2011-08-09	BKLN	ETF	23.01	23.41	23.01	23.41	94200.0
2011-08-09	BLNG	ETF	54.3453	54.3453	51.44	51.44	200.0
2011-08-09	BLV	ETF	86.06	88.86	85.96	87.37	124200.0
2011-08-09	BMVP	ETF	12.54	13.05	12.18	13.05	27752.0
2011-08-09	BND	ETF	83.05	83.98	82.72	83.35	2320800.0
2011-08-09	BNO	ETF	34.885	35.145	33.815	34.93	368000.0

> showing 50 of 876 rows — these rows as CSV

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