PREVIEW / etf_daily / 2012-09-13

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-13.parquet
  size:    39 KB
  rows:    951

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-09-13	SPY	ETF	144.37	147.04	143.99	146.59	225470200.0
2012-09-13	QQQ	ETF	68.71	69.86	68.62	69.56	45417791.0
2012-09-13	IWM	ETF	84.64	86.15	84.19	85.6	69437600.0
2012-09-13	DIA	ETF	133.27	135.71	133.21	135.39	6975700.0
2012-09-13	GLD	ETF	167.87	171.91	166.3	171.31	28336900.0
2012-09-13	TLT	ETF	122.39	123.09	120.27	121.53	12280200.0
2012-09-13	AAXJ	ETF	54.6	56.23	54.6	56.03	463200.0
2012-09-13	ACTV	ETF	12.3	12.35	12.0	12.14	926974.0
2012-09-13	ACWI	ETF	46.91	47.86	46.76	47.75	818200.0
2012-09-13	ACWV	ETF	56.33	57.86	56.32	56.86	49900.0
2012-09-13	ACWX	ETF	39.62	40.54	39.48	40.4	453086.0
2012-09-13	ADRE	ETF	38.9	40.01	38.8401	39.97	39547.0
2012-09-13	AFK	ETF	30.94	31.45	30.85	31.45	68670.0
2012-09-13	AGEM	ETF	22.0247	22.6816	21.96	22.6764	700.0
2012-09-13	AGG	ETF	111.75	111.89	111.37	111.83	2165200.0
2012-09-13	AGQ	ETF	216.84	238.24	210.4	236.64	1217150.0
2012-09-13	AGZ	ETF	113.84	113.85	113.48	113.53	42231.0
2012-09-13	AIA	ETF	43.34	44.49	43.34	44.38	14890.0
2012-09-13	AIQ	ETF	7.1	7.2	7.05	7.15	2552.0
2012-09-13	AIVI	ETF	41.18	42.15	41.14	42.06	59100.0
2012-09-13	ALTL	ETF	26.13	26.17	26.13	26.163	6388.0
2012-09-13	AMJ	ETF	39.65	40.04	39.6	39.95	495104.0
2012-09-13	AMLP	ETF	81.9	82.35	81.75	82.25	348800.0
2012-09-13	ANGL	ETF	26.49	26.58	26.49	26.58	1200.0
2012-09-13	AOA	ETF	36.92	37.43	36.86	37.4	9600.0
2012-09-13	AOK	ETF	30.49	30.662	30.4897	30.662	565910.0
2012-09-13	AOM	ETF	31.67	31.912	31.618	31.9	107272.0
2012-09-13	AOR	ETF	33.77	34.21	33.77	34.17	20347.0
2012-09-13	ARB	ETF	37.96	38.53	37.44	37.95	145386.0
2012-09-13	ARGT	ETF	17.4	17.64	17.4	17.64	1850.0
2012-09-13	ASEA	ETF	16.52	16.73	16.51	16.73	3900.0
2012-09-13	AWAY	ETF	23.93	24.2	23.842	24.042	301860.0
2012-09-13	BAB	ETF	29.99	30.02	29.76	29.9	221211.0
2012-09-13	BAL	ETF	48.49	48.64	48.03	48.55	12030.0
2012-09-13	BALT	ETF	3.3	3.47	3.25	3.33	65363.0
2012-09-13	BBH	ETF	52.19	52.78	52.0	52.58	7900.0
2012-09-13	BCM	ETF	47.01	47.09	47.01	47.09	735.0
2012-09-13	BIB	ETF	15.1675	15.385	14.9739	15.3637	47976.0
2012-09-13	BICK	ETF	23.11	23.65	22.96	23.56	35199.0
2012-09-13	BIL	ETF	91.62	91.64	91.62	91.62	553050.0
2012-09-13	BIS	ETF	2696.0	2702.4	2620.8	2622.4	43.1
2012-09-13	BIV	ETF	89.52	89.68	89.0	89.63	340100.0
2012-09-13	BJK	ETF	33.5	34.22	33.04	34.16	4800.0
2012-09-13	BKF	ETF	37.12	38.25	36.98	38.175	122817.0
2012-09-13	BKLN	ETF	25.0	25.05	24.96	25.05	561700.0
2012-09-13	BLV	ETF	95.07	95.85	94.11	94.85	99700.0
2012-09-13	BMVP	ETF	16.21	16.43	16.14	16.43	10952.0
2012-09-13	BND	ETF	84.61	84.71	84.3	84.7	1350200.0
2012-09-13	BNO	ETF	42.1	42.1	41.61	41.82	83800.0
2012-09-13	BOIL	ETF	928800.0	943600.0	890200.0	925800.0	18.8

> showing 50 of 951 rows — these rows as CSV

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