PREVIEW / etf_daily / 2013-03-13

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-13.parquet
  size:    40 KB
  rows:    975

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-13	SPY	ETF	155.76	156.12	155.23	155.9	92550900.0
2013-03-13	QQQ	ETF	68.8	68.89	68.39	68.63	34297271.0
2013-03-13	IWM	ETF	93.54	94.02	93.25	93.86	28662200.0
2013-03-13	DIA	ETF	144.44	144.71	144.09	144.46	4319500.0
2013-03-13	GLD	ETF	154.26	154.6	153.42	153.66	7436400.0
2013-03-13	TLT	ETF	115.24	115.74	115.03	115.57	7371500.0
2013-03-13	AADR	ETF	33.34	33.34	33.34	33.34	100.0
2013-03-13	AAXJ	ETF	59.58	59.58	59.18	59.18	342000.0
2013-03-13	ACTV	ETF	4.78	4.81	4.67	4.68	334795.0
2013-03-13	ACWI	ETF	50.76	50.83	50.55	50.75	786100.0
2013-03-13	ACWV	ETF	60.32	60.33	60.08	60.2	75400.0
2013-03-13	ACWX	ETF	43.12	43.1399	42.88	43.02	131810.0
2013-03-13	ADRE	ETF	39.56	39.56	39.15	39.15	24506.0
2013-03-13	AFK	ETF	30.66	30.66	30.44	30.56	20812.0
2013-03-13	AGEM	ETF	23.06	23.06	22.801	22.9399	2061.0
2013-03-13	AGG	ETF	109.92	110.08	109.92	109.99	1137000.0
2013-03-13	AGQ	ETF	160.2	161.2	156.64	157.16	205475.0
2013-03-13	AGZ	ETF	113.08	113.08	112.79	112.8401	7029.0
2013-03-13	AIA	ETF	46.51	46.51	46.31	46.4407	62390.0
2013-03-13	AIQ	ETF	7.064	7.22	7.05	7.2	2217.0
2013-03-13	AIVI	ETF	42.46	42.59	42.33	42.49	16500.0
2013-03-13	AMJ	ETF	43.47	43.69	43.27	43.37	1018481.0
2013-03-13	AMLP	ETF	86.1	86.15	85.55	85.55	513560.0
2013-03-13	ANGL	ETF	26.87	26.87	26.87	26.87	200.0
2013-03-13	AOA	ETF	39.53	39.6	39.39	39.52	95100.0
2013-03-13	AOK	ETF	31.08	31.09	31.033	31.08	15340.0
2013-03-13	AOM	ETF	32.62	32.68	32.59	32.65	25695.0
2013-03-13	AOR	ETF	35.41	35.52	35.38	35.51	46137.0
2013-03-13	ARB	ETF	46.87	46.88	46.75	46.78	435643.0
2013-03-13	ARGT	ETF	18.0	18.0	17.62	17.84	22250.0
2013-03-13	ASEA	ETF	17.39	17.39	17.33	17.35	9500.0
2013-03-13	ATMP	ETF	24.97	24.97	24.894	24.897	82050.0
2013-03-13	AWAY	ETF	30.75	30.92	30.23	30.44	592210.0
2013-03-13	BAB	ETF	30.07	30.09	30.0	30.06	215930.0
2013-03-13	BAL	ETF	56.69	57.57	56.59	57.24	24353.0
2013-03-13	BALT	ETF	3.92	3.94	3.84	3.92	79810.0
2013-03-13	BBH	ETF	62.8	63.0	62.36	62.74	51500.0
2013-03-13	BCM	ETF	43.23	43.24	42.9599	42.9599	3708.0
2013-03-13	BIB	ETF	18.725	18.795	18.495	18.675	50700.0
2013-03-13	BICK	ETF	24.76	24.84	24.73	24.78	2366.0
2013-03-13	BIL	ETF	91.6	91.62	91.6	91.62	161300.0
2013-03-13	BIS	ETF	2031.9	2031.9	2011.24	2011.24	29.5
2013-03-13	BIV	ETF	87.07	87.2	87.05	87.19	374100.0
2013-03-13	BIZD	ETF	20.8	20.81	20.75	20.81	2600.0
2013-03-13	BJK	ETF	38.33	38.66	38.33	38.54	3500.0
2013-03-13	BKF	ETF	39.97	39.97	39.65	39.68	97389.0
2013-03-13	BKLN	ETF	25.12	25.14	25.11	25.14	1866000.0
2013-03-13	BLV	ETF	90.68	90.71	90.31	90.59	71200.0
2013-03-13	BMVP	ETF	18.2667	18.3085	18.2633	18.2633	974.0
2013-03-13	BND	ETF	83.11	83.18	83.06	83.08	1287700.0

> showing 50 of 975 rows — these rows as CSV

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