PREVIEW / etf_daily / 2022-10-14

all etf daily files

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

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-14	SPY	ETF	368.55	370.26	356.96	357.63	123737000.0
2022-10-14	QQQ	ETF	271.2	271.81	260.14	260.74	77244302.0
2022-10-14	IWM	ETF	172.74	173.92	166.71	166.81	29608600.0
2022-10-14	DIA	ETF	302.54	304.36	296.19	296.82	5519400.0
2022-10-14	GLD	ETF	154.02	154.2	152.72	152.98	5471900.0
2022-10-14	TLT	ETF	100.19	100.19	98.25	98.57	18728200.0
2022-10-14	AAA	ETF	24.03	24.04	24.03	24.04	1223.0
2022-10-14	AAAU	ETF	16.42	16.43	16.28	16.31	525700.0
2022-10-14	AADR	ETF	44.25	44.37	43.93	43.93	1500.0
2022-10-14	AAPB	ETF	18.62	18.62	17.95	17.95	3020.0
2022-10-14	AAPD	ETF	28.1	29.32	28.07	29.28	121712.0
2022-10-14	AAPU	ETF	20.05	20.05	18.84	18.89	28108.0
2022-10-14	AAXJ	ETF	57.86	58.14	56.84	56.9	1151200.0
2022-10-14	ABEQ	ETF	25.69	25.76	25.368	25.368	15800.0
2022-10-14	ACES	ETF	51.41	51.772	48.539	48.539	35800.0
2022-10-14	ACIO	ETF	28.63	28.71	28.27	28.28	19600.0
2022-10-14	ACSI	ETF	40.3366	40.3366	40.3366	40.3366	33.0
2022-10-14	ACT	ETF	23.5	23.72	23.18	23.27	99857.0
2022-10-14	ACTV	ETF	27.4	27.4	26.8921	26.8921	5608.0
2022-10-14	ACVF	ETF	27.33	27.33	26.953	26.953	1800.0
2022-10-14	ACWF	ETF	29.73	29.74	29.33	29.33	18125.0
2022-10-14	ACWI	ETF	79.8	80.05	77.5	77.59	4166700.0
2022-10-14	ACWV	ETF	89.4	89.54	87.78	87.85	375400.0
2022-10-14	ACWX	ETF	40.55	40.7	39.695	39.72	3463182.0
2022-10-14	ADFI	ETF	8.19	8.19	8.111	8.125	2500.0
2022-10-14	ADIV	ETF	11.462	11.462	11.462	11.462	100.0
2022-10-14	ADME	ETF	33.44	33.9	33.39	33.42	11900.0
2022-10-14	ADRE	ETF	34.29	34.29	33.15	33.15	1934.0
2022-10-14	AEMB	ETF	35.43	35.43	34.974	34.985	2400.0
2022-10-14	AESR	ETF	10.9	10.9	10.64	10.653	29200.0
2022-10-14	AFIF	ETF	8.63	8.63	8.58	8.6	21371.0
2022-10-14	AFK	ETF	15.26	15.26	14.9	14.9	3331.0
2022-10-14	AFLG	ETF	21.84	21.84	21.73	21.73	100.0
2022-10-14	AFMC	ETF	20.77	20.77	20.653	20.653	100.0
2022-10-14	AFSM	ETF	21.287	21.287	21.287	21.287	100.0
2022-10-14	AFTY	ETF	15.29	15.29	15.192	15.192	700.0
2022-10-14	AGG	ETF	95.63	95.63	94.61	94.66	8580700.0
2022-10-14	AGGH	ETF	22.17	22.17	22.0742	22.0742	248.0
2022-10-14	AGGY	ETF	41.92	41.92	41.44	41.52	227900.0
2022-10-14	AGNG	ETF	24.23	24.23	23.767	23.767	600.0
2022-10-14	AGOV	ETF	75.935	75.935	75.935	75.935	20.0
2022-10-14	AGOX	ETF	19.67	19.67	19.179	19.179	23200.0
2022-10-14	AGQ	ETF	19.71	19.74	18.44	18.79	2125000.0
2022-10-14	AGZ	ETF	105.88	105.93	105.5	105.53	15848.0
2022-10-14	AGZD	ETF	22.825	22.825	22.715	22.76	44600.0
2022-10-14	AHHX	ETF	8.25	8.25	8.06	8.1304	6101.0
2022-10-14	AHYB	ETF	41.72	41.72	41.64	41.64	300.0
2022-10-14	AIA	ETF	49.52	49.52	48.23	48.28	151929.0
2022-10-14	AIEQ	ETF	29.907	29.907	28.889	28.889	5200.0
2022-10-14	AIQ	ETF	19.16	19.16	18.41	18.44	10340.0

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

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