PREVIEW / etf_daily / 2020-09-22

all etf daily files

  file:    by_date/etf_daily/2020/2020-09-22.parquet
  size:    79 KB
  rows:    2,082

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-09-22	SPY	ETF	328.57	330.9	325.86	330.3	63612100.0
2020-09-22	QQQ	ETF	270.05	273.08	266.54	272.48	41128886.0
2020-09-22	IWM	ETF	148.65	149.3	146.56	149.06	19385800.0
2020-09-22	DIA	ETF	271.67	273.24	269.79	272.81	3169800.0
2020-09-22	GLD	ETF	179.63	180.02	178.11	178.65	7977900.0
2020-09-22	TLT	ETF	164.44	164.88	163.87	164.27	10524100.0
2020-09-22	AAA	ETF	24.98	24.99	24.975	24.975	8267.0
2020-09-22	AAAU	ETF	19.05	19.1	18.89	18.96	517800.0
2020-09-22	AADR	ETF	54.72	55.21	54.62	55.21	9100.0
2020-09-22	AAXJ	ETF	76.68	76.7	75.85	76.48	1250500.0
2020-09-22	ABEQ	ETF	22.94	23.27	22.94	23.26	13100.0
2020-09-22	ACES	ETF	51.5	51.8	51.05	51.79	22600.0
2020-09-22	ACIO	ETF	26.32	26.46	26.22	26.45	19600.0
2020-09-22	ACSI	ETF	36.7788	36.7788	36.7788	36.7788	115.0
2020-09-22	ACTX	ETF	2.2939	2.4603	2.2715	2.4603	430.0
2020-09-22	ACWF	ETF	29.2883	29.4188	29.2173	29.4188	4260.0
2020-09-22	ACWI	ETF	78.88	79.29	78.28	79.17	2444500.0
2020-09-22	ACWV	ETF	90.73	91.22	90.42	91.11	203800.0
2020-09-22	ACWX	ETF	45.91	45.91	45.45	45.875	1116332.0
2020-09-22	ADME	ETF	33.04	34.38	32.82	33.24	101200.0
2020-09-22	ADRE	ETF	46.13	46.225	45.64	46.225	4044.0
2020-09-22	AESR	ETF	10.65	10.731	10.65	10.731	6300.0
2020-09-22	AFIF	ETF	9.83	9.83	9.81	9.8201	15938.0
2020-09-22	AFK	ETF	17.69	17.6985	17.5508	17.5508	2816.0
2020-09-22	AFLG	ETF	19.957	19.957	19.957	19.957	100.0
2020-09-22	AFSM	ETF	17.66	17.66	17.66	17.66	200.0
2020-09-22	AFTY	ETF	19.63	19.63	19.47	19.482	2900.0
2020-09-22	AGG	ETF	118.25	118.38	118.24	118.33	4390200.0
2020-09-22	AGGY	ETF	53.97	54.0	53.938	53.96	77100.0
2020-09-22	AGNG	ETF	25.044	25.245	25.044	25.245	400.0
2020-09-22	AGQ	ETF	46.75	47.42	45.36	46.68	1707700.0
2020-09-22	AGZ	ETF	121.38	121.39	121.23	121.39	65548.0
2020-09-22	AGZD	ETF	23.52	23.52	23.425	23.425	12800.0
2020-09-22	AIA	ETF	71.75	71.75	71.0	71.61	88557.0
2020-09-22	AIEQ	ETF	29.85	30.318	29.707	30.23	6100.0
2020-09-22	AIQ	ETF	22.78	22.9999	22.5701	22.9744	11651.0
2020-09-22	AIRR	ETF	25.146	25.209	24.96	25.209	4800.0
2020-09-22	AIVI	ETF	35.94	36.01	35.64	35.92	33300.0
2020-09-22	ALTL	ETF	24.6599	24.75	24.57	24.7	13005.0
2020-09-22	ALTY	ETF	10.7	10.72	10.61	10.621	6900.0
2020-09-22	AMJ	ETF	11.33	11.61	11.17	11.21	729603.0
2020-09-22	AMLP	ETF	21.0	21.45	20.6	20.61	1910100.0
2020-09-22	AMNA	ETF	22.86	22.86	22.56	22.6686	2300.0
2020-09-22	AMND	ETF	23.66	23.66	23.617	23.617	200.0
2020-09-22	AMOM	ETF	33.0	34.616	33.0	34.616	900.0
2020-09-22	AMUB	ETF	7.13	7.26	7.02	7.03	11632.0
2020-09-22	AMZA	ETF	14.26	14.59	13.912	13.95	116100.0
2020-09-22	ANGL	ETF	29.83	29.88	29.72	29.87	1058800.0
2020-09-22	AOA	ETF	57.31	57.56	57.01	57.5	40200.0
2020-09-22	AOK	ETF	37.0	37.12	36.94	37.11	115765.0

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

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