PREVIEW / etf_daily / 2023-12-04

all etf daily files

  file:    by_date/etf_daily/2023/2023-12-04.parquet
  size:    113 KB
  rows:    3,168

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-12-04	SPY	ETF	455.6	459.12	454.34	456.69	72430900.0
2023-12-04	QQQ	ETF	386.09	386.595	382.66	386.32	51186944.0
2023-12-04	IWM	ETF	184.23	186.99	184.02	186.89	44862600.0
2023-12-04	DIA	ETF	361.15	362.95	361.02	362.64	4211000.0
2023-12-04	GLD	ETF	189.6	190.38	187.26	187.86	18460500.0
2023-12-04	TLT	ETF	92.49	92.83	92.09	92.62	33766300.0
2023-12-04	AAA	ETF	24.93	24.93	24.85	24.86	4900.0
2023-12-04	AAAU	ETF	20.26	20.34	20.01	20.08	2073500.0
2023-12-04	AADR	ETF	53.75	54.1	53.75	54.1	3400.0
2023-12-04	AAPB	ETF	26.8472	26.8472	26.33	26.74	5172.0
2023-12-04	AAPD	ETF	20.64	20.88	20.6275	20.68	152724.0
2023-12-04	AAPU	ETF	27.27	27.27	26.7	27.15	50075.0
2023-12-04	AAXJ	ETF	65.06	65.18	64.7	64.76	1432200.0
2023-12-04	ABEQ	ETF	28.2	28.25	28.18	28.24	7600.0
2023-12-04	ACES	ETF	32.47	33.255	32.47	32.7	72300.0
2023-12-04	ACIO	ETF	32.11	32.244	32.1	32.244	37600.0
2023-12-04	ACT	ETF	27.78	28.03	27.77	27.96	230929.0
2023-12-04	ACTV	ETF	30.6	31.274	30.6	31.274	6100.0
2023-12-04	ACVF	ETF	35.45	35.45	34.809	34.92	11000.0
2023-12-04	ACWF	ETF	36.64	36.72	36.61	36.6944	3299.0
2023-12-04	ACWI	ETF	97.93	98.31	97.74	98.14	3605500.0
2023-12-04	ACWV	ETF	98.85	99.42	98.85	99.14	126600.0
2023-12-04	ACWX	ETF	49.33	49.5	49.19	49.32	1840700.0
2023-12-04	ADFI	ETF	8.42	8.42	8.39	8.41	8600.0
2023-12-04	ADIV	ETF	13.73	13.73	13.648	13.648	300.0
2023-12-04	ADME	ETF	37.086	37.13	37.03	37.12	7700.0
2023-12-04	ADPV	ETF	23.87	23.8919	23.72	23.738	84312.0
2023-12-04	AEMB	ETF	37.039	37.039	37.039	37.039	100.0
2023-12-04	AESR	ETF	13.04	13.05	12.975	13.02	12500.0
2023-12-04	AETH	ETF	33.19	33.36	33.0	33.3047	6477.0
2023-12-04	AFIF	ETF	9.0	9.02	9.0	9.01	15200.0
2023-12-04	AFK	ETF	14.01	14.24	13.91	13.92	10700.0
2023-12-04	AFLG	ETF	26.38	26.42	26.38	26.42	200.0
2023-12-04	AFMC	ETF	25.389	25.389	25.389	25.389	100.0
2023-12-04	AFSM	ETF	25.572	25.572	25.572	25.572	100.0
2023-12-04	AFTY	ETF	13.86	13.867	13.86	13.867	100.0
2023-12-04	AGG	ETF	96.58	96.67	96.31	96.46	9440200.0
2023-12-04	AGGH	ETF	21.49	21.57	21.46	21.57	24856.0
2023-12-04	AGGY	ETF	42.84	42.905	42.77	42.83	117900.0
2023-12-04	AGNG	ETF	26.87	27.03	26.87	27.03	1900.0
2023-12-04	AGOX	ETF	24.02	24.02	23.8	23.89	359100.0
2023-12-04	AGQ	ETF	30.1	30.52	29.03	29.3	1801300.0
2023-12-04	AGQI	ETF	12.74	12.78	12.72	12.78	62933.0
2023-12-04	AGZ	ETF	107.15	107.15	106.93	107.02	35000.0
2023-12-04	AGZD	ETF	22.39	22.4	22.32	22.39	489100.0
2023-12-04	AHLT	ETF	23.96	23.9844	23.52	23.98	13871.0
2023-12-04	AHYB	ETF	44.452	44.52	44.452	44.52	900.0
2023-12-04	AIA	ETF	56.41	56.65	56.21	56.3	51500.0
2023-12-04	AIEQ	ETF	32.2	32.65	32.2	32.621	49800.0
2023-12-04	AIQ	ETF	29.62	29.67	29.345	29.56	337000.0

> showing 50 of 3,168 rows — these rows as CSV

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