PREVIEW / etf_daily / 2017-11-07

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-07.parquet
  size:    59 KB
  rows:    1,522

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-11-07	SPY	ETF	258.97	259.35	258.09	258.67	57502200.0
2017-11-07	QQQ	ETF	153.67	154.0823	153.34	153.88	21333062.0
2017-11-07	IWM	ETF	148.8	148.85	146.54	147.0	29549300.0
2017-11-07	DIA	ETF	235.7	235.88	234.69	235.42	2390700.0
2017-11-07	GLD	ETF	121.51	121.56	120.78	121.21	4165900.0
2017-11-07	TLT	ETF	126.23	126.78	126.13	126.64	6422700.0
2017-11-07	AADR	ETF	57.81	57.81	57.14	57.29	50900.0
2017-11-07	AAXJ	ETF	76.49	76.58	76.09	76.18	1627300.0
2017-11-07	ACSI	ETF	29.49	29.49	29.455	29.455	1700.0
2017-11-07	ACTX	ETF	40.1204	41.3004	37.7603	41.3004	814.0
2017-11-07	ACWF	ETF	30.19	30.19	29.98	30.05	10567.0
2017-11-07	ACWI	ETF	70.73	70.85	70.49	70.7	1731100.0
2017-11-07	ACWV	ETF	82.67	82.9	82.67	82.9	91100.0
2017-11-07	ACWX	ETF	49.58	49.603	49.31	49.44	1306495.0
2017-11-07	ADRE	ETF	43.68	43.68	43.17	43.2491	3400.0
2017-11-07	AFK	ETF	23.81	23.9089	23.6	23.84	11500.0
2017-11-07	AFTY	ETF	18.25	18.25	18.1	18.13	14400.0
2017-11-07	AGG	ETF	109.58	109.61	109.49	109.58	2015500.0
2017-11-07	AGGY	ETF	50.77	50.84	50.76	50.83	180600.0
2017-11-07	AGNG	ETF	19.49	19.49	19.401	19.44	3100.0
2017-11-07	AGQ	ETF	35.13	35.14	34.09	34.23	89200.0
2017-11-07	AGZ	ETF	113.59	113.64	113.5	113.595	11821.0
2017-11-07	AGZD	ETF	24.09	24.15	24.09	24.15	4600.0
2017-11-07	AIA	ETF	65.99	66.09	65.6961	65.77	27197.0
2017-11-07	AIEQ	ETF	24.76	24.76	24.37	24.45	381200.0
2017-11-07	AIRR	ETF	26.615	26.615	26.29	26.32	11300.0
2017-11-07	AIVI	ETF	43.52	43.52	43.36	43.42	5400.0
2017-11-07	ALTY	ETF	15.39	15.39	15.39	15.39	26700.0
2017-11-07	AMJ	ETF	27.44	27.865	27.44	27.78	3661991.0
2017-11-07	AMLP	ETF	54.5	55.2	54.3	55.0	3407420.0
2017-11-07	AMZA	ETF	84.0	85.6	83.9	85.4	133950.0
2017-11-07	ANGL	ETF	30.26	30.26	30.12	30.12	209100.0
2017-11-07	AOA	ETF	54.65	54.7	54.5	54.58	56000.0
2017-11-07	AOK	ETF	34.76	34.76	34.64	34.64	113529.0
2017-11-07	AOM	ETF	38.35	38.37	38.25	38.32	187561.0
2017-11-07	AOR	ETF	45.5	45.522	45.38	45.46	65571.0
2017-11-07	ARGT	ETF	33.29	33.3	32.58	32.73	69200.0
2017-11-07	ARKG	ETF	25.28	25.28	24.601	24.63	42700.0
2017-11-07	ARKK	ETF	35.3	35.3	34.83	34.89	145300.0
2017-11-07	ARKQ	ETF	33.5	33.679	33.33	33.48	36500.0
2017-11-07	ARKW	ETF	43.74	43.75	43.09	43.26	126600.0
2017-11-07	ASEA	ETF	16.01	16.01	15.98	15.99	900.0
2017-11-07	ASHR	ETF	31.03	31.05	30.94	31.0	637200.0
2017-11-07	ASHS	ETF	35.9	36.06	35.9	35.99	2300.0
2017-11-07	ASHX	ETF	22.95	22.959	22.95	22.959	1220.0
2017-11-07	ATMP	ETF	20.94	21.0	20.79	20.96	15100.0
2017-11-07	BAB	ETF	30.66	30.7	30.63	30.65	95999.0
2017-11-07	BAL	ETF	45.4	45.4	44.84	45.0	11851.0
2017-11-07	BAR	ETF	12.797	12.797	12.762	12.762	14000.0
2017-11-07	BBC	ETF	27.96	28.3115	27.32	27.42	28953.0

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

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