PREVIEW / etf_daily / 2023-08-18

all etf daily files

  file:    by_date/etf_daily/2023/2023-08-18.parquet
  size:    107 KB
  rows:    2,988

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-08-18	SPY	ETF	433.37	437.57	433.01	436.5	98758400.0
2023-08-18	QQQ	ETF	355.26	359.41	354.71	358.13	61191389.0
2023-08-18	IWM	ETF	182.21	185.25	181.94	184.65	33349400.0
2023-08-18	DIA	ETF	342.95	345.91	342.68	345.12	3524900.0
2023-08-18	GLD	ETF	175.83	176.06	175.1	175.33	6251000.0
2023-08-18	TLT	ETF	93.43	94.19	93.3	93.77	24176000.0
2023-08-18	AAA	ETF	24.83	24.845	24.725	24.845	4000.0
2023-08-18	AAAU	ETF	18.77	18.8	18.7	18.72	1110900.0
2023-08-18	AADR	ETF	50.15	50.37	50.04	50.31	1600.0
2023-08-18	AAPB	ETF	23.4	24.13	23.4	24.04	17516.0
2023-08-18	AAPD	ETF	22.72	22.72	22.32	22.4	240289.0
2023-08-18	AAPU	ETF	24.1	24.74	24.1	24.62	142458.0
2023-08-18	AAXJ	ETF	63.91	64.2	63.7	64.07	1447700.0
2023-08-18	ABEQ	ETF	27.92	27.92	27.72	27.74	28800.0
2023-08-18	ACES	ETF	39.51	40.39	39.39	40.34	126700.0
2023-08-18	ACIO	ETF	30.81	30.89	30.79	30.83	91700.0
2023-08-18	ACSI	ETF	45.3	45.52	45.3	45.52	300.0
2023-08-18	ACT	ETF	28.49	28.95	28.385	28.83	154084.0
2023-08-18	ACTV	ETF	31.46	31.55	31.459	31.505	7100.0
2023-08-18	ACVF	ETF	33.44	33.68	33.44	33.589	12100.0
2023-08-18	ACWF	ETF	34.4	34.6479	34.4	34.6445	4091.0
2023-08-18	ACWI	ETF	93.05	93.94	93.02	93.73	2441400.0
2023-08-18	ACWV	ETF	96.4	96.85	96.36	96.65	118600.0
2023-08-18	ACWX	ETF	47.35	47.71	47.32	47.62	1068300.0
2023-08-18	ADFI	ETF	8.29	8.31	8.29	8.305	12400.0
2023-08-18	ADIV	ETF	13.25	13.25	13.25	13.25	100.0
2023-08-18	ADME	ETF	35.695	35.95	35.695	35.82	50400.0
2023-08-18	ADPV	ETF	24.05	24.2299	24.05	24.1439	2632.0
2023-08-18	AEMB	ETF	36.77	36.77	36.77	36.77	100.0
2023-08-18	AESR	ETF	12.445	12.53	12.42	12.44	26300.0
2023-08-18	AFIF	ETF	8.86	8.91	8.86	8.88	8600.0
2023-08-18	AFK	ETF	14.4	14.42	14.25	14.35	15300.0
2023-08-18	AFMC	ETF	24.5	24.521	24.5	24.521	1100.0
2023-08-18	AFSM	ETF	24.551	24.551	24.551	24.551	100.0
2023-08-18	AFTY	ETF	14.8	14.8	14.799	14.799	400.0
2023-08-18	AGG	ETF	95.47	95.75	95.43	95.62	6154600.0
2023-08-18	AGGH	ETF	22.0584	22.0584	22.0	22.0021	4869.0
2023-08-18	AGGY	ETF	42.16	42.29	42.16	42.25	60700.0
2023-08-18	AGNG	ETF	26.92	27.0	26.85	26.973	6600.0
2023-08-18	AGOV	ETF	74.32	75.02	74.32	75.02	671.0
2023-08-18	AGOX	ETF	22.88	23.04	22.82	22.94	20300.0
2023-08-18	AGQ	ETF	26.28	26.52	26.14	26.37	302500.0
2023-08-18	AGRH	ETF	25.65	25.65	25.65	25.65	101.0
2023-08-18	AGZ	ETF	106.28	106.44	106.28	106.36	10200.0
2023-08-18	AGZD	ETF	22.17	22.25	22.13	22.13	40600.0
2023-08-18	AHYB	ETF	43.659	43.7	43.634	43.634	800.0
2023-08-18	AIA	ETF	56.3	56.53	56.1	56.37	40000.0
2023-08-18	AIEQ	ETF	30.47	30.87	30.39	30.825	9000.0
2023-08-18	AIQ	ETF	26.65	26.97	26.559	26.87	355000.0
2023-08-18	AIRR	ETF	52.39	53.4	52.25	53.205	74900.0

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

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