PREVIEW / etf_daily / 2021-01-26

all etf daily files

  file:    by_date/etf_daily/2021/2021-01-26.parquet
  size:    85 KB
  rows:    2,239

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-01-26	SPY	ETF	385.41	385.85	383.54	383.79	42665300.0
2021-01-26	QQQ	ETF	328.85	329.76	327.22	328.59	25498112.0
2021-01-26	IWM	ETF	216.3	216.69	212.77	213.3	23969800.0
2021-01-26	DIA	ETF	310.54	311.19	309.21	309.39	2256100.0
2021-01-26	GLD	ETF	173.98	174.26	173.42	173.62	4685600.0
2021-01-26	TLT	ETF	153.1	153.6	152.92	153.38	7690300.0
2021-01-26	AAA	ETF	25.158	25.165	25.158	25.165	479.0
2021-01-26	AAAU	ETF	18.47	18.5	18.42	18.44	3794000.0
2021-01-26	AADR	ETF	63.04	63.04	62.42	62.42	13000.0
2021-01-26	AAXJ	ETF	98.13	98.22	97.62	98.18	691600.0
2021-01-26	ABEQ	ETF	25.81	25.83	25.74	25.79	6200.0
2021-01-26	ACES	ETF	98.19	99.18	97.2	97.95	161100.0
2021-01-26	ACIO	ETF	28.06	28.06	27.88	27.9	75000.0
2021-01-26	ACSI	ETF	44.6093	44.6093	44.6093	44.6093	122.0
2021-01-26	ACTV	ETF	33.01	33.1892	33.01	33.12	5460.0
2021-01-26	ACTX	ETF	5.5	5.5	4.8	5.0	1885.0
2021-01-26	ACVF	ETF	28.44	28.5	28.36	28.396	3500.0
2021-01-26	ACWF	ETF	35.47	35.47	35.1877	35.1877	8464.0
2021-01-26	ACWI	ETF	94.22	94.29	93.72	93.79	1123200.0
2021-01-26	ACWV	ETF	98.27	98.34	97.9	98.22	221100.0
2021-01-26	ACWX	ETF	55.46	55.495	55.19	55.39	975862.0
2021-01-26	ADFI	ETF	9.89	9.89	9.89	9.89	100.0
2021-01-26	ADME	ETF	36.89	36.89	36.48	36.48	58000.0
2021-01-26	ADRE	ETF	62.33	62.33	61.5955	61.7	13859.0
2021-01-26	AESR	ETF	12.176	12.2	12.163	12.163	3500.0
2021-01-26	AFIF	ETF	9.7	9.7601	9.7	9.755	8493.0
2021-01-26	AFK	ETF	21.45	21.4777	21.3301	21.36	7942.0
2021-01-26	AFLG	ETF	23.3	23.3	23.09	23.134	1400.0
2021-01-26	AFMC	ETF	22.81	22.81	22.755	22.755	200.0
2021-01-26	AFSM	ETF	24.43	24.43	24.23	24.263	1300.0
2021-01-26	AFTY	ETF	24.62	24.649	24.6	24.649	4500.0
2021-01-26	AGG	ETF	117.46	117.59	117.43	117.51	3639500.0
2021-01-26	AGGY	ETF	53.27	53.34	53.25	53.29	313800.0
2021-01-26	AGNG	ETF	29.27	29.31	29.268	29.27	7500.0
2021-01-26	AGQ	ETF	46.54	47.22	46.12	46.47	600000.0
2021-01-26	AGZ	ETF	119.57	119.5884	119.55	119.58	20668.0
2021-01-26	AGZD	ETF	23.735	23.735	23.555	23.585	129800.0
2021-01-26	AIA	ETF	98.78	98.82	98.15	98.62	307631.0
2021-01-26	AIEQ	ETF	40.27	40.31	39.52	39.68	263300.0
2021-01-26	AIQ	ETF	28.87	28.87	28.64	28.69	58354.0
2021-01-26	AIRR	ETF	37.19	37.33	36.387	36.395	48900.0
2021-01-26	AIVI	ETF	42.36	42.45	42.31	42.38	4200.0
2021-01-26	ALTL	ETF	33.685	33.685	32.91	32.9125	2570.0
2021-01-26	ALTY	ETF	12.02	12.07	12.01	12.04	17200.0
2021-01-26	AMJ	ETF	15.17	15.39	14.86	14.86	684263.0
2021-01-26	AMLP	ETF	27.88	28.39	27.43	27.46	2326900.0
2021-01-26	AMNA	ETF	26.783	26.783	26.783	26.783	1.0
2021-01-26	AMND	ETF	28.4773	28.4773	28.4773	28.4773	3.0
2021-01-26	AMOM	ETF	32.937	32.937	32.937	32.937	700.0
2021-01-26	AMTR	ETF	30.74	30.74	30.74	30.74	1419.0

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

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