PREVIEW / etf_daily / 2020-04-08

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-08.parquet
  size:    74 KB
  rows:    1,944

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-04-08	SPY	ETF	267.96	276.0	265.25	274.03	153774500.0
2020-04-08	QQQ	ETF	198.0835	201.17	196.1733	200.57	45940439.0
2020-04-08	IWM	ETF	114.88	119.24	113.29	118.07	52822300.0
2020-04-08	DIA	ETF	229.14	235.25	226.84	234.33	7010200.0
2020-04-08	GLD	ETF	155.91	155.94	154.59	154.65	7600800.0
2020-04-08	TLT	ETF	165.11	166.19	164.13	165.09	10147100.0
2020-04-08	AAAU	ETF	16.51	16.52	16.4	16.42	110700.0
2020-04-08	AADR	ETF	41.45	42.57	41.45	42.57	4800.0
2020-04-08	AAXJ	ETF	61.36	61.77	60.87	61.72	940500.0
2020-04-08	ABEQ	ETF	20.92	21.24	20.8	21.186	12700.0
2020-04-08	ACES	ETF	29.86	30.68	29.5	30.49	36000.0
2020-04-08	ACIO	ETF	23.148	23.48	23.03	23.26	14600.0
2020-04-08	ACSI	ETF	28.63	29.4784	28.63	29.4784	836.0
2020-04-08	ACTX	ETF	5.605	5.8411	4.7348	5.8411	410.0
2020-04-08	ACWF	ETF	24.88	25.43	24.8469	25.28	10118.0
2020-04-08	ACWI	ETF	64.34	65.54	63.74	65.3	6039200.0
2020-04-08	ACWV	ETF	83.35	84.72	82.34	84.41	309200.0
2020-04-08	ACWX	ETF	38.26	38.59	37.92	38.45	2236703.0
2020-04-08	ADME	ETF	28.52	29.2	28.463	29.092	23800.0
2020-04-08	ADRE	ETF	34.46	34.7513	34.2773	34.6866	5952.0
2020-04-08	AESR	ETF	8.59	8.729	8.59	8.729	144000.0
2020-04-08	AFIF	ETF	9.71	9.78	9.59	9.7218	924842.0
2020-04-08	AFK	ETF	13.5	13.54	13.25	13.36	7311.0
2020-04-08	AFMC	ETF	14.45	15.07	14.45	15.022	500.0
2020-04-08	AFTY	ETF	15.43	15.43	15.32	15.32	2200.0
2020-04-08	AGG	ETF	115.7	115.97	115.55	115.81	4674200.0
2020-04-08	AGGY	ETF	51.99	52.49	51.91	52.2	303300.0
2020-04-08	AGNG	ETF	20.6	21.26	20.6	21.26	2400.0
2020-04-08	AGQ	ETF	21.53	21.66	20.93	21.11	171800.0
2020-04-08	AGZ	ETF	120.27	120.27	119.9816	120.07	53131.0
2020-04-08	AGZD	ETF	23.285	23.375	23.18	23.22	31200.0
2020-04-08	AIA	ETF	57.64	58.12	57.28	57.94	58879.0
2020-04-08	AIEQ	ETF	23.0	23.538	23.0	23.48	13600.0
2020-04-08	AIQ	ETF	16.13	16.38	16.0	16.3243	8134.0
2020-04-08	AIRR	ETF	19.99	20.77	19.99	20.77	13300.0
2020-04-08	AIVI	ETF	31.94	32.22	31.82	32.1	9700.0
2020-04-08	ALTY	ETF	8.41	9.18	8.41	9.109	10300.0
2020-04-08	AMJ	ETF	9.76	10.09	9.38	9.38	3547329.0
2020-04-08	AMLP	ETF	18.5	19.25	18.15	18.65	9107140.0
2020-04-08	AMOM	ETF	23.492	23.769	23.492	23.769	300.0
2020-04-08	AMUB	ETF	6.09	6.252	6.09	6.2086	228453.0
2020-04-08	AMZA	ETF	11.87	12.43	11.72	12.05	225300.0
2020-04-08	ANGL	ETF	25.63	25.98	25.45	25.87	1243800.0
2020-04-08	AOA	ETF	48.67	49.41	48.24	49.17	137400.0
2020-04-08	AOK	ETF	34.11	34.5	34.09	34.41	150053.0
2020-04-08	AOM	ETF	36.96	37.2762	36.86	37.24	235572.0
2020-04-08	AOR	ETF	42.04	42.5	41.79	42.38	223894.0
2020-04-08	ARGT	ETF	17.16	17.5	17.15	17.48	36400.0
2020-04-08	ARKF	ETF	21.14	21.62	21.067	21.57	75200.0
2020-04-08	ARKG	ETF	32.3	32.585	31.499	32.56	148500.0

> showing 50 of 1,944 rows — these rows as CSV

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