PREVIEW / etf_daily / 2017-04-04

all etf daily files

  file:    by_date/etf_daily/2017/2017-04-04.parquet
  size:    54 KB
  rows:    1,354

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-04-04	SPY	ETF	235.0	235.58	234.56	235.48	56466200.0
2017-04-04	QQQ	ETF	131.9	132.53	131.87	132.51	13400022.0
2017-04-04	IWM	ETF	135.93	136.55	135.35	135.87	25642600.0
2017-04-04	DIA	ETF	206.02	206.77	205.81	206.65	2555400.0
2017-04-04	GLD	ETF	119.59	119.77	119.38	119.62	4687300.0
2017-04-04	TLT	ETF	121.37	121.59	120.95	121.01	6976700.0
2017-04-04	AADR	ETF	46.67	47.25	46.65	47.05	14800.0
2017-04-04	AAXJ	ETF	63.15	63.38	63.09	63.31	1048600.0
2017-04-04	ACSI	ETF	27.83	27.83	27.83	27.83	303.0
2017-04-04	ACTX	ETF	110.331	115.051	106.201	107.381	945.0
2017-04-04	ACWF	ETF	25.6901	25.6901	25.6901	25.6901	388.0
2017-04-04	ACWI	ETF	63.09	63.29	63.0	63.27	1977500.0
2017-04-04	ACWV	ETF	77.2	77.41	77.15	77.37	228500.0
2017-04-04	ACWX	ETF	43.5	43.67	43.44	43.65	536453.0
2017-04-04	ADRE	ETF	36.76	36.92	36.71	36.9147	7066.0
2017-04-04	AFK	ETF	20.82	20.82	20.56	20.7	4870.0
2017-04-04	AGG	ETF	108.61	108.65	108.52	108.57	1627500.0
2017-04-04	AGGY	ETF	49.92	49.97	49.9	49.925	6200.0
2017-04-04	AGQ	ETF	41.59	41.94	41.17	41.64	58800.0
2017-04-04	AGZ	ETF	113.15	113.2208	113.05	113.17	8213.0
2017-04-04	AGZD	ETF	24.045	24.045	23.99	23.99	3600.0
2017-04-04	AIA	ETF	52.8	53.1094	52.8	53.0	34204.0
2017-04-04	AIQ	ETF	9.95	10.15	9.95	10.0	9770.0
2017-04-04	AIRR	ETF	23.41	23.6	23.33	23.431	103200.0
2017-04-04	AIVI	ETF	39.41	39.62	39.38	39.58	67100.0
2017-04-04	ALTY	ETF	15.66	15.66	15.5	15.5	400.0
2017-04-04	AMJ	ETF	32.26	32.46	32.11	32.43	751721.0
2017-04-04	AMLP	ETF	63.7	63.9	63.35	63.8	1268720.0
2017-04-04	AMZA	ETF	107.2	107.2	106.0	107.0	155070.0
2017-04-04	ANGL	ETF	29.46	29.51	29.41	29.48	136300.0
2017-04-04	AOA	ETF	49.99	49.99	49.65	49.75	81800.0
2017-04-04	AOK	ETF	33.29	33.3	33.24	33.25	134565.0
2017-04-04	AOM	ETF	36.25	36.3444	36.21	36.31	78826.0
2017-04-04	AOR	ETF	42.18	42.25	42.13	42.25	66659.0
2017-04-04	ARCM	ETF	100.0	100.0	100.0	100.0	40000.0
2017-04-04	ARGT	ETF	28.81	28.96	28.65	28.89	213500.0
2017-04-04	ARKG	ETF	20.49	20.49	20.409	20.409	600.0
2017-04-04	ARKK	ETF	23.93	23.93	23.93	23.93	900.0
2017-04-04	ARKQ	ETF	24.69	24.7	24.557	24.58	6400.0
2017-04-04	ARKW	ETF	28.965	28.99	28.92	28.92	3700.0
2017-04-04	ASHR	ETF	25.24	25.3	25.21	25.29	469100.0
2017-04-04	ASHS	ETF	33.92	33.95	33.8	33.92	2200.0
2017-04-04	ASHX	ETF	19.7	19.7	19.66	19.66	330.0
2017-04-04	ATMP	ETF	23.72	23.91	23.58	23.91	71100.0
2017-04-04	BAB	ETF	29.41	29.4499	29.364	29.38	84698.0
2017-04-04	BAL	ETF	48.7072	48.79	48.39	48.79	32766.0
2017-04-04	BBC	ETF	22.695	22.98	22.4301	22.54	35857.0
2017-04-04	BBH	ETF	118.1	118.72	118.1	118.67	12900.0
2017-04-04	BBP	ETF	37.01	37.46	37.01	37.117	6100.0
2017-04-04	BCI	ETF	24.98	24.98	24.973	24.973	300.0

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

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