PREVIEW / etf_daily / 2011-10-26

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-26.parquet
  size:    37 KB
  rows:    884

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-10-26	SPY	ETF	124.35	124.77	122.21	124.3	289053800.0
2011-10-26	QQQ	ETF	57.65	57.78	56.2126	57.27	98193781.0
2011-10-26	IWM	ETF	72.6	73.04	70.54	72.59	76643400.0
2011-10-26	DIA	ETF	118.38	118.66	116.68	118.41	9938700.0
2011-10-26	GLD	ETF	167.03	168.05	166.42	167.4	17116300.0
2011-10-26	TLT	ETF	115.39	116.21	114.07	114.17	12747000.0
2011-10-26	AADR	ETF	28.12	28.2	27.98	28.2	700.0
2011-10-26	AAXJ	ETF	53.06	53.21	52.19	52.9	348200.0
2011-10-26	ACTV	ETF	14.11	14.33	13.54	13.93	93291.0
2011-10-26	ACWI	ETF	43.7	43.7	42.72	43.55	409300.0
2011-10-26	ACWV	ETF	51.22	51.29	51.06	51.06	700.0
2011-10-26	ACWX	ETF	39.01	39.05	38.19	38.913	68215.0
2011-10-26	ADRE	ETF	39.84	39.96	39.14	39.93	55314.0
2011-10-26	AFK	ETF	28.16	28.232	27.72	28.232	8776.0
2011-10-26	AGEM	ETF	22.17	22.23	22.07	22.23	1340.0
2011-10-26	AGG	ETF	109.59	109.77	109.39	109.5	664200.0
2011-10-26	AGQ	ETF	260.44	262.32	251.6	255.68	790175.0
2011-10-26	AGZ	ETF	112.31	112.35	112.16	112.21	10985.0
2011-10-26	AIA	ETF	40.7208	40.8708	40.2	40.81	30459.0
2011-10-26	AIQ	ETF	5.65	5.8	5.65	5.75	27068.0
2011-10-26	AIS	ETF	2.21	2.26	2.2	2.24	431151.0
2011-10-26	AIVI	ETF	42.6	42.6	41.6	42.44	38300.0
2011-10-26	AMJ	ETF	36.93	37.26	36.51	37.21	567453.0
2011-10-26	AMLP	ETF	80.25	80.4	79.7	80.3	178120.0
2011-10-26	AOA	ETF	33.01	33.1	32.57	33.1	5100.0
2011-10-26	AOK	ETF	29.3	29.3	29.15	29.24	20131.0
2011-10-26	AOM	ETF	29.8656	29.97	29.7704	29.97	20209.0
2011-10-26	AOR	ETF	31.13	31.16	30.9544	31.16	23106.0
2011-10-26	ARB	ETF	40.3	40.62	38.71	40.22	126548.0
2011-10-26	ARGT	ETF	21.94	21.94	21.94	21.94	750.0
2011-10-26	ASEA	ETF	14.85	15.01	14.79	14.87	2300.0
2011-10-26	AWAY	ETF	36.77	36.877	36.29	36.38	87461.0
2011-10-26	BAB	ETF	28.03	28.099	27.86	27.9199	120173.0
2011-10-26	BAL	ETF	62.11	62.23	61.461	61.85	32907.0
2011-10-26	BALT	ETF	5.6	5.9992	5.44	5.71	156674.0
2011-10-26	BBH	ETF	35.6233	35.7767	35.0633	35.7767	34200.0
2011-10-26	BCM	ETF	44.37	44.37	44.274	44.274	763.0
2011-10-26	BIB	ETF	7.5888	7.7225	7.4668	7.712	23800.0
2011-10-26	BICK	ETF	25.42	25.599	25.0555	25.599	19184.0
2011-10-26	BIL	ETF	91.68	91.7	91.68	91.7	239450.0
2011-10-26	BIS	ETF	6368.0	6454.4	6207.84	6207.84	3.75
2011-10-26	BITS	ETF	22.16	23.1684	21.84	22.6	1312.0
2011-10-26	BIV	ETF	87.19	87.43	87.1	87.21	225900.0
2011-10-26	BJK	ETF	31.12	31.33	30.67	31.33	16600.0
2011-10-26	BKF	ETF	38.79	39.06	38.12	38.89	103995.0
2011-10-26	BKLN	ETF	23.8	23.89	23.03	23.88	133300.0
2011-10-26	BLNG	ETF	52.67	52.72	52.66	52.66	2114.0
2011-10-26	BLV	ETF	90.77	91.08	90.06	90.21	39700.0
2011-10-26	BMVP	ETF	13.61	13.72	13.48	13.69	5610.0
2011-10-26	BND	ETF	83.46	83.64	83.36	83.38	887900.0

> showing 50 of 884 rows — these rows as CSV

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