PREVIEW / etf_daily / 2017-04-07

all etf daily files

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

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-07	SPY	ETF	235.15	236.0	234.64	235.2	74412300.0
2017-04-07	QQQ	ETF	131.99	132.37	131.5	131.97	16743064.0
2017-04-07	IWM	ETF	135.21	136.03	134.75	135.52	24300200.0
2017-04-07	DIA	ETF	206.19	207.07	205.89	206.38	2609300.0
2017-04-07	GLD	ETF	120.3	120.67	119.14	119.46	12351100.0
2017-04-07	TLT	ETF	121.84	122.25	120.69	120.71	10270000.0
2017-04-07	AADR	ETF	46.78	46.83	46.32	46.6	9200.0
2017-04-07	AAXJ	ETF	63.13	63.27	63.01	63.14	1075400.0
2017-04-07	ACSI	ETF	27.8703	27.8703	27.8703	27.8703	223.0
2017-04-07	ACTX	ETF	109.151	111.216	103.8409	107.971	1105.0
2017-04-07	ACWF	ETF	25.75	25.75	25.6	25.6115	16929.0
2017-04-07	ACWI	ETF	63.07	63.27	63.02	63.1	952900.0
2017-04-07	ACWV	ETF	77.28	77.47	77.22	77.28	138200.0
2017-04-07	ACWX	ETF	43.42	43.54	43.39	43.43	331041.0
2017-04-07	ADRE	ETF	36.56	36.7613	36.56	36.61	4744.0
2017-04-07	AFK	ETF	21.06	21.17	20.84	21.1	81524.0
2017-04-07	AFTY	ETF	13.9	13.9	13.9	13.9	200.0
2017-04-07	AGG	ETF	108.8	108.89	108.42	108.44	1783600.0
2017-04-07	AGGY	ETF	50.05	50.06	49.87	49.87	16200.0
2017-04-07	AGNG	ETF	17.0	17.0	17.0	17.0	100.0
2017-04-07	AGQ	ETF	41.93	42.04	39.61	40.15	243800.0
2017-04-07	AGZ	ETF	113.385	113.42	112.98	112.98	14692.0
2017-04-07	AGZD	ETF	24.02	24.035	24.01	24.035	1400.0
2017-04-07	AIA	ETF	52.68	52.75	52.5997	52.5997	13467.0
2017-04-07	AIQ	ETF	10.0	10.2	9.9	10.1	56046.0
2017-04-07	AIRR	ETF	23.65	23.99	23.65	23.97	21600.0
2017-04-07	AIVI	ETF	39.37	39.48	39.33	39.4	23900.0
2017-04-07	ALTY	ETF	15.498	15.498	15.43	15.43	1700.0
2017-04-07	AMJ	ETF	32.69	32.71	32.52	32.55	604006.0
2017-04-07	AMLP	ETF	64.15	64.2	63.85	63.9	1738900.0
2017-04-07	AMZA	ETF	107.3	107.5	106.9	107.1	42450.0
2017-04-07	ANGL	ETF	29.55	29.61	29.48	29.5	536800.0
2017-04-07	AOA	ETF	49.71	49.77	49.62	49.67	65100.0
2017-04-07	AOK	ETF	33.34	33.34	33.2434	33.26	54229.0
2017-04-07	AOM	ETF	36.32	36.33	36.2048	36.25	121202.0
2017-04-07	AOR	ETF	42.21	42.23	42.1383	42.16	72721.0
2017-04-07	ARCM	ETF	100.0	100.0	100.0	100.0	40000.0
2017-04-07	ARGT	ETF	28.83	28.99	28.8	28.83	49200.0
2017-04-07	ARKG	ETF	19.91	20.2	19.91	20.2	5000.0
2017-04-07	ARKK	ETF	23.76	23.95	23.76	23.944	6400.0
2017-04-07	ARKQ	ETF	24.56	24.66	24.49	24.66	4300.0
2017-04-07	ARKW	ETF	28.98	29.14	28.93	29.087	6200.0
2017-04-07	ASEA	ETF	14.11	14.24	14.11	14.24	800.0
2017-04-07	ASET	ETF	26.71	26.71	26.71	26.71	319.0
2017-04-07	ASHR	ETF	25.44	25.53	25.43	25.44	559100.0
2017-04-07	ASHS	ETF	34.55	34.69	34.55	34.66	3500.0
2017-04-07	ATMP	ETF	24.16	24.16	23.92	24.06	36900.0
2017-04-07	BAB	ETF	29.49	29.5	29.35	29.36	129262.0
2017-04-07	BAL	ETF	48.03	48.0502	47.5101	47.586	25433.0
2017-04-07	BBC	ETF	21.79	21.79	21.52	21.77	4847.0

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

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