PREVIEW / etf_daily / 2011-06-24

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-24.parquet
  size:    36 KB
  rows:    852

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-06-24	SPY	ETF	128.27	128.37	126.62	126.81	226129300.0
2011-06-24	QQQ	ETF	55.07	55.13	54.27	54.38	56298248.0
2011-06-24	IWM	ETF	80.63	80.76	79.47	79.94	73865400.0
2011-06-24	DIA	ETF	120.23	120.31	118.99	119.2	6643300.0
2011-06-24	GLD	ETF	147.86	148.02	145.97	146.26	19301400.0
2011-06-24	TLT	ETF	97.36	97.69	96.98	96.98	7960900.0
2011-06-24	AADR	ETF	30.19	30.33	30.19	30.33	500.0
2011-06-24	AAXJ	ETF	60.11	60.29	59.5	59.57	631800.0
2011-06-24	ACTV	ETF	16.85	16.91	15.83	16.0	1813524.0
2011-06-24	ACWI	ETF	46.73	46.73	46.05	46.12	315700.0
2011-06-24	ACWX	ETF	43.2	43.24	42.76	42.84	55983.0
2011-06-24	ADRE	ETF	44.84	44.84	44.38	44.42	70046.0
2011-06-24	AFK	ETF	31.82	31.82	31.22	31.25	23766.0
2011-06-24	AGEM	ETF	25.67	25.67	25.334	25.334	5395.0
2011-06-24	AGG	ETF	107.63	107.88	107.62	107.63	1084100.0
2011-06-24	AGQ	ETF	333.18	335.42	320.18	321.16	792350.0
2011-06-24	AGZ	ETF	110.94	111.074	110.84	111.0065	15983.0
2011-06-24	AIA	ETF	45.72	45.72	45.2823	45.3379	10653.0
2011-06-24	AIQ	ETF	18.7	19.4	18.55	19.25	85523.0
2011-06-24	AIS	ETF	1.97	2.17	1.96	2.17	2770715.0
2011-06-24	AIVI	ETF	45.31	45.31	44.74	44.79	221100.0
2011-06-24	AMJ	ETF	36.23	36.33	36.12	36.3	1327838.0
2011-06-24	AMLP	ETF	78.8	79.25	78.8	79.2	124120.0
2011-06-24	AOA	ETF	35.33	35.33	34.9	34.9	1800.0
2011-06-24	AOK	ETF	29.01	29.27	29.01	29.19	27194.0
2011-06-24	AOM	ETF	30.68	30.68	30.37	30.39	9358.0
2011-06-24	AOR	ETF	32.28	32.28	32.08	32.1	21721.0
2011-06-24	ARB	ETF	38.63	38.98	38.01	38.3	115100.0
2011-06-24	ASEA	ETF	15.95	15.95	15.95	15.95	2200.0
2011-06-24	BAB	ETF	26.6	26.69	26.53	26.53	571037.0
2011-06-24	BAL	ETF	74.57	76.11	74.5	75.5	39817.0
2011-06-24	BALT	ETF	5.97	6.03	5.8708	5.96	239088.0
2011-06-24	BBH	ETF	34.62	34.7967	34.4	34.6933	94800.0
2011-06-24	BCM	ETF	45.49	45.49	45.49	45.49	105.0
2011-06-24	BIB	ETF	9.085	9.085	8.8964	8.9757	38808.0
2011-06-24	BICK	ETF	30.59	30.59	30.36	30.46	4602.0
2011-06-24	BIL	ETF	91.72	91.72	91.7	91.7	357750.0
2011-06-24	BITS	ETF	21.0	21.56	21.0	21.56	15658.0
2011-06-24	BIV	ETF	85.11	85.4	85.0	85.37	103900.0
2011-06-24	BJK	ETF	32.55	32.55	32.27	32.35	2900.0
2011-06-24	BKF	ETF	46.24	46.24	45.72	45.72	151303.0
2011-06-24	BKLN	ETF	24.67	24.7	24.63	24.7	44400.0
2011-06-24	BLNG	ETF	47.72	47.72	47.68	47.68	1500.0
2011-06-24	BLV	ETF	81.92	82.19	81.85	81.9	83600.0
2011-06-24	BMVP	ETF	15.223	15.257	15.038	15.043	6809.0
2011-06-24	BND	ETF	81.93	82.14	81.92	82.05	725000.0
2011-06-24	BNO	ETF	35.58	35.725	34.625	35.215	436000.0
2011-06-24	BOSS	ETF	57.4	58.0	57.4	58.0	100.0
2011-06-24	BRF	ETF	55.36	59.33	54.8875	54.99	137825.0
2011-06-24	BSCE	ETF	21.19	21.26	21.1805	21.247	16012.0

> showing 50 of 852 rows — these rows as CSV

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