PREVIEW / etf_daily / 2011-11-18

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-18.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-11-18	SPY	ETF	122.5	122.75	121.47	121.98	215580400.0
2011-11-18	QQQ	ETF	55.85	55.9	55.3	55.4	60416982.0
2011-11-18	IWM	ETF	72.25	72.47	71.45	71.98	53462900.0
2011-11-18	DIA	ETF	117.96	118.3	117.29	117.73	8307400.0
2011-11-18	GLD	ETF	167.23	168.69	166.6	167.62	14172900.0
2011-11-18	TLT	ETF	119.18	119.55	118.32	119.34	6792600.0
2011-11-18	AADR	ETF	27.72	27.76	27.61	27.76	1500.0
2011-11-18	AAXJ	ETF	51.07	51.21	50.58	50.84	222700.0
2011-11-18	ACTV	ETF	15.16	15.44	14.9603	15.14	134938.0
2011-11-18	ACWI	ETF	41.98	41.98	41.53	41.71	1050900.0
2011-11-18	ACWV	ETF	49.65	49.65	49.65	49.65	200.0
2011-11-18	ACWX	ETF	37.23	37.23	36.79	36.93	1068229.0
2011-11-18	ADRE	ETF	39.69	39.71	39.06	39.24	29234.0
2011-11-18	AFK	ETF	27.2	27.34	27.1379	27.176	8826.0
2011-11-18	AGEM	ETF	21.47	21.54	21.47	21.54	510.0
2011-11-18	AGG	ETF	109.73	109.73	109.44	109.62	805700.0
2011-11-18	AGQ	ETF	230.36	239.96	227.36	235.2	667100.0
2011-11-18	AGZ	ETF	112.2039	112.6	112.2001	112.6	8932.0
2011-11-18	AIA	ETF	40.16	40.16	39.76	39.91	39563.0
2011-11-18	AIQ	ETF	5.85	6.3	5.85	6.05	53431.0
2011-11-18	AIS	ETF	2.85	2.85	2.57	2.61	3845277.0
2011-11-18	AIVI	ETF	40.02	40.02	39.54	39.65	100300.0
2011-11-18	AMJ	ETF	37.35	37.37	37.0847	37.37	347145.0
2011-11-18	AMLP	ETF	80.0	80.0	79.15	79.65	163300.0
2011-11-18	AOA	ETF	32.59	32.59	32.36	32.39	8200.0
2011-11-18	AOK	ETF	29.1	29.14	29.07	29.09	31098.0
2011-11-18	AOM	ETF	29.74	29.74	29.6103	29.67	11962.0
2011-11-18	AOR	ETF	30.83	30.83	30.7	30.73	8966.0
2011-11-18	ARB	ETF	39.84	40.24	39.5	39.63	96663.0
2011-11-18	ASEA	ETF	14.57	14.67	14.57	14.57	1300.0
2011-11-18	AWAY	ETF	31.69	31.88	30.52	31.11	216761.0
2011-11-18	BAB	ETF	28.57	28.69	28.41	28.66	155496.0
2011-11-18	BAL	ETF	60.24	60.2932	57.6	57.92	66398.0
2011-11-18	BALT	ETF	5.18	5.22	5.05	5.08	49814.0
2011-11-18	BBH	ETF	34.06	34.15	33.8833	33.98	20700.0
2011-11-18	BCM	ETF	44.06	44.128	44.06	44.128	325.0
2011-11-18	BIB	ETF	6.92	6.92	6.6937	6.825	18000.0
2011-11-18	BICK	ETF	24.19	24.19	24.13	24.13	4327.0
2011-11-18	BIL	ETF	91.7	91.7	91.68	91.7	274700.0
2011-11-18	BITS	ETF	21.88	21.88	21.24	21.6	1125.0
2011-11-18	BIV	ETF	87.61	87.75	87.44	87.56	266800.0
2011-11-18	BJK	ETF	30.58	30.58	30.3	30.33	17800.0
2011-11-18	BKF	ETF	38.02	38.1	37.6	37.83	76091.0
2011-11-18	BKLN	ETF	24.03	24.03	23.95	23.98	56600.0
2011-11-18	BLV	ETF	91.53	91.77	91.15	91.52	33500.0
2011-11-18	BMVP	ETF	13.3733	13.4067	13.2981	13.3167	3262.0
2011-11-18	BND	ETF	83.69	83.7	83.38	83.62	1032700.0
2011-11-18	BNO	ETF	37.75	37.885	37.12	37.3	74000.0
2011-11-18	BOIL	ETF	2885000.0	2905000.0	2809000.0	2866000.0	0.2
2011-11-18	BRF	ETF	43.52	43.52	42.6	42.65	107848.0

> showing 50 of 884 rows — these rows as CSV

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