PREVIEW / etf_daily / 2011-04-05

all etf daily files

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

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-04-05	SPY	ETF	133.0	133.83	132.94	133.24	120791500.0
2011-04-05	QQQ	ETF	57.16	57.49	57.0	57.12	55384927.0
2011-04-05	IWM	ETF	84.68	85.75	84.52	85.19	45454400.0
2011-04-05	DIA	ETF	123.52	124.14	123.26	123.65	8523300.0
2011-04-05	GLD	ETF	139.58	142.09	139.52	142.05	18295300.0
2011-04-05	TLT	ETF	92.16	92.38	91.67	91.92	9951600.0
2011-04-05	AADR	ETF	31.08	31.08	31.08	31.08	200.0
2011-04-05	AAXJ	ETF	64.62	65.04	64.56	64.86	775200.0
2011-04-05	ACWI	ETF	48.72	49.05	48.62	48.91	351000.0
2011-04-05	ACWX	ETF	45.74	46.137	45.68	46.03	82275.0
2011-04-05	ADRE	ETF	49.48	49.749	49.36	49.61	46416.0
2011-04-05	AFK	ETF	33.69	34.13	33.69	34.05	35632.0
2011-04-05	AGG	ETF	105.09	105.11	104.85	104.91	801900.0
2011-04-05	AGQ	ETF	466.94	487.96	466.1	487.96	580500.0
2011-04-05	AGZ	ETF	109.11	109.3675	109.11	109.16	15507.0
2011-04-05	AIA	ETF	48.75	49.0499	48.6	48.82	168934.0
2011-04-05	AIQ	ETF	22.15	22.55	22.15	22.35	12110.0
2011-04-05	AIS	ETF	1.72	1.73	1.68	1.7	278600.0
2011-04-05	AIVI	ETF	47.43	47.86	47.4	47.66	24400.0
2011-04-05	AMJ	ETF	38.21	38.21	37.98	38.15	521393.0
2011-04-05	AMLP	ETF	82.2	82.3	82.0	82.15	93960.0
2011-04-05	AOA	ETF	36.18	36.42	36.13	36.29	9000.0
2011-04-05	AOK	ETF	29.19	29.28	29.19	29.24	10616.0
2011-04-05	AOM	ETF	30.63	30.7	30.63	30.63	7454.0
2011-04-05	AOR	ETF	32.7	32.8	32.6644	32.744	12290.0
2011-04-05	ARB	ETF	39.85	40.07	39.13	39.14	125367.0
2011-04-05	ARGT	ETF	31.22	31.58	31.08	31.5	6600.0
2011-04-05	ASEA	ETF	16.17	16.18	16.13	16.18	3400.0
2011-04-05	BAB	ETF	25.45	25.45	25.26	25.28	244462.0
2011-04-05	BAL	ETF	100.51	104.88	97.57	103.46	138772.0
2011-04-05	BALT	ETF	9.3	9.3	8.9	8.95	197474.0
2011-04-05	BBH	ETF	35.5433	35.6067	35.4067	35.4433	51000.0
2011-04-05	BIB	ETF	9.1862	9.1937	8.6125	8.9362	57232.0
2011-04-05	BICK	ETF	34.26	34.39	34.23	34.24	8883.0
2011-04-05	BIL	ETF	91.72	91.72	91.7	91.7	165000.0
2011-04-05	BIS	ETF	6656.0	6656.0	6656.0	6656.0	0.625
2011-04-05	BITS	ETF	25.48	25.88	24.8	25.04	4325.0
2011-04-05	BIV	ETF	81.87	81.99	81.7	81.77	102000.0
2011-04-05	BJK	ETF	33.07	33.17	32.96	33.12	11600.0
2011-04-05	BKF	ETF	51.76	52.1	51.61	51.91	210666.0
2011-04-05	BKLN	ETF	25.22	25.22	25.14	25.19	108700.0
2011-04-05	BLV	ETF	78.19	78.49	78.15	78.43	11300.0
2011-04-05	BMVP	ETF	15.76	15.88	15.76	15.82	8264.0
2011-04-05	BND	ETF	79.93	79.97	79.79	79.81	990900.0
2011-04-05	BNO	ETF	40.33	40.745	40.275	40.375	421400.0
2011-04-05	BRF	ETF	58.9	59.47	58.51	59.19	229102.0
2011-04-05	BSCE	ETF	20.81	20.9	20.81	20.9	17219.0
2011-04-05	BSV	ETF	80.14	80.15	79.97	79.97	636300.0
2011-04-05	BTF	ETF	83.2	83.8475	83.0	83.35000000000001	3957.6000000000004
2011-04-05	BWX	ETF	29.825	29.985	29.78	29.78	486304.0

> showing 50 of 835 rows — these rows as CSV

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