PREVIEW / etf_daily / 2022-10-05

all etf daily files

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

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-05	SPY	ETF	373.39	379.46	370.95	377.09	88065700.0
2022-10-05	QQQ	ETF	278.28	283.81	275.42	281.98	55766318.0
2022-10-05	IWM	ETF	173.41	175.33	171.42	174.7	25281400.0
2022-10-05	DIA	ETF	299.73	304.55	298.8	302.79	2746900.0
2022-10-05	GLD	ETF	159.32	160.08	158.38	159.81	5296300.0
2022-10-05	TLT	ETF	102.73	102.84	101.58	102.55	20522100.0
2022-10-05	AAA	ETF	24.1	24.1	24.1	24.1	20.0
2022-10-05	AAAU	ETF	16.98	17.06	16.89	17.03	188600.0
2022-10-05	AADR	ETF	46.46	46.7	46.13	46.55	2200.0
2022-10-05	AAPB	ETF	19.35	19.96	19.13	19.7743	2760.0
2022-10-05	AAPD	ETF	28.19	28.3636	27.6	27.75	200330.0
2022-10-05	AAPU	ETF	20.0816	20.76	19.911	20.55	54248.0
2022-10-05	AAXJ	ETF	60.99	61.42	60.63	61.2	636000.0
2022-10-05	ABEQ	ETF	25.89	26.11	25.86	26.055	13800.0
2022-10-05	ACES	ETF	58.18	58.18	55.6	56.72	54800.0
2022-10-05	ACIO	ETF	28.83	29.05	28.803	28.97	85000.0
2022-10-05	ACSI	ETF	43.1193	43.1193	43.1193	43.1193	20.0
2022-10-05	ACT	ETF	23.45	23.51	22.98	23.46	169573.0
2022-10-05	ACTV	ETF	28.15	28.4	27.895	28.4	5026.0
2022-10-05	ACTX	ETF	0.4916	0.548	0.4916	0.548	470.0
2022-10-05	ACVF	ETF	28.25	28.54	28.04	28.389	7200.0
2022-10-05	ACWF	ETF	30.75	31.0187	30.53	30.879	10400.0
2022-10-05	ACWI	ETF	81.33	82.49	80.83	82.03	2050400.0
2022-10-05	ACWV	ETF	91.21	92.02	90.79	91.71	207200.0
2022-10-05	ACWX	ETF	41.84	42.21	41.54	42.04	2228855.0
2022-10-05	ADFI	ETF	8.31	8.31	8.246	8.285	4700.0
2022-10-05	ADIV	ETF	12.21	12.275	12.18	12.275	2000.0
2022-10-05	ADME	ETF	33.73	34.0	33.73	33.86	50100.0
2022-10-05	ADRE	ETF	36.61	36.91	36.38	36.91	3054.0
2022-10-05	AEMB	ETF	35.96	35.96	35.91	35.91	100.0
2022-10-05	AESR	ETF	11.03	11.22	11.02	11.15	90300.0
2022-10-05	AFIF	ETF	8.67	8.69	8.65	8.67	104923.0
2022-10-05	AFK	ETF	15.63	15.63	15.5217	15.59	2829.0
2022-10-05	AFLG	ETF	22.57	22.71	22.57	22.682	400.0
2022-10-05	AFMC	ETF	21.25	21.36	21.25	21.36	100.0
2022-10-05	AFSM	ETF	21.97	22.01	21.97	21.978	5300.0
2022-10-05	AFTY	ETF	16.26	16.3	16.24	16.24	2200.0
2022-10-05	AGG	ETF	96.69	96.99	96.27	96.66	9512800.0
2022-10-05	AGGH	ETF	22.62	22.71	22.62	22.7	2366.0
2022-10-05	AGGY	ETF	42.52	42.547	42.34	42.51	142400.0
2022-10-05	AGNG	ETF	24.25	24.74	24.17	24.379	4200.0
2022-10-05	AGOV	ETF	78.385	78.385	78.385	78.385	10.0
2022-10-05	AGOX	ETF	20.089	20.438	20.089	20.37	14500.0
2022-10-05	AGQ	ETF	23.57	24.66	22.74	24.41	2090800.0
2022-10-05	AGZ	ETF	106.675	106.675	106.48	106.61	17258.0
2022-10-05	AGZD	ETF	22.79	22.865	22.67	22.83	239600.0
2022-10-05	AHHX	ETF	8.21	8.33	8.21	8.33	2505.0
2022-10-05	AHYB	ETF	42.3	42.59	42.3	42.589	600.0
2022-10-05	AIA	ETF	52.68	53.02	52.34	52.8	107706.0
2022-10-05	AIEQ	ETF	30.71	31.393	30.5	31.228	3700.0

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

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