PREVIEW / etf_daily / 2022-01-25

all etf daily files

  file:    by_date/etf_daily/2022/2022-01-25.parquet
  size:    100 KB
  rows:    2,658

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
2022-01-25	SPY	ETF	433.06	439.72	427.15	434.47	167997300.0
2022-01-25	QQQ	ETF	346.67	351.0295	341.68	345.11	124398394.0
2022-01-25	IWM	ETF	198.48	201.7	194.56	198.84	61088500.0
2022-01-25	DIA	ETF	340.26	345.79	335.34	342.96	18657900.0
2022-01-25	GLD	ETF	171.95	173.15	171.78	172.58	17382100.0
2022-01-25	TLT	ETF	143.11	143.71	141.8	142.22	15599000.0
2022-01-25	AAA	ETF	25.0	25.0	24.985	24.985	335.0
2022-01-25	AAAU	ETF	18.31	18.42	18.29	18.37	334900.0
2022-01-25	AADR	ETF	59.07	60.72	59.07	60.27	3400.0
2022-01-25	AAXJ	ETF	81.04	81.69	80.71	81.29	2262600.0
2022-01-25	ABEQ	ETF	27.67	28.106	27.67	28.106	700.0
2022-01-25	ACES	ETF	51.81	52.21	50.45	51.28	63600.0
2022-01-25	ACIO	ETF	30.865	31.118	30.59	30.9	31700.0
2022-01-25	ACSI	ETF	48.22	48.5466	48.19	48.5466	710.0
2022-01-25	ACT	ETF	20.93	21.73	20.48	21.19	133879.0
2022-01-25	ACTV	ETF	33.75	34.38	33.75	34.2597	4059.0
2022-01-25	ACTX	ETF	1.1999	1.2	1.05	1.05	485.0
2022-01-25	ACVF	ETF	32.55	32.923	31.99	32.553	8400.0
2022-01-25	ACWF	ETF	36.57	36.89	36.27	36.5744	5538.0
2022-01-25	ACWI	ETF	98.03	99.38	96.92	98.36	17991900.0
2022-01-25	ACWV	ETF	102.01	102.63	101.28	101.83	260500.0
2022-01-25	ACWX	ETF	53.28	53.93	52.86	53.6	6680709.0
2022-01-25	ADFI	ETF	9.4	9.41	9.36	9.38	4800.0
2022-01-25	ADIV	ETF	16.127	16.127	16.127	16.127	100.0
2022-01-25	ADME	ETF	40.241	40.69	39.935	40.2	29700.0
2022-01-25	ADRE	ETF	45.81	46.2763	45.32	45.9267	14256.0
2022-01-25	AEMB	ETF	46.727	46.727	46.727	46.727	100.0
2022-01-25	AESR	ETF	12.75	12.89	12.58	12.755	14400.0
2022-01-25	AFIF	ETF	9.49	9.49	9.4744	9.48	9617.0
2022-01-25	AFK	ETF	20.21	20.26	20.04	20.26	4534.0
2022-01-25	AFLG	ETF	25.46	25.661	25.46	25.661	6000.0
2022-01-25	AFMC	ETF	24.252	24.252	24.252	24.252	100.0
2022-01-25	AFSM	ETF	24.706	24.706	24.706	24.706	100.0
2022-01-25	AFTY	ETF	20.176	20.176	20.176	20.176	100.0
2022-01-25	AGG	ETF	112.18	112.3	111.96	111.99	9541000.0
2022-01-25	AGGY	ETF	50.46	50.5	50.31	50.37	215100.0
2022-01-25	AGNG	ETF	26.23	26.44	26.11	26.26	3600.0
2022-01-25	AGOV	ETF	96.32	96.32	96.29	96.29	4033.0
2022-01-25	AGOX	ETF	23.27	23.74	23.2	23.56	149700.0
2022-01-25	AGQ	ETF	35.49	36.58	35.43	36.19	1048100.0
2022-01-25	AGZ	ETF	116.56	116.56	116.22	116.25	24133.0
2022-01-25	AGZD	ETF	23.235	23.275	23.225	23.26	138200.0
2022-01-25	AHHX	ETF	9.99	9.99	9.98	9.985	4460.0
2022-01-25	AHYB	ETF	49.16	49.18	49.16	49.18	400.0
2022-01-25	AIA	ETF	76.43	77.27	76.26	76.85	49571.0
2022-01-25	AIEQ	ETF	35.58	35.917	35.125	35.34	16200.0
2022-01-25	AIQ	ETF	27.48	27.75	27.1	27.31	25943.0
2022-01-25	AIRR	ETF	40.73	41.19	40.1	40.72	9300.0
2022-01-25	AIVI	ETF	41.33	42.18	41.33	42.04	7900.0
2022-01-25	AIVL	ETF	96.8	98.22	95.72	97.47	15900.0

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

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