PREVIEW / etf_daily / 2022-05-05

all etf daily files

  file:    by_date/etf_daily/2022/2022-05-05.parquet
  size:    100 KB
  rows:    2,672

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-05-05	SPY	ETF	424.55	425.0	409.44	413.81	172929100.0
2022-05-05	QQQ	ETF	325.17	325.25	309.62	313.0	154607447.0
2022-05-05	IWM	ETF	191.53	191.56	183.38	185.67	41468700.0
2022-05-05	DIA	ETF	337.83	338.24	326.89	330.24	9101200.0
2022-05-05	GLD	ETF	177.56	177.61	174.66	175.13	12794200.0
2022-05-05	TLT	ETF	116.35	116.47	114.02	115.37	48384500.0
2022-05-05	AAA	ETF	24.73	24.73	24.73	24.73	23.0
2022-05-05	AAAU	ETF	18.92	18.92	18.6	18.65	2065900.0
2022-05-05	AADR	ETF	54.25	54.38	53.69	54.04	3000.0
2022-05-05	AAXJ	ETF	70.9	70.9	69.01	69.57	3226900.0
2022-05-05	ABEQ	ETF	28.73	28.76	28.6	28.75	17300.0
2022-05-05	ACES	ETF	54.87	54.87	52.16	52.74	77500.0
2022-05-05	ACIO	ETF	30.35	30.35	29.829	29.99	103700.0
2022-05-05	ACSI	ETF	46.2499	46.3	45.9064	45.9064	2706.0
2022-05-05	ACT	ETF	24.19	24.24	23.48	23.93	190686.0
2022-05-05	ACTV	ETF	33.3592	33.3592	32.84	33.0239	11022.0
2022-05-05	ACTX	ETF	0.925	0.985	0.925	0.985	774.0
2022-05-05	ACVF	ETF	32.08	32.08	30.95	31.133	12600.0
2022-05-05	ACWF	ETF	35.21	35.21	34.2001	34.4599	4547.0
2022-05-05	ACWI	ETF	93.66	93.66	90.65	91.54	4187400.0
2022-05-05	ACWV	ETF	100.8	100.8	98.63	99.21	181500.0
2022-05-05	ACWX	ETF	49.04	49.09	47.8	48.19	4267996.0
2022-05-05	ADFI	ETF	8.7	8.7	8.62	8.65	12900.0
2022-05-05	ADIV	ETF	14.51	14.57	14.49	14.57	1700.0
2022-05-05	ADME	ETF	38.67	38.67	37.654	37.94	69200.0
2022-05-05	ADRE	ETF	40.65	40.65	39.32	39.52	3710.0
2022-05-05	AESR	ETF	12.59	12.59	12.15	12.24	30000.0
2022-05-05	AFIF	ETF	9.14	9.14	9.13	9.14	25654.0
2022-05-05	AFK	ETF	19.74	19.74	19.1	19.1	4028.0
2022-05-05	AFTY	ETF	17.06	17.06	16.71	16.756	11300.0
2022-05-05	AGG	ETF	102.48	102.52	101.59	102.0	17474400.0
2022-05-05	AGGY	ETF	45.19	45.217	44.9	45.08	1005200.0
2022-05-05	AGNG	ETF	26.81	26.81	26.05	26.23	7300.0
2022-05-05	AGOV	ETF	80.4	81.63	78.42	81.0058	5165.0
2022-05-05	AGOX	ETF	22.325	22.325	21.81	21.92	29000.0
2022-05-05	AGQ	ETF	32.59	32.63	30.45	30.99	1710600.0
2022-05-05	AGZ	ETF	110.06	110.1976	109.51	110.0	37660.0
2022-05-05	AGZD	ETF	23.0	23.035	22.89	22.995	63000.0
2022-05-05	AHHX	ETF	9.1399	9.14	9.12	9.13	4961.0
2022-05-05	AHYB	ETF	45.142	45.169	45.142	45.169	400.0
2022-05-05	AIA	ETF	64.14	64.15	62.44	62.85	34568.0
2022-05-05	AIEQ	ETF	34.99	34.99	33.87	34.14	12000.0
2022-05-05	AIQ	ETF	23.889	23.889	22.85	23.05	48960.0
2022-05-05	AIRR	ETF	39.98	40.013	38.76	39.17	15700.0
2022-05-05	AIVI	ETF	38.28	38.37	38.07	38.32	8200.0
2022-05-05	AIVL	ETF	96.85	97.02	94.5	95.24	7000.0
2022-05-05	ALTL	ETF	43.54	43.65	42.71	42.94	134931.0
2022-05-05	ALTY	ETF	12.51	12.51	12.17	12.235	27700.0
2022-05-05	AMAX	ETF	8.71	8.74	8.68	8.704	7000.0
2022-05-05	AMJ	ETF	22.08	22.14	21.27	21.62	1268314.0

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

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