PREVIEW / etf_daily / 2018-01-31

all etf daily files

  file:    by_date/etf_daily/2018/2018-01-31.parquet
  size:    61 KB
  rows:    1,572

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-01-31	SPY	ETF	282.73	283.3	280.68	281.9	108364800.0
2018-01-31	QQQ	ETF	169.67	169.9899	168.34	169.4	42449199.0
2018-01-31	IWM	ETF	157.74	158.42	155.92	156.36	27468900.0
2018-01-31	DIA	ETF	263.0	263.16	260.29	261.44	5360500.0
2018-01-31	GLD	ETF	127.45	127.85	126.4	127.65	13418900.0
2018-01-31	TLT	ETF	122.87	122.93	121.94	122.73	18045100.0
2018-01-31	AADR	ETF	62.63	62.7	62.3	62.42	70200.0
2018-01-31	AAXJ	ETF	82.28	82.39	81.32	81.78	4074300.0
2018-01-31	ACSI	ETF	32.32	32.32	32.29	32.29	492.0
2018-01-31	ACTX	ETF	90.2708	100.8909	86.1408	90.8608	2027.0
2018-01-31	ACWF	ETF	32.62	32.62	32.3448	32.4696	4957.0
2018-01-31	ACWI	ETF	76.47	76.56	75.91	76.2	2062100.0
2018-01-31	ACWV	ETF	87.21	87.21	86.63	86.92	172000.0
2018-01-31	ACWX	ETF	52.93	53.0199	52.56	52.68	728541.0
2018-01-31	ADRE	ETF	48.19	48.9	47.8773	48.08	12447.0
2018-01-31	AFK	ETF	26.03	26.3084	25.7	26.16	19081.0
2018-01-31	AFTY	ETF	20.01	20.125	20.01	20.06	43900.0
2018-01-31	AGG	ETF	108.2	108.21	107.88	108.1	8066500.0
2018-01-31	AGGY	ETF	50.1	50.1	50.0	50.07	46000.0
2018-01-31	AGNG	ETF	21.12	21.12	20.78	20.78	3500.0
2018-01-31	AGQ	ETF	34.88	35.65	34.55	35.24	162600.0
2018-01-31	AGZ	ETF	112.03	112.05	111.9102	112.001	11607.0
2018-01-31	AGZD	ETF	24.15	24.165	24.11	24.165	2400.0
2018-01-31	AIA	ETF	72.22	72.2899	71.3511	71.79	180618.0
2018-01-31	AIEQ	ETF	27.71	27.76	27.33	27.4	171000.0
2018-01-31	AIRR	ETF	27.885	27.99	27.42	27.42	25800.0
2018-01-31	AIVI	ETF	45.85	45.85	45.64	45.71	18600.0
2018-01-31	ALTY	ETF	15.54	15.54	15.31	15.31	2600.0
2018-01-31	AMJ	ETF	29.41	29.73	29.07	29.35	3005067.0
2018-01-31	AMLP	ETF	57.65	57.8	56.95	57.0	2532400.0
2018-01-31	AMZA	ETF	86.2	86.91	86.1	86.3	142460.0
2018-01-31	ANGL	ETF	30.17	30.28	30.06	30.11	2311800.0
2018-01-31	AOA	ETF	56.3	56.31	55.98	56.13	124000.0
2018-01-31	AOK	ETF	35.02	35.04	34.89	35.0	102204.0
2018-01-31	AOM	ETF	38.78	38.8	38.6102	38.71	142347.0
2018-01-31	AOR	ETF	46.31	46.35	46.1	46.23	138169.0
2018-01-31	ARGT	ETF	37.89	38.26	37.89	38.16	39400.0
2018-01-31	ARKG	ETF	28.76	28.76	27.5	27.69	255600.0
2018-01-31	ARKK	ETF	41.9	41.926	40.931	41.24	466900.0
2018-01-31	ARKQ	ETF	36.22	36.26	35.89	36.09	67600.0
2018-01-31	ARKW	ETF	50.99	51.21	50.51	50.68	174400.0
2018-01-31	ASEA	ETF	18.07	18.22	17.9	17.9	6400.0
2018-01-31	ASET	ETF	29.045	29.045	29.0445	29.0445	337.0
2018-01-31	ASHR	ETF	34.04	34.13	33.87	33.98	731900.0
2018-01-31	ASHS	ETF	35.94	35.98	35.88	35.93	8900.0
2018-01-31	ASHX	ETF	23.37	23.405	23.37	23.3989	2451.0
2018-01-31	ATMP	ETF	22.0	22.0	21.69	21.69	90400.0
2018-01-31	BAB	ETF	29.99	30.0	29.86	29.92	522956.0
2018-01-31	BAL	ETF	51.0	51.66	51.0	51.51	2274.0
2018-01-31	BAR	ETF	13.422	13.464	13.318	13.464	82130.0

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

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