PREVIEW / etf_daily / 2017-03-30

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-30.parquet
  size:    54 KB
  rows:    1,368

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
2017-03-30	SPY	ETF	235.47	236.52	235.27	236.29	56737900.0
2017-03-30	QQQ	ETF	132.22	132.61	132.08	132.47	16092374.0
2017-03-30	IWM	ETF	136.32	137.38	136.26	137.26	25792900.0
2017-03-30	DIA	ETF	206.3	207.26	206.15	206.96	2849200.0
2017-03-30	GLD	ETF	118.77	119.12	118.32	118.47	6894600.0
2017-03-30	TLT	ETF	121.07	121.09	120.32	120.36	7042400.0
2017-03-30	AADR	ETF	47.04	47.04	46.5	46.73	28300.0
2017-03-30	AAXJ	ETF	63.21	63.37	63.19	63.25	255700.0
2017-03-30	ACSI	ETF	27.92	27.992	27.92	27.992	4698.0
2017-03-30	ACTX	ETF	136.5862	139.2413	106.201	117.8831	4935.0
2017-03-30	ACWF	ETF	25.83	25.95	25.83	25.8912	3973.0
2017-03-30	ACWI	ETF	63.42	63.6	63.38	63.41	1574500.0
2017-03-30	ACWV	ETF	77.28	77.46	77.23	77.31	191100.0
2017-03-30	ACWX	ETF	43.79	43.9	43.72	43.78	530482.0
2017-03-30	ADRE	ETF	36.83	36.961	36.82	36.83	2656.0
2017-03-30	AFK	ETF	21.1999	21.2399	20.8826	20.8826	5234.0
2017-03-30	AGG	ETF	108.52	108.58	108.38	108.41	1733900.0
2017-03-30	AGGY	ETF	49.81	49.81	49.7	49.75	3100.0
2017-03-30	AGNG	ETF	16.88	16.94	16.88	16.94	200.0
2017-03-30	AGQ	ETF	40.92	41.6	40.8	40.85	104900.0
2017-03-30	AGZ	ETF	113.0739	113.1199	112.9	112.95	16159.0
2017-03-30	AGZD	ETF	24.075	24.075	24.05	24.05	4000.0
2017-03-30	AIA	ETF	52.88	53.039	52.88	52.997	8675.0
2017-03-30	AIQ	ETF	10.2	10.3	10.2	10.25	12480.0
2017-03-30	AIRR	ETF	23.36	23.6	23.36	23.56	35300.0
2017-03-30	AIVI	ETF	39.79	39.89	39.67	39.71	28600.0
2017-03-30	ALTY	ETF	15.6	15.63	15.54	15.56	12500.0
2017-03-30	AMJ	ETF	32.05	32.0869	31.7436	31.89	1091263.0
2017-03-30	AMLP	ETF	63.35	63.45	62.95	63.1	981020.0
2017-03-30	AMZA	ETF	111.0	111.1	110.07	110.6	92680.0
2017-03-30	ANGL	ETF	29.4	29.56	29.35	29.52	1992300.0
2017-03-30	AOA	ETF	49.99	50.09	49.96	50.02	39900.0
2017-03-30	AOK	ETF	33.36	33.36	33.25	33.28	32458.0
2017-03-30	AOM	ETF	36.42	36.44	36.37	36.43	69976.0
2017-03-30	AOR	ETF	42.4	42.48	42.38	42.43	67184.0
2017-03-30	ARGT	ETF	28.26	28.34	28.18	28.24	108400.0
2017-03-30	ARKG	ETF	20.63	20.63	20.53	20.598	6400.0
2017-03-30	ARKK	ETF	23.94	23.94	23.769	23.85	2600.0
2017-03-30	ARKQ	ETF	24.54	24.59	24.54	24.589	4500.0
2017-03-30	ARKW	ETF	28.772	28.772	28.726	28.726	2500.0
2017-03-30	ASEA	ETF	14.17	14.18	14.15	14.17	3000.0
2017-03-30	ASET	ETF	26.47	26.47	26.4355	26.449	1536.0
2017-03-30	ASHR	ETF	24.93	24.98	24.86	24.89	595000.0
2017-03-30	ASHS	ETF	33.6	33.62	33.6	33.6	3500.0
2017-03-30	ASHX	ETF	19.42	19.42	19.42	19.42	156.0
2017-03-30	ATMP	ETF	23.61	23.73	23.4	23.57	159300.0
2017-03-30	BAB	ETF	29.42	29.4566	29.33	29.33	97072.0
2017-03-30	BAL	ETF	49.5684	49.58	49.43	49.43	3827.0
2017-03-30	BBC	ETF	23.7	23.7	22.92	23.1457	7831.0
2017-03-30	BBH	ETF	119.57	119.57	118.9	119.21	37000.0

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

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