PREVIEW / etf_daily / 2020-08-24

all etf daily files

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

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-24	SPY	ETF	342.12	343.0	339.45	342.92	48588700.0
2020-08-24	QQQ	ETF	285.06	286.0	281.27	283.63	36418533.0
2020-08-24	IWM	ETF	155.86	156.27	154.33	156.23	13707100.0
2020-08-24	DIA	ETF	281.72	283.25	280.47	283.18	2622800.0
2020-08-24	GLD	ETF	182.91	182.93	180.69	181.0	11605800.0
2020-08-24	TLT	ETF	166.32	166.97	165.86	165.93	6490600.0
2020-08-24	AAAU	ETF	19.41	19.41	19.17	19.2	311600.0
2020-08-24	AADR	ETF	56.74	56.75	56.13	56.2	5700.0
2020-08-24	AAXJ	ETF	78.1	78.23	77.58	77.91	1029700.0
2020-08-24	ABEQ	ETF	23.513	23.59	23.513	23.59	1000.0
2020-08-24	ACES	ETF	52.22	52.409	51.48	52.11	56700.0
2020-08-24	ACIO	ETF	27.22	27.22	26.83	26.912	12900.0
2020-08-24	ACSI	ETF	37.9	37.9595	37.9	37.9595	481.0
2020-08-24	ACTX	ETF	2.5459	2.7376	2.3541	2.7376	402.0
2020-08-24	ACWF	ETF	30.33	30.33	30.15	30.29	12595.0
2020-08-24	ACWI	ETF	81.47	81.52	81.13	81.48	4682900.0
2020-08-24	ACWV	ETF	92.79	92.86	92.51	92.79	238900.0
2020-08-24	ACWX	ETF	47.13	47.18	46.87	47.05	498497.0
2020-08-24	ADME	ETF	34.318	34.41	34.27	34.355	9400.0
2020-08-24	ADRE	ETF	46.86	46.9502	46.575	46.635	4813.0
2020-08-24	AESR	ETF	11.04	11.09	11.04	11.082	24200.0
2020-08-24	AFIF	ETF	9.65	9.84	9.65	9.8198	169128.0
2020-08-24	AFK	ETF	17.85	17.98	17.55	17.74	24454.0
2020-08-24	AFLG	ETF	20.714	20.738	20.714	20.738	200.0
2020-08-24	AFTY	ETF	19.19	19.25	19.13	19.18	4000.0
2020-08-24	AGG	ETF	118.72	118.82	118.6	118.63	4620900.0
2020-08-24	AGGY	ETF	54.26	54.28	54.17	54.23	148100.0
2020-08-24	AGNG	ETF	25.396	25.396	25.355	25.355	400.0
2020-08-24	AGQ	ETF	58.22	58.27	55.58	56.1	2219200.0
2020-08-24	AGZ	ETF	121.47	121.47	121.33	121.38	30050.0
2020-08-24	AGZD	ETF	23.6	23.61	23.53	23.555	15600.0
2020-08-24	AIA	ETF	73.03	73.05	72.5601	72.73	127080.0
2020-08-24	AIEQ	ETF	31.53	31.6	30.89	31.0	15000.0
2020-08-24	AIQ	ETF	23.22	23.24	23.025	23.0997	28075.0
2020-08-24	AIRR	ETF	26.79	26.98	26.63	26.918	8400.0
2020-08-24	AIVI	ETF	37.42	37.46	37.37	37.46	3500.0
2020-08-24	ALTL	ETF	25.33	25.33	25.2732	25.3195	3837.0
2020-08-24	ALTY	ETF	10.93	11.03	10.86	11.0	13200.0
2020-08-24	AMJ	ETF	13.34	13.4	13.18	13.26	654309.0
2020-08-24	AMLP	ETF	23.91	24.03	23.61	23.7	2060300.0
2020-08-24	AMNA	ETF	24.9613	24.9613	24.9613	24.9613	70.0
2020-08-24	AMND	ETF	26.43	26.43	26.27	26.2956	804.0
2020-08-24	AMOM	ETF	35.29	35.32	35.04	35.2	3100.0
2020-08-24	AMUB	ETF	8.41	8.41	8.3195	8.3195	19104.0
2020-08-24	AMZA	ETF	17.5	17.564	17.197	17.286	57100.0
2020-08-24	ANGL	ETF	30.29	30.55	30.29	30.55	6521700.0
2020-08-24	AOA	ETF	58.85	59.0	58.76	58.97	47500.0
2020-08-24	AOK	ETF	37.5	37.6	37.469	37.55	216674.0
2020-08-24	AOM	ETF	41.5	41.54	41.4	41.54	133807.0
2020-08-24	AOR	ETF	48.94	49.09	48.81	49.06	143084.0

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

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