PREVIEW / etf_daily / 2020-03-23

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-23.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-23	SPY	ETF	228.19	229.68	218.26	222.95	326025200.0
2020-03-23	QQQ	ETF	170.92	174.21	164.93	170.46	124639782.0
2020-03-23	IWM	ETF	101.9	102.18	95.91	99.9	63534700.0
2020-03-23	DIA	ETF	190.13	191.2	182.1	186.13	15712300.0
2020-03-23	GLD	ETF	142.68	146.93	142.28	146.3	28275200.0
2020-03-23	TLT	ETF	157.5	166.69	156.57	166.0	19971800.0
2020-03-23	AAAU	ETF	16.55	16.55	15.09	15.49	421600.0
2020-03-23	AADR	ETF	35.33	35.64	34.79	35.16	40800.0
2020-03-23	AAXJ	ETF	54.57	54.59	52.95	53.81	1296100.0
2020-03-23	ABEQ	ETF	18.64	18.64	18.009	18.163	4700.0
2020-03-23	ACES	ETF	25.72	25.76	24.064	24.46	53800.0
2020-03-23	ACIO	ETF	21.29	22.26	21.29	22.053	18700.0
2020-03-23	ACSI	ETF	24.4	25.0	24.32	24.7102	1346.0
2020-03-23	ACTX	ETF	2.36	3.481	2.36	3.1123	1124.0
2020-03-23	ACWF	ETF	21.32	21.32	20.7499	21.0	65701.0
2020-03-23	ACWI	ETF	55.18	55.52	53.31	54.33	8156700.0
2020-03-23	ACWV	ETF	72.88	72.91	70.06	70.74	1379500.0
2020-03-23	ACWX	ETF	33.41	33.67	32.59	32.8	5159266.0
2020-03-23	ADME	ETF	25.94	26.57	25.94	26.42	15400.0
2020-03-23	ADRE	ETF	30.28	30.365	29.264	30.2363	14869.0
2020-03-23	AESR	ETF	7.301	7.301	7.301	7.301	100.0
2020-03-23	AFIF	ETF	9.685	9.7508	9.68	9.7508	716.0
2020-03-23	AFK	ETF	11.48	12.41	11.45	11.6899	23599.0
2020-03-23	AFLG	ETF	13.47	13.62	13.44	13.62	200.0
2020-03-23	AFMC	ETF	12.094	12.094	12.094	12.094	100.0
2020-03-23	AFSM	ETF	12.2	12.2	11.37	11.805	1400.0
2020-03-23	AFTY	ETF	14.45	14.45	14.08	14.1	6800.0
2020-03-23	AGG	ETF	109.9	112.94	109.0	112.64	12572200.0
2020-03-23	AGGY	ETF	46.21	49.36	46.21	49.33	1302900.0
2020-03-23	AGNG	ETF	18.16	18.16	17.141	17.2	9000.0
2020-03-23	AGQ	ETF	15.33	16.37	15.2	16.22	751900.0
2020-03-23	AGZ	ETF	120.97	121.8356	119.01	120.4973	124906.0
2020-03-23	AGZD	ETF	21.61	22.53	21.395	22.315	36400.0
2020-03-23	AIA	ETF	51.31	51.69	50.26	51.26	276941.0
2020-03-23	AIEQ	ETF	20.06	20.06	19.14	19.73	45500.0
2020-03-23	AIQ	ETF	13.8	14.14	13.55	13.99	10501.0
2020-03-23	AIRR	ETF	17.68	17.68	16.58	17.024	56600.0
2020-03-23	AIVI	ETF	27.97	28.46	27.35	27.81	151200.0
2020-03-23	ALTY	ETF	7.75	7.789	6.7	7.32	32800.0
2020-03-23	AMJ	ETF	9.0	9.04	8.0	8.0	4707019.0
2020-03-23	AMLP	ETF	17.3	17.3	15.45	15.65	13469880.0
2020-03-23	AMOM	ETF	20.46	20.46	20.029	20.029	400.0
2020-03-23	AMUB	ETF	5.14	5.36	5.04	5.1028	8836.0
2020-03-23	AMZA	ETF	11.3	11.7	10.0	10.0	112550.0
2020-03-23	ANGL	ETF	22.2	23.5	21.99	22.3	2323200.0
2020-03-23	AOA	ETF	42.63	43.0	41.85	42.55	502100.0
2020-03-23	AOK	ETF	31.49	32.1	31.11	31.84	376716.0
2020-03-23	AOM	ETF	33.93	34.32	33.6	34.19	1431937.0
2020-03-23	AOR	ETF	37.83	38.4277	37.2616	37.67	949931.0
2020-03-23	ARCM	ETF	107.21	107.21	99.225	99.225	500.0

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

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