PREVIEW / etf_daily / 2019-06-24

all etf daily files

  file:    by_date/etf_daily/2019/2019-06-24.parquet
  size:    69 KB
  rows:    1,816

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-06-24	SPY	ETF	294.23	294.58	293.47	293.64	47582700.0
2019-06-24	QQQ	ETF	188.52	188.72	188.06	188.16	19375205.0
2019-06-24	IWM	ETF	154.36	154.41	152.0	152.08	24002600.0
2019-06-24	DIA	ETF	267.33	267.91	267.1	267.17	1654200.0
2019-06-24	GLD	ETF	132.77	134.04	132.58	133.94	17851800.0
2019-06-24	TLT	ETF	132.16	132.53	132.08	132.41	6378800.0
2019-06-24	AAAU	ETF	14.05	14.18	14.04	14.17	83900.0
2019-06-24	AADR	ETF	49.58	49.71	49.52	49.65	4100.0
2019-06-24	AAXJ	ETF	69.37	69.46	69.2	69.32	232600.0
2019-06-24	ACES	ETF	29.35	29.5	29.28	29.28	2900.0
2019-06-24	ACSI	ETF	33.92	33.92	33.6887	33.6887	1663.0
2019-06-24	ACTX	ETF	20.6502	24.4852	18.2902	18.8802	403.0
2019-06-24	ACWF	ETF	29.1099	29.115	29.016	29.0285	4261.0
2019-06-24	ACWI	ETF	73.83	73.89	73.66	73.66	1265800.0
2019-06-24	ACWV	ETF	92.59	92.83	92.58	92.72	253800.0
2019-06-24	ACWX	ETF	46.73	46.78	46.665	46.73	948210.0
2019-06-24	ADRE	ETF	40.05	40.08	40.0	40.03	2341.0
2019-06-24	AFIF	ETF	9.89	9.9	9.88	9.9	3900.0
2019-06-24	AFK	ETF	22.08	22.1	21.9802	22.0695	7981.0
2019-06-24	AFTY	ETF	17.513	17.514	17.49	17.49	4800.0
2019-06-24	AGG	ETF	111.23	111.38	111.22	111.32	3079800.0
2019-06-24	AGGY	ETF	51.14	51.2	51.08	51.155	250300.0
2019-06-24	AGNG	ETF	21.64	21.68	21.34	21.34	1200.0
2019-06-24	AGQ	ETF	24.8	25.27	24.8	25.2	512600.0
2019-06-24	AGZ	ETF	115.12	115.2599	115.12	115.22	17464.0
2019-06-24	AGZD	ETF	23.74	23.795	23.74	23.795	5600.0
2019-06-24	AIA	ETF	60.84	60.88	60.6732	60.74	24299.0
2019-06-24	AIEQ	ETF	26.35	26.53	26.3	26.3	56400.0
2019-06-24	AIQ	ETF	16.3	16.36	16.2801	16.305	3962.0
2019-06-24	AIRR	ETF	25.62	25.64	25.44	25.46	3900.0
2019-06-24	AIVI	ETF	40.92	40.98	40.91	40.93	119000.0
2019-06-24	ALTY	ETF	15.0	15.0	14.92	14.965	4800.0
2019-06-24	AMJ	ETF	24.82	24.91	24.71	24.84	1212263.0
2019-06-24	AMLP	ETF	48.8	49.15	48.65	49.15	2210560.0
2019-06-24	AMOM	ETF	25.767	25.767	25.767	25.767	100.0
2019-06-24	AMUB	ETF	15.6306	15.6306	15.6306	15.6306	1.0
2019-06-24	AMZA	ETF	55.3	55.3	54.3	54.8	74080.0
2019-06-24	ANGL	ETF	29.19	29.21	29.15	29.17	162500.0
2019-06-24	AOA	ETF	55.06	55.14	55.03	55.06	53500.0
2019-06-24	AOK	ETF	35.35	35.3728	35.3	35.34	54987.0
2019-06-24	AOM	ETF	39.03	39.07	38.9411	38.98	125517.0
2019-06-24	AOR	ETF	46.03	46.03	45.872	45.95	62016.0
2019-06-24	ARGT	ETF	32.21	32.4	31.97	32.09	81600.0
2019-06-24	ARKF	ETF	22.64	22.663	22.5	22.527	18200.0
2019-06-24	ARKG	ETF	32.79	32.79	31.85	31.85	190800.0
2019-06-24	ARKK	ETF	45.56	45.65	44.76	44.79	227400.0
2019-06-24	ARKQ	ETF	32.52	32.52	32.19	32.19	7600.0
2019-06-24	ARKW	ETF	51.58	51.809	51.25	51.29	54500.0
2019-06-24	ASEA	ETF	16.89	17.02	16.55	16.91	71300.0
2019-06-24	ASET	ETF	29.8924	29.8924	29.8924	29.8924	170.0

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

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