PREVIEW / etf_daily / 2020-06-22

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-22.parquet
  size:    76 KB
  rows:    2,025

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-06-22	SPY	ETF	307.99	311.05	306.75	310.62	74649400.0
2020-06-22	QQQ	ETF	243.77	246.87	243.38	246.74	24068676.0
2020-06-22	IWM	ETF	140.24	142.56	138.83	142.4	28983200.0
2020-06-22	DIA	ETF	257.88	260.58	256.68	260.32	2823500.0
2020-06-22	GLD	ETF	165.06	165.73	164.41	165.09	12385600.0
2020-06-22	TLT	ETF	163.19	163.42	162.07	162.41	9319700.0
2020-06-22	AAAU	ETF	17.5	17.57	17.44	17.5	308300.0
2020-06-22	AADR	ETF	52.09	53.0	52.09	52.98	5700.0
2020-06-22	AAXJ	ETF	69.15	69.77	69.03	69.71	989000.0
2020-06-22	ABEQ	ETF	22.4	22.43	22.369	22.369	4100.0
2020-06-22	ACES	ETF	38.71	38.875	37.856	38.17	21700.0
2020-06-22	ACIO	ETF	24.99	25.18	24.96	25.174	2800.0
2020-06-22	ACSI	ETF	33.43	33.6161	33.43	33.6161	574.0
2020-06-22	ACTX	ETF	3.835	4.248	3.245	3.894	1349.0
2020-06-22	ACWF	ETF	27.75	28.01	27.69	27.9679	6727.0
2020-06-22	ACWI	ETF	73.95	74.53	73.65	74.47	1953200.0
2020-06-22	ACWV	ETF	87.85	88.41	87.73	88.3	250600.0
2020-06-22	ACWX	ETF	43.54	43.815	43.41	43.76	1959606.0
2020-06-22	ADME	ETF	31.99	32.29	31.95	32.257	13800.0
2020-06-22	ADRE	ETF	39.765	39.93	39.638	39.83	3866.0
2020-06-22	AESR	ETF	9.89	9.98	9.89	9.976	2800.0
2020-06-22	AFIF	ETF	9.8128	9.8244	9.81	9.81	6047.0
2020-06-22	AFK	ETF	16.12	16.17	16.041	16.15	13779.0
2020-06-22	AFLG	ETF	18.935	18.935	18.935	18.935	100.0
2020-06-22	AFMC	ETF	17.0	17.096	17.0	17.096	100.0
2020-06-22	AFSM	ETF	16.62	16.801	16.62	16.801	100.0
2020-06-22	AFTY	ETF	16.62	16.7	16.62	16.676	500.0
2020-06-22	AGG	ETF	118.0	118.0	117.73	117.77	3445700.0
2020-06-22	AGGY	ETF	53.74	53.8	53.7	53.71	186600.0
2020-06-22	AGNG	ETF	24.82	24.82	24.545	24.741	4300.0
2020-06-22	AGQ	ETF	28.39	28.75	27.5	27.67	719800.0
2020-06-22	AGZ	ETF	121.11	121.11	120.76	120.76	17033.0
2020-06-22	AGZD	ETF	23.505	23.6	23.495	23.55	10200.0
2020-06-22	AIA	ETF	64.3	64.91	64.14	64.75	57351.0
2020-06-22	AIEQ	ETF	27.72	28.2	27.72	28.1	24300.0
2020-06-22	AIQ	ETF	20.47	20.79	20.47	20.765	14751.0
2020-06-22	AIRR	ETF	23.058	23.655	23.058	23.655	45700.0
2020-06-22	AIVI	ETF	36.2	36.48	36.2	36.43	58200.0
2020-06-22	ALTY	ETF	11.1	11.1	10.942	11.03	10300.0
2020-06-22	AMJ	ETF	14.52	14.78	14.36	14.73	1109158.0
2020-06-22	AMLP	ETF	27.07	27.52	26.72	27.47	2110200.0
2020-06-22	AMNA	ETF	25.145	25.145	25.145	25.145	0.0
2020-06-22	AMOM	ETF	29.66	29.67	29.649	29.649	600.0
2020-06-22	AMUB	ETF	9.12	9.32	9.12	9.32	9979.0
2020-06-22	AMZA	ETF	20.2	20.55	19.65	20.48	48400.0
2020-06-22	ANGL	ETF	29.08	29.13	28.85	29.0	362500.0
2020-06-22	AOA	ETF	54.85	55.25	54.85	55.23	129900.0
2020-06-22	AOK	ETF	36.38	36.44	36.3	36.44	187296.0
2020-06-22	AOM	ETF	39.9	40.04	39.7737	40.02	144598.0
2020-06-22	AOR	ETF	46.29	46.63	46.29	46.62	124190.0

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

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