PREVIEW / etf_daily / 2011-04-28

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-28.parquet
  size:    36 KB
  rows:    852

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-28	SPY	ETF	135.43	136.29	135.41	136.11	124791100.0
2011-04-28	QQQ	ETF	59.06	59.23	58.88	59.13	48138342.0
2011-04-28	IWM	ETF	85.6	86.5	85.52	86.08	43464600.0
2011-04-28	DIA	ETF	126.56	127.54	126.54	127.42	11788000.0
2011-04-28	GLD	ETF	149.3	150.0	148.6	149.82	20754000.0
2011-04-28	TLT	ETF	93.22	93.6	92.97	93.6	8110200.0
2011-04-28	AADR	ETF	31.75	31.76	31.74	31.76	1300.0
2011-04-28	AAXJ	ETF	64.6	64.7	64.3	64.58	268200.0
2011-04-28	ACWI	ETF	50.24	50.58	50.22	50.54	807300.0
2011-04-28	ACWX	ETF	47.28	47.51	47.25	47.48	74127.0
2011-04-28	ADRE	ETF	48.19	48.37	47.98	48.24	50546.0
2011-04-28	AFK	ETF	34.15	34.165	33.61	33.9972	16070.0
2011-04-28	AGG	ETF	106.28	106.39	106.17	106.37	573100.0
2011-04-28	AGQ	ETF	732.44	764.16	695.04	730.52	3107500.0
2011-04-28	AGZ	ETF	109.7301	110.0	109.7301	109.93	24541.0
2011-04-28	AIA	ETF	49.27	49.27	49.032	49.23	54549.0
2011-04-28	AIQ	ETF	22.7	23.1	22.7	22.85	29333.0
2011-04-28	AIS	ETF	1.74	1.8	1.74	1.8	1049162.0
2011-04-28	AIVI	ETF	50.04	50.34	49.97	50.34	10800.0
2011-04-28	AMJ	ETF	39.09	39.28	38.93	39.28	760129.0
2011-04-28	AMLP	ETF	82.8	83.65	82.8	83.65	188300.0
2011-04-28	AOA	ETF	36.9	37.06	36.9	37.03	17200.0
2011-04-28	AOK	ETF	29.55	29.57	29.51	29.5518	4614.0
2011-04-28	AOM	ETF	31.07	31.11	31.038	31.098	18781.0
2011-04-28	AOR	ETF	33.26	33.35	33.25	33.34	124727.0
2011-04-28	ARB	ETF	37.47	38.15	37.03	38.08	167809.0
2011-04-28	ARGT	ETF	30.2	30.2	30.04	30.04	3850.0
2011-04-28	ASEA	ETF	16.66	16.72	16.62	16.71	14900.0
2011-04-28	BAB	ETF	25.79	25.87	25.77	25.86	115839.0
2011-04-28	BAL	ETF	84.01	85.54	81.69	83.82	264617.0
2011-04-28	BALT	ETF	8.07	8.17	8.0	8.15	106325.0
2011-04-28	BBH	ETF	34.6	34.6767	34.4833	34.5633	47400.0
2011-04-28	BCM	ETF	50.63	50.7	50.06	50.24	6700.0
2011-04-28	BIB	ETF	10.1013	10.165	9.9375	10.1115	305144.0
2011-04-28	BICK	ETF	34.68	34.79	34.554	34.68	8285.0
2011-04-28	BIL	ETF	91.7	91.72	91.7	91.7	97050.0
2011-04-28	BIS	ETF	5872.0	5872.0	5846.4	5846.4	2.5
2011-04-28	BITS	ETF	24.72	24.72	24.72	24.72	75.0
2011-04-28	BIV	ETF	83.2	83.23	83.0	83.15	87400.0
2011-04-28	BJK	ETF	34.94	34.99	34.7	34.84	7400.0
2011-04-28	BKF	ETF	50.29	50.29	49.61	50.02	299437.0
2011-04-28	BKLN	ETF	25.27	25.28	25.26	25.28	232900.0
2011-04-28	BLNG	ETF	52.1	52.22	52.1	52.22	1000.0
2011-04-28	BLV	ETF	79.34	79.84	79.34	79.84	21500.0
2011-04-28	BMVP	ETF	16.03	16.08	16.02	16.06	6956.0
2011-04-28	BND	ETF	80.79	80.87	80.74	80.85	1046600.0
2011-04-28	BNO	ETF	41.69	42.095	41.25	41.535	305800.0
2011-04-28	BRF	ETF	58.82	58.84	57.5	57.95	451021.0
2011-04-28	BSCE	ETF	21.16	21.16	21.06	21.09	15247.0
2011-04-28	BSV	ETF	80.69	80.74	80.66	80.71	380900.0

> showing 50 of 852 rows — these rows as CSV

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