PREVIEW / etf_daily / 2018-04-24

all etf daily files

  file:    by_date/etf_daily/2018/2018-04-24.parquet
  size:    61 KB
  rows:    1,562

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
2018-04-24	SPY	ETF	267.73	267.98	261.28	262.98	112885500.0
2018-04-24	QQQ	ETF	162.62	162.905	157.39	158.46	70256751.0
2018-04-24	IWM	ETF	155.9	156.63	153.19	154.43	24859700.0
2018-04-24	DIA	ETF	245.39	245.56	238.12	240.09	7088900.0
2018-04-24	GLD	ETF	125.78	126.34	125.67	126.23	4733100.0
2018-04-24	TLT	ETF	118.21	118.45	117.76	117.95	8190800.0
2018-04-24	AADR	ETF	59.23	59.76	58.54	58.95	24800.0
2018-04-24	AAXJ	ETF	76.35	76.58	75.21	75.54	561200.0
2018-04-24	ACSI	ETF	30.98	30.98	30.605	30.7	1211.0
2018-04-24	ACTX	ETF	62.5406	64.9006	59.5905	64.9006	372.0
2018-04-24	ACWF	ETF	31.05	31.05	30.5141	30.6874	8661.0
2018-04-24	ACWI	ETF	72.61	72.69	71.34	71.67	2147300.0
2018-04-24	ACWV	ETF	83.95	83.95	82.83	83.11	74000.0
2018-04-24	ACWX	ETF	50.29	50.329	49.76	49.9	607811.0
2018-04-24	ADRE	ETF	43.58	43.58	43.049	43.1	4364.0
2018-04-24	AFK	ETF	25.19	25.635	25.19	25.3	10342.0
2018-04-24	AFTY	ETF	17.58	17.58	17.41	17.41	3100.0
2018-04-24	AGG	ETF	105.85	105.92	105.78	105.81	3442300.0
2018-04-24	AGGY	ETF	48.6	48.62	48.53	48.567	56700.0
2018-04-24	AGNG	ETF	19.55	19.55	19.16	19.16	8700.0
2018-04-24	AGQ	ETF	32.08	32.49	32.0	32.4	70600.0
2018-04-24	AGZ	ETF	110.86	111.0117	110.85	110.9001	18280.0
2018-04-24	AGZD	ETF	24.015	24.05	23.98	24.05	3000.0
2018-04-24	AIA	ETF	67.3	67.31	66.11	66.45	105856.0
2018-04-24	AIEQ	ETF	26.67	26.75	26.131	26.3	27300.0
2018-04-24	AIRR	ETF	26.16	26.223	25.47	25.61	32600.0
2018-04-24	AIVI	ETF	44.41	44.42	44.08	44.13	7700.0
2018-04-24	ALTY	ETF	14.536	14.54	14.495	14.54	700.0
2018-04-24	AMJ	ETF	26.21	26.33	25.57	25.66	3555714.0
2018-04-24	AMLP	ETF	51.25	51.5	50.0	50.25	3729300.0
2018-04-24	AMZA	ETF	74.3	74.8	72.3	72.4	121000.0
2018-04-24	ANGL	ETF	29.21	29.31	29.0	29.04	1480400.0
2018-04-24	AOA	ETF	53.91	53.94	53.1	53.33	55800.0
2018-04-24	AOK	ETF	34.1	34.1	33.9	33.95	42449.0
2018-04-24	AOM	ETF	37.61	37.61	37.32	37.41	84677.0
2018-04-24	AOR	ETF	44.64	44.64	44.1664	44.27	90531.0
2018-04-24	ARGT	ETF	35.48	35.72	35.09	35.26	24000.0
2018-04-24	ARKG	ETF	26.33	26.43	25.545	25.74	218600.0
2018-04-24	ARKK	ETF	40.3	40.72	39.16	39.63	285900.0
2018-04-24	ARKQ	ETF	33.37	33.56	32.405	32.72	31300.0
2018-04-24	ARKW	ETF	50.88	51.02	49.04	49.52	218200.0
2018-04-24	ASEA	ETF	17.99	17.99	17.85	17.85	1200.0
2018-04-24	ASET	ETF	27.7689	27.8171	27.7682	27.8171	1085.0
2018-04-24	ASHR	ETF	30.45	30.57	30.26	30.37	1546300.0
2018-04-24	ASHS	ETF	34.47	34.49	34.19	34.2	2800.0
2018-04-24	ASHX	ETF	20.97	20.97	20.97	20.97	101.0
2018-04-24	ATMP	ETF	20.03	20.03	19.45	19.54	40100.0
2018-04-24	BAB	ETF	29.54	29.64	29.54	29.6001	109525.0
2018-04-24	BAL	ETF	50.52	50.659	49.43	49.43	2126.0
2018-04-24	BAR	ETF	13.269	13.301	13.269	13.301	11060.0

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

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