PREVIEW / etf_daily / 2020-03-18

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-18.parquet
  size:    75 KB
  rows:    1,980

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
2020-03-18	SPY	ETF	236.25	248.37	228.02	240.0	327597100.0
2020-03-18	QQQ	ETF	171.605	179.22	166.8	176.6	114156320.0
2020-03-18	IWM	ETF	103.05	106.78	96.25	99.97	62296700.0
2020-03-18	DIA	ETF	199.07	205.44	189.67	199.39	13369800.0
2020-03-18	GLD	ETF	141.75	142.88	138.5	140.7	21953400.0
2020-03-18	TLT	ETF	152.84	154.14	139.01	144.35	47061000.0
2020-03-18	AAAU	ETF	15.01	15.14	14.71	14.93	256200.0
2020-03-18	AADR	ETF	35.75	36.49	33.75	34.41	17500.0
2020-03-18	AAXJ	ETF	54.72	55.95	53.37	54.6	1602600.0
2020-03-18	ABEQ	ETF	19.213	19.32	18.738	19.053	12600.0
2020-03-18	ACES	ETF	26.5	26.785	23.574	24.5	49400.0
2020-03-18	ACIO	ETF	22.63	22.83	21.86	22.55	13200.0
2020-03-18	ACSI	ETF	26.3535	26.3535	25.5	25.838	932.0
2020-03-18	ACTX	ETF	4.72	4.72	3.0149	3.54	1769.0
2020-03-18	ACWF	ETF	21.67	22.285	21.1601	21.77	56396.0
2020-03-18	ACWI	ETF	56.1	58.0	54.17	56.76	9230200.0
2020-03-18	ACWV	ETF	75.41	78.48	73.06	76.35	1868500.0
2020-03-18	ACWX	ETF	33.19	34.2	32.4	33.17	2380260.0
2020-03-18	ADME	ETF	27.1	27.88	26.73	27.88	16400.0
2020-03-18	ADRE	ETF	30.79	31.6075	28.52	30.7873	28589.0
2020-03-18	AESR	ETF	7.642	7.642	7.642	7.642	100.0
2020-03-18	AFIF	ETF	9.45	9.64	9.11	9.13	10513.0
2020-03-18	AFK	ETF	12.8121	12.85	12.005	12.01	44164.0
2020-03-18	AFLG	ETF	15.06	15.09	14.641	14.641	600.0
2020-03-18	AFSM	ETF	12.57	12.9	11.859	11.859	2200.0
2020-03-18	AFTY	ETF	14.46	14.6	14.19	14.435	6100.0
2020-03-18	AGG	ETF	109.36	110.57	105.77	106.57	17061700.0
2020-03-18	AGGY	ETF	49.04	49.561	47.76	47.83	753600.0
2020-03-18	AGNG	ETF	17.41	17.895	16.71	17.441	11300.0
2020-03-18	AGQ	ETF	13.96	14.46	12.66	13.43	583700.0
2020-03-18	AGZ	ETF	118.83	119.65	118.39	119.05	814901.0
2020-03-18	AGZD	ETF	21.715	23.1	21.715	22.435	49600.0
2020-03-18	AIA	ETF	50.08	51.31	49.2113	50.24	101617.0
2020-03-18	AIEQ	ETF	20.19	20.889	19.48	20.69	43000.0
2020-03-18	AIQ	ETF	13.35	13.9702	12.96	13.57	42619.0
2020-03-18	AIRR	ETF	18.21	18.24	16.731	17.06	57000.0
2020-03-18	AIVI	ETF	28.21	28.77	27.47	28.09	49300.0
2020-03-18	ALTY	ETF	8.88	8.88	6.81	7.25	48900.0
2020-03-18	AMJ	ETF	7.49	7.84	6.15	6.9	8016145.0
2020-03-18	AMLP	ETF	15.2	15.3	12.05	14.1	14435280.0
2020-03-18	AMOM	ETF	20.21	20.233	19.99	20.233	900.0
2020-03-18	AMUB	ETF	4.53	4.98	3.68	4.52	15059.0
2020-03-18	AMZA	ETF	10.7	10.7	7.2	8.3	267750.0
2020-03-18	ANGL	ETF	23.94	24.49	22.25	22.4	1613800.0
2020-03-18	AOA	ETF	43.56	44.6	42.2	43.35	245100.0
2020-03-18	AOK	ETF	32.08	32.39	30.54	31.5585	327397.0
2020-03-18	AOM	ETF	34.58	34.8198	33.58	34.17	524897.0
2020-03-18	AOR	ETF	38.23	39.07	36.81	38.46	418624.0
2020-03-18	ARCM	ETF	99.25	99.505	99.245	99.505	900.0
2020-03-18	ARGT	ETF	15.7	16.06	14.4	14.79	74600.0

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

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