PREVIEW / etf_daily / 2020-03-17

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-17.parquet
  size:    75 KB
  rows:    1,980

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-03-17	SPY	ETF	245.04	256.17	237.07	252.8	262070500.0
2020-03-17	QQQ	ETF	175.47	184.39	169.78	182.14	121257108.0
2020-03-17	IWM	ETF	104.96	110.5	100.61	108.37	59344800.0
2020-03-17	DIA	ETF	207.01	214.47	199.35	213.47	16128100.0
2020-03-17	GLD	ETF	140.18	146.2	139.93	143.56	24490300.0
2020-03-17	TLT	ETF	163.5	165.63	152.71	152.98	18570900.0
2020-03-17	AAAU	ETF	14.86	15.5	14.85	15.25	266000.0
2020-03-17	AADR	ETF	38.15	39.08	37.08	38.68	51300.0
2020-03-17	AAXJ	ETF	56.68	58.84	55.93	58.56	1878500.0
2020-03-17	ABEQ	ETF	19.48	20.4	19.14	20.079	6400.0
2020-03-17	ACES	ETF	26.39	27.795	25.32	27.78	29100.0
2020-03-17	ACIO	ETF	22.67	23.25	22.67	23.209	14000.0
2020-03-17	ACSI	ETF	25.9912	27.332	25.9912	27.332	1281.0
2020-03-17	ACTX	ETF	4.425	5.9001	4.425	4.72	827.0
2020-03-17	ACWF	ETF	22.6735	23.3981	22.3	23.381	11663.0
2020-03-17	ACWI	ETF	58.09	60.44	56.6	60.39	8580800.0
2020-03-17	ACWV	ETF	76.62	80.8	76.25	80.8	1076500.0
2020-03-17	ACWX	ETF	34.49	35.74	33.96	35.57	4880323.0
2020-03-17	ADME	ETF	27.51	28.15	27.32	28.15	21700.0
2020-03-17	ADRE	ETF	31.97	33.5136	31.87	33.1616	14648.0
2020-03-17	AESR	ETF	7.75	8.022	7.75	8.022	100.0
2020-03-17	AFIF	ETF	9.88	9.88	9.59	9.59	804.0
2020-03-17	AFK	ETF	12.65	13.58	12.4899	13.56	38266.0
2020-03-17	AFLG	ETF	15.49	15.566	15.21	15.566	400.0
2020-03-17	AFMC	ETF	13.7	13.857	13.7	13.857	300.0
2020-03-17	AFSM	ETF	13.226	13.263	13.07	13.263	2100.0
2020-03-17	AFTY	ETF	14.8	15.183	14.77	15.183	14000.0
2020-03-17	AGG	ETF	112.89	113.92	110.59	110.79	15737200.0
2020-03-17	AGGY	ETF	49.33	50.54	49.33	49.64	503900.0
2020-03-17	AGNG	ETF	17.74	18.564	17.74	18.564	2500.0
2020-03-17	AGQ	ETF	14.56	16.29	14.14	15.12	926700.0
2020-03-17	AGZ	ETF	123.56	123.56	119.3782	119.8	244669.0
2020-03-17	AGZD	ETF	23.09	23.44	22.225	22.94	82600.0
2020-03-17	AIA	ETF	52.15	54.29	51.7835	53.92	125787.0
2020-03-17	AIEQ	ETF	20.68	21.69	20.12	21.5	64400.0
2020-03-17	AIQ	ETF	13.9	14.45	13.5319	14.3	12308.0
2020-03-17	AIRR	ETF	18.54	19.444	17.99	19.389	35000.0
2020-03-17	AIVI	ETF	28.71	29.82	28.41	29.72	45500.0
2020-03-17	ALTY	ETF	9.02	9.623	8.75	8.97	124600.0
2020-03-17	AMJ	ETF	9.13	9.25	8.28	8.33	9260309.0
2020-03-17	AMLP	ETF	17.7	17.95	16.15	16.6	12455640.0
2020-03-17	AMOM	ETF	21.542	21.542	21.542	21.542	100.0
2020-03-17	AMUB	ETF	5.43	5.43	5.01	5.2479	129701.0
2020-03-17	AMZA	ETF	13.0	13.0	11.1	11.1	160290.0
2020-03-17	ANGL	ETF	25.36	25.36	24.31	24.7	1152300.0
2020-03-17	AOA	ETF	45.0	46.06	44.21	45.68	203200.0
2020-03-17	AOK	ETF	32.7	32.97	32.41	32.75	340388.0
2020-03-17	AOM	ETF	35.21	35.6699	34.83	35.46	813760.0
2020-03-17	AOR	ETF	39.56	40.2585	38.912	39.85	356369.0
2020-03-17	ARGT	ETF	16.75	17.14	16.27	16.76	17300.0

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

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