PREVIEW / etf_daily / 2011-08-15

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-15.parquet
  size:    37 KB
  rows:    869

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-15	SPY	ETF	119.19	120.74	119.0	120.62	258810600.0
2011-08-15	QQQ	ETF	53.77	54.36	53.53	54.36	73554257.0
2011-08-15	IWM	ETF	70.58	71.83	70.38	71.76	57616800.0
2011-08-15	DIA	ETF	113.78	114.88	113.44	114.81	13586200.0
2011-08-15	GLD	ETF	169.32	171.91	168.95	171.8	17798000.0
2011-08-15	TLT	ETF	104.94	105.48	104.47	104.5	10051700.0
2011-08-15	AAXJ	ETF	56.05	56.72	56.05	56.62	201500.0
2011-08-15	ACTV	ETF	15.72	16.3099	15.72	16.14	191189.0
2011-08-15	ACWI	ETF	43.15	43.72	43.14	43.72	340700.0
2011-08-15	ACWX	ETF	39.86	40.2	39.84	40.1684	354982.0
2011-08-15	ADRE	ETF	41.1	41.65	41.1	41.6	72273.0
2011-08-15	AFK	ETF	29.2	29.76	29.2	29.76	33953.0
2011-08-15	AGEM	ETF	23.14	23.31	23.126	23.2495	8755.0
2011-08-15	AGG	ETF	109.53	109.57	109.25	109.41	1034200.0
2011-08-15	AGQ	ETF	408.94	419.06	406.52	416.5	427500.0
2011-08-15	AGZ	ETF	112.16	112.39	112.05	112.05	10280.0
2011-08-15	AIA	ETF	41.18	41.45	41.04	41.45	51077.0
2011-08-15	AIQ	ETF	9.2	9.2	7.7	7.85	96940.0
2011-08-15	AIS	ETF	2.06	2.23	2.06	2.2	965128.0
2011-08-15	AIVI	ETF	42.01	42.65	42.01	42.65	500500.0
2011-08-15	AMJ	ETF	35.96	36.39	35.8997	36.33	1539826.0
2011-08-15	AMLP	ETF	77.85	79.0	77.75	78.3	148920.0
2011-08-15	AOA	ETF	32.45	32.77	32.45	32.77	29500.0
2011-08-15	AOK	ETF	29.0	29.1	29.0	29.06	111708.0
2011-08-15	AOM	ETF	29.7836	29.9	29.782	29.9	152008.0
2011-08-15	AOR	ETF	30.81	30.94	30.76	30.94	72353.0
2011-08-15	ARB	ETF	35.25	35.7	34.6	35.54	85700.0
2011-08-15	ARGT	ETF	25.98	25.98	25.98	25.98	450.0
2011-08-15	ASEA	ETF	16.31	16.44	16.31	16.44	8400.0
2011-08-15	AWAY	ETF	37.57	37.92	36.63	37.015	86926.0
2011-08-15	BAB	ETF	26.98	27.18	26.8	27.09	186087.0
2011-08-15	BAL	ETF	62.97	65.56	62.97	65.03	85920.0
2011-08-15	BALT	ETF	4.58	4.6392	4.3	4.54	143273.0
2011-08-15	BBH	ETF	31.0667	31.5033	30.99	31.4033	149400.0
2011-08-15	BIB	ETF	6.955	7.2138	6.9062	7.2138	99728.0
2011-08-15	BICK	ETF	27.12	27.54	27.12	27.5134	29368.0
2011-08-15	BIL	ETF	91.7	91.72	91.7	91.72	9127350.0
2011-08-15	BIS	ETF	7376.0	7409.92	7216.0	7216.0	4.81
2011-08-15	BITS	ETF	19.64	21.6	19.64	21.4	4968.0
2011-08-15	BIV	ETF	87.65	87.82	87.48	87.54	188400.0
2011-08-15	BJK	ETF	33.34	33.7	33.06	33.7	28100.0
2011-08-15	BKF	ETF	41.61	42.03	41.39	41.93	153855.0
2011-08-15	BKLN	ETF	23.18	23.45	23.18	23.42	250800.0
2011-08-15	BLV	ETF	86.23	86.29	85.59	85.76	37000.0
2011-08-15	BMVP	ETF	13.4667	13.6067	13.451	13.6067	13076.0
2011-08-15	BND	ETF	83.48	83.58	83.31	83.33	1549600.0
2011-08-15	BNO	ETF	36.38	36.755	36.335	36.71	71000.0
2011-08-15	BRF	ETF	48.07	49.02	48.07	48.8	181116.0
2011-08-15	BSCE	ETF	21.07	21.15	21.07	21.15	21425.0
2011-08-15	BSV	ETF	81.62	81.72	81.54	81.57	688100.0

> showing 50 of 869 rows — these rows as CSV

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