PREVIEW / etf_daily / 2022-04-05

all etf daily files

  file:    by_date/etf_daily/2022/2022-04-05.parquet
  size:    101 KB
  rows:    2,697

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-04-05	SPY	ETF	455.22	457.83	449.82	451.03	74214500.0
2022-04-05	QQQ	ETF	367.81	368.54	359.93	361.1	62738661.0
2022-04-05	IWM	ETF	207.96	209.44	202.51	202.99	26509800.0
2022-04-05	DIA	ETF	347.82	351.05	345.5	346.34	4331700.0
2022-04-05	GLD	ETF	180.91	181.49	178.93	179.24	10828500.0
2022-04-05	TLT	ETF	130.76	130.78	128.29	128.49	25196900.0
2022-04-05	AAA	ETF	24.865	24.865	24.865	24.865	4.0
2022-04-05	AAAU	ETF	19.25	19.31	19.06	19.08	521800.0
2022-04-05	AADR	ETF	60.37	60.37	59.15	59.3	6600.0
2022-04-05	AAXJ	ETF	77.64	77.64	76.33	76.49	1673000.0
2022-04-05	ABEQ	ETF	30.21	30.21	29.888	29.888	5600.0
2022-04-05	ACES	ETF	65.13	65.66	62.45	62.61	140000.0
2022-04-05	ACIO	ETF	31.21	31.558	31.21	31.4	18200.0
2022-04-05	ACSI	ETF	50.2711	50.2711	50.2711	50.2711	70.0
2022-04-05	ACT	ETF	21.98	22.11	21.65	21.85	72777.0
2022-04-05	ACTV	ETF	36.14	36.142	35.68	35.73	7018.0
2022-04-05	ACTX	ETF	1.0	1.0	0.78	1.0	1746.0
2022-04-05	ACVF	ETF	34.09	34.09	33.71	33.71	6400.0
2022-04-05	ACWF	ETF	37.09	37.09	36.63	36.66	5786.0
2022-04-05	ACWI	ETF	100.97	101.35	99.68	99.95	4349400.0
2022-04-05	ACWV	ETF	105.74	106.77	105.54	105.74	345400.0
2022-04-05	ACWX	ETF	52.99	53.08	52.34	52.46	2259581.0
2022-04-05	ADFI	ETF	8.97	8.98	8.94	8.95	3100.0
2022-04-05	ADIV	ETF	15.85	15.85	15.67	15.693	5100.0
2022-04-05	ADME	ETF	41.15	41.15	40.749	40.76	10300.0
2022-04-05	ADRE	ETF	45.0217	45.0217	44.59	44.73	3801.0
2022-04-05	AEMB	ETF	43.4	43.45	42.99	42.99	1400.0
2022-04-05	AESR	ETF	13.45	13.45	13.26	13.26	24500.0
2022-04-05	AFIF	ETF	9.26	9.26	9.2	9.2197	32136.0
2022-04-05	AFK	ETF	21.69	21.69	21.2515	21.2515	14618.0
2022-04-05	AFLG	ETF	26.556	26.556	26.556	26.556	100.0
2022-04-05	AFMC	ETF	24.273	24.273	24.273	24.273	100.0
2022-04-05	AFSM	ETF	25.163	25.163	25.163	25.163	100.0
2022-04-05	AFTY	ETF	18.56	18.56	18.381	18.381	700.0
2022-04-05	AGG	ETF	106.58	106.63	105.74	105.76	11028300.0
2022-04-05	AGGH	ETF	24.32	24.32	24.2397	24.2397	2310.0
2022-04-05	AGGY	ETF	47.71	47.72	47.392	47.4	135200.0
2022-04-05	AGNG	ETF	29.025	29.025	28.83	28.844	4200.0
2022-04-05	AGOV	ETF	83.79	83.82	82.49	82.8946	5936.0
2022-04-05	AGOX	ETF	23.99	24.13	23.69	23.69	15800.0
2022-04-05	AGQ	ETF	38.49	38.95	36.7	36.72	747500.0
2022-04-05	AGZ	ETF	111.82	111.8322	111.395	111.49	34252.0
2022-04-05	AGZD	ETF	23.295	23.33	23.265	23.325	45400.0
2022-04-05	AHHX	ETF	9.41	9.49	9.36	9.4066	20870.0
2022-04-05	AHYB	ETF	47.15	47.15	47.15	47.15	100.0
2022-04-05	AIA	ETF	71.0	71.0	69.52	69.64	67412.0
2022-04-05	AIEQ	ETF	37.15	37.15	36.54	36.614	8400.0
2022-04-05	AIQ	ETF	27.68	27.68	26.92	27.05	12394.0
2022-04-05	AIRR	ETF	42.26	42.44	41.32	41.324	12100.0
2022-04-05	AIVI	ETF	39.99	40.08	39.87	39.97	6800.0

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

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