PREVIEW / etf_daily / 2011-05-05

all etf daily files

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

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-05	SPY	ETF	134.08	134.95	133.02	133.61	226900000.0
2011-05-05	QQQ	ETF	58.32	58.97	58.08	58.28	72153289.0
2011-05-05	IWM	ETF	82.64	84.08	82.41	82.83	91858900.0
2011-05-05	DIA	ETF	126.58	126.84	125.0	125.64	11362900.0
2011-05-05	GLD	ETF	146.82	147.58	142.55	143.47	51284000.0
2011-05-05	TLT	ETF	94.92	95.63	94.81	95.49	9600000.0
2011-05-05	AADR	ETF	31.3	31.49	31.21	31.49	1600.0
2011-05-05	AAXJ	ETF	62.93	63.38	62.64	62.98	487400.0
2011-05-05	ACWI	ETF	49.4	49.55	48.88	49.08	456000.0
2011-05-05	ACWX	ETF	46.13	46.25	45.58	45.78	71430.0
2011-05-05	ADRE	ETF	46.25	46.5252	45.8009	46.17	64080.0
2011-05-05	AFK	ETF	33.13	33.25	32.66	32.851	11665.0
2011-05-05	AGG	ETF	106.47	106.72	106.47	106.67	800700.0
2011-05-05	AGQ	ETF	426.0	434.0	356.06	358.68	4680450.0
2011-05-05	AGZ	ETF	110.08	110.212	109.95	110.01	76208.0
2011-05-05	AIA	ETF	48.07	48.1	47.65	47.81	190434.0
2011-05-05	AIQ	ETF	20.65	21.4	20.35	20.5	16569.0
2011-05-05	AIS	ETF	1.7	1.77	1.67	1.67	533014.0
2011-05-05	AIVI	ETF	49.08	49.08	48.23	48.4	12900.0
2011-05-05	AMJ	ETF	37.18	37.26	36.44	36.86	2558205.0
2011-05-05	AMLP	ETF	81.05	81.05	80.0	80.7	312860.0
2011-05-05	AOA	ETF	36.28	36.52	36.13	36.13	13000.0
2011-05-05	AOK	ETF	29.44	29.49	29.4009	29.45	37710.0
2011-05-05	AOM	ETF	30.93	30.97	30.8228	30.8899	23014.0
2011-05-05	AOR	ETF	32.9	33.1	32.865	32.87	16289.0
2011-05-05	ARB	ETF	38.41	39.97	38.16	39.09	155896.0
2011-05-05	ARGT	ETF	29.46	29.46	29.12	29.26	700.0
2011-05-05	ASEA	ETF	16.03	16.1	15.99	15.99	6400.0
2011-05-05	BAB	ETF	26.19	26.26	26.13	26.22	193014.0
2011-05-05	BAL	ETF	80.07	82.77	79.3101	80.04	204299.0
2011-05-05	BALT	ETF	7.22	7.32	6.9601	7.0	183621.0
2011-05-05	BBH	ETF	34.6367	34.8467	34.43	34.4667	38400.0
2011-05-05	BCM	ETF	48.22	48.22	47.21	47.21	1300.0
2011-05-05	BIB	ETF	9.4113	9.575	9.3125	9.34	97624.0
2011-05-05	BICK	ETF	32.86	33.0928	32.67	32.82	20007.0
2011-05-05	BIL	ETF	91.72	91.74	91.72	91.74	800000.0
2011-05-05	BIS	ETF	6297.6	6297.6	6038.4	6281.76	34.8
2011-05-05	BITS	ETF	23.84	23.84	22.92	23.328	250.0
2011-05-05	BIV	ETF	83.41	83.68	83.41	83.66	73900.0
2011-05-05	BJK	ETF	34.16	34.43	34.0	34.04	14000.0
2011-05-05	BKF	ETF	47.58	47.92	46.93	47.12	441497.0
2011-05-05	BKLN	ETF	25.27	25.27	25.24	25.25	61700.0
2011-05-05	BLNG	ETF	47.68	47.68	47.0	47.0	1600.0
2011-05-05	BLV	ETF	80.6	81.08	80.49	81.0	30700.0
2011-05-05	BMVP	ETF	15.69	15.88	15.67	15.68	6255.0
2011-05-05	BND	ETF	81.01	81.17	80.99	81.13	581500.0
2011-05-05	BNO	ETF	38.99	39.02	36.14	36.33	464000.0
2011-05-05	BRF	ETF	55.74	56.2052	55.042	55.44	231275.0
2011-05-05	BSCE	ETF	21.0694	21.13	21.0694	21.096	11944.0
2011-05-05	BSV	ETF	80.65	80.75	80.65	80.71	240500.0

> showing 50 of 854 rows — these rows as CSV

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