PREVIEW / etf_daily / 2011-08-24

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-24.parquet
  size:    36 KB
  rows:    866

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-24	SPY	ETF	116.19	118.24	115.92	118.08	246869700.0
2011-08-24	QQQ	ETF	52.18	53.42	51.71	52.69	80197612.0
2011-08-24	IWM	ETF	68.12	69.63	67.52	69.2	67698000.0
2011-08-24	DIA	ETF	111.25	113.07	110.91	112.95	9256900.0
2011-08-24	GLD	ETF	177.9	178.31	170.31	171.65	70700300.0
2011-08-24	TLT	ETF	109.29	109.41	106.15	106.28	14621600.0
2011-08-24	AADR	ETF	28.4	28.4	28.11	28.11	300.0
2011-08-24	AAXJ	ETF	53.57	54.24	53.35	54.19	221700.0
2011-08-24	ACTV	ETF	16.85	16.92	16.57	16.89	47546.0
2011-08-24	ACWI	ETF	41.91	42.44	41.72	42.32	1278000.0
2011-08-24	ACWX	ETF	38.54	39.01	38.32	38.74	62036.0
2011-08-24	ADRE	ETF	40.05	40.52	39.72	40.21	35101.0
2011-08-24	AFK	ETF	28.6	28.73	28.33	28.69	56839.0
2011-08-24	AGEM	ETF	22.42	22.6424	22.38	22.45	13099.0
2011-08-24	AGG	ETF	109.5	109.51	108.93	109.01	663300.0
2011-08-24	AGQ	ETF	446.42	452.0	400.02	417.0	892200.0
2011-08-24	AGZ	ETF	112.282	112.29	112.06	112.1499	9725.0
2011-08-24	AIA	ETF	39.9	40.3	39.71	40.3	73844.0
2011-08-24	AIQ	ETF	7.5	7.65	7.14	7.25	18411.0
2011-08-24	AIS	ETF	2.33	2.4	2.27	2.4	639070.0
2011-08-24	AIVI	ETF	41.62	42.05	41.34	41.83	119700.0
2011-08-24	AMJ	ETF	33.85	34.32	33.64	34.1	898734.0
2011-08-24	AMLP	ETF	75.5	76.25	74.25	75.95	80880.0
2011-08-24	AOA	ETF	31.47	31.93	31.46	31.89	14800.0
2011-08-24	AOK	ETF	28.8284	28.8284	28.7464	28.81	12155.0
2011-08-24	AOM	ETF	29.39	29.54	29.3797	29.46	14894.0
2011-08-24	AOR	ETF	30.15	30.38	30.075	30.38	40922.0
2011-08-24	ARB	ETF	33.64	34.46	33.25	34.2	109338.0
2011-08-24	ARGT	ETF	24.56	24.56	24.56	24.56	200.0
2011-08-24	ASEA	ETF	15.78	15.92	15.69	15.92	19000.0
2011-08-24	AWAY	ETF	35.5	37.29	34.63	36.84	109962.0
2011-08-24	BAB	ETF	27.62	27.64	27.27	27.2999	144343.0
2011-08-24	BAL	ETF	66.25	67.562	64.9155	65.59	61185.0
2011-08-24	BALT	ETF	4.44	4.6	4.36	4.48	198016.0
2011-08-24	BBH	ETF	31.93	32.0967	31.7333	32.0733	21900.0
2011-08-24	BCM	ETF	46.97	46.97	46.97	46.97	1200.0
2011-08-24	BIB	ETF	6.8425	6.9262	6.6409	6.9262	54960.0
2011-08-24	BICK	ETF	25.77	25.95	25.545	25.893	24429.0
2011-08-24	BIL	ETF	91.72	91.72	91.7	91.72	190750.0
2011-08-24	BIS	ETF	7625.6	7625.6	7425.6	7425.6	8.05
2011-08-24	BITS	ETF	21.88	22.84	21.0	22.0	1044.0
2011-08-24	BIV	ETF	87.62	87.64	87.03	87.09	92100.0
2011-08-24	BJK	ETF	31.18	31.64	31.15	31.56	18000.0
2011-08-24	BKF	ETF	39.74	40.17	39.3201	39.86	158300.0
2011-08-24	BKLN	ETF	23.3	23.3	22.77	23.02	174600.0
2011-08-24	BLNG	ETF	55.99	55.99	55.99	55.99	175.0
2011-08-24	BLV	ETF	87.73	87.73	85.64	85.7	33200.0
2011-08-24	BMVP	ETF	13.1235	13.2767	13.0167	13.2493	8511.0
2011-08-24	BND	ETF	83.5	83.5	83.06	83.07	1464900.0
2011-08-24	BNO	ETF	36.79	37.095	36.6	36.775	177200.0

> showing 50 of 866 rows — these rows as CSV

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