PREVIEW / etf_daily / 2019-11-08

all etf daily files

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

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-08	SPY	ETF	307.8	309.0	307.03	308.94	49032100.0
2019-11-08	QQQ	ETF	200.02	201.25	199.54	201.23	15272516.0
2019-11-08	IWM	ETF	158.28	159.27	157.95	159.08	11967400.0
2019-11-08	DIA	ETF	277.16	277.24	276.05	277.07	1512000.0
2019-11-08	GLD	ETF	137.73	138.33	137.39	137.39	10377400.0
2019-11-08	TLT	ETF	135.15	135.95	134.78	134.91	10222900.0
2019-11-08	AAAU	ETF	14.59	14.64	14.56	14.56	58100.0
2019-11-08	AADR	ETF	49.79	49.98	49.67	49.9	16900.0
2019-11-08	AAXJ	ETF	71.62	71.69	71.36	71.64	1268400.0
2019-11-08	ACES	ETF	31.37	31.62	31.35	31.424	5200.0
2019-11-08	ACSI	ETF	34.75	34.8142	34.75	34.8142	14569.0
2019-11-08	ACTX	ETF	8.8501	10.6791	8.8501	10.0301	199.0
2019-11-08	ACWF	ETF	30.3157	30.3826	30.3066	30.3768	3505.0
2019-11-08	ACWI	ETF	76.94	77.17	76.72	77.17	1846200.0
2019-11-08	ACWV	ETF	95.04	95.09	94.77	94.91	768900.0
2019-11-08	ACWX	ETF	48.27	48.35	48.14	48.35	1045785.0
2019-11-08	ADME	ETF	30.0661	30.0661	30.0661	30.0661	349.0
2019-11-08	ADRE	ETF	41.84	41.84	41.54	41.54	1259.0
2019-11-08	AFIF	ETF	9.795	9.795	9.795	9.795	104.0
2019-11-08	AFK	ETF	21.06	21.06	20.69	20.74	8308.0
2019-11-08	AFTY	ETF	18.09	18.09	17.98	18.04	9200.0
2019-11-08	AGG	ETF	111.87	112.1	111.81	111.81	3866100.0
2019-11-08	AGGY	ETF	51.77	51.87	51.77	51.78	92400.0
2019-11-08	AGNG	ETF	22.69	22.88	22.69	22.88	1600.0
2019-11-08	AGQ	ETF	28.57	28.93	28.33	28.33	274000.0
2019-11-08	AGZ	ETF	115.41	115.53	115.36	115.41	26251.0
2019-11-08	AGZD	ETF	24.0	24.01	23.955	24.01	4600.0
2019-11-08	AIA	ETF	63.4	63.4652	63.23	63.34	52578.0
2019-11-08	AIEQ	ETF	26.79	26.93	26.79	26.92	11500.0
2019-11-08	AIQ	ETF	16.744	16.7825	16.744	16.772	5751.0
2019-11-08	AIRR	ETF	28.82	28.855	28.74	28.837	4100.0
2019-11-08	AIVI	ETF	42.03	42.11	42.02	42.11	3000.0
2019-11-08	ALTY	ETF	14.734	14.774	14.712	14.712	4000.0
2019-11-08	AMJ	ETF	21.37	21.54	21.16	21.54	3828138.0
2019-11-08	AMLP	ETF	41.85	41.95	41.35	41.8	5625960.0
2019-11-08	AMOM	ETF	26.11	26.11	26.082	26.082	500.0
2019-11-08	AMUB	ETF	13.39	13.4743	13.39	13.4743	200.0
2019-11-08	AMZA	ETF	44.1	44.1	43.3	43.8	86000.0
2019-11-08	ANGL	ETF	29.21	29.24	29.17	29.21	196700.0
2019-11-08	AOA	ETF	56.47	56.62	56.46	56.62	34500.0
2019-11-08	AOK	ETF	35.8	35.83	35.74	35.81	106565.0
2019-11-08	AOM	ETF	39.5	39.56	39.495	39.56	82495.0
2019-11-08	AOR	ETF	46.89	46.94	46.85	46.94	81745.0
2019-11-08	ARGT	ETF	21.99	21.99	21.81	21.82	31200.0
2019-11-08	ARKF	ETF	22.8	22.89	22.79	22.89	6000.0
2019-11-08	ARKG	ETF	29.91	30.7	29.9	30.7	88700.0
2019-11-08	ARKK	ETF	45.17	45.85	45.058	45.85	132700.0
2019-11-08	ARKQ	ETF	35.1	35.23	34.9	35.17	11000.0
2019-11-08	ARKW	ETF	52.38	52.93	52.27	52.88	35400.0
2019-11-08	ASEA	ETF	16.33	16.33	16.2	16.24	1200.0

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

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