PREVIEW / etf_daily / 2019-11-06

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-06.parquet
  size:    71 KB
  rows:    1,860

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-11-06	SPY	ETF	307.03	307.4	306.06	307.1	46487100.0
2019-11-06	QQQ	ETF	199.98	200.0	198.785	199.76	19725486.0
2019-11-06	IWM	ETF	158.99	158.99	157.81	158.23	16025500.0
2019-11-06	DIA	ETF	275.02	275.21	273.99	274.8	1605900.0
2019-11-06	GLD	ETF	140.12	140.79	140.0	140.45	6416500.0
2019-11-06	TLT	ETF	138.02	138.41	137.34	137.98	9351900.0
2019-11-06	AAAU	ETF	14.85	14.89	14.84	14.87	31400.0
2019-11-06	AADR	ETF	50.14	50.56	50.14	50.25	9900.0
2019-11-06	AAXJ	ETF	71.72	71.75	71.34	71.55	895100.0
2019-11-06	ACES	ETF	31.68	31.784	31.493	31.56	13500.0
2019-11-06	ACIO	ETF	25.17	25.175	25.142	25.142	4000.0
2019-11-06	ACSI	ETF	35.0071	35.0071	34.82	34.8807	1546.0
2019-11-06	ACTX	ETF	11.2101	11.2101	8.8501	11.2101	618.0
2019-11-06	ACWF	ETF	30.23	30.3176	30.2	30.2829	56875.0
2019-11-06	ACWI	ETF	76.85	76.94	76.62	76.85	1388600.0
2019-11-06	ACWV	ETF	95.0	95.36	94.97	95.32	155600.0
2019-11-06	ACWX	ETF	48.32	48.38	48.1813	48.29	987068.0
2019-11-06	ADRE	ETF	41.6	41.6	41.45	41.5001	1736.0
2019-11-06	AFIF	ETF	9.79	9.8088	9.75	9.775	13229.0
2019-11-06	AFK	ETF	21.0	21.09	20.8468	20.93	12537.0
2019-11-06	AFTY	ETF	18.034	18.034	17.933	17.958	2300.0
2019-11-06	AGG	ETF	112.4	112.51	112.26	112.4	3840500.0
2019-11-06	AGGY	ETF	52.06	52.1	52.0	52.08	736400.0
2019-11-06	AGNG	ETF	22.572	22.614	22.572	22.614	500.0
2019-11-06	AGQ	ETF	31.08	31.3	30.92	31.28	111100.0
2019-11-06	AGZ	ETF	115.81	115.86	115.71	115.77	24776.0
2019-11-06	AGZD	ETF	23.895	23.99	23.875	23.94	22800.0
2019-11-06	AIA	ETF	63.86	63.91	63.5666	63.65	16909.0
2019-11-06	AIEQ	ETF	26.64	26.69	26.57	26.6	11800.0
2019-11-06	AIQ	ETF	16.555	16.555	16.5	16.5231	2408.0
2019-11-06	AIRR	ETF	29.04	29.04	28.815	28.848	5200.0
2019-11-06	AIVI	ETF	42.24	42.24	42.05	42.08	6900.0
2019-11-06	ALTY	ETF	14.845	14.872	14.804	14.815	5500.0
2019-11-06	AMJ	ETF	22.03	22.1	21.65	21.69	2140415.0
2019-11-06	AMLP	ETF	43.2	43.2	42.35	42.5	3390920.0
2019-11-06	AMUB	ETF	13.6798	13.6798	13.6798	13.6798	0.0
2019-11-06	AMZA	ETF	45.7	45.8	44.5	44.6	55890.0
2019-11-06	ANGL	ETF	29.31	29.33	29.21	29.24	241400.0
2019-11-06	AOA	ETF	56.5	56.53	56.41	56.52	35900.0
2019-11-06	AOK	ETF	35.81	35.87	35.81	35.86	66983.0
2019-11-06	AOM	ETF	39.58	39.62	39.55	39.61	91491.0
2019-11-06	AOR	ETF	46.92	46.94	46.8	46.92	87430.0
2019-11-06	ARGT	ETF	22.23	22.24	21.82	21.86	20500.0
2019-11-06	ARKF	ETF	22.5	22.554	22.49	22.535	13200.0
2019-11-06	ARKG	ETF	30.65	30.65	30.16	30.22	122700.0
2019-11-06	ARKK	ETF	45.4	45.402	45.057	45.22	260600.0
2019-11-06	ARKQ	ETF	34.65	34.65	34.419	34.569	5700.0
2019-11-06	ARKW	ETF	52.2	52.4	51.96	52.23	128300.0
2019-11-06	ASEA	ETF	16.2	16.2	16.19	16.19	3200.0
2019-11-06	ASET	ETF	30.34	30.34	30.2914	30.2914	1264.0

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

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