PREVIEW / etf_daily / 2019-07-19

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-19.parquet
  size:    70 KB
  rows:    1,826

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-07-19	SPY	ETF	300.04	300.07	296.98	297.17	58678600.0
2019-07-19	QQQ	ETF	193.82	193.83	190.81	191.01	29387945.0
2019-07-19	IWM	ETF	154.94	155.43	153.82	153.82	17182600.0
2019-07-19	DIA	ETF	273.18	273.34	271.36	271.45	2364300.0
2019-07-19	GLD	ETF	135.45	136.03	133.97	134.47	18079200.0
2019-07-19	TLT	ETF	131.59	131.93	131.51	131.69	5804800.0
2019-07-19	AAAU	ETF	14.34	14.39	14.2	14.23	123700.0
2019-07-19	AADR	ETF	52.09	52.09	51.51	51.51	7600.0
2019-07-19	AAXJ	ETF	70.08	70.15	69.66	69.67	573800.0
2019-07-19	ACES	ETF	30.61	30.7	30.51	30.511	3800.0
2019-07-19	ACIO	ETF	25.12	25.18	25.11	25.11	106900.0
2019-07-19	ACSI	ETF	34.56	34.56	34.1997	34.1997	1778.0
2019-07-19	ACTX	ETF	27.7302	29.4944	24.2492	25.3702	198.0
2019-07-19	ACWF	ETF	29.8	29.8	29.5687	29.5687	4680.0
2019-07-19	ACWI	ETF	74.77	74.81	74.22	74.22	2375600.0
2019-07-19	ACWV	ETF	93.61	93.72	92.91	92.92	176600.0
2019-07-19	ACWX	ETF	46.95	47.0	46.7824	46.84	1470849.0
2019-07-19	ADRE	ETF	40.89	40.89	40.7491	40.7491	2580.0
2019-07-19	AFIF	ETF	9.85	9.87	9.845	9.87	2522.0
2019-07-19	AFK	ETF	21.88	22.03	21.81	21.81	7737.0
2019-07-19	AFTY	ETF	17.427	17.458	17.372	17.388	4600.0
2019-07-19	AGG	ETF	111.22	111.29	111.14	111.17	3150800.0
2019-07-19	AGGY	ETF	51.33	51.37	51.31	51.35	95600.0
2019-07-19	AGNG	ETF	21.5	21.64	21.5	21.51	900.0
2019-07-19	AGQ	ETF	28.36	28.84	27.02	27.47	894300.0
2019-07-19	AGZ	ETF	114.91	114.95	114.8761	114.93	30615.0
2019-07-19	AGZD	ETF	23.95	23.95	23.895	23.91	28400.0
2019-07-19	AIA	ETF	61.85	61.88	61.488	61.59	42224.0
2019-07-19	AIEQ	ETF	26.89	26.96	26.68	26.68	12100.0
2019-07-19	AIQ	ETF	16.81	16.85	16.67	16.71	13267.0
2019-07-19	AIRR	ETF	25.9	26.165	25.9	25.986	7000.0
2019-07-19	AIVI	ETF	40.9	40.97	40.84	40.84	2800.0
2019-07-19	ALTY	ETF	15.04	15.088	15.0	15.0	16400.0
2019-07-19	AMJ	ETF	25.45	25.54	25.33	25.4	858615.0
2019-07-19	AMLP	ETF	49.95	50.25	49.75	49.9	1921140.0
2019-07-19	AMOM	ETF	26.51	26.51	26.268	26.268	200.0
2019-07-19	AMUB	ETF	16.037	16.037	16.037	16.037	1.0
2019-07-19	AMZA	ETF	56.5	56.7	56.15	56.6	85400.0
2019-07-19	ANGL	ETF	29.15	29.17	29.08	29.08	171800.0
2019-07-19	AOA	ETF	55.11	55.15	54.84	54.84	39400.0
2019-07-19	AOK	ETF	35.34	35.3899	35.2701	35.29	39422.0
2019-07-19	AOM	ETF	38.94	38.96	38.82	38.86	71526.0
2019-07-19	AOR	ETF	45.85	45.9442	45.68	45.68	65577.0
2019-07-19	ARGT	ETF	32.89	33.0	32.31	32.32	70300.0
2019-07-19	ARKF	ETF	23.36	23.36	23.01	23.01	18000.0
2019-07-19	ARKG	ETF	34.23	34.24	33.79	33.82	123100.0
2019-07-19	ARKK	ETF	48.99	49.04	48.28	48.29	188300.0
2019-07-19	ARKQ	ETF	33.99	34.21	33.79	33.79	11500.0
2019-07-19	ARKW	ETF	54.29	54.35	53.6	53.6	45400.0
2019-07-19	ASEA	ETF	16.57	16.97	16.57	16.93	16700.0

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

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