PREVIEW / etf_daily / 2022-10-18

all etf daily files

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

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-18	SPY	ETF	375.13	375.45	367.52	371.13	97162900.0
2022-10-18	QQQ	ETF	276.53	277.21	268.74	271.48	69780995.0
2022-10-18	IWM	ETF	175.86	177.29	172.69	174.17	34523100.0
2022-10-18	DIA	ETF	308.26	308.38	303.04	305.47	4685500.0
2022-10-18	GLD	ETF	154.08	154.24	153.24	153.75	4528400.0
2022-10-18	TLT	ETF	97.95	98.46	96.87	98.32	16931500.0
2022-10-18	AAA	ETF	24.12	24.12	24.12	24.12	211.0
2022-10-18	AAAU	ETF	16.43	16.43	16.34	16.39	521500.0
2022-10-18	AADR	ETF	45.71	45.71	45.2	45.58	4700.0
2022-10-18	AAPB	ETF	19.5824	19.5824	18.53	19.0533	2260.0
2022-10-18	AAPD	ETF	27.76	28.75	27.59	28.18	201442.0
2022-10-18	AAPU	ETF	20.36	20.51	19.42	19.92	78077.0
2022-10-18	AAXJ	ETF	58.87	58.88	57.8	58.08	602400.0
2022-10-18	ABEQ	ETF	25.97	26.08	25.9	26.08	14500.0
2022-10-18	ACES	ETF	52.0	52.31	50.59	51.43	266500.0
2022-10-18	ACIO	ETF	28.854	28.9	28.67	28.79	40000.0
2022-10-18	ACSI	ETF	41.7831	41.7831	41.7831	41.7831	21.0
2022-10-18	ACT	ETF	24.09	24.3	23.85	24.1	183476.0
2022-10-18	ACTV	ETF	28.29	28.33	27.83	27.9978	7691.0
2022-10-18	ACTX	ETF	0.498	0.498	0.498	0.498	344.0
2022-10-18	ACVF	ETF	28.04	28.04	27.72	27.861	1600.0
2022-10-18	ACWF	ETF	30.58	30.58	30.16	30.2639	12477.0
2022-10-18	ACWI	ETF	81.14	81.22	79.63	80.35	3955700.0
2022-10-18	ACWV	ETF	90.27	90.44	89.4	89.76	155800.0
2022-10-18	ACWX	ETF	41.26	41.31	40.62	40.94	2967996.0
2022-10-18	ADFI	ETF	8.14	8.2	8.14	8.185	20100.0
2022-10-18	ADIV	ETF	11.61	11.61	11.6	11.605	1400.0
2022-10-18	ADME	ETF	34.21	34.21	33.91	34.01	11100.0
2022-10-18	ADRE	ETF	34.61	34.61	33.805	34.11	2152.0
2022-10-18	AESR	ETF	11.1	11.11	10.95	11.0	473000.0
2022-10-18	AFIF	ETF	8.63	8.64	8.61	8.625	19168.0
2022-10-18	AFK	ETF	15.58	15.58	15.175	15.22	5233.0
2022-10-18	AFLG	ETF	22.5	22.5	22.417	22.417	300.0
2022-10-18	AFSM	ETF	22.103	22.103	22.103	22.103	300.0
2022-10-18	AFTY	ETF	15.17	15.17	15.1	15.12	3000.0
2022-10-18	AGG	ETF	95.11	95.18	94.64	95.02	6389100.0
2022-10-18	AGGH	ETF	22.17	22.22	22.17	22.22	902.0
2022-10-18	AGGY	ETF	41.66	41.749	41.483	41.66	200600.0
2022-10-18	AGNG	ETF	24.26	24.41	24.26	24.41	600.0
2022-10-18	AGOV	ETF	76.24	76.81	76.21	76.8095	1121.0
2022-10-18	AGOX	ETF	19.94	19.94	19.62	19.745	43200.0
2022-10-18	AGQ	ETF	20.05	20.18	19.4	19.75	1061400.0
2022-10-18	AGZ	ETF	105.8	105.8	105.57	105.7752	17357.0
2022-10-18	AGZD	ETF	22.75	22.77	22.7	22.73	53600.0
2022-10-18	AHHX	ETF	8.33	8.39	8.21	8.2903	33249.0
2022-10-18	AHYB	ETF	42.3	42.375	42.3	42.375	800.0
2022-10-18	AIA	ETF	50.06	50.18	48.965	49.26	65870.0
2022-10-18	AIEQ	ETF	30.63	30.808	29.98	30.31	14500.0
2022-10-18	AIQ	ETF	19.65	19.81	19.23	19.348	16240.0
2022-10-18	AIRR	ETF	41.87	41.87	41.26	41.625	57600.0

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

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