PREVIEW / etf_daily / 2014-03-19

all etf daily files

  file:    by_date/etf_daily/2014/2014-03-19.parquet
  size:    43 KB
  rows:    1,079

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-19	SPY	ETF	187.68	187.94	185.47	186.66	176267300.0
2014-03-19	QQQ	ETF	90.56	90.66	89.45	90.04	40869371.0
2014-03-19	IWM	ETF	119.68	119.74	118.1	119.0	47423000.0
2014-03-19	DIA	ETF	163.26	163.57	161.15	162.19	7936400.0
2014-03-19	GLD	ETF	129.55	129.68	127.94	128.09	12932900.0
2014-03-19	TLT	ETF	107.92	107.98	106.81	107.26	11557600.0
2014-03-19	AADR	ETF	37.6	37.7	37.4	37.57	13200.0
2014-03-19	AAXJ	ETF	57.45	57.48	56.44	56.72	387500.0
2014-03-19	ACWI	ETF	57.46	57.58	56.66	56.98	665600.0
2014-03-19	ACWV	ETF	63.19	63.72	63.03	63.17	79300.0
2014-03-19	ACWX	ETF	45.55	45.64	44.89	45.12	176285.0
2014-03-19	ADRE	ETF	34.52	34.79	34.27	34.39	17592.0
2014-03-19	AFK	ETF	31.18	31.18	30.55	30.6	41456.0
2014-03-19	AGG	ETF	107.98	107.98	107.41	107.52	702000.0
2014-03-19	AGQ	ETF	70.32	71.67	68.95	69.43	479100.0
2014-03-19	AGZ	ETF	111.7758	111.81	111.4001	111.62	10813.0
2014-03-19	AGZD	ETF	25.06	25.06	25.06	25.06	1000.0
2014-03-19	AIA	ETF	44.2	44.3367	43.86	43.86	5280.0
2014-03-19	AIQ	ETF	29.0	29.0	28.1701	28.96	34404.0
2014-03-19	AIRR	ETF	20.03	20.03	19.7	19.8	73300.0
2014-03-19	AIVI	ETF	48.91	48.99	48.25	48.31	33800.0
2014-03-19	ALTL	ETF	33.6914	33.6914	33.6914	33.6914	100.0
2014-03-19	AMJ	ETF	46.45	46.62	45.809	45.95	531521.0
2014-03-19	AMLP	ETF	88.1	88.2	87.1	87.25	833340.0
2014-03-19	ANGL	ETF	27.79	27.79	27.66	27.66	2300.0
2014-03-19	AOA	ETF	45.15	45.15	44.63	44.75	38300.0
2014-03-19	AOK	ETF	32.35	32.35	32.14	32.14	40469.0
2014-03-19	AOM	ETF	34.74	34.74	34.41	34.52	30259.0
2014-03-19	AOR	ETF	39.0	39.0	38.62	38.74	46123.0
2014-03-19	ARGT	ETF	19.27	19.27	19.1	19.1	1600.0
2014-03-19	ASEA	ETF	15.78	15.8	15.49	15.56	81800.0
2014-03-19	ASHR	ETF	21.8	21.8	21.6	21.71	153700.0
2014-03-19	ATMP	ETF	27.55	27.55	27.3	27.34	36100.0
2014-03-19	AVIV	ETF	25.03	25.18	24.55	24.64	252770.0
2014-03-19	AWAY	ETF	43.62	43.945	41.76	41.93	1308007.0
2014-03-19	BAB	ETF	28.58	28.6	28.3801	28.47	149907.0
2014-03-19	BAL	ETF	57.8875	58.08	57.86	57.86	3180.0
2014-03-19	BALT	ETF	6.85	7.05	6.634	6.75	544982.0
2014-03-19	BBH	ETF	101.0	101.09	98.98	99.61	88600.0
2014-03-19	BCM	ETF	40.63	40.836	40.61	40.765	3634.0
2014-03-19	BFOR	ETF	7.715	7.715	7.6	7.645	124400.0
2014-03-19	BIB	ETF	50.12	50.12	47.875	48.55	541666.0
2014-03-19	BICK	ETF	23.12	23.24	23.12	23.24	736.0
2014-03-19	BIL	ETF	91.54	91.56	91.54	91.56	97950.0
2014-03-19	BIS	ETF	584.0	609.6	582.0	599.6	5572.5
2014-03-19	BIV	ETF	83.57	83.63	82.83	83.09	193100.0
2014-03-19	BIZD	ETF	20.52	20.56	20.46	20.46	15300.0
2014-03-19	BJK	ETF	53.59	53.6	52.84	53.04	12600.0
2014-03-19	BKF	ETF	34.03	34.16	33.65	33.69	60158.0
2014-03-19	BKLN	ETF	24.79	24.79	24.77	24.78	1393200.0

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

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