PREVIEW / etf_daily / 2011-06-07

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-07.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-06-07	SPY	ETF	129.7	130.07	128.85	128.96	161660500.0
2011-06-07	QQQ	ETF	56.05	56.26	55.75	55.79	46311059.0
2011-06-07	IWM	ETF	80.04	80.43	79.53	79.74	58242200.0
2011-06-07	DIA	ETF	121.28	121.6	120.47	120.49	3834600.0
2011-06-07	GLD	ETF	150.67	150.85	149.68	150.42	10140500.0
2011-06-07	TLT	ETF	95.23	96.06	95.12	96.04	7399200.0
2011-06-07	AAXJ	ETF	62.92	63.01	62.6	62.61	230600.0
2011-06-07	ACTV	ETF	19.0	19.89	18.6801	19.4	211087.0
2011-06-07	ACWI	ETF	48.3	48.41	48.03	48.07	190400.0
2011-06-07	ACWX	ETF	45.4	45.576	45.23	45.26	43034.0
2011-06-07	ADRE	ETF	46.15	46.33	45.94	45.94	30930.0
2011-06-07	AFK	ETF	32.98	33.3	32.98	33.11	18126.0
2011-06-07	AGG	ETF	107.24	107.56	107.18	107.56	1737600.0
2011-06-07	AGQ	ETF	386.04	386.36	368.0	379.9	835200.0
2011-06-07	AGZ	ETF	110.85	110.85	110.6	110.76	144707.0
2011-06-07	AIA	ETF	48.07	48.07	47.84	47.84	10684.0
2011-06-07	AIQ	ETF	19.4	19.848	19.4	19.65	22780.0
2011-06-07	AIS	ETF	1.86	1.98	1.84	1.89	2493130.0
2011-06-07	AIVI	ETF	48.23	48.54	48.2	48.2	38200.0
2011-06-07	AMJ	ETF	35.92	35.96	35.56	35.59	875323.0
2011-06-07	AMLP	ETF	78.25	78.4	78.0	78.1	132880.0
2011-06-07	AOA	ETF	35.4	35.5	35.36	35.46	14300.0
2011-06-07	AOK	ETF	29.24	29.28	29.23	29.259	7473.0
2011-06-07	AOM	ETF	30.68	30.7	30.625	30.6768	13089.0
2011-06-07	AOR	ETF	32.4244	32.52	32.4244	32.4366	10137.0
2011-06-07	ARB	ETF	38.39	39.13	38.146	38.2	104882.0
2011-06-07	ARGT	ETF	28.6	28.74	28.6	28.68	800.0
2011-06-07	ASEA	ETF	16.34	16.34	16.26	16.28	3800.0
2011-06-07	BAB	ETF	26.5	26.58	26.47	26.51	220627.0
2011-06-07	BAL	ETF	85.01	85.2	81.39	81.79	132153.0
2011-06-07	BALT	ETF	6.17	6.18	6.05	6.13	142694.0
2011-06-07	BBH	ETF	34.4967	34.7633	34.4067	34.6233	51000.0
2011-06-07	BIB	ETF	9.15	9.6312	9.15	9.55	213024.0
2011-06-07	BICK	ETF	32.17	32.33	32.17	32.177	15814.0
2011-06-07	BIL	ETF	91.72	91.72	91.7	91.72	882450.0
2011-06-07	BIS	ETF	6118.4	6121.6	6070.4	6070.4	5.95
2011-06-07	BITS	ETF	21.6	21.6	21.0	21.4	3000.0
2011-06-07	BIV	ETF	84.57	84.86	84.42	84.86	330000.0
2011-06-07	BJK	ETF	33.67	33.71	33.26	33.26	7200.0
2011-06-07	BKF	ETF	47.99	48.29	47.8	47.8001	87294.0
2011-06-07	BKLN	ETF	24.99	25.04	24.92	25.01	237300.0
2011-06-07	BLNG	ETF	49.25	49.25	49.02	49.23	1000.0
2011-06-07	BLV	ETF	81.09	81.56	80.88	81.54	97900.0
2011-06-07	BMVP	ETF	15.22	15.31	15.18	15.21	16381.0
2011-06-07	BND	ETF	81.56	81.73	81.49	81.72	917800.0
2011-06-07	BNO	ETF	38.4	39.065	38.245	38.805	33400.0
2011-06-07	BRF	ETF	57.28	58.01	57.2007	57.74	439349.0
2011-06-07	BSCE	ETF	21.16	21.21	21.11	21.196	14864.0
2011-06-07	BSV	ETF	81.13	81.18	81.1	81.18	353200.0
2011-06-07	BTF	ETF	82.14999999999999	83.35000000000001	82.14999999999999	82.44999999999999	3079.4

> showing 50 of 851 rows — these rows as CSV

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