PREVIEW / etf_daily / 2012-11-12

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-12.parquet
  size:    39 KB
  rows:    942

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
2012-11-12	SPY	ETF	138.59	138.81	137.96	138.27	97677500.0
2012-11-12	QQQ	ETF	63.79	63.87	63.25	63.42	32663656.0
2012-11-12	IWM	ETF	79.56	79.66	79.03	79.15	20155100.0
2012-11-12	DIA	ETF	128.19	128.54	127.7	128.04	3758200.0
2012-11-12	GLD	ETF	168.1	168.28	167.21	167.45	5647600.0
2012-11-12	TLT	ETF	125.84	126.38	125.79	126.19	2072200.0
2012-11-12	AADR	ETF	29.51	29.59	29.48	29.59	1000.0
2012-11-12	AAXJ	ETF	56.62	56.88	56.56	56.73	283000.0
2012-11-12	ACTV	ETF	5.71	5.75	5.295	5.34	721809.0
2012-11-12	ACWI	ETF	45.84	45.93	45.71	45.78	260900.0
2012-11-12	ACWV	ETF	55.55	55.59	55.41	55.56	87100.0
2012-11-12	ACWX	ETF	39.09	39.19	39.03	39.12	86432.0
2012-11-12	ADRE	ETF	38.42	38.48	38.32	38.34	37910.0
2012-11-12	AFK	ETF	31.5425	31.58	31.4	31.4	39827.0
2012-11-12	AGEM	ETF	22.01	22.01	22.01	22.01	664.0
2012-11-12	AGG	ETF	112.13	112.15	112.02	112.05	612700.0
2012-11-12	AGQ	ETF	205.44	206.08	200.8	203.48	258650.0
2012-11-12	AGZ	ETF	113.88	114.03	113.78	113.8001	23487.0
2012-11-12	AIA	ETF	44.88	44.9399	44.7	44.72	39214.0
2012-11-12	AIQ	ETF	7.25	7.3	7.05	7.05	6379.0
2012-11-12	AIVI	ETF	39.12	39.14	38.94	39.0	19300.0
2012-11-12	ALTL	ETF	24.72	24.72	24.72	24.72	100.0
2012-11-12	AMJ	ETF	39.59	39.88	38.76	38.77	1165039.0
2012-11-12	AMLP	ETF	80.7	80.75	79.25	79.35	896220.0
2012-11-12	ANGL	ETF	26.76	26.76	26.76	26.76	400.0
2012-11-12	AOA	ETF	35.92	35.94	35.79	35.85	5500.0
2012-11-12	AOK	ETF	30.32	30.32	30.2788	30.29	8951.0
2012-11-12	AOM	ETF	31.29	31.29	31.228	31.26	10046.0
2012-11-12	AOR	ETF	33.13	33.18	33.0801	33.126	14515.0
2012-11-12	ARB	ETF	36.1	36.38	35.8	36.25	69663.0
2012-11-12	ARGT	ETF	16.34	16.34	16.08	16.08	2200.0
2012-11-12	ASEA	ETF	16.67	16.67	16.58	16.6	10200.0
2012-11-12	AWAY	ETF	21.18	21.44	20.84	21.11	702552.0
2012-11-12	BAB	ETF	30.59	30.65	30.5748	30.6	105494.0
2012-11-12	BAL	ETF	46.74	46.76	45.98	46.26	8600.0
2012-11-12	BALT	ETF	3.37	3.39	3.29	3.35	44481.0
2012-11-12	BBH	ETF	51.82	52.23	51.71	52.1	25100.0
2012-11-12	BCM	ETF	44.1	44.1	44.1	44.1	200.0
2012-11-12	BIB	ETF	13.43	13.7498	13.375	13.475	77936.0
2012-11-12	BICK	ETF	23.46	23.62	23.4401	23.4518	3317.0
2012-11-12	BIL	ETF	91.64	91.64	91.62	91.64	376650.0
2012-11-12	BIS	ETF	2902.4	2904.0	2874.8	2904.0	44.7
2012-11-12	BIV	ETF	90.45	90.49	90.35	90.47	290200.0
2012-11-12	BJK	ETF	34.37	34.37	34.16	34.29	1000.0
2012-11-12	BKF	ETF	38.09	38.09	37.91	37.96	90329.0
2012-11-12	BKLN	ETF	24.81	24.82	24.77	24.82	409400.0
2012-11-12	BLV	ETF	97.59	97.68	97.25	97.57	29400.0
2012-11-12	BMVP	ETF	15.55	15.5833	15.5292	15.5656	3034.0
2012-11-12	BND	ETF	84.98	85.04	84.91	85.03	842200.0
2012-11-12	BNO	ETF	39.815	39.995	39.53	39.55	14200.0

> showing 50 of 942 rows — these rows as CSV

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