PREVIEW / etf_daily / 2013-11-19

all etf daily files

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

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-19	SPY	ETF	179.33	179.87	178.72	179.03	93891000.0
2013-11-19	QQQ	ETF	83.09	83.49	82.76	82.9	25545292.0
2013-11-19	IWM	ETF	110.11	110.69	108.99	109.37	36081300.0
2013-11-19	DIA	ETF	159.58	159.93	159.09	159.33	5017300.0
2013-11-19	GLD	ETF	122.97	123.4	122.83	122.95	3666500.0
2013-11-19	TLT	ETF	104.95	105.14	104.41	104.56	7251100.0
2013-11-19	AADR	ETF	36.5	36.5	36.35	36.35	1200.0
2013-11-19	AAXJ	ETF	61.03	61.18	60.82	60.84	344400.0
2013-11-19	ACWI	ETF	56.78	56.83	56.51	56.62	1107000.0
2013-11-19	ACWV	ETF	64.41	64.67	64.41	64.48	14600.0
2013-11-19	ACWX	ETF	46.52	46.5615	46.34	46.415	156121.0
2013-11-19	ADRE	ETF	38.77	38.77	38.32	38.41	9187.0
2013-11-19	AFK	ETF	31.18	31.39	31.13	31.264	5503.0
2013-11-19	AGG	ETF	107.48	107.5	107.26	107.28	1703100.0
2013-11-19	AGQ	ETF	69.96	70.72	69.56	69.76	205275.0
2013-11-19	AGZ	ETF	111.95	111.99	111.5801	111.87	17605.0
2013-11-19	AIA	ETF	49.24	49.258	49.05	49.06	27435.0
2013-11-19	AIQ	ETF	24.75	25.255	24.14	24.55	29891.0
2013-11-19	AIVI	ETF	47.05	47.26	47.02	47.09	16400.0
2013-11-19	ALTL	ETF	31.92	31.92	31.92	31.92	400.0
2013-11-19	AMJ	ETF	45.96	45.96	45.2	45.21	402089.0
2013-11-19	AMLP	ETF	87.35	88.1	87.0	87.1	665620.0
2013-11-19	ANGL	ETF	26.89	26.9	26.89	26.89	2700.0
2013-11-19	AOA	ETF	43.75	43.81	43.63	43.63	6100.0
2013-11-19	AOK	ETF	31.9199	31.9299	31.85	31.87	46609.0
2013-11-19	AOM	ETF	34.12	34.13	34.0	34.02	78239.0
2013-11-19	AOR	ETF	38.06	38.12	37.9403	37.98	39195.0
2013-11-19	ARGT	ETF	19.86	19.86	19.59	19.59	7600.0
2013-11-19	ASEA	ETF	16.74	16.75	16.65	16.65	9800.0
2013-11-19	ASHR	ETF	25.78	25.82	25.61	25.61	656400.0
2013-11-19	ATMP	ETF	26.77	26.77	26.53	26.53	49800.0
2013-11-19	AVIV	ETF	25.92	25.92	25.38	25.64	141868.0
2013-11-19	AWAY	ETF	36.45	36.6399	35.63	35.79	1551064.0
2013-11-19	BAB	ETF	27.52	27.5799	27.45	27.48	139914.0
2013-11-19	BAL	ETF	48.49	48.94	48.49	48.52	12702.0
2013-11-19	BALT	ETF	4.75	4.875	4.64	4.66	675681.0
2013-11-19	BBH	ETF	82.4	82.81	81.64	82.51	100400.0
2013-11-19	BCM	ETF	39.016	39.016	38.86	38.86	3290.0
2013-11-19	BFOR	ETF	7.195	7.21	7.13	7.16	162800.0
2013-11-19	BIB	ETF	32.015	32.5523	31.5025	32.14	124224.0
2013-11-19	BICK	ETF	24.99	24.99	24.9199	24.9199	1304.0
2013-11-19	BIL	ETF	91.56	91.58	91.56	91.56	93750.0
2013-11-19	BIS	ETF	1020.4	1020.4	980.0	991.2	2725.0
2013-11-19	BIV	ETF	83.87	83.93	83.68	83.75	516700.0
2013-11-19	BIZD	ETF	21.05	21.05	20.97	21.01	6800.0
2013-11-19	BJK	ETF	49.8	49.8	49.12	49.28	21000.0
2013-11-19	BKF	ETF	39.37	39.37	38.8828	38.91	53792.0
2013-11-19	BKLN	ETF	24.83	24.83	24.8	24.82	1444900.0
2013-11-19	BLV	ETF	83.25	83.29	82.82	82.86	55600.0
2013-11-19	BMVP	ETF	22.0133	22.0666	21.8933	21.8933	2998.0

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

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