PREVIEW / etf_daily / 2013-07-02

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-02.parquet
  size:    41 KB
  rows:    1,000

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-07-02	SPY	ETF	161.12	162.3	160.5	161.21	154863700.0
2013-07-02	QQQ	ETF	71.68	72.1796	71.35	71.74	23069566.0
2013-07-02	IWM	ETF	98.16	98.85	97.45	98.08	36848900.0
2013-07-02	DIA	ETF	149.15	150.21	148.4	148.93	4873800.0
2013-07-02	GLD	ETF	121.34	121.47	119.78	120.05	10550300.0
2013-07-02	TLT	ETF	110.5	110.8	110.24	110.34	5333900.0
2013-07-02	AADR	ETF	32.92	32.92	32.92	32.92	400.0
2013-07-02	AAXJ	ETF	54.75	55.07	54.05	54.33	457500.0
2013-07-02	ACTV	ETF	7.71	7.925	7.66	7.84	457996.0
2013-07-02	ACWI	ETF	50.23	50.54	49.92	50.14	1916600.0
2013-07-02	ACWV	ETF	59.94	60.4	59.72	59.92	57700.0
2013-07-02	ACWX	ETF	40.9	41.13	40.6	40.76	186016.0
2013-07-02	ADRE	ETF	34.44	34.52	33.61	33.74	42539.0
2013-07-02	AFK	ETF	27.31	27.6399	27.2123	27.26	38063.0
2013-07-02	AGEM	ETF	20.68	20.68	20.33	20.33	3139.0
2013-07-02	AGG	ETF	107.24	107.31	107.13	107.16	636900.0
2013-07-02	AGQ	ETF	68.52	68.52	65.6	66.2	398650.0
2013-07-02	AGZ	ETF	110.98	111.33	110.92	111.03	14714.0
2013-07-02	AIA	ETF	42.573	42.59	41.91	41.97	47983.0
2013-07-02	AIQ	ETF	15.92	16.15	15.79	15.92	57875.0
2013-07-02	AIVI	ETF	40.13	40.41	39.95	40.1	33400.0
2013-07-02	ALTL	ETF	28.5299	28.5299	28.43	28.43	296.0
2013-07-02	AMJ	ETF	48.18	48.19	46.81	46.9	440233.0
2013-07-02	AMLP	ETF	90.4	90.4	89.3	89.6	584040.0
2013-07-02	ANGL	ETF	26.45	26.45	26.36	26.36	1100.0
2013-07-02	AOA	ETF	39.76	39.94	39.59	39.68	20400.0
2013-07-02	AOK	ETF	30.73	30.7664	30.652	30.69	11905.0
2013-07-02	AOM	ETF	32.291	32.3899	32.2001	32.23	19330.0
2013-07-02	AOR	ETF	35.45	35.519	35.26	35.35	17555.0
2013-07-02	ARB	ETF	46.36	46.4	46.21	46.38	330744.0
2013-07-02	ARGT	ETF	16.32	16.32	16.18	16.18	400.0
2013-07-02	ASEA	ETF	16.83	16.96	16.72	16.72	9800.0
2013-07-02	ATMP	ETF	26.26	26.28	26.07	26.08	14500.0
2013-07-02	AVIV	ETF	24.81	25.26	24.7	25.0	313519.0
2013-07-02	AWAY	ETF	31.83	32.02	31.23	31.5	1310009.0
2013-07-02	BAB	ETF	28.18	28.37	28.0	28.33	244416.0
2013-07-02	BAL	ETF	54.51	54.7701	54.34	54.39	10972.0
2013-07-02	BALT	ETF	3.71	3.72	3.49	3.59	152844.0
2013-07-02	BBH	ETF	71.76	72.1	71.2	71.73	84700.0
2013-07-02	BCM	ETF	38.87	38.999	38.77	38.9099	14836.0
2013-07-02	BFOR	ETF	6.2575	6.2875	6.2025	6.235	285600.0
2013-07-02	BIB	ETF	24.1825	24.2925	23.8652	24.045	83192.0
2013-07-02	BICK	ETF	21.15	21.151	20.79	20.81	5202.0
2013-07-02	BIL	ETF	91.62	91.62	91.6	91.6	378300.0
2013-07-02	BIS	ETF	1457.2	1458.8	1432.0	1446.72	173.5
2013-07-02	BIV	ETF	83.44	83.59	83.42	83.52	394700.0
2013-07-02	BIZD	ETF	19.78	19.82	19.65	19.65	13300.0
2013-07-02	BJK	ETF	40.77	40.81	40.18	40.26	7600.0
2013-07-02	BKF	ETF	33.93	34.06	33.12	33.36	559641.0
2013-07-02	BKLN	ETF	24.71	24.76	24.71	24.74	2491000.0

> showing 50 of 1,000 rows — these rows as CSV

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