PREVIEW / etf_daily / 2019-02-21

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-21.parquet
  size:    67 KB
  rows:    1,743

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
2019-02-21	SPY	ETF	277.7	278.1	276.35	277.42	64214700.0
2019-02-21	QQQ	ETF	171.77	172.26	170.71	171.62	25207401.0
2019-02-21	IWM	ETF	157.13	157.37	156.06	156.79	17497000.0
2019-02-21	DIA	ETF	258.94	259.24	257.5	258.53	3197200.0
2019-02-21	GLD	ETF	126.15	126.22	125.05	125.05	8634600.0
2019-02-21	TLT	ETF	121.07	121.16	120.7	120.85	7382500.0
2019-02-21	AAAU	ETF	13.34	13.34	13.23	13.23	20100.0
2019-02-21	AADR	ETF	45.65	45.65	45.59	45.63	2400.0
2019-02-21	AAXJ	ETF	69.37	69.45	69.03	69.25	1464700.0
2019-02-21	ACES	ETF	26.34	26.58	26.34	26.447	4200.0
2019-02-21	ACSI	ETF	32.43	32.43	32.33	32.4266	1014.0
2019-02-21	ACTX	ETF	64.3106	68.4406	59.0005	64.9006	1472.0
2019-02-21	ACWF	ETF	29.1865	29.2195	29.0627	29.13	14683.0
2019-02-21	ACWI	ETF	70.88	70.88	70.52	70.77	2037700.0
2019-02-21	ACWV	ETF	87.16	87.32	87.01	87.26	240100.0
2019-02-21	ACWX	ETF	45.74	45.79	45.58	45.67	1506725.0
2019-02-21	ADRE	ETF	40.0259	40.13	39.9788	40.0812	6981.0
2019-02-21	AFIF	ETF	9.98	10.0299	9.97	10.005	6974.0
2019-02-21	AFK	ETF	22.3	22.3	22.02	22.0454	18814.0
2019-02-21	AFTY	ETF	15.4	15.4	15.258	15.269	4500.0
2019-02-21	AGG	ETF	107.16	107.18	107.1	107.13	3677000.0
2019-02-21	AGGY	ETF	48.8	48.83	48.8	48.815	27800.0
2019-02-21	AGNG	ETF	21.32	21.327	21.2	21.327	3000.0
2019-02-21	AGQ	ETF	27.55	27.63	27.11	27.12	239500.0
2019-02-21	AGZ	ETF	112.13	112.19	112.1244	112.1694	21081.0
2019-02-21	AGZD	ETF	23.79	23.835	23.76	23.785	97800.0
2019-02-21	AIA	ETF	60.85	61.0	60.68	60.77	46247.0
2019-02-21	AIEQ	ETF	25.72	25.72	25.46	25.57	36600.0
2019-02-21	AIQ	ETF	15.21	15.23	15.1185	15.17	4325.0
2019-02-21	AIRR	ETF	25.65	25.65	25.448	25.57	27500.0
2019-02-21	AIVI	ETF	40.78	40.83	40.71	40.74	8000.0
2019-02-21	ALTY	ETF	14.8	14.8	14.726	14.785	9700.0
2019-02-21	AMJ	ETF	25.81	25.91	25.4	25.53	1926428.0
2019-02-21	AMLP	ETF	50.0	50.05	49.05	49.3	3533020.0
2019-02-21	AMUB	ETF	16.0743	16.0743	16.0743	16.0743	0.0
2019-02-21	AMZA	ETF	60.6	61.1	59.2	59.5	81930.0
2019-02-21	ANGL	ETF	28.48	28.5	28.36	28.5	149900.0
2019-02-21	AOA	ETF	52.74	52.76	52.51	52.65	76300.0
2019-02-21	AOK	ETF	33.99	33.99	33.91	33.9245	51389.0
2019-02-21	AOM	ETF	37.43	37.43	37.321	37.36	102958.0
2019-02-21	AOR	ETF	44.03	44.04	43.8786	43.93	90541.0
2019-02-21	ARGT	ETF	27.13	27.14	26.97	27.11	36500.0
2019-02-21	ARKF	ETF	20.62	20.62	20.45	20.504	10000.0
2019-02-21	ARKG	ETF	29.58	29.62	28.78	28.99	91500.0
2019-02-21	ARKK	ETF	45.51	45.578	44.49	44.7	701900.0
2019-02-21	ARKQ	ETF	35.0	35.085	34.59	34.66	47700.0
2019-02-21	ARKW	ETF	50.95	51.08	50.235	50.34	86000.0
2019-02-21	ASEA	ETF	16.2	16.2	16.05	16.05	3600.0
2019-02-21	ASET	ETF	28.27	28.37	28.27	28.2831	1971.0
2019-02-21	ASHR	ETF	25.8	25.8	25.65	25.68	2502600.0

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

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