PREVIEW / etf_daily / 2020-09-15

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-15.parquet
  size:    79 KB
  rows:    2,081

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-09-15	SPY	ETF	341.12	342.02	338.47	340.17	52920900.0
2020-09-15	QQQ	ETF	278.9	280.45	275.1332	279.06	41849926.0
2020-09-15	IWM	ETF	154.38	154.7	152.86	153.37	16175500.0
2020-09-15	DIA	ETF	282.42	282.9	279.88	280.58	2331800.0
2020-09-15	GLD	ETF	184.46	184.67	182.92	183.45	7993700.0
2020-09-15	TLT	ETF	164.17	164.47	163.79	164.07	6928500.0
2020-09-15	AAA	ETF	25.02	25.03	25.01	25.01	12395.0
2020-09-15	AAAU	ETF	19.57	19.59	19.41	19.46	343800.0
2020-09-15	AADR	ETF	56.69	56.88	56.66	56.77	1900.0
2020-09-15	AAXJ	ETF	78.6	78.75	78.45	78.56	800100.0
2020-09-15	ABEQ	ETF	24.08	24.08	23.92	23.927	5400.0
2020-09-15	ACES	ETF	52.11	53.03	52.11	52.67	35500.0
2020-09-15	ACIO	ETF	26.714	26.76	26.659	26.72	4600.0
2020-09-15	ACSI	ETF	37.3505	37.3505	37.3505	37.3505	222.0
2020-09-15	ACTX	ETF	2.4751	2.4751	2.242	2.242	302.0
2020-09-15	ACWF	ETF	30.12	30.2267	30.081	30.0935	4686.0
2020-09-15	ACWI	ETF	81.57	81.69	81.1	81.32	2183600.0
2020-09-15	ACWV	ETF	93.06	93.29	92.8	92.93	355700.0
2020-09-15	ACWX	ETF	47.45	47.45	47.18	47.26	610254.0
2020-09-15	ADFI	ETF	10.015	10.015	10.015	10.015	100.0
2020-09-15	ADME	ETF	33.84	33.884	33.73	33.81	7400.0
2020-09-15	ADRE	ETF	47.385	47.8	47.355	47.8	1918.0
2020-09-15	AESR	ETF	11.0	11.04	10.997	10.997	12900.0
2020-09-15	AFIF	ETF	9.81	9.84	9.81	9.825	18473.0
2020-09-15	AFK	ETF	18.44	18.44	18.1899	18.215	4121.0
2020-09-15	AFLG	ETF	20.49	20.49	20.41	20.41	300.0
2020-09-15	AFMC	ETF	18.05	18.053	17.98	17.98	700.0
2020-09-15	AFSM	ETF	18.1	18.1	17.985	17.985	500.0
2020-09-15	AFTY	ETF	19.81	19.81	19.78	19.783	3500.0
2020-09-15	AGG	ETF	118.29	118.43	118.29	118.39	4163000.0
2020-09-15	AGGY	ETF	54.14	54.14	54.02	54.1	69300.0
2020-09-15	AGNG	ETF	25.94	26.0	25.91	25.915	3500.0
2020-09-15	AGQ	ETF	59.23	59.56	57.82	58.33	1307100.0
2020-09-15	AGZ	ETF	121.14	121.33	121.0967	121.16	78040.0
2020-09-15	AGZD	ETF	23.51	23.545	23.475	23.51	21000.0
2020-09-15	AIA	ETF	73.96	74.175	73.87	74.0	124557.0
2020-09-15	AIEQ	ETF	30.18	30.36	30.154	30.232	6000.0
2020-09-15	AIQ	ETF	23.43	23.4799	23.3	23.3211	15570.0
2020-09-15	AIRR	ETF	26.43	26.46	26.1	26.135	5600.0
2020-09-15	AIVI	ETF	37.54	37.66	37.45	37.51	150700.0
2020-09-15	ALTL	ETF	25.21	25.28	25.178	25.178	5055.0
2020-09-15	ALTY	ETF	10.87	10.93	10.803	10.81	10200.0
2020-09-15	AMJ	ETF	12.0	12.0	11.57	11.57	812686.0
2020-09-15	AMLP	ETF	21.92	22.02	21.33	21.37	2398300.0
2020-09-15	AMNA	ETF	23.42	23.56	23.07	23.07	2214.0
2020-09-15	AMND	ETF	24.44	24.44	24.12	24.1234	800.0
2020-09-15	AMOM	ETF	34.865	35.01	34.845	34.88	3700.0
2020-09-15	AMUB	ETF	7.62	7.62	7.31	7.31	24302.0
2020-09-15	AMZA	ETF	15.5	15.5	14.9	14.9	120500.0
2020-09-15	ANGL	ETF	30.01	30.06	29.96	30.05	1062200.0

> showing 50 of 2,081 rows — these rows as CSV

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