PREVIEW / etf_daily / 2010-11-04

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-04.parquet
  size:    34 KB
  rows:    804

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
2010-11-04	SPY	ETF	121.28	122.32	119.97	122.26	215039400.0
2010-11-04	QQQ	ETF	53.63	53.8614	53.5	53.67	84200976.0
2010-11-04	IWM	ETF	72.86	73.38	72.62	73.36	60908000.0
2010-11-04	DIA	ETF	113.31	114.52	113.24	114.43	9353700.0
2010-11-04	GLD	ETF	134.64	136.13	134.24	136.03	23464700.0
2010-11-04	TLT	ETF	99.17	99.87	99.08	99.69	13246500.0
2010-11-04	AADR	ETF	29.49	29.49	29.45	29.47	3200.0
2010-11-04	AAXJ	ETF	65.07	65.53	64.83	65.45	702200.0
2010-11-04	ACWI	ETF	46.17	46.6	46.05	46.6	880200.0
2010-11-04	ACWX	ETF	44.35	44.71	44.35	44.71	57928.0
2010-11-04	ADRE	ETF	47.57	48.39	47.57	48.39	77364.0
2010-11-04	AFK	ETF	34.0	34.539	34.0	34.539	23978.0
2010-11-04	AGG	ETF	108.75	108.99	108.67	108.92	626100.0
2010-11-04	AGQ	ETF	224.9	237.84	223.42	236.98	567150.0
2010-11-04	AGZ	ETF	111.55	111.83	111.53	111.76	19516.0
2010-11-04	AIA	ETF	46.11	46.6	46.11	46.46	47751.0
2010-11-04	AIQ	ETF	22.45	22.6	21.8	21.9	69560.0
2010-11-04	AIS	ETF	1.4	1.42	1.36	1.42	426945.0
2010-11-04	AIVI	ETF	46.82	47.01	46.58	46.89	198700.0
2010-11-04	AMJ	ETF	36.2	36.355	35.995	36.165	1024103.0
2010-11-04	AMLP	ETF	80.85	81.55	80.45	80.55	98160.0
2010-11-04	AOA	ETF	33.58	33.75	33.55	33.75	16600.0
2010-11-04	AOK	ETF	28.98	29.09	28.98	29.08	51676.0
2010-11-04	AOM	ETF	30.07	30.15	30.055	30.15	38941.0
2010-11-04	AOR	ETF	31.27	31.44	31.27	31.44	221596.0
2010-11-04	ARB	ETF	27.16	27.44	26.89	27.25	248407.0
2010-11-04	BAB	ETF	25.98	26.08	25.95	26.06	275467.0
2010-11-04	BAL	ETF	68.45	69.675	68.0	69.0	91072.0
2010-11-04	BALT	ETF	11.8	12.31	11.75	11.82	232465.0
2010-11-04	BBH	ETF	33.9467	33.9833	33.6067	33.6833	82800.0
2010-11-04	BIB	ETF	7.0137	7.0137	6.855	6.855	4000.0
2010-11-04	BICK	ETF	34.12	34.35	34.04	34.34	47395.0
2010-11-04	BIL	ETF	91.7	91.72	91.7	91.7	934100.0
2010-11-04	BITS	ETF	28.36	28.88	27.8	28.32	3450.0
2010-11-04	BIV	ETF	87.35	87.61	87.35	87.48	211100.0
2010-11-04	BJK	ETF	32.74	32.84	32.53	32.84	52000.0
2010-11-04	BKF	ETF	51.45	52.12	51.42	52.09	193145.0
2010-11-04	BLV	ETF	83.53	83.89	83.05	83.72	123100.0
2010-11-04	BMVP	ETF	14.05	14.24	14.05	14.24	22902.0
2010-11-04	BND	ETF	82.87	83.0	82.84	82.96	838100.0
2010-11-04	BNE	ETF	11.34	11.36	11.31	11.35	187308.0
2010-11-04	BNO	ETF	29.385	29.46	29.35	29.46	10600.0
2010-11-04	BRF	ETF	62.69	63.7797	62.5701	63.73	716207.0
2010-11-04	BSCE	ETF	21.08	21.08	21.05	21.08	19499.0
2010-11-04	BSV	ETF	81.95	82.06	81.94	82.01	586400.0
2010-11-04	BTF	ETF	78.75	80.05	78.75	80.05	3723.6000000000004
2010-11-04	BWX	ETF	31.07	31.225	31.045	31.13	562098.0
2010-11-04	BWZ	ETF	38.51	38.54	38.4	38.46	70965.0
2010-11-04	BZQ	ETF	2459.2	2460.8	2372.8	2385.6	1434.0
2010-11-04	CEF	ETF	18.09	18.55	18.01	18.52	1828800.0

> showing 50 of 804 rows — these rows as CSV

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