PREVIEW / etf_daily / 2011-09-02

all etf daily files

  file:    by_date/etf_daily/2011/2011-09-02.parquet
  size:    36 KB
  rows:    860

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
2011-09-02	SPY	ETF	118.42	120.87	117.43	117.85	255517200.0
2011-09-02	QQQ	ETF	53.58	54.6143	52.99	53.28	58185104.0
2011-09-02	IWM	ETF	69.36	70.04	68.1	68.46	78920100.0
2011-09-02	DIA	ETF	112.74	113.28	111.95	112.28	9426300.0
2011-09-02	GLD	ETF	182.82	183.51	182.1	183.24	19911200.0
2011-09-02	TLT	ETF	111.39	112.58	110.66	112.51	16557100.0
2011-09-02	AADR	ETF	28.99	28.99	28.99	28.99	1100.0
2011-09-02	AAXJ	ETF	55.12	55.32	54.56	54.71	172400.0
2011-09-02	ACTV	ETF	15.13	15.45	14.78	14.93	61547.0
2011-09-02	ACWI	ETF	42.62	42.71	42.19	42.35	385200.0
2011-09-02	ACWX	ETF	38.99	39.2	38.7	38.81	114763.0
2011-09-02	ADRE	ETF	41.47	41.57	40.8404	41.18	66345.0
2011-09-02	AFK	ETF	29.37	29.5	29.14	29.24	7870.0
2011-09-02	AGEM	ETF	23.18	23.25	23.12	23.25	1346.0
2011-09-02	AGG	ETF	109.97	110.16	109.8	109.95	923900.0
2011-09-02	AGQ	ETF	478.8	490.44	474.0	487.8	581700.0
2011-09-02	AGZ	ETF	112.65	112.83	112.41	112.83	22782.0
2011-09-02	AIA	ETF	41.29	41.45	41.0352	41.18	36193.0
2011-09-02	AIQ	ETF	7.0	7.2975	6.7	6.7	34531.0
2011-09-02	AIS	ETF	2.42	2.42	2.27	2.31	784085.0
2011-09-02	AIVI	ETF	41.42	41.64	41.13	41.24	47200.0
2011-09-02	AMJ	ETF	35.0	35.45	34.75	34.9	699746.0
2011-09-02	AMLP	ETF	77.65	78.6	76.65	77.2	115640.0
2011-09-02	AOA	ETF	32.13	32.26	31.84	31.92	13700.0
2011-09-02	AOK	ETF	28.99	29.07	28.99	29.05	13755.0
2011-09-02	AOM	ETF	29.71	29.77	29.62	29.66	24868.0
2011-09-02	AOR	ETF	30.56	30.6928	30.46	30.49	10290.0
2011-09-02	ARB	ETF	35.04	35.46	34.13	34.4	144081.0
2011-09-02	ARGT	ETF	25.0	25.0	25.0	25.0	650.0
2011-09-02	ASEA	ETF	16.03	16.03	15.86	15.86	1100.0
2011-09-02	AWAY	ETF	40.64	41.01	39.08	40.56	109003.0
2011-09-02	BAB	ETF	27.81	28.24	27.81	28.22	125266.0
2011-09-02	BAL	ETF	65.11	65.7801	65.11	65.43	37215.0
2011-09-02	BALT	ETF	4.87	4.99	4.77	4.79	158530.0
2011-09-02	BBH	ETF	32.27	32.7567	32.18	32.19	55500.0
2011-09-02	BCM	ETF	48.28	48.57	48.28	48.51	655.0
2011-09-02	BIB	ETF	7.0388	7.3587	6.975	6.977	62272.0
2011-09-02	BICK	ETF	27.0	27.06	26.67	26.67	19084.0
2011-09-02	BIL	ETF	91.72	91.72	91.7	91.72	479450.0
2011-09-02	BIS	ETF	7096.0	7144.0	7027.2	7118.4	32.25
2011-09-02	BITS	ETF	21.24	22.12	21.24	21.4	3025.0
2011-09-02	BIV	ETF	88.3	88.53	88.06	88.4	114600.0
2011-09-02	BJK	ETF	32.69	32.82	32.28	32.38	11400.0
2011-09-02	BKF	ETF	41.32	41.37	40.61	40.84	106488.0
2011-09-02	BKLN	ETF	23.27	23.78	23.27	23.39	231700.0
2011-09-02	BLNG	ETF	59.41	59.49	59.37	59.49	881.0
2011-09-02	BLV	ETF	89.1	89.63	88.52	89.44	67200.0
2011-09-02	BMVP	ETF	13.22	13.34	13.11	13.11	2437.0
2011-09-02	BND	ETF	83.75	83.89	83.63	83.77	1355800.0
2011-09-02	BNO	ETF	37.455	37.925	37.3	37.61	27600.0

> showing 50 of 860 rows — these rows as CSV

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