PREVIEW / etf_daily / 2011-08-22

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-22.parquet
  size:    36 KB
  rows:    871

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-22	SPY	ETF	115.17	115.23	112.41	112.73	275090600.0
2011-08-22	QQQ	ETF	51.21	51.24	50.06	50.21	77107681.0
2011-08-22	IWM	ETF	67.12	67.19	64.57	65.05	72211900.0
2011-08-22	DIA	ETF	110.18	110.3	108.01	108.3	11314800.0
2011-08-22	GLD	ETF	181.95	184.82	181.6	184.59	27482600.0
2011-08-22	TLT	ETF	110.46	111.26	110.39	110.92	13157700.0
2011-08-22	AADR	ETF	28.26	28.7	27.37	27.37	1200.0
2011-08-22	AAXJ	ETF	53.34	53.43	52.36	52.6	251600.0
2011-08-22	ACTV	ETF	16.6	16.6	16.21	16.48	119072.0
2011-08-22	ACWI	ETF	41.67	41.7	40.75	40.78	986000.0
2011-08-22	ACWX	ETF	38.58	38.58	37.66	37.66	172978.0
2011-08-22	ADRE	ETF	40.18	40.44	39.42	39.48	61423.0
2011-08-22	AFK	ETF	28.69	28.739	28.18	28.18	70719.0
2011-08-22	AGEM	ETF	22.29	22.29	22.0075	22.0256	1307.0
2011-08-22	AGG	ETF	109.82	109.98	109.72	109.89	761800.0
2011-08-22	AGQ	ETF	492.76	508.3	488.0	504.64	887650.0
2011-08-22	AGZ	ETF	112.32	112.6	112.25	112.52	41064.0
2011-08-22	AIA	ETF	39.83	39.83	38.9656	39.24	59362.0
2011-08-22	AIQ	ETF	7.15	7.25	6.75	6.9	52804.0
2011-08-22	AIS	ETF	2.23	2.28	2.17	2.21	604830.0
2011-08-22	AIVI	ETF	41.39	41.39	40.35	40.39	438400.0
2011-08-22	AMJ	ETF	34.89	34.89	33.2428	33.29	1996246.0
2011-08-22	AMLP	ETF	75.25	75.9	72.8	72.9	200840.0
2011-08-22	AOA	ETF	31.28	31.28	30.67	30.73	3600.0
2011-08-22	AOK	ETF	28.88	28.88	28.68	28.68	21439.0
2011-08-22	AOM	ETF	29.3	29.339	29.16	29.17	7136.0
2011-08-22	AOR	ETF	30.12	30.12	29.6801	29.6972	12231.0
2011-08-22	ARB	ETF	32.98	32.98	31.37	31.75	108498.0
2011-08-22	ARGT	ETF	24.88	24.88	24.54	24.58	25250.0
2011-08-22	ASEA	ETF	15.92	15.92	15.7	15.72	11800.0
2011-08-22	AWAY	ETF	35.49	35.99	33.5	34.02	88233.0
2011-08-22	BAB	ETF	27.72	27.9	27.67	27.9	139253.0
2011-08-22	BAL	ETF	66.07	66.89	65.5951	65.5951	63430.0
2011-08-22	BALT	ETF	4.21	4.21	4.09	4.12	142714.0
2011-08-22	BBH	ETF	31.5333	31.68	31.23	31.26	10500.0
2011-08-22	BCM	ETF	47.47	47.47	47.47	47.47	100.0
2011-08-22	BIB	ETF	6.5987	6.64	6.305	6.3288	165976.0
2011-08-22	BICK	ETF	25.34	25.34	24.9161	24.9161	46823.0
2011-08-22	BIL	ETF	91.7	91.72	91.68	91.68	247900.0
2011-08-22	BIS	ETF	7748.8	8100.48	7732.8	8094.4	20.3
2011-08-22	BITS	ETF	21.08	22.0	21.0	21.28	3177.0
2011-08-22	BIV	ETF	88.1	88.26	88.0	88.18	130200.0
2011-08-22	BJK	ETF	31.31	31.31	30.39	30.39	60300.0
2011-08-22	BKF	ETF	39.82	39.82	38.8275	38.95	189076.0
2011-08-22	BKLN	ETF	23.21	23.27	23.1	23.19	74700.0
2011-08-22	BLNG	ETF	59.17	59.81	59.17	59.81	2180.0
2011-08-22	BLV	ETF	88.77	89.04	88.61	88.77	37500.0
2011-08-22	BMVP	ETF	12.83	12.83	12.59	12.59	6754.0
2011-08-22	BND	ETF	83.83	83.9	83.7	83.8	1035400.0
2011-08-22	BNO	ETF	35.825	36.275	35.7	36.155	283600.0

> showing 50 of 871 rows — these rows as CSV

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