PREVIEW / etf_daily / 2018-04-25

all etf daily files

  file:    by_date/etf_daily/2018/2018-04-25.parquet
  size:    60 KB
  rows:    1,545

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-25	SPY	ETF	262.91	264.13	260.85	263.63	103840900.0
2018-04-25	QQQ	ETF	158.8	159.31	156.47	158.65	52089323.0
2018-04-25	IWM	ETF	154.36	154.8	152.96	154.2	21981400.0
2018-04-25	DIA	ETF	240.29	241.33	238.09	240.7	5269200.0
2018-04-25	GLD	ETF	125.23	125.51	125.06	125.41	5985700.0
2018-04-25	TLT	ETF	117.41	117.65	116.94	117.16	6603800.0
2018-04-25	AADR	ETF	58.59	58.59	57.78	57.94	15100.0
2018-04-25	AAXJ	ETF	75.21	75.29	74.68	75.1	389900.0
2018-04-25	ACSI	ETF	30.6199	30.7899	30.6199	30.7899	1399.0
2018-04-25	ACTX	ETF	64.9006	64.9006	5.9001	58.4105	447.0
2018-04-25	ACWF	ETF	30.35	30.6171	30.35	30.5582	6848.0
2018-04-25	ACWI	ETF	71.56	71.78	71.1	71.68	1268500.0
2018-04-25	ACWV	ETF	82.94	83.12	82.67	83.07	194400.0
2018-04-25	ACWX	ETF	49.71	49.825	49.51	49.8	263898.0
2018-04-25	ADRE	ETF	42.92	42.92	42.4436	42.79	3166.0
2018-04-25	AFK	ETF	25.3566	25.3566	25.12	25.12	2679.0
2018-04-25	AFTY	ETF	17.24	17.24	17.17	17.24	1400.0
2018-04-25	AGG	ETF	105.72	105.74	105.6	105.67	3785000.0
2018-04-25	AGGY	ETF	48.45	48.5	48.43	48.43	50000.0
2018-04-25	AGNG	ETF	19.08	19.172	19.07	19.15	2400.0
2018-04-25	AGQ	ETF	31.86	31.88	31.58	31.75	111900.0
2018-04-25	AGZ	ETF	110.82	110.9786	110.8141	110.86	74983.0
2018-04-25	AGZD	ETF	24.115	24.115	23.965	24.035	5600.0
2018-04-25	AIA	ETF	66.26	66.32	65.89	66.29	87112.0
2018-04-25	AIEQ	ETF	26.22	26.35	26.02	26.24	47300.0
2018-04-25	AIRR	ETF	25.57	25.726	25.511	25.61	7500.0
2018-04-25	AIVI	ETF	43.93	44.2	43.93	44.2	81400.0
2018-04-25	ALTY	ETF	14.41	14.47	14.38	14.47	4400.0
2018-04-25	AMJ	ETF	25.48	25.86	25.4	25.86	2816697.0
2018-04-25	AMLP	ETF	50.0	50.65	49.55	50.65	3011940.0
2018-04-25	AMZA	ETF	72.3	73.5	71.5	73.5	71370.0
2018-04-25	ANGL	ETF	29.0	29.09	28.94	29.02	568200.0
2018-04-25	AOA	ETF	53.25	53.33	52.94	53.28	47700.0
2018-04-25	AOK	ETF	33.91	33.95	33.81	33.94	34562.0
2018-04-25	AOM	ETF	37.34	37.3698	37.245	37.36	68467.0
2018-04-25	AOR	ETF	44.22	44.29	44.04	44.25	123618.0
2018-04-25	ARGT	ETF	35.0	35.0	34.52	34.79	99900.0
2018-04-25	ARKG	ETF	25.67	25.83	25.261	25.46	57400.0
2018-04-25	ARKK	ETF	39.55	39.69	38.44	38.86	304100.0
2018-04-25	ARKQ	ETF	32.45	32.515	31.94	32.3	21200.0
2018-04-25	ARKW	ETF	49.52	49.52	48.07	48.67	304000.0
2018-04-25	ASEA	ETF	17.8	17.8	17.6	17.74	2800.0
2018-04-25	ASET	ETF	27.65	27.659	27.6149	27.659	2458.0
2018-04-25	ASHR	ETF	30.19	30.25	29.96	30.19	570400.0
2018-04-25	ASHS	ETF	34.0	34.25	34.0	34.25	300.0
2018-04-25	ASHX	ETF	20.88	20.88	20.88	20.88	140.0
2018-04-25	ATMP	ETF	19.28	19.62	19.28	19.62	25900.0
2018-04-25	BAB	ETF	29.51	29.51	29.41	29.46	301477.0
2018-04-25	BAR	ETF	13.207	13.21	13.2052	13.21	5750.0
2018-04-25	BBC	ETF	31.07	31.07	30.23	30.8602	12788.0

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

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