PREVIEW / etf_daily / 2011-02-15

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-15.parquet
  size:    35 KB
  rows:    827

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-02-15	SPY	ETF	133.02	133.22	132.32	133.01	119575400.0
2011-02-15	QQQ	ETF	58.44	58.57	58.23	58.5	39723754.0
2011-02-15	IWM	ETF	82.27	82.49	81.83	82.02	42908600.0
2011-02-15	DIA	ETF	122.34	122.37	121.88	122.2	4854700.0
2011-02-15	GLD	ETF	133.86	134.17	133.63	133.97	10111200.0
2011-02-15	TLT	ETF	89.56	89.97	89.37	89.92	7298000.0
2011-02-15	AADR	ETF	30.36	30.38	30.2	30.2	2500.0
2011-02-15	AAXJ	ETF	60.72	60.77	60.46	60.67	230600.0
2011-02-15	ACWI	ETF	48.52	48.58	48.34	48.47	523000.0
2011-02-15	ACWX	ETF	45.19	45.22	44.99	45.06	118737.0
2011-02-15	ADRE	ETF	46.44	46.772	46.36	46.57	52007.0
2011-02-15	AFK	ETF	33.59	33.76	33.54	33.61	14107.0
2011-02-15	AGG	ETF	104.35	104.49	104.32	104.48	513500.0
2011-02-15	AGQ	ETF	308.96	311.48	305.1	307.92	498050.0
2011-02-15	AGZ	ETF	108.65	109.02	108.65	109.02	20443.0
2011-02-15	AIA	ETF	46.11	46.2	45.95	46.14	57989.0
2011-02-15	AIQ	ETF	20.55	20.75	20.2	20.5	15818.0
2011-02-15	AIS	ETF	1.75	1.75	1.64	1.67	738929.0
2011-02-15	AIVI	ETF	45.82	45.87	45.69	45.72	10100.0
2011-02-15	AMJ	ETF	37.98	38.48	37.886	38.15	667643.0
2011-02-15	AMLP	ETF	81.15	81.7	81.05	81.6	291840.0
2011-02-15	AOA	ETF	35.75	35.84	35.73	35.73	13300.0
2011-02-15	AOK	ETF	28.97	28.98	28.92	28.96	5093.0
2011-02-15	AOM	ETF	30.32	30.37	30.31	30.36	12378.0
2011-02-15	AOR	ETF	32.41	32.41	32.3201	32.36	33826.0
2011-02-15	ARB	ETF	43.82	44.01	43.35	43.59	238552.0
2011-02-15	BAB	ETF	24.74	24.78	24.66	24.78	315419.0
2011-02-15	BAL	ETF	97.28	97.82	95.851	97.78	85192.0
2011-02-15	BALT	ETF	8.82	8.91	8.69	8.78	211730.0
2011-02-15	BBH	ETF	33.6367	33.9833	33.6167	33.9833	20700.0
2011-02-15	BIB	ETF	7.6775	7.6775	7.6775	7.6775	1600.0
2011-02-15	BICK	ETF	31.03	31.32	31.03	31.178	25446.0
2011-02-15	BIL	ETF	91.72	91.72	91.7	91.72	193200.0
2011-02-15	BIS	ETF	7846.4	7846.4	7846.4	7846.4	3.125
2011-02-15	BITS	ETF	27.08	27.2	26.8512	26.892	2495.0
2011-02-15	BIV	ETF	81.45	81.6	81.32	81.56	76300.0
2011-02-15	BJK	ETF	32.25	32.44	32.18	32.33	10300.0
2011-02-15	BKF	ETF	47.11	47.37	47.0	47.17	254343.0
2011-02-15	BLV	ETF	76.78	77.01	76.65	77.0	16700.0
2011-02-15	BMVP	ETF	15.51	15.55	15.49	15.53	5673.0
2011-02-15	BND	ETF	79.37	79.53	79.34	79.5	473400.0
2011-02-15	BNO	ETF	34.14	34.375	33.69	33.81	19800.0
2011-02-15	BRF	ETF	52.31	52.829	52.31	52.7	152987.0
2011-02-15	BSCE	ETF	20.76	20.78	20.74	20.774	51105.0
2011-02-15	BSV	ETF	79.93	80.04	79.93	80.03	413600.0
2011-02-15	BTF	ETF	85.19999999999999	86.11	84.94999999999999	85.89999999999999	27290.2
2011-02-15	BWX	ETF	28.885	28.985	28.773	28.93	305800.0
2011-02-15	BWZ	ETF	37.6	37.6	37.0	37.39	9184.0
2011-02-15	BZQ	ETF	2694.4	2697.6	2641.6	2676.8	244.5
2011-02-15	CEF	ETF	20.35	20.48	20.19	20.34	1228000.0

> showing 50 of 827 rows — these rows as CSV

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