PREVIEW / etf_daily / 2020-08-10

all etf daily files

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

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-10	SPY	ETF	335.06	335.77	332.96	335.57	44282100.0
2020-08-10	QQQ	ETF	271.74	271.98	266.67	270.31	35088373.0
2020-08-10	IWM	ETF	156.65	158.83	156.65	157.79	24000500.0
2020-08-10	DIA	ETF	275.51	278.28	275.48	278.14	2313900.0
2020-08-10	GLD	ETF	191.2	192.61	189.66	190.15	19047200.0
2020-08-10	TLT	ETF	170.22	170.25	169.07	169.12	6408500.0
2020-08-10	AAAU	ETF	20.38	20.43	20.13	20.19	819100.0
2020-08-10	AADR	ETF	57.75	57.75	56.87	56.97	4100.0
2020-08-10	AAXJ	ETF	76.17	76.32	75.68	76.25	1242800.0
2020-08-10	ABEQ	ETF	23.54	23.66	23.5	23.591	52800.0
2020-08-10	ACES	ETF	49.98	50.37	49.7	50.18	135400.0
2020-08-10	ACIO	ETF	26.47	26.56	26.38	26.499	13800.0
2020-08-10	ACSI	ETF	37.54	37.6909	37.54	37.6909	940.0
2020-08-10	ACTX	ETF	2.4013	2.9146	2.3541	2.8999	795.0
2020-08-10	ACWF	ETF	30.0388	30.0388	29.9419	30.0334	1278.0
2020-08-10	ACWI	ETF	79.49	79.62	79.01	79.56	1113700.0
2020-08-10	ACWV	ETF	91.98	92.19	91.75	91.87	1074300.0
2020-08-10	ACWX	ETF	46.0	46.1	45.81	46.08	689955.0
2020-08-10	ADME	ETF	33.97	33.97	33.63	33.75	7000.0
2020-08-10	ADRE	ETF	45.53	45.95	45.2434	45.34	12046.0
2020-08-10	AESR	ETF	10.75	10.775	10.66	10.775	9800.0
2020-08-10	AFIF	ETF	9.8501	9.89	9.85	9.855	21250.0
2020-08-10	AFK	ETF	17.0	17.32	17.0	17.145	5989.0
2020-08-10	AFMC	ETF	18.478	18.478	18.478	18.478	200.0
2020-08-10	AFSM	ETF	18.625	18.625	18.512	18.512	300.0
2020-08-10	AFTY	ETF	18.86	18.902	18.8	18.902	3600.0
2020-08-10	AGG	ETF	119.62	119.64	119.28	119.32	5152700.0
2020-08-10	AGGY	ETF	54.62	54.62	54.532	54.56	91500.0
2020-08-10	AGNG	ETF	25.425	25.425	25.39	25.39	400.0
2020-08-10	AGQ	ETF	67.59	71.6	67.4	69.7	5019700.0
2020-08-10	AGZ	ETF	121.6	121.6	121.39	121.41	27773.0
2020-08-10	AGZD	ETF	23.585	23.675	23.585	23.625	6200.0
2020-08-10	AIA	ETF	71.08	71.09	70.56	71.06	65978.0
2020-08-10	AIEQ	ETF	30.76	30.76	30.3	30.55	42200.0
2020-08-10	AIQ	ETF	22.63	22.63	22.28	22.45	13499.0
2020-08-10	AIRR	ETF	27.39	27.66	27.35	27.48	24200.0
2020-08-10	AIVI	ETF	36.76	36.84	36.64	36.84	15300.0
2020-08-10	ALTL	ETF	25.15	25.1946	24.91	25.1946	3259.0
2020-08-10	ALTY	ETF	11.1	11.178	11.1	11.15	12000.0
2020-08-10	AMJ	ETF	13.61	13.99	13.61	13.92	3177437.0
2020-08-10	AMLP	ETF	25.24	25.94	25.24	25.88	3122300.0
2020-08-10	AMNA	ETF	25.2	25.45	25.05	25.43	14400.0
2020-08-10	AMND	ETF	26.91	26.91	26.87	26.8724	206.0
2020-08-10	AMOM	ETF	36.36	36.36	33.27	33.69	6800.0
2020-08-10	AMUB	ETF	8.67	8.785	8.645	8.785	1283.0
2020-08-10	AMZA	ETF	18.29	18.97	18.29	18.95	121000.0
2020-08-10	ANGL	ETF	30.65	30.7	30.59	30.64	647700.0
2020-08-10	AOA	ETF	57.91	58.19	57.85	58.05	41400.0
2020-08-10	AOK	ETF	37.48	37.55	37.4216	37.48	105126.0
2020-08-10	AOM	ETF	41.18	41.345	41.11	41.29	118690.0

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

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