PREVIEW / etf_daily / 2013-03-04

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-04.parquet
  size:    40 KB
  rows:    976

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-04	SPY	ETF	151.76	152.92	151.52	152.92	99010200.0
2013-03-04	QQQ	ETF	67.19	67.69	67.07	67.68	19380446.0
2013-03-04	IWM	ETF	90.67	91.17	90.2	91.13	27577000.0
2013-03-04	DIA	ETF	140.36	141.1	140.1	141.07	3619700.0
2013-03-04	GLD	ETF	152.45	152.74	151.87	152.3	6643800.0
2013-03-04	TLT	ETF	118.79	118.97	118.26	118.27	4511400.0
2013-03-04	AAXJ	ETF	59.58	59.66	59.29	59.66	454500.0
2013-03-04	ACTV	ETF	4.53	4.59	4.47	4.54	1663954.0
2013-03-04	ACWI	ETF	49.78	50.0	49.64	50.0	487400.0
2013-03-04	ACWV	ETF	59.56	59.86	59.43	59.78	331500.0
2013-03-04	ACWX	ETF	42.35	42.58	42.26	42.56	224804.0
2013-03-04	ADRE	ETF	38.93	38.94	38.711	38.91	18361.0
2013-03-04	AFK	ETF	30.49	30.49	30.128	30.24	34109.0
2013-03-04	AGEM	ETF	22.6	22.62	22.427	22.62	585.0
2013-03-04	AGG	ETF	110.65	110.66	110.57	110.58	782100.0
2013-03-04	AGQ	ETF	153.8	155.12	152.32	153.52	212300.0
2013-03-04	AGZ	ETF	113.3553	113.38	113.31	113.3248	8762.0
2013-03-04	AIA	ETF	46.9	46.98	46.681	46.98	12743.0
2013-03-04	AIQ	ETF	7.01	7.05	6.94	7.05	11385.0
2013-03-04	AIVI	ETF	41.57	41.93	41.56	41.93	31500.0
2013-03-04	AMJ	ETF	43.14	43.48	42.96	43.48	802917.0
2013-03-04	AMLP	ETF	85.25	85.7	85.1	85.65	392260.0
2013-03-04	ANGL	ETF	26.97	27.33	26.82	26.82	27100.0
2013-03-04	AOA	ETF	38.79	38.94	38.75	38.94	49800.0
2013-03-04	AOK	ETF	30.93	30.969	30.9	30.9574	13797.0
2013-03-04	AOM	ETF	32.32	32.44	32.32	32.42	93723.0
2013-03-04	AOR	ETF	35.05	35.12	34.95	35.08	143395.0
2013-03-04	ARB	ETF	46.78	46.85	46.76	46.84	206404.0
2013-03-04	ARGT	ETF	16.94	16.94	16.78	16.78	1900.0
2013-03-04	ASEA	ETF	17.25	17.27	17.16	17.27	17500.0
2013-03-04	AWAY	ETF	29.71	30.61	29.58	30.35	1172376.0
2013-03-04	BAB	ETF	30.55	30.65	30.55	30.61	168662.0
2013-03-04	BAL	ETF	55.3499	56.09	55.344	56.09	101822.0
2013-03-04	BALT	ETF	3.74	3.9975	3.74	3.95	157330.0
2013-03-04	BBH	ETF	59.8	60.57	59.65	60.57	30900.0
2013-03-04	BCM	ETF	42.6999	42.6999	42.542	42.62	1363.0
2013-03-04	BIB	ETF	17.1325	17.59	16.9255	17.59	128080.0
2013-03-04	BICK	ETF	24.75	24.81	24.58	24.81	8363.0
2013-03-04	BIL	ETF	91.6	91.62	91.6	91.6	86700.0
2013-03-04	BIS	ETF	2226.36	2226.4	2149.2	2149.2	54.5
2013-03-04	BIV	ETF	87.84	87.9	87.79	87.83	272600.0
2013-03-04	BIZD	ETF	20.35	20.43	20.2	20.43	8300.0
2013-03-04	BJK	ETF	38.37	38.44	38.16	38.44	5500.0
2013-03-04	BKF	ETF	39.29	39.43	39.13	39.43	73367.0
2013-03-04	BKLN	ETF	25.01	25.01	24.99	25.01	3384800.0
2013-03-04	BLV	ETF	92.53	92.57	92.15	92.25	63900.0
2013-03-04	BMVP	ETF	17.7	17.91	17.7	17.91	4920.0
2013-03-04	BND	ETF	83.66	83.67	83.6	83.6	914700.0
2013-03-04	BNO	ETF	41.385	41.47	41.13	41.33	119200.0
2013-03-04	BOIL	ETF	784800.0	800000.0	778200.0	797600.0	12.2

> showing 50 of 976 rows — these rows as CSV

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