PREVIEW / etf_daily / 2020-09-03

all etf daily files

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

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-03	SPY	ETF	355.87	356.38	342.59	345.39	148011100.0
2020-09-03	QQQ	ETF	298.2	298.62	284.41	287.41	110083282.0
2020-09-03	IWM	ETF	158.12	158.29	152.96	153.78	32117600.0
2020-09-03	DIA	ETF	290.97	292.36	281.1	283.34	6118500.0
2020-09-03	GLD	ETF	182.3	182.82	180.49	181.14	12148100.0
2020-09-03	TLT	ETF	165.75	167.24	165.44	165.89	16416600.0
2020-09-03	AAAU	ETF	19.32	19.39	19.15	19.23	1519300.0
2020-09-03	AADR	ETF	56.89	56.89	55.18	55.38	6200.0
2020-09-03	AAXJ	ETF	78.45	78.45	76.88	77.37	1772700.0
2020-09-03	ABEQ	ETF	23.86	23.93	23.744	23.832	9800.0
2020-09-03	ACES	ETF	52.9	52.9	50.02	50.36	117200.0
2020-09-03	ACIO	ETF	27.6	27.603	26.87	27.014	28200.0
2020-09-03	ACSI	ETF	38.89	38.89	38.2521	38.2521	322.0
2020-09-03	ACTX	ETF	2.95	3.127	2.36	3.127	1191.0
2020-09-03	ACWF	ETF	30.5501	30.5501	29.94	30.0226	3148.0
2020-09-03	ACWI	ETF	83.55	83.59	80.96	81.45	3526500.0
2020-09-03	ACWV	ETF	93.85	94.11	92.0	92.43	275800.0
2020-09-03	ACWX	ETF	47.33	47.38	46.35	46.52	1980023.0
2020-09-03	ADFI	ETF	10.05	10.05	10.05	10.05	100.0
2020-09-03	ADME	ETF	35.65	35.65	34.828	34.984	8200.0
2020-09-03	ADRE	ETF	47.9	47.9	46.58	47.355	12902.0
2020-09-03	AESR	ETF	11.52	11.52	11.12	11.179	23700.0
2020-09-03	AFIF	ETF	9.85	9.86	9.84	9.8499	46360.0
2020-09-03	AFK	ETF	17.935	17.935	17.5594	17.7	5052.0
2020-09-03	AFLG	ETF	21.06	21.06	20.58	20.65	2400.0
2020-09-03	AFMC	ETF	18.42	18.42	18.115	18.115	200.0
2020-09-03	AFSM	ETF	18.44	18.44	18.141	18.141	100.0
2020-09-03	AFTY	ETF	19.65	19.65	19.56	19.589	3200.0
2020-09-03	AGG	ETF	118.73	118.87	118.62	118.69	6856700.0
2020-09-03	AGGY	ETF	54.26	54.32	54.21	54.26	240300.0
2020-09-03	AGNG	ETF	25.956	25.956	25.22	25.307	2100.0
2020-09-03	AGQ	ETF	59.13	59.69	55.49	55.94	2441200.0
2020-09-03	AGZ	ETF	121.39	121.83	121.29	121.83	55208.0
2020-09-03	AGZD	ETF	23.61	23.61	23.55	23.575	11600.0
2020-09-03	AIA	ETF	72.6	72.6	71.337	71.74	1086877.0
2020-09-03	AIEQ	ETF	32.0	32.0	30.59	30.82	43600.0
2020-09-03	AIQ	ETF	24.54	24.54	23.45	23.6353	51605.0
2020-09-03	AIRR	ETF	27.593	27.593	26.778	26.89	17300.0
2020-09-03	AIVI	ETF	37.35	37.36	36.65	36.76	4500.0
2020-09-03	ALTL	ETF	25.7508	25.8584	25.14	25.26	8708.0
2020-09-03	ALTY	ETF	10.98	10.98	10.79	10.8	17900.0
2020-09-03	AMJ	ETF	12.21	12.39	12.1	12.13	1574188.0
2020-09-03	AMLP	ETF	22.66	22.87	22.33	22.48	2312300.0
2020-09-03	AMNA	ETF	24.35	24.35	23.85	23.9455	6000.0
2020-09-03	AMND	ETF	25.0456	25.0456	25.0456	25.0456	4.0
2020-09-03	AMOM	ETF	37.51	37.738	35.35	35.63	13400.0
2020-09-03	AMUB	ETF	7.76	7.78	7.62	7.6504	47925.0
2020-09-03	AMZA	ETF	16.37	16.541	16.05	16.15	111900.0
2020-09-03	ANGL	ETF	30.66	30.66	30.27	30.45	1128300.0
2020-09-03	AOA	ETF	60.29	60.29	58.68	58.88	80600.0

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

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