PREVIEW / etf_daily / 2020-08-20

all etf daily files

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

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-20	SPY	ETF	335.36	338.8	335.22	338.28	42207800.0
2020-08-20	QQQ	ETF	275.3	280.43	274.86	279.93	27723379.0
2020-08-20	IWM	ETF	154.8	156.49	154.54	155.76	15413000.0
2020-08-20	DIA	ETF	276.04	278.34	275.87	277.87	2063700.0
2020-08-20	GLD	ETF	181.19	183.71	180.93	183.5	16692200.0
2020-08-20	TLT	ETF	165.39	165.65	164.93	165.21	10319900.0
2020-08-20	AAAU	ETF	19.23	19.49	19.2	19.46	293800.0
2020-08-20	AADR	ETF	56.19	56.66	56.19	56.66	3800.0
2020-08-20	AAXJ	ETF	75.44	76.37	75.3	76.36	1122100.0
2020-08-20	ABEQ	ETF	23.44	23.47	23.417	23.417	2500.0
2020-08-20	ACES	ETF	51.45	51.529	50.74	51.26	43900.0
2020-08-20	ACIO	ETF	26.86	26.86	26.7	26.85	57200.0
2020-08-20	ACSI	ETF	37.58	37.58	37.58	37.58	303.0
2020-08-20	ACTX	ETF	2.36	2.7553	2.36	2.36	238.0
2020-08-20	ACWF	ETF	30.07	30.1609	30.065	30.1609	2777.0
2020-08-20	ACWI	ETF	79.69	80.61	79.68	80.49	2487300.0
2020-08-20	ACWV	ETF	92.0	92.65	92.0	92.52	191200.0
2020-08-20	ACWX	ETF	46.24	46.61	46.1212	46.58	858840.0
2020-08-20	ADFI	ETF	10.025	10.025	10.025	10.025	100.0
2020-08-20	ADME	ETF	34.14	34.23	34.07	34.175	13600.0
2020-08-20	ADRE	ETF	45.15	45.75	45.15	45.75	6228.0
2020-08-20	AESR	ETF	10.891	10.97	10.88	10.939	7700.0
2020-08-20	AFIF	ETF	9.83	9.86	9.83	9.8448	35971.0
2020-08-20	AFK	ETF	17.31	17.48	17.31	17.39	2543.0
2020-08-20	AFLG	ETF	20.509	20.509	20.509	20.509	100.0
2020-08-20	AFMC	ETF	18.291	18.291	18.291	18.291	100.0
2020-08-20	AFTY	ETF	19.052	19.142	19.052	19.142	1200.0
2020-08-20	AGG	ETF	118.58	118.71	118.56	118.56	4487500.0
2020-08-20	AGGY	ETF	54.14	54.21	54.14	54.16	105800.0
2020-08-20	AGNG	ETF	25.53	25.59	25.497	25.513	13800.0
2020-08-20	AGQ	ETF	57.29	60.72	57.18	60.53	2524700.0
2020-08-20	AGZ	ETF	121.29	121.39	121.13	121.23	38296.0
2020-08-20	AGZD	ETF	23.51	23.555	23.51	23.55	7000.0
2020-08-20	AIA	ETF	70.01	70.899	69.79	70.8097	141856.0
2020-08-20	AIEQ	ETF	30.8	31.225	30.75	31.154	13100.0
2020-08-20	AIQ	ETF	22.5	22.88	22.41	22.88	10339.0
2020-08-20	AIRR	ETF	26.73	26.777	26.675	26.675	2000.0
2020-08-20	AIVI	ETF	37.05	37.24	37.0	37.24	5900.0
2020-08-20	ALTL	ETF	25.22	25.26	25.16	25.2036	111508.0
2020-08-20	ALTY	ETF	10.99	10.99	10.93	10.94	5000.0
2020-08-20	AMJ	ETF	13.47	13.475	13.22	13.38	854559.0
2020-08-20	AMLP	ETF	24.1	24.13	23.68	24.04	2375700.0
2020-08-20	AMNA	ETF	25.01	25.14	24.89	25.0202	10100.0
2020-08-20	AMND	ETF	26.4206	26.4206	26.4206	26.4206	0.0
2020-08-20	AMOM	ETF	34.98	35.7	34.98	35.632	1600.0
2020-08-20	AMUB	ETF	8.35	8.46	8.33	8.42	478156.0
2020-08-20	AMZA	ETF	17.6	17.704	17.17	17.66	118200.0
2020-08-20	ANGL	ETF	30.2	30.33	30.17	30.33	517500.0
2020-08-20	AOA	ETF	58.06	58.51	58.06	58.42	28100.0
2020-08-20	AOK	ETF	37.4	37.467	37.24	37.36	125784.0

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

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