PREVIEW / etf_daily / 2023-03-30

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-30.parquet
  size:    109 KB
  rows:    2,951

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
2023-03-30	SPY	ETF	404.09	404.35	401.76	403.7	69840000.0
2023-03-30	QQQ	ETF	315.24	316.32	312.8088	315.68	58354808.0
2023-03-30	IWM	ETF	176.88	177.31	174.45	175.18	26728600.0
2023-03-30	DIA	ETF	328.88	328.95	326.72	328.48	2487000.0
2023-03-30	GLD	ETF	182.75	184.44	182.55	184.18	6360300.0
2023-03-30	TLT	ETF	104.46	105.05	104.27	104.8	14315800.0
2023-03-30	AAA	ETF	24.52	24.54	24.52	24.54	141.0
2023-03-30	AAAU	ETF	19.5	19.68	19.48	19.65	883600.0
2023-03-30	AADR	ETF	48.21	48.21	48.21	48.21	100.0
2023-03-30	AAPB	ETF	21.879	22.09	21.879	22.0892	3585.0
2023-03-30	AAPD	ETF	24.1	24.1584	23.9907	24.0045	136257.0
2023-03-30	AAPU	ETF	22.63	22.81	22.5861	22.78	186841.0
2023-03-30	AAXJ	ETF	67.95	68.12	67.75	67.99	218900.0
2023-03-30	ABEQ	ETF	27.781	27.83	27.77	27.83	8500.0
2023-03-30	ACES	ETF	45.46	46.09	45.1	45.23	195800.0
2023-03-30	ACIO	ETF	29.82	29.91	29.79	29.88	53500.0
2023-03-30	ACSI	ETF	43.7675	43.7675	43.7675	43.7675	38.0
2023-03-30	ACT	ETF	22.8	22.84	22.51	22.62	36878.0
2023-03-30	ACTV	ETF	29.47	29.47	29.17	29.24	3026.0
2023-03-30	ACVF	ETF	31.0	31.075	30.99	31.035	2300.0
2023-03-30	ACWF	ETF	33.254	33.3	33.2198	33.2812	3876.0
2023-03-30	ACWI	ETF	90.32	90.4	89.92	90.26	1973900.0
2023-03-30	ACWV	ETF	96.35	96.35	95.91	96.17	73000.0
2023-03-30	ACWX	ETF	48.58	48.66	48.49	48.61	1095235.0
2023-03-30	ADFI	ETF	8.5	8.5	8.47	8.48	7200.0
2023-03-30	ADIV	ETF	13.76	13.76	13.76	13.76	100.0
2023-03-30	ADME	ETF	34.2	34.25	34.14	34.21	20000.0
2023-03-30	ADPV	ETF	23.15	23.21	22.96	23.0076	18831.0
2023-03-30	ADRE	ETF	38.14	38.2	38.07	38.2	109538.0
2023-03-30	AEMB	ETF	37.647	37.647	37.647	37.647	100.0
2023-03-30	AESR	ETF	11.85	11.87	11.81	11.87	21000.0
2023-03-30	AFIF	ETF	8.77	8.78	8.72	8.7549	14647.0
2023-03-30	AFK	ETF	15.88	16.22	15.78	15.9595	27667.0
2023-03-30	AFLG	ETF	23.698	23.698	23.698	23.698	100.0
2023-03-30	AFMC	ETF	22.752	22.752	22.752	22.752	100.0
2023-03-30	AFSM	ETF	22.854	22.854	22.854	22.854	100.0
2023-03-30	AFTY	ETF	16.36	16.38	16.36	16.365	300.0
2023-03-30	AGG	ETF	99.03	99.23	98.95	99.16	4251900.0
2023-03-30	AGGY	ETF	43.4	43.49	43.38	43.46	78700.0
2023-03-30	AGNG	ETF	26.62	26.62	26.59	26.59	300.0
2023-03-30	AGOV	ETF	77.99	77.99	76.565	76.565	510.0
2023-03-30	AGOX	ETF	21.41	21.59	21.41	21.56	39500.0
2023-03-30	AGQ	ETF	30.01	30.8	29.65	30.77	647300.0
2023-03-30	AGZ	ETF	107.87	108.21	107.87	108.21	30581.0
2023-03-30	AGZD	ETF	21.775	21.79	21.67	21.775	30400.0
2023-03-30	AHHX	ETF	8.31	8.355	8.17	8.3346	36001.0
2023-03-30	AHYB	ETF	43.77	43.888	43.64	43.888	1800.0
2023-03-30	AIA	ETF	61.98	62.25	61.89	62.12	47246.0
2023-03-30	AIEQ	ETF	28.58	28.79	28.2	28.38	37400.0
2023-03-30	AIQ	ETF	24.25	24.62	24.08	24.24	70141.0

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

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