PREVIEW / etf_daily / 2017-01-19

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-19.parquet
  size:    54 KB
  rows:    1,360

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-01-19	SPY	ETF	226.84	227.0	225.41	225.91	66608800.0
2017-01-19	QQQ	ETF	123.19	123.65	122.72	122.98	12710659.0
2017-01-19	IWM	ETF	135.14	135.44	133.17	133.75	34105900.0
2017-01-19	DIA	ETF	198.03	198.16	196.69	197.28	3050900.0
2017-01-19	GLD	ETF	114.32	114.96	113.94	114.77	6437000.0
2017-01-19	TLT	ETF	120.49	120.58	119.55	120.18	11795600.0
2017-01-19	AADR	ETF	43.46	43.51	43.35	43.43	7600.0
2017-01-19	AAXJ	ETF	57.6	57.61	57.26	57.43	524200.0
2017-01-19	ACSI	ETF	27.13	27.14	27.05	27.05	5412.0
2017-01-19	ACTX	ETF	54.8705	63.1306	44.8404	55.4605	2546.0
2017-01-19	ACWF	ETF	24.89	24.99	24.77	24.99	2610.0
2017-01-19	ACWI	ETF	60.43	60.45	60.1	60.24	2137900.0
2017-01-19	ACWV	ETF	73.52	73.6	73.17	73.37	399200.0
2017-01-19	ACWX	ETF	41.31	41.33	41.13	41.24	946688.0
2017-01-19	ADRE	ETF	34.28	34.4	34.2001	34.26	3560.0
2017-01-19	AFK	ETF	21.01	21.35	21.01	21.24	12297.0
2017-01-19	AFTY	ETF	13.58	13.601	13.58	13.59	1400.0
2017-01-19	AGG	ETF	108.06	108.16	107.93	108.04	2388000.0
2017-01-19	AGGY	ETF	49.596	49.662	49.523	49.59	8600.0
2017-01-19	AGQ	ETF	35.79	36.67	35.39	36.51	176900.0
2017-01-19	AGZ	ETF	112.74	112.81	112.4625	112.6	40850.0
2017-01-19	AGZD	ETF	24.115	24.155	24.09	24.1	11000.0
2017-01-19	AIA	ETF	48.46	48.59	48.34	48.52	41039.0
2017-01-19	AIQ	ETF	9.6	9.65	9.6	9.6	14001.0
2017-01-19	AIRR	ETF	23.38	23.556	23.227	23.3	39000.0
2017-01-19	AIVI	ETF	38.24	38.34	38.22	38.34	5400.0
2017-01-19	ALTY	ETF	15.3	15.3	15.208	15.24	2300.0
2017-01-19	AMJ	ETF	32.09	32.13	31.8	31.82	1330737.0
2017-01-19	AMLP	ETF	63.5	63.75	63.3	63.35	1101120.0
2017-01-19	AMZA	ETF	109.3	109.5	108.0	108.1	30650.0
2017-01-19	ANGL	ETF	29.24	29.24	29.09	29.12	186500.0
2017-01-19	AOA	ETF	47.92	47.98	47.67	47.81	57900.0
2017-01-19	AOK	ETF	32.69	32.7046	32.57	32.64	185403.0
2017-01-19	AOM	ETF	35.43	35.4704	35.36	35.37	262114.0
2017-01-19	AOR	ETF	40.88	40.9599	40.8125	40.85	307771.0
2017-01-19	ARGT	ETF	25.13	25.22	24.97	24.97	18600.0
2017-01-19	ARKG	ETF	17.712	17.712	17.658	17.71	900.0
2017-01-19	ARKK	ETF	21.95	21.965	21.76	21.83	4700.0
2017-01-19	ARKQ	ETF	23.236	23.28	23.1	23.14	18500.0
2017-01-19	ARKW	ETF	27.14	27.14	27.01	27.01	4000.0
2017-01-19	ASET	ETF	25.9	25.9	25.8	25.8	20801.0
2017-01-19	ASHR	ETF	24.31	24.44	24.3	24.35	1065000.0
2017-01-19	ASHS	ETF	32.15	32.15	32.05	32.05	900.0
2017-01-19	ATMP	ETF	23.68	23.68	23.27	23.28	169700.0
2017-01-19	BAB	ETF	29.17	29.27	29.0101	29.13	240083.0
2017-01-19	BAL	ETF	47.98	48.11	47.81	47.92	4128.0
2017-01-19	BBC	ETF	19.63	19.63	19.2029	19.3	3087.0
2017-01-19	BBH	ETF	112.54	112.65	111.76	112.09	227600.0
2017-01-19	BBP	ETF	35.0	35.0	34.56	34.56	16800.0
2017-01-19	BCM	ETF	27.5129	27.59	27.5129	27.56	5345.0

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

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