PREVIEW / etf_daily / 2022-10-21

all etf daily files

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

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-21	SPY	ETF	365.12	374.8	363.54	374.29	131038400.0
2022-10-21	QQQ	ETF	267.98	275.969	266.8236	275.42	77897694.0
2022-10-21	IWM	ETF	169.4	173.2	168.19	172.7	45402700.0
2022-10-21	DIA	ETF	303.08	311.2	302.01	310.88	5357200.0
2022-10-21	GLD	ETF	151.98	154.31	151.83	154.15	6898400.0
2022-10-21	TLT	ETF	93.02	93.93	92.26	93.17	46280300.0
2022-10-21	AAA	ETF	24.16	24.16	24.16	24.16	30.0
2022-10-21	AAAU	ETF	16.2	16.45	16.18	16.43	570800.0
2022-10-21	AADR	ETF	44.97	46.12	44.97	46.12	2200.0
2022-10-21	AAPB	ETF	19.9117	19.9117	19.9117	19.9117	416.0
2022-10-21	AAPD	ETF	28.25	28.3911	27.38	27.49	165798.0
2022-10-21	AAPU	ETF	19.78	20.77	19.78	20.69	56269.0
2022-10-21	AAXJ	ETF	56.81	57.72	56.66	57.7	644000.0
2022-10-21	ABEQ	ETF	25.91	26.247	25.91	26.247	4900.0
2022-10-21	ACES	ETF	48.69	50.28	48.19	50.08	297600.0
2022-10-21	ACIO	ETF	28.749	29.029	28.725	29.02	12400.0
2022-10-21	ACSI	ETF	42.0362	42.0362	42.0362	42.0362	10.0
2022-10-21	ACT	ETF	23.82	24.34	23.63	24.32	166174.0
2022-10-21	ACTV	ETF	27.82	27.83	27.82	27.83	669.0
2022-10-21	ACTX	ETF	0.497	0.497	0.497	0.497	250.0
2022-10-21	ACVF	ETF	27.579	28.068	27.498	28.068	2800.0
2022-10-21	ACWF	ETF	29.9	30.72	29.9	30.6711	39989.0
2022-10-21	ACWI	ETF	78.93	80.92	78.57	80.83	4754500.0
2022-10-21	ACWV	ETF	88.36	90.06	87.98	89.82	321000.0
2022-10-21	ACWX	ETF	40.11	41.12	39.97	41.1	3400887.0
2022-10-21	ADFI	ETF	8.1	8.14	8.1	8.14	19700.0
2022-10-21	ADIV	ETF	11.42	11.62	11.42	11.591	800.0
2022-10-21	ADME	ETF	33.865	34.13	33.75	34.05	9100.0
2022-10-21	ADRE	ETF	33.26	34.11	33.26	34.06	4091.0
2022-10-21	AEMB	ETF	34.57	34.69	34.485	34.69	300.0
2022-10-21	AESR	ETF	10.949	11.13	10.88	11.107	30700.0
2022-10-21	AFIF	ETF	8.635	8.67	8.63	8.6649	58166.0
2022-10-21	AFK	ETF	15.76	15.76	15.0299	15.41	11105.0
2022-10-21	AFLG	ETF	22.668	22.668	22.668	22.668	100.0
2022-10-21	AFMC	ETF	21.03	21.358	21.03	21.358	100.0
2022-10-21	AFSM	ETF	22.126	22.126	22.126	22.126	100.0
2022-10-21	AFTY	ETF	14.801	14.801	14.801	14.801	100.0
2022-10-21	AGG	ETF	93.27	93.87	93.2	93.77	8371100.0
2022-10-21	AGGY	ETF	40.87	41.09	40.84	41.07	103200.0
2022-10-21	AGNG	ETF	23.635	24.11	23.635	24.11	2300.0
2022-10-21	AGOV	ETF	77.4605	77.4605	77.4605	77.4605	9.0
2022-10-21	AGOX	ETF	19.43	19.99	19.43	19.99	22000.0
2022-10-21	AGQ	ETF	19.65	21.06	19.5	21.05	1539700.0
2022-10-21	AGZ	ETF	105.04	105.305	105.04	105.22	14937.0
2022-10-21	AGZD	ETF	22.685	22.75	22.685	22.73	146200.0
2022-10-21	AHHX	ETF	8.15	8.34	8.15	8.3004	10376.0
2022-10-21	AHYB	ETF	42.12	42.15	42.12	42.142	300.0
2022-10-21	AIA	ETF	47.43	48.32	47.3981	48.3	42478.0
2022-10-21	AIEQ	ETF	29.18	29.9	28.975	29.826	3900.0
2022-10-21	AIQ	ETF	19.19	19.59	18.9918	19.52	9722.0

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

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