PREVIEW / etf_daily / 2017-01-25

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-25.parquet
  size:    55 KB
  rows:    1,378

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-25	SPY	ETF	228.7	229.57	228.51	229.57	84437700.0
2017-01-25	QQQ	ETF	124.94	125.46	124.85	125.43	15036221.0
2017-01-25	IWM	ETF	137.06	137.55	136.95	137.21	29127300.0
2017-01-25	DIA	ETF	200.01	200.55	199.75	200.42	4880800.0
2017-01-25	GLD	ETF	114.14	114.44	113.68	114.32	6697500.0
2017-01-25	TLT	ETF	119.28	119.6	118.56	118.8	11115100.0
2017-01-25	AADR	ETF	44.59	44.85	44.47	44.85	33400.0
2017-01-25	AAXJ	ETF	58.79	59.05	58.73	59.02	538800.0
2017-01-25	ACSI	ETF	27.25	27.36	27.23	27.36	5550.0
2017-01-25	ACTX	ETF	96.7609	102.6609	74.9307	85.5508	6993.0
2017-01-25	ACWF	ETF	25.57	25.57	25.57	25.57	400.0
2017-01-25	ACWI	ETF	61.08	61.48	61.08	61.43	2840200.0
2017-01-25	ACWV	ETF	73.89	74.14	73.87	74.08	219900.0
2017-01-25	ACWX	ETF	42.05	42.2299	42.0	42.2	1096050.0
2017-01-25	ADRE	ETF	35.45	35.5498	35.43	35.5498	9513.0
2017-01-25	AFK	ETF	21.6	21.79	21.562	21.7	9486.0
2017-01-25	AGG	ETF	107.98	108.04	107.83	107.92	2912900.0
2017-01-25	AGGY	ETF	49.472	49.5	49.32	49.36	132600.0
2017-01-25	AGQ	ETF	35.77	36.47	35.51	36.39	144700.0
2017-01-25	AGZ	ETF	112.61	113.25	112.0	112.42	72597.0
2017-01-25	AGZD	ETF	24.04	24.06	23.97	23.97	7800.0
2017-01-25	AIA	ETF	49.48	49.65	49.4301	49.63	70350.0
2017-01-25	AIQ	ETF	9.6535	9.75	9.65	9.65	8862.0
2017-01-25	AIRR	ETF	24.34	24.509	24.268	24.47	195600.0
2017-01-25	AIVI	ETF	38.89	39.01	38.89	39.01	6600.0
2017-01-25	ALTY	ETF	15.301	15.369	15.3	15.369	1900.0
2017-01-25	AMJ	ETF	33.1	33.5	32.83	33.41	1940813.0
2017-01-25	AMLP	ETF	65.0	65.45	64.6	65.3	2642600.0
2017-01-25	AMUB	ETF	20.8709	20.8709	20.8709	20.8709	200.0
2017-01-25	AMZA	ETF	111.2	112.18	110.5	112.1	86230.0
2017-01-25	ANGL	ETF	29.28	29.4	29.26	29.36	1099800.0
2017-01-25	AOA	ETF	48.5	48.57	48.34	48.55	76000.0
2017-01-25	AOK	ETF	32.83	32.83	32.7428	32.8	104622.0
2017-01-25	AOM	ETF	35.66	35.67	35.6	35.64	59260.0
2017-01-25	AOR	ETF	41.23	41.36	41.2	41.35	136566.0
2017-01-25	ARGT	ETF	25.88	26.1	25.88	26.03	102200.0
2017-01-25	ARKG	ETF	17.7	17.748	17.64	17.748	1700.0
2017-01-25	ARKK	ETF	22.22	22.3	22.21	22.245	4400.0
2017-01-25	ARKQ	ETF	23.7	23.75	23.64	23.69	5300.0
2017-01-25	ARKW	ETF	27.38	27.7	27.38	27.671	5100.0
2017-01-25	ASEA	ETF	13.55	13.65	13.49	13.61	4300.0
2017-01-25	ASET	ETF	26.06	26.07	26.06	26.07	2453.0
2017-01-25	ASHR	ETF	24.76	24.85	24.76	24.85	909800.0
2017-01-25	ASHS	ETF	32.82	33.14	32.82	33.09	6300.0
2017-01-25	ASHX	ETF	19.2	19.28	19.2	19.28	676.0
2017-01-25	ATMP	ETF	24.04	24.37	24.04	24.32	87900.0
2017-01-25	BAB	ETF	29.06	29.1	28.95	28.97	225040.0
2017-01-25	BAL	ETF	48.34	48.801	48.34	48.7007	8397.0
2017-01-25	BBC	ETF	19.2	19.3607	19.1876	19.1876	3452.0
2017-01-25	BBH	ETF	110.65	111.68	110.65	111.46	48700.0

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

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