PREVIEW / etf_daily / 2019-10-18

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-18.parquet
  size:    70 KB
  rows:    1,838

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-18	SPY	ETF	298.69	299.4	297.03	297.97	64304000.0
2019-10-18	QQQ	ETF	193.26	193.67	190.705	191.69	27719069.0
2019-10-18	IWM	ETF	152.93	153.5	151.45	152.61	14490200.0
2019-10-18	DIA	ETF	269.61	275.0	267.62	267.64	2232400.0
2019-10-18	GLD	ETF	140.5	140.71	140.32	140.46	6416100.0
2019-10-18	TLT	ETF	139.81	140.23	139.45	139.58	6456100.0
2019-10-18	AAAU	ETF	14.88	14.9	14.86	14.87	166300.0
2019-10-18	AADR	ETF	48.52	48.67	48.28	48.43	5600.0
2019-10-18	AAXJ	ETF	68.44	68.52	67.99	68.11	559500.0
2019-10-18	ACES	ETF	31.36	31.36	31.06	31.21	4500.0
2019-10-18	ACIO	ETF	24.669	24.67	24.638	24.645	11800.0
2019-10-18	ACSI	ETF	34.0336	34.0336	33.97	33.9953	637.0
2019-10-18	ACTX	ETF	11.8001	14.7484	11.8001	12.0656	593.0
2019-10-18	ACWF	ETF	29.14	29.25	29.09	29.1781	9158.0
2019-10-18	ACWI	ETF	74.63	74.74	74.23	74.46	1509800.0
2019-10-18	ACWV	ETF	95.01	95.31	94.89	95.16	143500.0
2019-10-18	ACWX	ETF	46.81	46.895	46.65	46.78	627296.0
2019-10-18	ADRE	ETF	39.7383	39.77	39.3668	39.3668	2835.0
2019-10-18	AFIF	ETF	9.7397	9.7397	9.723	9.735	4019.0
2019-10-18	AFK	ETF	20.61	20.61	20.45	20.45	2956.0
2019-10-18	AFTY	ETF	17.39	17.39	17.307	17.314	6100.0
2019-10-18	AGG	ETF	112.76	112.91	112.73	112.8	1454200.0
2019-10-18	AGGY	ETF	52.23	52.27	52.19	52.24	46400.0
2019-10-18	AGNG	ETF	21.75	21.75	21.73	21.74	1600.0
2019-10-18	AGQ	ETF	30.98	31.31	30.93	31.2	134800.0
2019-10-18	AGZ	ETF	116.23	116.2691	116.1502	116.2	13680.0
2019-10-18	AGZD	ETF	23.91	24.0	23.865	23.865	8400.0
2019-10-18	AIA	ETF	60.59	60.59	60.23	60.28	45478.0
2019-10-18	AIEQ	ETF	26.474	26.474	26.22	26.33	9100.0
2019-10-18	AIQ	ETF	16.1	16.1	15.85	15.8978	7254.0
2019-10-18	AIRR	ETF	27.33	27.558	27.33	27.558	5400.0
2019-10-18	AIVI	ETF	41.12	41.24	41.1	41.22	32700.0
2019-10-18	ALTY	ETF	14.75	14.785	14.742	14.754	2700.0
2019-10-18	AMJ	ETF	21.94	22.32	21.94	22.17	1242807.0
2019-10-18	AMLP	ETF	43.3	43.85	43.25	43.55	2829460.0
2019-10-18	AMUB	ETF	13.9839	13.9839	13.9839	13.9839	1.0
2019-10-18	AMZA	ETF	46.2	47.0	46.1	46.8	53050.0
2019-10-18	ANGL	ETF	29.36	29.36	29.3	29.35	434800.0
2019-10-18	AOA	ETF	55.24	55.29	55.04	55.18	31000.0
2019-10-18	AOK	ETF	35.65	35.6799	35.61	35.65	40026.0
2019-10-18	AOM	ETF	39.17	39.2399	39.1098	39.1829	164384.0
2019-10-18	AOR	ETF	46.12	46.19	46.0101	46.16	48463.0
2019-10-18	ARCM	ETF	100.24	100.24	100.185	100.185	500.0
2019-10-18	ARGT	ETF	22.7	22.92	22.4	22.46	19500.0
2019-10-18	ARKF	ETF	21.84	21.84	21.5	21.591	10000.0
2019-10-18	ARKG	ETF	28.95	29.06	28.12	28.42	73800.0
2019-10-18	ARKK	ETF	42.83	42.86	41.51	41.93	161500.0
2019-10-18	ARKQ	ETF	32.42	32.45	31.97	32.08	10200.0
2019-10-18	ARKW	ETF	50.35	50.41	48.461	49.05	31300.0
2019-10-18	ASET	ETF	30.1	30.1184	30.1	30.1184	282.0

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

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