PREVIEW / etf_daily / 2019-10-23

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-23.parquet
  size:    71 KB
  rows:    1,850

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-10-23	SPY	ETF	298.73	299.94	298.5	299.88	34352200.0
2019-10-23	QQQ	ETF	191.43	192.2582	191.15	192.22	15198327.0
2019-10-23	IWM	ETF	154.34	154.75	153.55	154.4	8728000.0
2019-10-23	DIA	ETF	268.12	268.9	267.36	268.24	1693400.0
2019-10-23	GLD	ETF	140.59	141.0	140.5	140.53	4155300.0
2019-10-23	TLT	ETF	140.03	140.31	139.36	139.48	5995400.0
2019-10-23	AAAU	ETF	14.9	14.93	14.89	14.89	22400.0
2019-10-23	AADR	ETF	48.41	48.55	48.26	48.45	4600.0
2019-10-23	AAXJ	ETF	68.29	68.58	68.26	68.58	373200.0
2019-10-23	ACES	ETF	30.97	31.274	30.97	31.21	8500.0
2019-10-23	ACIO	ETF	24.73	24.78	24.73	24.777	24900.0
2019-10-23	ACSI	ETF	34.2572	34.41	34.2572	34.41	898.0
2019-10-23	ACTX	ETF	11.2101	11.8001	10.7381	11.8001	946.0
2019-10-23	ACWF	ETF	29.3255	29.4365	29.3082	29.3907	11336.0
2019-10-23	ACWI	ETF	74.75	75.03	74.69	75.03	2133100.0
2019-10-23	ACWV	ETF	95.03	95.21	94.92	95.1	136100.0
2019-10-23	ACWX	ETF	47.01	47.19	47.0	47.16	1973827.0
2019-10-23	ADRE	ETF	39.63	39.6988	39.63	39.67	3303.0
2019-10-23	AFIF	ETF	9.735	9.735	9.735	9.735	104.0
2019-10-23	AFK	ETF	20.34	20.51	20.34	20.4644	1787.0
2019-10-23	AFTY	ETF	17.382	17.429	17.36	17.429	1900.0
2019-10-23	AGG	ETF	112.82	112.88	112.73	112.75	1887800.0
2019-10-23	AGGY	ETF	52.1	52.16	52.09	52.11	135600.0
2019-10-23	AGNG	ETF	21.95	21.95	21.788	21.918	1100.0
2019-10-23	AGQ	ETF	31.12	31.36	31.07	31.07	75000.0
2019-10-23	AGZ	ETF	116.25	116.26	116.09	116.09	54549.0
2019-10-23	AGZD	ETF	23.815	23.965	23.81	23.91	28200.0
2019-10-23	AIA	ETF	60.56	60.79	60.52	60.79	33064.0
2019-10-23	AIEQ	ETF	26.2	26.358	26.17	26.21	9400.0
2019-10-23	AIQ	ETF	15.8592	15.8887	15.8592	15.8683	1187.0
2019-10-23	AIRR	ETF	27.89	28.03	27.783	27.99	51500.0
2019-10-23	AIVI	ETF	41.6	41.73	41.6	41.73	2300.0
2019-10-23	ALTY	ETF	14.85	14.907	14.85	14.88	5100.0
2019-10-23	AMJ	ETF	22.27	22.27	22.05	22.14	842888.0
2019-10-23	AMLP	ETF	43.55	43.65	43.25	43.4	2556740.0
2019-10-23	AMUB	ETF	13.9187	13.9187	13.9187	13.9187	0.0
2019-10-23	AMZA	ETF	45.9	46.4	45.6	45.9	61270.0
2019-10-23	ANGL	ETF	29.34	29.38	29.3	29.37	330500.0
2019-10-23	AOA	ETF	55.34	55.49	55.34	55.42	101700.0
2019-10-23	AOK	ETF	35.65	35.7499	35.65	35.7	45968.0
2019-10-23	AOM	ETF	39.22	39.3218	39.21	39.3	144105.0
2019-10-23	AOR	ETF	46.13	46.2935	46.13	46.22	279264.0
2019-10-23	ARGT	ETF	22.17	22.41	22.17	22.3	20800.0
2019-10-23	ARKF	ETF	21.49	21.67	21.49	21.6	7500.0
2019-10-23	ARKG	ETF	28.6	28.793	28.36	28.45	121100.0
2019-10-23	ARKK	ETF	41.9	42.194	41.66	41.76	142200.0
2019-10-23	ARKQ	ETF	32.27	32.323	32.14	32.23	16400.0
2019-10-23	ARKW	ETF	48.85	49.34	48.6	48.75	26600.0
2019-10-23	ASEA	ETF	15.74	15.75	15.74	15.75	4400.0
2019-10-23	ASET	ETF	30.34	30.34	30.34	30.34	297.0

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

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