PREVIEW / etf_daily / 2013-11-18

all etf daily files

  file:    by_date/etf_daily/2013/2013-11-18.parquet
  size:    43 KB
  rows:    1,056

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-11-18	SPY	ETF	180.35	180.5	179.02	179.42	104796000.0
2013-11-18	QQQ	ETF	83.94	84.105	82.98	83.14	31679608.0
2013-11-18	IWM	ETF	111.32	111.42	109.75	110.05	35509600.0
2013-11-18	DIA	ETF	159.71	159.95	159.07	159.44	5236000.0
2013-11-18	GLD	ETF	123.7	123.96	122.55	122.9	6241300.0
2013-11-18	TLT	ETF	104.65	105.41	104.65	105.36	5451300.0
2013-11-18	AADR	ETF	37.1	37.1	36.88	36.88	2900.0
2013-11-18	AAXJ	ETF	61.2	61.49	60.97	61.02	246700.0
2013-11-18	ACWI	ETF	57.0	57.11	56.67	56.77	783300.0
2013-11-18	ACWV	ETF	64.76	64.91	64.59	64.63	61600.0
2013-11-18	ACWX	ETF	46.77	46.88	46.52	46.56	185668.0
2013-11-18	ADRE	ETF	38.72	38.97	38.62	38.62	12826.0
2013-11-18	AFK	ETF	31.2	31.48	31.2	31.31	12212.0
2013-11-18	AGG	ETF	107.43	107.57	107.42	107.57	856100.0
2013-11-18	AGQ	ETF	71.76	72.0	69.44	70.16	386900.0
2013-11-18	AGZ	ETF	111.85	111.94	111.55	111.6001	10502.0
2013-11-18	AIA	ETF	49.17	49.228	48.8	48.94	41470.0
2013-11-18	AIQ	ETF	25.12	26.539	24.01	24.69	45992.0
2013-11-18	AIVI	ETF	47.48	47.55	47.2	47.24	70600.0
2013-11-18	AMJ	ETF	46.0	46.11	45.74	45.84	796052.0
2013-11-18	AMLP	ETF	88.15	88.3	87.75	88.0	528580.0
2013-11-18	ANGL	ETF	26.95	27.0	26.95	27.0	900.0
2013-11-18	AOA	ETF	44.02	44.04	43.74	43.77	77500.0
2013-11-18	AOK	ETF	32.0	32.0	31.84	31.84	37285.0
2013-11-18	AOM	ETF	34.24	34.24	34.101	34.15	37589.0
2013-11-18	AOR	ETF	38.25	38.25	38.04	38.1	134197.0
2013-11-18	ARGT	ETF	20.15	20.15	20.0	20.0	8900.0
2013-11-18	ASEA	ETF	16.7	16.93	16.7	16.93	7700.0
2013-11-18	ASHR	ETF	26.05	26.2	25.91	26.0	1170600.0
2013-11-18	ATMP	ETF	27.44	27.44	26.89	26.89	25300.0
2013-11-18	AVIV	ETF	25.81	26.02	25.68	25.99	156102.0
2013-11-18	AWAY	ETF	38.0	38.09	36.07	36.5	2419505.0
2013-11-18	BAB	ETF	27.49	27.62	27.474	27.62	122582.0
2013-11-18	BAL	ETF	48.9	48.979	48.65	48.65	6752.0
2013-11-18	BALT	ETF	4.84	4.84	4.63	4.65	932293.0
2013-11-18	BBH	ETF	83.64	84.0	82.05	82.3	65300.0
2013-11-18	BCM	ETF	38.918	38.918	38.88	38.88	1226.0
2013-11-18	BFOR	ETF	7.26	7.27	7.1575	7.185	303200.0
2013-11-18	BIB	ETF	33.125	33.625	31.8625	32.2325	180000.0
2013-11-18	BICK	ETF	24.99	25.1	24.99	25.1	2310.0
2013-11-18	BIL	ETF	91.56	91.58	91.56	91.56	180200.0
2013-11-18	BIS	ETF	961.2	998.0	944.4	992.8	262.0
2013-11-18	BIV	ETF	83.84	84.03	83.84	83.99	180200.0
2013-11-18	BIZD	ETF	21.04	21.15	21.0	21.01	7400.0
2013-11-18	BJK	ETF	50.27	50.57	50.1	50.1	26900.0
2013-11-18	BKF	ETF	39.22	39.589	39.15	39.23	149738.0
2013-11-18	BKLN	ETF	24.83	24.83	24.8	24.82	2085900.0
2013-11-18	BLV	ETF	82.91	83.3	82.77	83.27	46600.0
2013-11-18	BMVP	ETF	22.156	22.1933	22.0733	22.0733	4364.0
2013-11-18	BND	ETF	80.97	81.12	80.97	81.1	875500.0

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

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