PREVIEW / etf_daily / 2016-04-06

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-06.parquet
  size:    50 KB
  rows:    1,256

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
2016-04-06	SPY	ETF	204.19	206.49	203.98	206.42	91839800.0
2016-04-06	QQQ	ETF	109.0	110.71	108.99	110.67	25056031.0
2016-04-06	IWM	ETF	108.93	110.27	108.59	110.17	28157800.0
2016-04-06	DIA	ETF	175.86	177.09	175.24	177.04	4086700.0
2016-04-06	GLD	ETF	116.7	117.39	116.26	116.94	7549400.0
2016-04-06	TLT	ETF	131.53	131.67	130.74	131.23	6393700.0
2016-04-06	AADR	ETF	38.95	38.95	38.01	38.55	1600.0
2016-04-06	AAXJ	ETF	53.02	53.66	52.88	53.64	476000.0
2016-04-06	ACTX	ETF	7.0801	7.0801	4.13	5.31	1233.0
2016-04-06	ACWI	ETF	55.1	55.73	55.01	55.68	2503100.0
2016-04-06	ACWV	ETF	72.89	73.39	72.76	73.35	170900.0
2016-04-06	ACWX	ETF	38.29	38.81	38.25	38.78	487790.0
2016-04-06	ADRE	ETF	30.03	30.3328	30.03	30.3328	1876.0
2016-04-06	AFK	ETF	18.64	18.91	18.3	18.7601	80395.0
2016-04-06	AFTY	ETF	12.92	13.03	12.92	12.98	40600.0
2016-04-06	AGG	ETF	110.8	110.8	110.62	110.75	2027400.0
2016-04-06	AGGY	ETF	50.65	50.68	50.65	50.671	2300.0
2016-04-06	AGQ	ETF	31.24	31.84	31.04	31.37	120800.0
2016-04-06	AGZ	ETF	114.6899	114.71	114.53	114.66	586902.0
2016-04-06	AGZD	ETF	23.79	23.82	23.415	23.415	12800.0
2016-04-06	AIA	ETF	41.97	42.2825	41.93	42.2825	10385.0
2016-04-06	AIQ	ETF	6.94	7.21	6.94	7.09	12516.0
2016-04-06	AIRR	ETF	17.2	17.28	17.12	17.28	3800.0
2016-04-06	AIVI	ETF	37.3	37.6	37.3	37.57	4500.0
2016-04-06	ALTY	ETF	14.15	14.15	14.106	14.106	600.0
2016-04-06	AMJ	ETF	25.98	26.44	25.715	26.26	2063501.0
2016-04-06	AMLP	ETF	51.7	53.2	51.5	52.75	1772520.0
2016-04-06	AMUB	ETF	16.35	16.36	16.35	16.36	340.0
2016-04-06	AMZA	ETF	82.0	84.2	81.0	83.6	6110.0
2016-04-06	ANGL	ETF	25.66	25.71	25.56	25.69	25900.0
2016-04-06	AOA	ETF	44.52	44.9	44.45	44.88	60500.0
2016-04-06	AOK	ETF	32.11	32.2	32.08	32.2	42410.0
2016-04-06	AOM	ETF	34.5	34.62	34.3601	34.62	66304.0
2016-04-06	AOR	ETF	38.93	39.15	38.84	39.15	68233.0
2016-04-06	ARGT	ETF	18.85	18.85	18.66	18.68	15300.0
2016-04-06	ARKG	ETF	18.38	18.38	18.38	18.38	300.0
2016-04-06	ARKK	ETF	19.46	19.483	19.46	19.483	400.0
2016-04-06	ARKQ	ETF	18.96	19.12	18.96	19.12	900.0
2016-04-06	ARKW	ETF	20.7	20.77	20.7	20.76	400.0
2016-04-06	ASEA	ETF	13.3	13.36	13.3	13.36	900.0
2016-04-06	ASHR	ETF	24.7	24.99	24.65	24.99	878900.0
2016-04-06	ASHS	ETF	35.5	35.83	35.5	35.83	60200.0
2016-04-06	ASHX	ETF	21.98	22.05	21.97	22.05	2160.0
2016-04-06	ATMP	ETF	17.32	18.15	17.32	17.59	30300.0
2016-04-06	BAB	ETF	30.38	30.38	30.2	30.27	125809.0
2016-04-06	BAL	ETF	38.48	38.7681	38.31	38.31	6553.0
2016-04-06	BBC	ETF	20.32	21.29	20.32	21.29	19660.0
2016-04-06	BBH	ETF	107.1	112.35	107.1	112.35	187900.0
2016-04-06	BBP	ETF	25.537	26.67	25.537	26.67	27700.0
2016-04-06	BFOR	ETF	7.4425	7.5325	7.4425	7.5275	26000.0

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

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