PREVIEW / etf_daily / 2021-12-28

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-28.parquet
  size:    98 KB
  rows:    2,612

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-12-28	SPY	ETF	477.72	478.81	476.06	476.87	47274600.0
2021-12-28	QQQ	ETF	404.4	404.58	400.71	401.61	33113728.0
2021-12-28	IWM	ETF	223.79	225.73	222.35	222.75	23120300.0
2021-12-28	DIA	ETF	363.11	365.12	362.89	363.99	3048500.0
2021-12-28	GLD	ETF	169.33	169.65	168.62	168.64	4541900.0
2021-12-28	TLT	ETF	149.6	149.78	148.01	148.29	9174600.0
2021-12-28	AAA	ETF	25.02	25.032	25.02	25.025	400.0
2021-12-28	AAAU	ETF	18.02	18.04	17.94	17.94	123700.0
2021-12-28	AADR	ETF	64.39	64.44	64.38	64.38	900.0
2021-12-28	AAXJ	ETF	82.89	82.89	82.47	82.51	739100.0
2021-12-28	ABEQ	ETF	28.465	28.465	28.419	28.419	3600.0
2021-12-28	ACES	ETF	64.65	64.959	63.63	63.89	96900.0
2021-12-28	ACIO	ETF	32.81	32.82	32.73	32.75	49500.0
2021-12-28	ACSI	ETF	53.23	53.23	53.1795	53.1795	675.0
2021-12-28	ACT	ETF	20.24	20.4	19.99	20.2	212633.0
2021-12-28	ACTV	ETF	36.73	36.82	36.38	36.454	25912.0
2021-12-28	ACTX	ETF	1.4	1.415	1.34	1.34	974.0
2021-12-28	ACVF	ETF	35.89	35.89	35.68	35.705	4300.0
2021-12-28	ACWF	ETF	39.23	39.255	39.1	39.1	10187.0
2021-12-28	ACWI	ETF	106.36	106.54	106.04	106.14	7115000.0
2021-12-28	ACWV	ETF	107.99	108.19	107.92	108.11	98000.0
2021-12-28	ACWX	ETF	55.84	55.93	55.75	55.81	1313738.0
2021-12-28	ADFI	ETF	9.59	9.61	9.59	9.605	1800.0
2021-12-28	ADIV	ETF	16.47	16.486	16.45	16.486	500.0
2021-12-28	ADME	ETF	43.59	43.67	43.433	43.44	89200.0
2021-12-28	ADRE	ETF	45.27	45.27	45.01	45.02	15376.0
2021-12-28	AEMB	ETF	48.4	48.42	48.344	48.344	2000.0
2021-12-28	AESR	ETF	14.1	14.1	14.03	14.03	3500.0
2021-12-28	AFIF	ETF	9.58	9.581	9.57	9.57	6839.0
2021-12-28	AFK	ETF	19.84	20.2349	19.84	19.88	12439.0
2021-12-28	AFLG	ETF	28.089	28.09	28.089	28.09	300.0
2021-12-28	AFMC	ETF	26.526	26.526	26.526	26.526	100.0
2021-12-28	AFSM	ETF	27.851	27.851	27.642	27.642	700.0
2021-12-28	AFTY	ETF	21.17	21.195	21.17	21.195	300.0
2021-12-28	AGG	ETF	114.43	114.45	114.17	114.21	5253800.0
2021-12-28	AGGY	ETF	51.8	51.847	51.706	51.72	170000.0
2021-12-28	AGNG	ETF	29.178	29.178	29.06	29.06	2300.0
2021-12-28	AGOV	ETF	98.37	98.37	98.1545	98.1545	640.0
2021-12-28	AGOX	ETF	25.77	25.77	25.37	25.37	18300.0
2021-12-28	AGQ	ETF	34.41	34.67	33.87	33.93	524000.0
2021-12-28	AGZ	ETF	117.325	117.3437	117.23	117.23	23864.0
2021-12-28	AGZD	ETF	23.335	23.415	23.335	23.35	48400.0
2021-12-28	AHHX	ETF	10.26	10.52	10.25	10.389	1955.0
2021-12-28	AHYB	ETF	50.216	50.225	50.216	50.22	8900.0
2021-12-28	AIA	ETF	76.65	76.72	76.28	76.35	80022.0
2021-12-28	AIEQ	ETF	42.28	42.28	41.7	41.783	11400.0
2021-12-28	AIQ	ETF	32.26	32.26	31.93	32.01	26403.0
2021-12-28	AIRR	ETF	45.107	45.25	44.95	45.01	10600.0
2021-12-28	AIVI	ETF	41.94	42.14	41.94	42.03	5700.0
2021-12-28	ALTL	ETF	46.49	46.57	46.0212	46.17	250735.0

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

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