PREVIEW / etf_daily / 2022-08-17

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-17.parquet
  size:    102 KB
  rows:    2,766

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-08-17	SPY	ETF	425.91	429.5	424.54	426.65	63563400.0
2022-08-17	QQQ	ETF	329.07	331.43	326.36	328.49	47842155.0
2022-08-17	IWM	ETF	198.72	199.33	196.38	197.61	22428000.0
2022-08-17	DIA	ETF	339.67	342.06	338.7	340.2	2960300.0
2022-08-17	GLD	ETF	165.21	165.23	163.95	164.35	5569100.0
2022-08-17	TLT	ETF	115.06	115.1	114.31	114.72	14131300.0
2022-08-17	AAA	ETF	24.39	24.39	24.39	24.39	3.0
2022-08-17	AAAU	ETF	17.61	17.61	17.48	17.52	1324000.0
2022-08-17	AADR	ETF	51.49	51.94	51.45	51.94	1900.0
2022-08-17	AAPB	ETF	27.34	27.7612	27.15	27.5293	5786.0
2022-08-17	AAPD	ETF	23.91	23.91	23.4	23.6132	85702.0
2022-08-17	AAPU	ETF	26.88	27.5599	26.87	27.21	50494.0
2022-08-17	AAXJ	ETF	68.61	68.81	68.33	68.48	326000.0
2022-08-17	ABEQ	ETF	27.778	27.89	27.74	27.783	21300.0
2022-08-17	ACES	ETF	65.64	66.09	64.48	65.09	111800.0
2022-08-17	ACIO	ETF	31.287	31.33	31.163	31.29	35100.0
2022-08-17	ACSI	ETF	48.6385	48.6385	48.6385	48.6385	17.0
2022-08-17	ACT	ETF	27.35	27.68	27.35	27.66	138176.0
2022-08-17	ACTV	ETF	32.5	32.63	32.24	32.4359	5861.0
2022-08-17	ACTX	ETF	0.63	0.65	0.63	0.65	720.0
2022-08-17	ACVF	ETF	32.11	32.13	31.97	32.029	5100.0
2022-08-17	ACWF	ETF	33.89	33.9601	33.72	33.879	6422.0
2022-08-17	ACWI	ETF	91.9	92.6	91.59	92.03	2873100.0
2022-08-17	ACWV	ETF	99.75	100.25	99.65	99.88	144900.0
2022-08-17	ACWX	ETF	46.73	47.01	46.54	46.75	3335056.0
2022-08-17	ADFI	ETF	8.65	8.71	8.65	8.678	23100.0
2022-08-17	ADIV	ETF	13.88	13.88	13.88	13.88	100.0
2022-08-17	ADME	ETF	37.42	37.59	37.39	37.46	13700.0
2022-08-17	ADRE	ETF	40.35	40.35	40.0999	40.24	2856.0
2022-08-17	AEMB	ETF	39.06	39.12	39.01	39.12	500.0
2022-08-17	AESR	ETF	12.32	12.36	12.28	12.3	21600.0
2022-08-17	AFIF	ETF	8.95	8.98	8.95	8.97	3713.0
2022-08-17	AFK	ETF	17.99	17.99	17.68	17.84	11640.0
2022-08-17	AFLG	ETF	25.104	25.144	25.104	25.144	300.0
2022-08-17	AFMC	ETF	23.505	23.596	23.505	23.596	300.0
2022-08-17	AFSM	ETF	24.513	24.575	24.513	24.575	300.0
2022-08-17	AFTY	ETF	17.42	17.426	17.4	17.426	500.0
2022-08-17	AGG	ETF	102.64	102.74	102.34	102.49	7222300.0
2022-08-17	AGGH	ETF	23.64	23.64	23.64	23.64	766.0
2022-08-17	AGGY	ETF	45.48	45.538	45.37	45.445	69200.0
2022-08-17	AGIH	ETF	25.67	25.67	25.635	25.635	201.0
2022-08-17	AGNG	ETF	26.25	26.25	26.08	26.138	6200.0
2022-08-17	AGOV	ETF	83.0	83.0	82.17	82.8027	675.0
2022-08-17	AGOX	ETF	22.42	22.53	22.335	22.45	14400.0
2022-08-17	AGQ	ETF	23.2	23.32	22.66	22.97	812800.0
2022-08-17	AGZ	ETF	109.92	110.0	109.7409	109.89	11301.0
2022-08-17	AGZD	ETF	23.075	23.08	23.01	23.075	43600.0
2022-08-17	AHHX	ETF	8.83	8.87	8.82	8.8549	7241.0
2022-08-17	AHYB	ETF	45.09	45.09	44.953	44.953	200.0
2022-08-17	AIA	ETF	60.04	60.39	59.825	60.16	48350.0

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

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