PREVIEW / etf_daily / 2022-10-17

all etf daily files

  file:    by_date/etf_daily/2022/2022-10-17.parquet
  size:    105 KB
  rows:    2,828

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-10-17	SPY	ETF	364.01	367.98	357.28	366.82	93168200.0
2022-10-17	QQQ	ETF	266.84	270.24	266.74	269.35	64576452.0
2022-10-17	IWM	ETF	170.22	172.62	170.11	172.13	28199200.0
2022-10-17	DIA	ETF	300.89	303.21	299.98	302.06	3555700.0
2022-10-17	GLD	ETF	154.92	155.33	153.32	153.42	4348000.0
2022-10-17	TLT	ETF	99.29	99.66	97.94	98.09	18969900.0
2022-10-17	AAA	ETF	24.09	24.09	24.05	24.07	201.0
2022-10-17	AAAU	ETF	16.52	16.55	16.35	16.35	462000.0
2022-10-17	AADR	ETF	45.32	45.32	45.21	45.21	900.0
2022-10-17	AAPB	ETF	18.5074	18.7605	18.4399	18.7605	5672.0
2022-10-17	AAPD	ETF	28.71	28.85	28.331	28.42	72926.0
2022-10-17	AAPU	ETF	19.39	19.759	19.27	19.66	27963.0
2022-10-17	AAXJ	ETF	57.9	58.5	57.83	58.29	777300.0
2022-10-17	ABEQ	ETF	25.75	25.83	25.727	25.79	8100.0
2022-10-17	ACES	ETF	50.18	51.33	50.07	50.39	87000.0
2022-10-17	ACIO	ETF	28.68	28.68	28.58	28.616	21000.0
2022-10-17	ACSI	ETF	41.3634	41.3634	41.3634	41.3634	23.0
2022-10-17	ACT	ETF	23.67	23.92	23.49	23.74	132703.0
2022-10-17	ACTV	ETF	27.5299	27.66	27.515	27.5899	9298.0
2022-10-17	ACTX	ETF	0.498	0.498	0.498	0.498	367.0
2022-10-17	ACVF	ETF	27.58	27.66	27.492	27.555	2600.0
2022-10-17	ACWF	ETF	30.0714	30.12	29.94	30.0461	6242.0
2022-10-17	ACWI	ETF	79.07	79.85	79.07	79.6	5449900.0
2022-10-17	ACWV	ETF	88.93	89.65	88.93	89.35	139200.0
2022-10-17	ACWX	ETF	40.56	40.89	40.55	40.73	3889049.0
2022-10-17	ADFI	ETF	8.179	8.18	8.15	8.165	4800.0
2022-10-17	ADIV	ETF	11.69	11.7	11.672	11.672	2000.0
2022-10-17	ADME	ETF	33.0	33.85	33.0	33.76	12600.0
2022-10-17	ADRE	ETF	33.77	34.32	33.77	34.06	25469.0
2022-10-17	AEMB	ETF	35.3	35.31	35.057	35.057	1700.0
2022-10-17	AESR	ETF	10.92	11.08	10.88	10.94	349700.0
2022-10-17	AFIF	ETF	8.63	8.64	8.62	8.64	22275.0
2022-10-17	AFK	ETF	15.49	15.49	15.14	15.37	4511.0
2022-10-17	AFLG	ETF	22.19	22.19	22.166	22.166	1500.0
2022-10-17	AFSM	ETF	21.81	21.873	21.81	21.873	3500.0
2022-10-17	AFTY	ETF	15.323	15.323	15.323	15.323	200.0
2022-10-17	AGG	ETF	95.25	95.4	94.83	94.86	5460600.0
2022-10-17	AGGY	ETF	41.7	41.76	41.52	41.54	182900.0
2022-10-17	AGNG	ETF	24.3	24.3	24.3	24.3	200.0
2022-10-17	AGOV	ETF	76.0	77.35	75.41	76.2064	2533.0
2022-10-17	AGOX	ETF	19.69	19.71	19.53	19.628	40100.0
2022-10-17	AGQ	ETF	20.01	20.25	19.51	19.52	1318500.0
2022-10-17	AGZ	ETF	105.8	106.0	105.6233	105.64	34174.0
2022-10-17	AGZD	ETF	22.835	22.835	22.75	22.76	55400.0
2022-10-17	AHHX	ETF	8.22	8.3399	8.19	8.2554	6761.0
2022-10-17	AHYB	ETF	42.09	42.122	42.06	42.122	700.0
2022-10-17	AIA	ETF	49.28	49.83	49.28	49.6	58468.0
2022-10-17	AIEQ	ETF	29.33	29.888	29.33	29.67	10600.0
2022-10-17	AIQ	ETF	18.91	19.26	18.91	19.25	8277.0
2022-10-17	AIRR	ETF	40.22	40.89	40.22	40.89	34200.0

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

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