PREVIEW / etf_daily / 2013-03-11

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-11.parquet
  size:    40 KB
  rows:    978

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
2013-03-11	SPY	ETF	155.32	156.04	155.13	156.03	83746800.0
2013-03-11	QQQ	ETF	68.68	68.99	68.47	68.97	23194121.0
2013-03-11	IWM	ETF	93.42	93.75	93.33	93.7	26716100.0
2013-03-11	DIA	ETF	143.73	144.36	143.61	144.36	4373000.0
2013-03-11	GLD	ETF	152.82	153.06	152.65	152.99	4810700.0
2013-03-11	TLT	ETF	115.12	115.23	114.74	114.86	5815800.0
2013-03-11	AADR	ETF	33.33	33.36	32.96	33.06	1800.0
2013-03-11	AAXJ	ETF	60.4	60.52	60.27	60.39	625800.0
2013-03-11	ACTV	ETF	4.82	4.96	4.76	4.95	644929.0
2013-03-11	ACWI	ETF	50.83	51.02	50.76	51.02	289900.0
2013-03-11	ACWV	ETF	60.2	60.33	60.12	60.33	133200.0
2013-03-11	ACWX	ETF	43.27	43.4	43.16	43.4	63359.0
2013-03-11	ADRE	ETF	39.89	39.9801	39.75	39.91	52435.0
2013-03-11	AFK	ETF	30.7	30.7	30.55	30.62	34518.0
2013-03-11	AGEM	ETF	23.2	23.31	23.08	23.18	3693.0
2013-03-11	AGG	ETF	109.84	109.92	109.82	109.88	1163500.0
2013-03-11	AGQ	ETF	156.36	158.44	155.88	158.32	249025.0
2013-03-11	AGZ	ETF	112.884	112.966	112.8	112.89	39158.0
2013-03-11	AIA	ETF	47.33	47.336	47.16	47.17	57701.0
2013-03-11	AIQ	ETF	7.1	7.25	7.1	7.15	4123.0
2013-03-11	AIVI	ETF	42.55	42.78	42.55	42.78	46700.0
2013-03-11	ALTL	ETF	28.884	28.92	28.884	28.92	1195.0
2013-03-11	AMJ	ETF	43.8	43.85	43.45	43.71	1263495.0
2013-03-11	AMLP	ETF	86.15	86.35	85.75	86.15	574200.0
2013-03-11	AOA	ETF	39.52	39.62	39.46	39.62	20300.0
2013-03-11	AOK	ETF	31.03	31.09	31.03	31.079	24972.0
2013-03-11	AOM	ETF	32.59	32.69	32.59	32.6699	20135.0
2013-03-11	AOR	ETF	35.41	35.55	35.41	35.55	75377.0
2013-03-11	ARB	ETF	46.96	47.0	46.77	46.88	924364.0
2013-03-11	ARGT	ETF	17.62	17.78	17.62	17.78	6350.0
2013-03-11	ASEA	ETF	17.46	17.46	17.37	17.42	10500.0
2013-03-11	AWAY	ETF	30.43	30.887	30.25	30.49	719977.0
2013-03-11	BAB	ETF	30.05	30.12	30.02	30.03	241348.0
2013-03-11	BAL	ETF	55.42	56.1775	55.36	56.16	10973.0
2013-03-11	BALT	ETF	3.94	4.07	3.94	4.01	69828.0
2013-03-11	BBH	ETF	62.5	62.61	62.29	62.61	74500.0
2013-03-11	BCM	ETF	42.9	43.04	42.85	43.04	3848.0
2013-03-11	BIB	ETF	18.6425	18.663	18.4475	18.64	123912.0
2013-03-11	BICK	ETF	25.41	25.41	25.3	25.356	925.0
2013-03-11	BIL	ETF	91.6	91.62	91.6	91.62	126700.0
2013-03-11	BIS	ETF	2044.4	2044.4	2026.4	2026.4	8.75
2013-03-11	BIV	ETF	87.04	87.14	86.99	87.0	277400.0
2013-03-11	BIZD	ETF	20.88	20.88	20.75	20.85	12300.0
2013-03-11	BJK	ETF	38.54	38.78	38.54	38.78	700.0
2013-03-11	BKF	ETF	40.75	40.78	40.561	40.69	195004.0
2013-03-11	BKLN	ETF	25.1	25.11	25.09	25.11	2216700.0
2013-03-11	BLV	ETF	90.43	90.44	90.11	90.11	73700.0
2013-03-11	BMVP	ETF	18.153	18.236	18.153	18.231	4260.0
2013-03-11	BND	ETF	83.04	83.14	83.02	83.02	1668900.0
2013-03-11	BNO	ETF	41.465	41.615	41.295	41.455	64400.0

> showing 50 of 978 rows — these rows as CSV

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