PREVIEW / etf_daily / 2011-05-17

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-17.parquet
  size:    36 KB
  rows:    851

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-05-17	SPY	ETF	132.69	133.35	132.12	133.17	192686200.0
2011-05-17	QQQ	ETF	57.12	57.57	56.98	57.56	63176058.0
2011-05-17	IWM	ETF	81.63	82.32	81.4	82.03	76475100.0
2011-05-17	DIA	ETF	124.93	125.26	123.85	124.81	25391000.0
2011-05-17	GLD	ETF	144.23	144.78	143.42	144.74	17192100.0
2011-05-17	TLT	ETF	96.03	96.6	95.98	96.59	9826900.0
2011-05-17	AADR	ETF	31.11	31.11	31.11	31.11	1400.0
2011-05-17	AAXJ	ETF	62.02	62.36	61.81	62.2	371700.0
2011-05-17	ACWI	ETF	48.37	48.6	48.09	48.58	157600.0
2011-05-17	ACWX	ETF	44.84	45.15	44.6652	45.11	51854.0
2011-05-17	ADRE	ETF	45.28	45.65	44.99	45.56	78676.0
2011-05-17	AFK	ETF	32.41	32.7	32.18	32.6999	8501.0
2011-05-17	AGG	ETF	107.11	107.21	107.06	107.14	683500.0
2011-05-17	AGQ	ETF	312.78	324.36	305.08	322.92	1728650.0
2011-05-17	AGZ	ETF	110.45	110.45	110.27	110.4	12721.0
2011-05-17	AIA	ETF	47.14	47.2621	46.92	47.25	36411.0
2011-05-17	AIQ	ETF	20.1	20.3	19.0	19.95	62132.0
2011-05-17	AIS	ETF	1.68	1.68	1.65	1.66	570410.0
2011-05-17	AIVI	ETF	47.56	47.96	47.31	47.95	17400.0
2011-05-17	AMJ	ETF	36.04	36.1	35.21	35.61	2633482.0
2011-05-17	AMLP	ETF	78.2	78.2	76.85	77.3	336620.0
2011-05-17	AOA	ETF	35.93	36.08	35.77	35.96	33700.0
2011-05-17	AOK	ETF	29.34	29.3892	29.34	29.37	7172.0
2011-05-17	AOM	ETF	30.74	30.8	30.7099	30.78	22194.0
2011-05-17	AOR	ETF	32.7	32.7708	32.665	32.73	2711.0
2011-05-17	ARB	ETF	41.34	41.43	40.52	41.11	91882.0
2011-05-17	ARGT	ETF	29.3	29.32	29.3	29.32	2250.0
2011-05-17	ASEA	ETF	16.09	16.24	16.09	16.24	900.0
2011-05-17	BAB	ETF	26.35	26.48	26.35	26.44	81315.0
2011-05-17	BAL	ETF	84.43	87.43	84.43	85.8	72785.0
2011-05-17	BALT	ETF	6.27	6.51	6.23	6.49	356673.0
2011-05-17	BBH	ETF	35.04	35.4667	34.8667	35.4333	42300.0
2011-05-17	BIB	ETF	9.7737	9.8265	9.5638	9.7925	76432.0
2011-05-17	BICK	ETF	32.01	32.27	31.87	32.27	19344.0
2011-05-17	BIL	ETF	91.74	91.74	91.72	91.72	582700.0
2011-05-17	BIS	ETF	6052.8	6052.8	5980.8	5980.8	15.3
2011-05-17	BITS	ETF	20.96	21.6	20.96	21.0	5738.0
2011-05-17	BIV	ETF	84.16	84.22	84.03	84.18	116000.0
2011-05-17	BJK	ETF	33.66	33.66	33.41	33.56	17900.0
2011-05-17	BKF	ETF	46.79	47.18	46.541	47.14	85285.0
2011-05-17	BKLN	ETF	25.21	25.21	25.18	25.2	138600.0
2011-05-17	BLV	ETF	81.44	81.89	81.44	81.84	55900.0
2011-05-17	BMVP	ETF	15.69	15.72	15.59	15.72	12220.0
2011-05-17	BND	ETF	81.49	81.54	81.44	81.51	713200.0
2011-05-17	BNO	ETF	36.605	36.73	35.995	36.71	139800.0
2011-05-17	BRF	ETF	55.53	56.47	55.26	56.47	179875.0
2011-05-17	BSCE	ETF	21.13	21.13	21.116	21.13	7813.0
2011-05-17	BSV	ETF	80.92	80.95	80.89	80.93	968900.0
2011-05-17	BTF	ETF	83.35000000000001	83.6	82.65	83.2	2532.6000000000004
2011-05-17	BWX	ETF	30.425	30.5414	30.38	30.485	507394.0

> showing 50 of 851 rows — these rows as CSV

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