PREVIEW / etf_daily / 2011-06-20

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-20.parquet
  size:    36 KB
  rows:    848

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-20	SPY	ETF	126.62	127.97	126.58	127.7	159479000.0
2011-06-20	QQQ	ETF	53.66	54.23	53.64	54.07	37402830.0
2011-06-20	IWM	ETF	77.96	79.23	77.93	78.95	53343900.0
2011-06-20	DIA	ETF	119.35	120.74	119.34	120.54	5679800.0
2011-06-20	GLD	ETF	150.08	150.79	149.58	150.03	10463400.0
2011-06-20	TLT	ETF	97.33	97.36	96.59	97.02	6613800.0
2011-06-20	AADR	ETF	30.1	30.22	29.93	30.17	2700.0
2011-06-20	AAXJ	ETF	59.23	59.77	59.23	59.77	168100.0
2011-06-20	ACTV	ETF	18.09	18.23	18.0	18.18	67251.0
2011-06-20	ACWI	ETF	46.73	46.96	46.49	46.94	616900.0
2011-06-20	ACWX	ETF	43.52	43.74	43.4748	43.72	25960.0
2011-06-20	ADRE	ETF	43.78	44.2	43.62	44.12	42741.0
2011-06-20	AFK	ETF	31.76	32.02	31.73	31.95	36776.0
2011-06-20	AGG	ETF	107.52	107.52	107.29	107.35	731900.0
2011-06-20	AGQ	ETF	353.16	358.92	348.88	356.14	437450.0
2011-06-20	AGZ	ETF	110.8001	110.8899	110.7801	110.868	6216.0
2011-06-20	AIA	ETF	45.23	45.53	45.111	45.4814	43929.0
2011-06-20	AIQ	ETF	19.3	19.5	18.9	19.0	9222.0
2011-06-20	AIS	ETF	1.97	2.0	1.91	1.94	637134.0
2011-06-20	AIVI	ETF	46.2	46.44	46.15	46.44	16400.0
2011-06-20	AMJ	ETF	35.25	35.58	35.22	35.56	441156.0
2011-06-20	AMLP	ETF	77.75	78.0	77.45	78.0	171140.0
2011-06-20	AOA	ETF	34.65	34.97	34.65	34.89	116800.0
2011-06-20	AOK	ETF	29.0959	29.16	29.0959	29.15	7677.0
2011-06-20	AOM	ETF	30.36	30.4336	30.36	30.39	3900.0
2011-06-20	AOR	ETF	31.96	32.12	31.96	32.08	4288.0
2011-06-20	ARB	ETF	37.88	38.68	37.77	38.33	114973.0
2011-06-20	ARGT	ETF	28.78	28.78	28.56	28.72	3000.0
2011-06-20	ASEA	ETF	15.92	16.0	15.92	15.98	5400.0
2011-06-20	BAB	ETF	26.64	26.661	26.49	26.57	124991.0
2011-06-20	BAL	ETF	78.11	78.44	76.54	76.85	63741.0
2011-06-20	BALT	ETF	5.92	6.37	5.92	6.07	214097.0
2011-06-20	BBH	ETF	34.34	34.6733	34.34	34.6733	66000.0
2011-06-20	BCM	ETF	46.53	46.538	46.2	46.538	2300.0
2011-06-20	BIB	ETF	8.6875	8.94	8.6875	8.8856	37976.0
2011-06-20	BICK	ETF	30.46	30.54	30.24	30.46	14636.0
2011-06-20	BIL	ETF	91.72	91.72	91.7	91.72	102900.0
2011-06-20	BIS	ETF	6537.6	6539.2	6480.0	6480.0	1.875
2011-06-20	BITS	ETF	20.84	21.44	20.84	21.28	396.0
2011-06-20	BIV	ETF	85.09	85.09	84.76	84.92	91500.0
2011-06-20	BJK	ETF	31.92	32.3	31.87	32.18	15800.0
2011-06-20	BKF	ETF	45.94	46.06	45.82	45.98	74738.0
2011-06-20	BKLN	ETF	24.75	24.76	24.7	24.73	36100.0
2011-06-20	BLV	ETF	81.64	81.87	81.32	81.59	17100.0
2011-06-20	BMVP	ETF	14.82	15.02	14.82	14.96	5945.0
2011-06-20	BND	ETF	81.85	81.87	81.67	81.73	804700.0
2011-06-20	BNO	ETF	37.39	37.5	37.135	37.24	188600.0
2011-06-20	BRF	ETF	55.27	55.75	55.12	55.45	154289.0
2011-06-20	BSCE	ETF	21.16	21.21	21.15	21.2	14594.0
2011-06-20	BSV	ETF	81.28	81.3	81.19	81.26	333800.0

> showing 50 of 848 rows — these rows as CSV

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