PREVIEW / etf_daily / 2020-08-03

all etf daily files

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

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-03	SPY	ETF	328.32	329.62	327.73	328.79	53077900.0
2020-08-03	QQQ	ETF	268.05	270.15	267.87	269.38	32081566.0
2020-08-03	IWM	ETF	148.29	149.97	147.22	149.76	20777100.0
2020-08-03	DIA	ETF	265.67	267.15	265.35	266.72	2569300.0
2020-08-03	GLD	ETF	185.05	185.82	184.2	185.64	12897000.0
2020-08-03	TLT	ETF	169.24	169.99	168.97	169.95	9066200.0
2020-08-03	AAAU	ETF	19.64	19.71	19.54	19.7	619400.0
2020-08-03	AADR	ETF	55.93	57.72	55.93	57.63	6700.0
2020-08-03	AAXJ	ETF	75.1	75.56	75.06	75.4	1681100.0
2020-08-03	ABEQ	ETF	23.19	23.22	23.19	23.22	100.0
2020-08-03	ACES	ETF	46.48	46.5	45.5	46.5	76900.0
2020-08-03	ACIO	ETF	26.227	26.29	26.22	26.253	19200.0
2020-08-03	ACSI	ETF	36.0111	36.0111	36.0111	36.0111	116.0
2020-08-03	ACTX	ETF	3.4161	3.4161	2.3541	2.891	361.0
2020-08-03	ACWF	ETF	29.49	29.72	29.49	29.6249	8624.0
2020-08-03	ACWI	ETF	78.19	78.6	78.07	78.49	5849300.0
2020-08-03	ACWV	ETF	91.27	91.27	90.82	91.13	159700.0
2020-08-03	ACWX	ETF	45.36	45.64	45.245	45.62	1196116.0
2020-08-03	ADME	ETF	33.844	33.95	33.844	33.943	4700.0
2020-08-03	ADRE	ETF	45.5	45.8955	45.5	45.7853	15716.0
2020-08-03	AESR	ETF	10.62	10.65	10.62	10.64	3500.0
2020-08-03	AFIF	ETF	9.83	9.87	9.83	9.86	5706.0
2020-08-03	AFK	ETF	17.15	17.24	16.84	16.96	16850.0
2020-08-03	AFLG	ETF	20.06	20.06	20.048	20.048	100.0
2020-08-03	AFSM	ETF	18.017	18.017	18.017	18.017	100.0
2020-08-03	AFTY	ETF	18.97	19.02	18.97	19.0	8600.0
2020-08-03	AGG	ETF	119.37	119.4	119.19	119.4	13013600.0
2020-08-03	AGGY	ETF	54.5	54.56	54.43	54.56	185500.0
2020-08-03	AGNG	ETF	25.42	25.71	25.42	25.66	22600.0
2020-08-03	AGQ	ETF	49.55	50.31	48.64	50.18	1799700.0
2020-08-03	AGZ	ETF	121.73	121.73	121.56	121.6	58949.0
2020-08-03	AGZD	ETF	23.58	23.595	23.555	23.58	18800.0
2020-08-03	AIA	ETF	69.81	70.1799	69.81	70.06	48243.0
2020-08-03	AIEQ	ETF	30.44	30.89	30.44	30.77	20100.0
2020-08-03	AIQ	ETF	22.29	22.51	22.29	22.48	58370.0
2020-08-03	AIRR	ETF	24.87	25.39	24.775	25.351	12000.0
2020-08-03	AIVI	ETF	36.06	36.34	36.06	36.33	5200.0
2020-08-03	ALTL	ETF	24.95	24.99	24.76	24.8788	5144.0
2020-08-03	ALTY	ETF	10.75	10.84	10.67	10.81	31700.0
2020-08-03	AMJ	ETF	12.97	13.135	12.71	12.99	745146.0
2020-08-03	AMLP	ETF	23.81	24.35	23.56	24.12	1387500.0
2020-08-03	AMNA	ETF	23.945	23.945	23.8283	23.8283	150.0
2020-08-03	AMND	ETF	25.1352	25.1352	25.1352	25.1352	0.0
2020-08-03	AMOM	ETF	33.95	34.34	33.91	34.32	2000.0
2020-08-03	AMUB	ETF	7.92	8.25	7.92	8.1649	6943.0
2020-08-03	AMZA	ETF	17.11	17.39	16.83	17.09	43100.0
2020-08-03	ANGL	ETF	30.4	30.47	30.31	30.46	1190400.0
2020-08-03	AOA	ETF	57.06	57.34	56.75	57.23	42500.0
2020-08-03	AOK	ETF	37.14	37.3	37.14	37.24	85433.0
2020-08-03	AOM	ETF	40.89	41.0	40.8005	40.98	136105.0

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

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