PREVIEW / etf_daily / 2021-10-26

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-26.parquet
  size:    95 KB
  rows:    2,538

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
2021-10-26	SPY	ETF	457.2	458.49	455.56	455.96	56075100.0
2021-10-26	QQQ	ETF	380.23	382.71	377.905	379.12	47191279.0
2021-10-26	IWM	ETF	230.03	230.72	227.8	227.84	25290200.0
2021-10-26	DIA	ETF	358.56	358.93	357.37	357.5	3182200.0
2021-10-26	GLD	ETF	167.88	167.91	166.63	167.68	6658900.0
2021-10-26	TLT	ETF	144.62	145.1	143.74	145.1	13671000.0
2021-10-26	AAA	ETF	25.01	25.01	25.01	25.01	61.0
2021-10-26	AAAU	ETF	17.86	17.86	17.72	17.83	311600.0
2021-10-26	AADR	ETF	66.34	66.36	65.86	66.0	1800.0
2021-10-26	AAXJ	ETF	88.9	88.9	87.9	87.94	1440500.0
2021-10-26	ABEQ	ETF	28.0	28.03	27.93	27.99	1700.0
2021-10-26	ACES	ETF	74.57	74.95	73.148	73.43	44100.0
2021-10-26	ACIO	ETF	31.66	31.681	31.51	31.62	68500.0
2021-10-26	ACSI	ETF	52.42	52.42	52.0323	52.0323	842.0
2021-10-26	ACT	ETF	22.58	22.76	22.35	22.5	73336.0
2021-10-26	ACTV	ETF	39.048	39.125	38.7573	38.7573	9887.0
2021-10-26	ACVF	ETF	34.39	34.459	34.264	34.31	9200.0
2021-10-26	ACWF	ETF	38.47	38.47	38.16	38.1915	4001.0
2021-10-26	ACWI	ETF	105.67	105.84	105.12	105.21	6043500.0
2021-10-26	ACWV	ETF	106.0	106.18	105.95	105.98	89300.0
2021-10-26	ACWX	ETF	57.76	57.78	57.39	57.45	890563.0
2021-10-26	ADFI	ETF	8.95	9.65	8.95	9.64	1600.0
2021-10-26	ADIV	ETF	17.685	17.685	17.685	17.685	100.0
2021-10-26	ADME	ETF	41.76	41.76	41.57	41.61	52800.0
2021-10-26	ADRE	ETF	51.6	51.6	50.79	50.98	9289.0
2021-10-26	AESR	ETF	14.47	14.56	14.46	14.46	7500.0
2021-10-26	AFIF	ETF	9.6176	9.63	9.6176	9.6251	13578.0
2021-10-26	AFK	ETF	22.0	22.0	21.66	21.75	7586.0
2021-10-26	AFLG	ETF	26.86	26.86	26.746	26.746	100.0
2021-10-26	AFSM	ETF	27.36	27.36	27.083	27.083	600.0
2021-10-26	AFTY	ETF	21.72	21.72	21.7	21.704	1800.0
2021-10-26	AGG	ETF	114.25	114.38	114.11	114.38	5429800.0
2021-10-26	AGGY	ETF	51.71	51.73	51.62	51.73	66000.0
2021-10-26	AGNG	ETF	29.7	29.8	29.4	29.79	4300.0
2021-10-26	AGOV	ETF	99.215	99.215	99.215	99.215	73.0
2021-10-26	AGOX	ETF	27.43	27.43	27.143	27.2	76400.0
2021-10-26	AGQ	ETF	38.19	38.19	37.18	38.06	1305000.0
2021-10-26	AGZ	ETF	117.79	117.8999	117.7794	117.86	14573.0
2021-10-26	AGZD	ETF	23.43	23.475	23.425	23.43	77000.0
2021-10-26	AIA	ETF	82.88	82.9402	81.93	82.06	66241.0
2021-10-26	AIEQ	ETF	43.4	43.48	43.02	43.17	17100.0
2021-10-26	AIQ	ETF	31.93	31.95	31.5896	31.68	37222.0
2021-10-26	AIRR	ETF	43.71	43.95	43.41	43.52	22300.0
2021-10-26	AIVI	ETF	41.73	41.75	41.59	41.6	2700.0
2021-10-26	ALTL	ETF	43.59	43.8511	43.28	43.28	34220.0
2021-10-26	ALTY	ETF	13.78	13.78	13.68	13.72	36400.0
2021-10-26	AMJ	ETF	19.85	19.945	19.49	19.56	405119.0
2021-10-26	AMLP	ETF	36.64	36.8	35.92	36.03	1678800.0
2021-10-26	AMNA	ETF	35.4215	35.4215	35.4215	35.4215	0.0
2021-10-26	AMND	ETF	36.5477	36.5477	36.5477	36.5477	101.0

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

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