PREVIEW / etf_daily / 2011-04-21

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-21.parquet
  size:    36 KB
  rows:    845

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-21	SPY	ETF	133.79	133.84	133.1	133.78	135935400.0
2011-04-21	QQQ	ETF	58.47	58.47	58.16	58.34	43666772.0
2011-04-21	IWM	ETF	84.34	84.48	83.73	84.45	30293300.0
2011-04-21	DIA	ETF	124.63	124.81	124.19	124.79	4019100.0
2011-04-21	GLD	ETF	146.57	147.06	146.32	146.74	10109400.0
2011-04-21	TLT	ETF	92.89	93.23	92.56	92.6	3365600.0
2011-04-21	AAXJ	ETF	64.77	65.07	64.72	65.05	119100.0
2011-04-21	ACWI	ETF	49.55	49.55	49.28	49.47	90500.0
2011-04-21	ACWX	ETF	46.83	46.83	46.59	46.74	33095.0
2011-04-21	ADRE	ETF	48.56	48.834	48.5	48.74	30040.0
2011-04-21	AFK	ETF	33.98	34.038	33.71	33.77	24866.0
2011-04-21	AGG	ETF	105.7	105.83	105.67	105.76	447800.0
2011-04-21	AGQ	ETF	657.84	683.0	647.34	681.92	1617150.0
2011-04-21	AGZ	ETF	109.87	109.87	109.4521	109.46	11309.0
2011-04-21	AIA	ETF	49.27	49.41	49.0876	49.34	29137.0
2011-04-21	AIQ	ETF	23.1	23.1	22.85	23.05	40938.0
2011-04-21	AIS	ETF	1.67	1.67	1.59	1.61	380445.0
2011-04-21	AIVI	ETF	48.71	48.87	48.6	48.68	8900.0
2011-04-21	AMJ	ETF	38.56	38.56	38.349	38.49	461677.0
2011-04-21	AMLP	ETF	82.3	82.8	82.3	82.8	154300.0
2011-04-21	AOA	ETF	36.46	36.46	36.3	36.45	29900.0
2011-04-21	AOK	ETF	29.34	29.4	29.34	29.3644	46917.0
2011-04-21	AOM	ETF	30.85	30.85	30.78	30.8274	24104.0
2011-04-21	AOR	ETF	32.88	32.935	32.84	32.928	48401.0
2011-04-21	ARB	ETF	36.73	37.12	36.53	37.06	53864.0
2011-04-21	ARGT	ETF	30.6	30.64	30.4	30.4	3450.0
2011-04-21	ASEA	ETF	16.52	16.59	16.5	16.52	4200.0
2011-04-21	BAB	ETF	25.6	25.64	25.56	25.57	92455.0
2011-04-21	BAL	ETF	92.91	94.021	91.614	93.05	1118406.0
2011-04-21	BALT	ETF	8.14	8.14	7.95	8.04	92122.0
2011-04-21	BBH	ETF	37.77	38.3067	37.3033	37.3333	178200.0
2011-04-21	BCM	ETF	50.14	51.25	50.07	50.28	4800.0
2011-04-21	BIB	ETF	9.5512	9.5512	9.3562	9.3788	57240.0
2011-04-21	BICK	ETF	35.28	35.3	35.05	35.2254	27104.0
2011-04-21	BIL	ETF	91.7	91.72	91.7	91.7	89850.0
2011-04-21	BIS	ETF	6308.8	6308.8	6308.8	6308.8	0.655
2011-04-21	BITS	ETF	24.4	25.016	24.4	24.44	1600.0
2011-04-21	BIV	ETF	82.42	82.63	82.42	82.59	92100.0
2011-04-21	BJK	ETF	34.57	34.76	34.57	34.74	8400.0
2011-04-21	BKF	ETF	51.48	51.58	51.18	51.5	191250.0
2011-04-21	BKLN	ETF	25.27	25.28	25.25	25.28	113900.0
2011-04-21	BLNG	ETF	50.56	50.69	50.56	50.66	3100.0
2011-04-21	BLV	ETF	78.84	79.24	78.75	78.98	27100.0
2011-04-21	BMVP	ETF	15.893	15.893	15.833	15.88	11497.0
2011-04-21	BND	ETF	80.39	80.48	80.38	80.44	568100.0
2011-04-21	BNO	ETF	41.07	41.285	40.96	41.215	149600.0
2011-04-21	BRF	ETF	59.69	59.87	59.3	59.87	126284.0
2011-04-21	BSCE	ETF	20.97	21.03	20.97	21.0	30519.0
2011-04-21	BSV	ETF	80.45	80.54	80.43	80.52	532800.0
2011-04-21	BTF	ETF	83.6	83.75	83.0	83.6	3487.8

> showing 50 of 845 rows — these rows as CSV

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