PREVIEW / etf_daily / 2013-04-02

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-02.parquet
  size:    40 KB
  rows:    981

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-04-02	SPY	ETF	156.61	157.21	156.37	156.82	101504300.0
2013-04-02	QQQ	ETF	68.81	69.27	68.77	69.04	29431878.0
2013-04-02	IWM	ETF	93.78	93.92	92.5	92.58	47917200.0
2013-04-02	DIA	ETF	145.87	146.5	145.78	146.27	5672300.0
2013-04-02	GLD	ETF	153.09	153.31	152.26	152.43	9398300.0
2013-04-02	TLT	ETF	118.07	118.14	117.75	117.91	5438000.0
2013-04-02	AADR	ETF	33.24	33.24	33.24	33.24	200.0
2013-04-02	AAXJ	ETF	59.0	59.01	58.73	58.81	396400.0
2013-04-02	ACTV	ETF	3.97	4.1	3.89	4.08	507531.0
2013-04-02	ACWI	ETF	50.69	50.89	50.63	50.72	826400.0
2013-04-02	ACWV	ETF	61.82	62.09	61.8	61.94	33500.0
2013-04-02	ACWX	ETF	42.71	42.87	42.6	42.72	661535.0
2013-04-02	ADRE	ETF	38.49	38.55	38.2328	38.27	26215.0
2013-04-02	AFK	ETF	30.4	30.6199	30.09	30.34	325476.0
2013-04-02	AGEM	ETF	22.67	22.67	22.44	22.51	8310.0
2013-04-02	AGG	ETF	110.51	110.52	110.41	110.45	875300.0
2013-04-02	AGQ	ETF	142.84	143.4	138.76	139.24	508325.0
2013-04-02	AGZ	ETF	113.26	113.35	113.24	113.2701	8636.0
2013-04-02	AIA	ETF	46.43	46.43	46.18	46.22	21528.0
2013-04-02	AIQ	ETF	7.99	8.1	7.8	7.95	72151.0
2013-04-02	AIVI	ETF	42.14	42.35	42.11	42.18	32300.0
2013-04-02	ALTL	ETF	29.19	29.19	29.13	29.13	400.0
2013-04-02	AMJ	ETF	45.69	45.88	45.4401	45.76	1683190.0
2013-04-02	AMLP	ETF	88.6	88.85	88.35	88.5	639960.0
2013-04-02	AOA	ETF	39.57	39.67	39.5	39.55	44200.0
2013-04-02	AOK	ETF	31.11	31.15	31.1	31.12	53869.0
2013-04-02	AOM	ETF	32.65	32.73	32.6499	32.68	51593.0
2013-04-02	AOR	ETF	35.58	35.58	35.451	35.51	22739.0
2013-04-02	ARB	ETF	46.94	46.95	46.84	46.86	290318.0
2013-04-02	ARGT	ETF	17.42	17.54	17.26	17.28	7500.0
2013-04-02	ASEA	ETF	17.59	17.74	17.59	17.66	51900.0
2013-04-02	ATMP	ETF	26.32	26.35	26.18	26.21	28000.0
2013-04-02	AVIV	ETF	24.4	24.43	23.95	24.0	325801.0
2013-04-02	AWAY	ETF	31.73	32.02	31.37	31.55	685005.0
2013-04-02	BAB	ETF	30.2	30.28	30.19	30.19	290556.0
2013-04-02	BAL	ETF	56.75	57.9	56.7	57.16	38594.0
2013-04-02	BALT	ETF	3.77	3.82	3.77	3.8	30260.0
2013-04-02	BBH	ETF	65.15	65.95	65.15	65.81	162100.0
2013-04-02	BCM	ETF	42.65	42.6665	42.6191	42.6191	1208.0
2013-04-02	BIB	ETF	19.65	20.2925	19.65	20.09	152460.0
2013-04-02	BICK	ETF	23.92	23.922	23.9	23.922	284.0
2013-04-02	BIL	ETF	91.62	91.62	91.6	91.62	139900.0
2013-04-02	BIS	ETF	1910.0	1910.0	1839.6	1858.8	460.0
2013-04-02	BIV	ETF	87.51	87.56	87.4	87.51	223100.0
2013-04-02	BIZD	ETF	20.07	20.27	20.07	20.2	10200.0
2013-04-02	BJK	ETF	39.95	39.96	39.76	39.82	13400.0
2013-04-02	BKF	ETF	38.64	38.67	38.37	38.42	98806.0
2013-04-02	BKLN	ETF	25.12	25.13	25.11	25.12	2555100.0
2013-04-02	BLV	ETF	91.39	91.41	91.1	91.19	43800.0
2013-04-02	BMVP	ETF	18.6433	18.6433	18.4834	18.4834	1793.0

> showing 50 of 981 rows — these rows as CSV

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