PREVIEW / etf_daily / 2020-02-05

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-05.parquet
  size:    74 KB
  rows:    1,947

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
2020-02-05	SPY	ETF	332.27	333.09	330.67	332.86	65951100.0
2020-02-05	QQQ	ETF	230.22	230.25	226.85	228.22	38534817.0
2020-02-05	IWM	ETF	166.48	167.53	165.69	167.31	17807000.0
2020-02-05	DIA	ETF	290.76	293.04	289.95	292.86	3305900.0
2020-02-05	GLD	ETF	146.38	146.81	146.16	146.61	6160700.0
2020-02-05	TLT	ETF	142.3	142.7	141.9	142.01	10782600.0
2020-02-05	AAAU	ETF	15.51	15.56	15.49	15.54	29000.0
2020-02-05	AADR	ETF	56.31	56.31	55.57	55.63	45000.0
2020-02-05	AAXJ	ETF	72.89	72.89	71.84	72.0	1459300.0
2020-02-05	ABEQ	ETF	24.99	25.016	24.98	24.994	9300.0
2020-02-05	ACES	ETF	38.85	39.021	38.04	38.39	34600.0
2020-02-05	ACIO	ETF	25.319	25.38	25.315	25.332	13400.0
2020-02-05	ACSI	ETF	36.6341	36.786	36.53	36.7671	1435.0
2020-02-05	ACTX	ETF	7.3751	8.2601	7.3751	7.6701	309.0
2020-02-05	ACWF	ETF	31.4179	31.58	31.4106	31.5057	4991.0
2020-02-05	ACWI	ETF	80.82	80.83	80.36	80.75	2399200.0
2020-02-05	ACWV	ETF	98.71	98.71	98.36	98.62	312200.0
2020-02-05	ACWX	ETF	49.06	49.06	48.79	48.89	806873.0
2020-02-05	ADME	ETF	31.17	31.35	31.17	31.29	16500.0
2020-02-05	ADRE	ETF	43.95	43.95	43.5021	43.585	6804.0
2020-02-05	AESR	ETF	10.385	10.405	10.385	10.405	400.0
2020-02-05	AFIF	ETF	9.72	9.725	9.72	9.725	1437.0
2020-02-05	AFK	ETF	19.9	19.9	19.7278	19.735	9357.0
2020-02-05	AFLG	ETF	20.98	21.003	20.98	21.003	100.0
2020-02-05	AFSM	ETF	20.454	20.454	20.454	20.454	100.0
2020-02-05	AFTY	ETF	16.39	16.39	16.22	16.22	5500.0
2020-02-05	AGG	ETF	113.82	113.87	113.76	113.82	6066900.0
2020-02-05	AGGY	ETF	53.0	53.06	53.0	53.03	328100.0
2020-02-05	AGNG	ETF	24.06	24.579	24.06	24.579	3700.0
2020-02-05	AGQ	ETF	30.47	30.61	30.26	30.48	92800.0
2020-02-05	AGZ	ETF	116.73	116.77	116.7	116.76	69002.0
2020-02-05	AGZD	ETF	24.005	24.06	24.005	24.045	12200.0
2020-02-05	AIA	ETF	65.83	65.83	65.01	65.28	34741.0
2020-02-05	AIEQ	ETF	29.67	29.7	29.44	29.57	86500.0
2020-02-05	AIQ	ETF	19.53	19.53	19.2	19.295	28464.0
2020-02-05	AIRR	ETF	29.08	29.415	29.03	29.38	12600.0
2020-02-05	AIVI	ETF	42.0	42.05	41.96	42.04	4300.0
2020-02-05	ALTY	ETF	14.77	14.895	14.77	14.895	12200.0
2020-02-05	AMJ	ETF	20.91	21.28	20.905	20.95	4215216.0
2020-02-05	AMLP	ETF	41.0	41.55	40.8	40.95	6806000.0
2020-02-05	AMOM	ETF	27.155	27.155	27.155	27.155	100.0
2020-02-05	AMUB	ETF	13.25	13.25	13.199	13.199	126.0
2020-02-05	AMZA	ETF	41.1	42.0	41.1	41.4	65210.0
2020-02-05	ANGL	ETF	30.05	30.25	30.02	30.11	1669900.0
2020-02-05	AOA	ETF	58.69	58.81	58.66	58.79	62400.0
2020-02-05	AOK	ETF	36.69	36.71	36.62	36.69	79580.0
2020-02-05	AOM	ETF	40.62	40.72	40.6	40.71	339427.0
2020-02-05	AOR	ETF	48.53	48.53	48.35	48.51	87496.0
2020-02-05	ARGT	ETF	26.56	26.63	25.86	25.9	15800.0
2020-02-05	ARKF	ETF	26.72	26.81	26.06	26.14	57200.0

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

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