PREVIEW / etf_daily / 2020-08-25

all etf daily files

  file:    by_date/etf_daily/2020/2020-08-25.parquet
  size:    78 KB
  rows:    2,060

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-08-25	SPY	ETF	343.53	344.21	342.27	344.12	38463400.0
2020-08-25	QQQ	ETF	282.78	286.06	282.37	285.86	34866586.0
2020-08-25	IWM	ETF	156.81	156.82	154.79	156.4	16269700.0
2020-08-25	DIA	ETF	284.23	284.23	281.02	282.62	3346000.0
2020-08-25	GLD	ETF	181.06	181.25	179.73	181.22	10056100.0
2020-08-25	TLT	ETF	164.35	165.09	163.83	164.66	10518300.0
2020-08-25	AAAU	ETF	19.21	19.23	19.08	19.22	235700.0
2020-08-25	AADR	ETF	56.32	56.48	56.2	56.48	7000.0
2020-08-25	AAXJ	ETF	78.12	78.87	78.03	78.87	1504400.0
2020-08-25	ABEQ	ETF	23.55	23.58	23.43	23.56	9900.0
2020-08-25	ACES	ETF	52.33	52.48	51.81	52.42	63600.0
2020-08-25	ACIO	ETF	26.97	27.07	26.97	27.048	9600.0
2020-08-25	ACSI	ETF	37.915	38.0064	37.915	38.0064	252.0
2020-08-25	ACTX	ETF	2.5046	2.6491	2.1299	2.36	1520.0
2020-08-25	ACWF	ETF	30.35	30.41	30.2157	30.3555	6329.0
2020-08-25	ACWI	ETF	81.63	81.8	81.33	81.8	1400200.0
2020-08-25	ACWV	ETF	92.98	93.1	92.69	92.99	216300.0
2020-08-25	ACWX	ETF	47.27	47.27	46.94	47.19	694230.0
2020-08-25	ADFI	ETF	10.015	10.015	10.015	10.015	100.0
2020-08-25	ADME	ETF	34.46	34.57	34.422	34.563	8200.0
2020-08-25	ADRE	ETF	46.9223	47.67	46.9223	47.67	5599.0
2020-08-25	AESR	ETF	11.05	11.126	11.05	11.126	30500.0
2020-08-25	AFIF	ETF	10.77	10.77	9.79	9.82	12845.0
2020-08-25	AFK	ETF	17.85	17.85	17.48	17.75	5296.0
2020-08-25	AFSM	ETF	18.562	18.562	18.562	18.562	100.0
2020-08-25	AFTY	ETF	19.27	19.39	19.25	19.374	3100.0
2020-08-25	AGG	ETF	118.35	118.46	118.18	118.38	4002300.0
2020-08-25	AGGY	ETF	53.98	54.04	53.895	54.03	144300.0
2020-08-25	AGNG	ETF	25.4	25.54	25.4	25.54	1100.0
2020-08-25	AGQ	ETF	56.54	56.59	54.39	56.52	1702100.0
2020-08-25	AGZ	ETF	121.29	121.2902	121.16	121.17	34317.0
2020-08-25	AGZD	ETF	23.51	23.535	23.51	23.53	9200.0
2020-08-25	AIA	ETF	72.91	73.22	72.76	73.16	56876.0
2020-08-25	AIEQ	ETF	31.0	31.142	30.8	31.12	9200.0
2020-08-25	AIQ	ETF	23.15	23.43	23.12	23.3703	214610.0
2020-08-25	AIRR	ETF	26.92	26.92	26.7	26.869	2200.0
2020-08-25	AIVI	ETF	37.58	37.58	37.22	37.39	5200.0
2020-08-25	ALTL	ETF	25.355	25.355	25.33	25.33	1139.0
2020-08-25	ALTY	ETF	11.0	11.05	10.94	10.97	6700.0
2020-08-25	AMJ	ETF	13.32	13.36	12.9	13.03	1045242.0
2020-08-25	AMLP	ETF	23.77	23.95	23.12	23.43	2272600.0
2020-08-25	AMNA	ETF	24.84	24.84	24.51	24.7188	4400.0
2020-08-25	AMND	ETF	26.058	26.058	26.058	26.058	1.0
2020-08-25	AMOM	ETF	35.33	35.685	35.25	35.685	4300.0
2020-08-25	AMUB	ETF	8.22	8.23	8.21	8.21	3856.0
2020-08-25	AMZA	ETF	17.54	17.54	16.67	17.01	117700.0
2020-08-25	ANGL	ETF	30.59	30.62	30.5	30.58	1203000.0
2020-08-25	AOA	ETF	59.12	59.15	58.87	59.12	82400.0
2020-08-25	AOK	ETF	37.62	37.7	37.4659	37.49	109373.0
2020-08-25	AOM	ETF	41.46	41.54	41.37	41.47	109674.0

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

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