PREVIEW / etf_daily / 2013-10-22

all etf daily files

  file:    by_date/etf_daily/2013/2013-10-22.parquet
  size:    42 KB
  rows:    1,045

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
2013-10-22	SPY	ETF	174.91	175.93	174.43	175.41	126663000.0
2013-10-22	QQQ	ETF	82.62	82.9	81.93	82.45	43944821.0
2013-10-22	IWM	ETF	110.95	111.49	110.37	110.76	38112600.0
2013-10-22	DIA	ETF	154.03	154.86	153.82	154.25	7501700.0
2013-10-22	GLD	ETF	128.25	129.81	128.22	129.34	8849000.0
2013-10-22	TLT	ETF	107.6	108.12	107.56	107.89	9708500.0
2013-10-22	AADR	ETF	37.05	37.12	37.05	37.05	400.0
2013-10-22	AAXJ	ETF	61.35	61.88	61.35	61.45	1211700.0
2013-10-22	ACTV	ETF	14.4	14.42	14.39	14.41	1252377.0
2013-10-22	ACWI	ETF	56.29	56.66	56.26	56.49	691200.0
2013-10-22	ACWV	ETF	63.96	64.34	63.87	64.21	179400.0
2013-10-22	ACWX	ETF	46.98	47.2	46.87	47.07	161349.0
2013-10-22	ADRE	ETF	39.18	39.41	39.06	39.19	25554.0
2013-10-22	AFK	ETF	31.78	31.99	31.65	31.94	37620.0
2013-10-22	AGG	ETF	107.98	108.07	107.92	108.04	1572300.0
2013-10-22	AGQ	ETF	85.52	88.08	85.4	87.16	488025.0
2013-10-22	AGZ	ETF	111.5	111.7566	111.2801	111.405	7198.0
2013-10-22	AIA	ETF	48.67	48.93	48.6	48.6	73465.0
2013-10-22	AIQ	ETF	31.38	32.4	30.62	31.32	27114.0
2013-10-22	AIVI	ETF	47.48	47.89	47.48	47.83	45400.0
2013-10-22	AMJ	ETF	45.86	46.27	45.769	46.03	625576.0
2013-10-22	AMLP	ETF	89.35	89.9	89.2	89.65	591340.0
2013-10-22	ANGL	ETF	26.8	27.05	26.8	27.02	1700.0
2013-10-22	AOA	ETF	43.43	43.63	43.43	43.5	22900.0
2013-10-22	AOK	ETF	31.9299	31.93	31.86	31.86	194182.0
2013-10-22	AOM	ETF	33.95	34.08	33.95	34.05	13324.0
2013-10-22	AOR	ETF	37.83	37.95	37.7901	37.87	64583.0
2013-10-22	ARGT	ETF	21.82	21.83	21.56	21.71	7400.0
2013-10-22	ASEA	ETF	17.19	17.45	17.18	17.33	7900.0
2013-10-22	ATMP	ETF	26.85	26.95	26.8	26.93	113000.0
2013-10-22	AVIV	ETF	24.74	24.76	24.29	24.62	160882.0
2013-10-22	AWAY	ETF	28.69	29.35	28.6	29.23	1066165.0
2013-10-22	BAB	ETF	27.7	27.8	27.6815	27.76	92874.0
2013-10-22	BAL	ETF	52.98	52.98	52.65	52.6781	4493.0
2013-10-22	BALT	ETF	5.16	5.19	4.86	5.1	912271.0
2013-10-22	BBH	ETF	80.64	82.37	80.45	82.26	96100.0
2013-10-22	BCM	ETF	40.706	40.706	40.706	40.706	209.0
2013-10-22	BFOR	ETF	7.11	7.15	7.0825	7.1075	384000.0
2013-10-22	BIB	ETF	30.6325	32.0165	30.6325	32.01	278464.0
2013-10-22	BICK	ETF	25.36	25.5	25.36	25.38	1771.0
2013-10-22	BIL	ETF	91.56	91.58	91.56	91.58	100200.0
2013-10-22	BIS	ETF	1037.2	1044.8	1005.6	1005.6	171.5
2013-10-22	BIV	ETF	84.37	84.5	84.26	84.49	260500.0
2013-10-22	BIZD	ETF	20.65	20.67	20.58	20.65	11200.0
2013-10-22	BJK	ETF	51.35	51.35	50.59	51.05	54900.0
2013-10-22	BKF	ETF	39.29	39.667	39.29	39.44	128228.0
2013-10-22	BKLN	ETF	24.74	24.76	24.72	24.75	3756100.0
2013-10-22	BLV	ETF	84.53	84.69	84.43	84.67	49200.0
2013-10-22	BMVP	ETF	21.42	21.6	21.42	21.51	4656.0
2013-10-22	BND	ETF	81.32	81.43	81.32	81.37	763900.0

> showing 50 of 1,045 rows — these rows as CSV

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