PREVIEW / etf_daily / 2014-03-21

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-21.parquet
  size:    44 KB
  rows:    1,075

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
2014-03-21	SPY	ETF	187.71	189.02	186.03	186.2	163128000.0
2014-03-21	QQQ	ETF	90.61	90.65	88.825	89.0	62812715.0
2014-03-21	IWM	ETF	119.72	120.26	118.56	118.61	47110800.0
2014-03-21	DIA	ETF	163.47	164.2	162.53	162.63	7629500.0
2014-03-21	GLD	ETF	129.04	129.09	128.41	128.47	7237300.0
2014-03-21	TLT	ETF	107.41	108.32	107.37	108.23	8986200.0
2014-03-21	AADR	ETF	37.65	37.8	37.3	37.3	1100.0
2014-03-21	AAXJ	ETF	56.95	57.41	56.74	56.85	452100.0
2014-03-21	ACWI	ETF	57.29	57.55	56.92	56.98	724800.0
2014-03-21	ACWV	ETF	63.33	63.55	62.89	62.91	21900.0
2014-03-21	ACWX	ETF	45.2	45.43	44.97	45.02	188677.0
2014-03-21	ADRE	ETF	34.59	34.9348	34.59	34.62	8876.0
2014-03-21	AFK	ETF	31.18	31.4599	31.18	31.35	2179.0
2014-03-21	AGG	ETF	107.52	107.65	107.46	107.59	756600.0
2014-03-21	AGQ	ETF	68.72	68.72	67.28	67.52	233700.0
2014-03-21	AGZ	ETF	111.3801	111.4999	111.38	111.43	8510.0
2014-03-21	AIA	ETF	43.96	44.3199	43.84	43.84	16101.0
2014-03-21	AIQ	ETF	29.78	31.49	28.92	31.45	105040.0
2014-03-21	AIRR	ETF	19.96	20.05	19.85	19.89	16900.0
2014-03-21	AIVI	ETF	48.51	48.67	48.21	48.23	91500.0
2014-03-21	ALTL	ETF	34.0075	34.0108	34.0075	34.0108	417.0
2014-03-21	AMJ	ETF	46.19	46.59	45.8	46.13	892838.0
2014-03-21	AMLP	ETF	87.65	87.65	87.25	87.4	590620.0
2014-03-21	ANGL	ETF	27.69	27.69	27.49	27.51	18500.0
2014-03-21	AOA	ETF	45.06	45.16	44.8	44.8	10900.0
2014-03-21	AOK	ETF	32.2599	32.26	32.14	32.14	13103.0
2014-03-21	AOM	ETF	34.6399	34.679	34.511	34.54	23599.0
2014-03-21	AOR	ETF	38.96	39.02	38.78	38.79	56884.0
2014-03-21	ARGT	ETF	19.17	19.18	19.1	19.1	1300.0
2014-03-21	ASEA	ETF	15.5	15.52	15.37	15.38	115700.0
2014-03-21	ASHR	ETF	21.95	22.25	21.95	22.07	328000.0
2014-03-21	ATMP	ETF	26.28	27.42	26.28	27.21	15600.0
2014-03-21	AVIV	ETF	24.65	24.81	24.48	24.64	384547.0
2014-03-21	AWAY	ETF	41.62	42.07	40.31	40.87	2049120.0
2014-03-21	BAB	ETF	28.57	28.61	28.495	28.61	82568.0
2014-03-21	BAL	ETF	57.99	58.54	57.98	58.38	17462.0
2014-03-21	BALT	ETF	6.65	6.65	6.4	6.59	529919.0
2014-03-21	BBH	ETF	100.1	100.1	93.84	94.16	433700.0
2014-03-21	BCM	ETF	40.54	40.54	40.54	40.54	400.0
2014-03-21	BFOR	ETF	7.685	7.745	7.6325	7.6375	324000.0
2014-03-21	BIB	ETF	48.475	48.625	43.38	43.64	1784008.0
2014-03-21	BICK	ETF	23.51	23.57	23.413	23.413	2433.0
2014-03-21	BIL	ETF	91.56	91.56	91.54	91.56	138200.0
2014-03-21	BIS	ETF	602.4	666.4	592.4	663.6	21992.0
2014-03-21	BIV	ETF	83.01	83.23	83.0	83.19	225200.0
2014-03-21	BIZD	ETF	20.81	20.81	20.47	20.52	24900.0
2014-03-21	BJK	ETF	52.44	52.52	51.85	51.85	12600.0
2014-03-21	BKF	ETF	34.06	34.6	33.97	34.24	127159.0
2014-03-21	BKLN	ETF	24.78	24.8	24.77	24.8	1124000.0
2014-03-21	BLV	ETF	85.41	85.85	85.41	85.83	20600.0

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

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