PREVIEW / etf_daily / 2017-03-15

all etf daily files

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

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-15	SPY	ETF	237.56	239.44	237.29	238.95	96081800.0
2017-03-15	QQQ	ETF	131.58	132.405	131.14	132.1	22709139.0
2017-03-15	IWM	ETF	136.29	138.02	135.97	137.73	31230400.0
2017-03-15	DIA	ETF	208.83	209.91	208.71	209.58	5737000.0
2017-03-15	GLD	ETF	114.29	116.25	114.02	116.25	13524100.0
2017-03-15	TLT	ETF	117.56	118.83	117.43	118.5	14600500.0
2017-03-15	AADR	ETF	44.81	45.97	44.81	45.81	10800.0
2017-03-15	AAXJ	ETF	61.44	62.56	61.32	62.38	897600.0
2017-03-15	ACSI	ETF	27.91	28.07	27.91	28.07	4859.0
2017-03-15	ACTX	ETF	106.496	114.461	101.4809	102.6609	1004.0
2017-03-15	ACWF	ETF	25.85	25.85	25.85	25.85	3000.0
2017-03-15	ACWI	ETF	62.91	63.53	62.82	63.41	3030700.0
2017-03-15	ACWV	ETF	76.57	77.38	76.55	77.25	108300.0
2017-03-15	ACWX	ETF	42.74	43.31	42.68	43.3	635909.0
2017-03-15	ADRE	ETF	35.82	36.32	35.6365	36.32	11219.0
2017-03-15	AFK	ETF	20.9	20.9892	20.62	20.9499	7515.0
2017-03-15	AFTY	ETF	13.87	14.03	13.87	14.03	1100.0
2017-03-15	AGG	ETF	107.25	107.79	107.2	107.78	2162900.0
2017-03-15	AGGY	ETF	49.15	49.52	49.15	49.52	8700.0
2017-03-15	AGNG	ETF	16.73	16.73	16.73	16.73	1000.0
2017-03-15	AGQ	ETF	35.64	37.57	35.32	37.49	331400.0
2017-03-15	AGZ	ETF	112.24	112.57	112.19	112.57	34865.0
2017-03-15	AGZD	ETF	24.065	24.075	24.065	24.07	6800.0
2017-03-15	AIA	ETF	51.42	52.2775	51.28	52.2	24148.0
2017-03-15	AIQ	ETF	10.1	10.1	9.85	9.85	2476.0
2017-03-15	AIRR	ETF	23.67	23.99	23.638	23.95	107300.0
2017-03-15	AIVI	ETF	38.67	39.34	38.67	39.32	134200.0
2017-03-15	ALTY	ETF	15.27	15.317	15.141	15.26	14900.0
2017-03-15	AMJ	ETF	32.05	32.19	31.71	32.11	4088225.0
2017-03-15	AMLP	ETF	63.35	63.7	63.0	63.65	1525180.0
2017-03-15	AMZA	ETF	110.1	111.0	109.4	110.8	67030.0
2017-03-15	ANGL	ETF	28.9	29.24	28.85	29.2	622900.0
2017-03-15	AOA	ETF	49.45	49.93	49.44	49.84	31100.0
2017-03-15	AOK	ETF	32.91	33.1699	32.91	33.1	55137.0
2017-03-15	AOM	ETF	36.06	36.292	35.98	36.24	66604.0
2017-03-15	AOR	ETF	41.92	42.3065	41.92	42.29	49025.0
2017-03-15	ARGT	ETF	26.73	27.31	26.73	27.26	21700.0
2017-03-15	ARKG	ETF	20.46	20.786	20.46	20.786	1200.0
2017-03-15	ARKK	ETF	23.38	23.6	23.38	23.595	2200.0
2017-03-15	ARKQ	ETF	23.9	24.1	23.9	24.1	2800.0
2017-03-15	ARKW	ETF	28.6	28.72	28.471	28.71	4700.0
2017-03-15	ASEA	ETF	13.61	13.91	13.61	13.9	2900.0
2017-03-15	ASET	ETF	25.91	25.97	25.91	25.97	1085.0
2017-03-15	ASHR	ETF	24.99	25.3	24.94	25.27	684500.0
2017-03-15	ASHS	ETF	34.08	34.4	34.08	34.4	2300.0
2017-03-15	ATMP	ETF	23.39	23.76	23.37	23.7	63200.0
2017-03-15	BAB	ETF	29.12	29.2	29.0	29.14	455898.0
2017-03-15	BAL	ETF	50.51	50.85	50.51	50.85	2520.0
2017-03-15	BBC	ETF	23.59	24.0	23.35	23.95	12669.0
2017-03-15	BBH	ETF	121.53	123.15	121.4	122.82	49800.0

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

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