PREVIEW / etf_daily / 2017-12-12

all etf daily files

  file:    by_date/etf_daily/2017/2017-12-12.parquet
  size:    59 KB
  rows:    1,510

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-12-12	SPY	ETF	267.21	267.32	266.35	266.78	85195800.0
2017-12-12	QQQ	ETF	155.81	156.15	155.36	155.69	20310252.0
2017-12-12	IWM	ETF	151.7	151.93	150.82	150.88	25854800.0
2017-12-12	DIA	ETF	244.93	245.87	244.8	245.44	3282400.0
2017-12-12	GLD	ETF	117.65	118.17	117.4	118.15	8020100.0
2017-12-12	TLT	ETF	126.17	126.41	125.67	126.38	7502400.0
2017-12-12	AADR	ETF	56.81	56.95	56.61	56.79	25900.0
2017-12-12	AAXJ	ETF	75.21	75.28	75.03	75.15	1067400.0
2017-12-12	ACSI	ETF	31.09	31.13	31.039	31.039	1740.0
2017-12-12	ACTX	ETF	63.4256	76.1107	63.4256	72.5707	938.0
2017-12-12	ACWF	ETF	30.52	30.52	30.41	30.41	5838.0
2017-12-12	ACWI	ETF	71.79	71.97	71.75	71.88	1731000.0
2017-12-12	ACWV	ETF	84.52	84.64	84.41	84.56	87700.0
2017-12-12	ACWX	ETF	49.38	49.5	49.33	49.46	430315.0
2017-12-12	ADRE	ETF	41.96	42.205	41.83	42.1355	8438.0
2017-12-12	AFK	ETF	24.2999	24.2999	23.9125	24.1	5056.0
2017-12-12	AFTY	ETF	18.37	18.37	18.14	18.295	9500.0
2017-12-12	AGG	ETF	109.1	109.11	108.95	109.1	3142400.0
2017-12-12	AGGY	ETF	50.61	50.68	50.61	50.654	70200.0
2017-12-12	AGNG	ETF	19.481	19.63	19.481	19.62	2000.0
2017-12-12	AGQ	ETF	29.08	29.36	28.9	29.31	170700.0
2017-12-12	AGZ	ETF	113.11	113.18	113.1	113.16	12799.0
2017-12-12	AGZD	ETF	24.145	24.15	24.14	24.15	2800.0
2017-12-12	AIA	ETF	64.79	64.84	64.66	64.84	20484.0
2017-12-12	AIEQ	ETF	25.7	25.79	25.68	25.69	126700.0
2017-12-12	AIRR	ETF	26.84	26.857	26.7	26.71	13300.0
2017-12-12	AIVI	ETF	43.1	43.28	43.1	43.26	5900.0
2017-12-12	ALTY	ETF	15.45	15.45	15.31	15.32	8000.0
2017-12-12	AMJ	ETF	26.91	27.43	26.85	27.17	5970922.0
2017-12-12	AMLP	ETF	53.1	54.2	53.0	53.65	4878320.0
2017-12-12	AMZA	ETF	83.7	85.2	83.2	84.6	84440.0
2017-12-12	ANGL	ETF	29.99	30.01	29.94	30.01	295400.0
2017-12-12	AOA	ETF	55.27	55.33	55.2	55.3	67800.0
2017-12-12	AOK	ETF	34.52	34.54	34.46	34.53	94604.0
2017-12-12	AOM	ETF	38.54	38.562	38.4	38.53	133775.0
2017-12-12	AOR	ETF	45.79	45.9	45.79	45.83	79871.0
2017-12-12	ARCM	ETF	100.2	100.2	100.2	100.2	50000.0
2017-12-12	ARGT	ETF	33.96	34.39	33.96	34.34	75100.0
2017-12-12	ARKG	ETF	24.88	24.88	24.177	24.26	48300.0
2017-12-12	ARKK	ETF	37.22	37.78	37.051	37.54	458000.0
2017-12-12	ARKQ	ETF	33.92	34.046	33.66	33.84	61700.0
2017-12-12	ARKW	ETF	46.75	47.149	46.02	46.85	307200.0
2017-12-12	ASEA	ETF	16.84	16.84	16.63	16.7	4700.0
2017-12-12	ASET	ETF	28.74	28.8	28.71	28.7859	2913.0
2017-12-12	ASHR	ETF	30.59	30.63	30.5	30.56	695000.0
2017-12-12	ASHS	ETF	34.04	34.18	34.04	34.13	7400.0
2017-12-12	ASHX	ETF	22.59	22.6	22.59	22.6	523.0
2017-12-12	ATMP	ETF	20.42	20.58	20.22	20.4	157500.0
2017-12-12	BAB	ETF	30.61	30.61	30.52	30.56	79393.0
2017-12-12	BAL	ETF	48.771	48.7861	48.1972	48.36	17108.0

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

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