PREVIEW / etf_daily / 2014-06-19

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-19.parquet
  size:    44 KB
  rows:    1,097

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-06-19	SPY	ETF	196.43	196.6	195.8	196.48	85929000.0
2014-06-19	QQQ	ETF	93.1	93.17	92.49	92.91	38427402.0
2014-06-19	IWM	ETF	118.17	118.23	117.1	117.86	30915900.0
2014-06-19	DIA	ETF	169.02	169.19	168.54	169.09	3028000.0
2014-06-19	GLD	ETF	124.33	127.23	124.32	126.94	24374800.0
2014-06-19	TLT	ETF	112.51	112.56	110.74	110.96	14215500.0
2014-06-19	AADR	ETF	38.91	39.01	38.9	38.97	16100.0
2014-06-19	AAXJ	ETF	62.9	62.97	62.72	62.87	901600.0
2014-06-19	ACWI	ETF	61.28	61.28	61.04	61.18	975400.0
2014-06-19	ACWV	ETF	67.28	67.56	67.28	67.54	56100.0
2014-06-19	ACWX	ETF	49.23	49.25	49.07	49.16	396445.0
2014-06-19	ADRE	ETF	39.26	39.3199	39.21	39.29	3970.0
2014-06-19	AFK	ETF	32.94	32.98	32.59	32.79	10687.0
2014-06-19	AGG	ETF	109.0	109.03	108.68	108.75	690000.0
2014-06-19	AGQ	ETF	65.5	70.48	65.5	69.43	922100.0
2014-06-19	AGZ	ETF	112.45	112.475	112.2582	112.3699	8445.0
2014-06-19	AIA	ETF	48.47	48.537	48.39	48.4701	25542.0
2014-06-19	AIQ	ETF	27.01	27.12	26.73	27.07	25171.0
2014-06-19	AIRR	ETF	19.18	19.32	19.18	19.32	12500.0
2014-06-19	AIVI	ETF	52.2	52.21	52.06	52.13	13500.0
2014-06-19	ALTL	ETF	35.51	35.51	35.4825	35.4825	444.0
2014-06-19	AMJ	ETF	50.25	50.93	50.02	50.86	325859.0
2014-06-19	AMLP	ETF	92.0	93.25	91.65	93.15	971760.0
2014-06-19	ANGL	ETF	28.4	28.4	28.34	28.35	3000.0
2014-06-19	AOA	ETF	47.31	47.31	47.02	47.13	43000.0
2014-06-19	AOK	ETF	33.15	33.15	32.96	33.0	16055.0
2014-06-19	AOM	ETF	35.86	35.86	35.6	35.67	25119.0
2014-06-19	AOR	ETF	40.52	40.52	40.3	40.39	31287.0
2014-06-19	ARGT	ETF	21.02	21.05	20.9	21.05	4200.0
2014-06-19	ASEA	ETF	16.65	16.67	16.63	16.63	1400.0
2014-06-19	ASHR	ETF	22.04	22.04	21.96	22.03	379100.0
2014-06-19	ASHS	ETF	25.01	25.03	24.96	24.97	8800.0
2014-06-19	ATMP	ETF	30.4	30.65	30.37	30.65	23600.0
2014-06-19	AVIV	ETF	28.16	28.66	28.16	28.57	444968.0
2014-06-19	AWAY	ETF	32.46	33.64	32.41	33.56	2257446.0
2014-06-19	BAB	ETF	29.13	29.209	28.93	29.01	94561.0
2014-06-19	BAL	ETF	51.98	52.4	51.92	52.27	7466.0
2014-06-19	BALT	ETF	6.63	6.71	6.58	6.67	311797.0
2014-06-19	BBH	ETF	92.83	93.0	92.34	92.96	71600.0
2014-06-19	BCHP	ETF	20.6	20.71	20.6	20.63	32840.0
2014-06-19	BCM	ETF	42.029	42.03	42.015	42.015	5851.0
2014-06-19	BFOR	ETF	7.8125	7.825	7.7725	7.7925	38400.0
2014-06-19	BIB	ETF	43.975	44.275	43.45	44.075	304760.0
2014-06-19	BICK	ETF	26.79	26.79	26.79	26.79	50.0
2014-06-19	BIL	ETF	91.52	91.54	91.52	91.54	75700.0
2014-06-19	BIS	ETF	598.0	610.4	597.6	601.2	4567.5
2014-06-19	BIV	ETF	84.46	84.47	84.04	84.19	521500.0
2014-06-19	BIZD	ETF	20.38	20.38	20.22	20.29	31000.0
2014-06-19	BJK	ETF	48.52	49.04	48.43	48.83	6300.0
2014-06-19	BKF	ETF	39.3	39.33	39.0001	39.13	42495.0

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

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