PREVIEW / etf_daily / 2013-03-18

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-18.parquet
  size:    40 KB
  rows:    980

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-18	SPY	ETF	154.34	155.64	154.2	154.97	126704300.0
2013-03-18	QQQ	ETF	67.885	68.6367	67.73	68.36	36164493.0
2013-03-18	IWM	ETF	93.74	94.61	93.67	94.23	36700800.0
2013-03-18	DIA	ETF	143.85	144.88	143.7	144.17	5511200.0
2013-03-18	GLD	ETF	155.7	155.93	155.0	155.38	9302400.0
2013-03-18	TLT	ETF	116.83	116.88	116.15	116.64	9152200.0
2013-03-18	AAXJ	ETF	58.46	58.46	58.1	58.17	839000.0
2013-03-18	ACTV	ETF	4.52	4.65	4.52	4.65	224619.0
2013-03-18	ACWI	ETF	50.57	50.83	50.39	50.57	773100.0
2013-03-18	ACWV	ETF	60.13	60.56	60.13	60.38	211000.0
2013-03-18	ACWX	ETF	42.9	43.17	42.82	42.91	142242.0
2013-03-18	ADRE	ETF	38.43	38.75	38.29	38.57	43470.0
2013-03-18	AFK	ETF	30.37	30.52	30.3	30.4	15387.0
2013-03-18	AGEM	ETF	22.48	22.48	22.4624	22.4624	4198.0
2013-03-18	AGG	ETF	110.36	110.38	110.28	110.31	1231900.0
2013-03-18	AGQ	ETF	157.88	158.64	156.2	157.12	207775.0
2013-03-18	AGZ	ETF	113.25	113.25	113.12	113.205	8464.0
2013-03-18	AIA	ETF	45.5	45.62	45.4	45.47	51484.0
2013-03-18	AIQ	ETF	7.03	7.05	6.85	6.96	9946.0
2013-03-18	AIVI	ETF	42.48	42.77	42.46	42.52	27400.0
2013-03-18	AMJ	ETF	43.13	43.35	42.996	43.24	1482304.0
2013-03-18	AMLP	ETF	85.1	85.55	85.0	85.55	475300.0
2013-03-18	ANGL	ETF	27.21	27.21	27.05	27.06	1100.0
2013-03-18	AOA	ETF	39.46	39.7	39.39	39.56	37500.0
2013-03-18	AOK	ETF	31.1	31.16	31.1	31.117	40128.0
2013-03-18	AOM	ETF	32.6	32.76	32.6	32.7	33266.0
2013-03-18	AOR	ETF	35.4	35.6055	35.35	35.509	41032.0
2013-03-18	ARB	ETF	46.8	46.97	46.78	46.91	223943.0
2013-03-18	ARGT	ETF	17.82	17.82	17.76	17.76	900.0
2013-03-18	ASEA	ETF	17.08	17.18	17.05	17.16	5800.0
2013-03-18	ATMP	ETF	25.0	25.0	24.67	24.75	34200.0
2013-03-18	AWAY	ETF	30.07	30.24	29.88	30.01	519385.0
2013-03-18	BAB	ETF	30.2	30.23	30.12	30.19	236785.0
2013-03-18	BAL	ETF	58.32	59.18	58.06	58.72	44547.0
2013-03-18	BALT	ETF	3.85	3.99	3.81	3.9	32561.0
2013-03-18	BBH	ETF	62.5	62.5	61.35	61.99	54300.0
2013-03-18	BIB	ETF	18.5375	18.5625	18.0575	18.37	107604.0
2013-03-18	BICK	ETF	24.36	24.39	24.27	24.28	53141.0
2013-03-18	BIL	ETF	91.62	91.62	91.6	91.6	2238950.0
2013-03-18	BIS	ETF	2032.4	2043.2	2032.4	2040.0	152.5
2013-03-18	BIV	ETF	87.45	87.52	87.42	87.44	222200.0
2013-03-18	BIZD	ETF	20.75	20.83	20.71	20.71	6900.0
2013-03-18	BJK	ETF	38.49	38.77	38.49	38.62	5500.0
2013-03-18	BKF	ETF	39.12	39.31	39.04	39.14	112753.0
2013-03-18	BKLN	ETF	25.05	25.08	25.05	25.08	2141600.0
2013-03-18	BLV	ETF	91.33	91.35	90.72	90.95	47200.0
2013-03-18	BMVP	ETF	18.1833	18.32	18.1767	18.2527	7795.0
2013-03-18	BND	ETF	83.32	83.39	83.3	83.37	1176100.0
2013-03-18	BNO	ETF	40.92	41.46	40.91	41.38	64400.0
2013-03-18	BOIL	ETF	983000.0	993000.0	941400.0	945600.0	13.4

> showing 50 of 980 rows — these rows as CSV

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