PREVIEW / etf_daily / 2022-08-24

all etf daily files

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

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-24	SPY	ETF	412.11	415.11	411.39	413.67	49177800.0
2022-08-24	QQQ	ETF	313.61	316.87	312.99	315.01	38057059.0
2022-08-24	IWM	ETF	190.79	193.3	190.16	192.41	16038300.0
2022-08-24	DIA	ETF	328.93	331.03	328.33	329.86	2581700.0
2022-08-24	GLD	ETF	162.44	163.61	162.37	163.25	3202400.0
2022-08-24	TLT	ETF	111.49	111.87	110.86	111.22	13971600.0
2022-08-24	AAA	ETF	24.43	24.43	24.43	24.43	0.0
2022-08-24	AAAU	ETF	17.32	17.43	17.31	17.4	1638800.0
2022-08-24	AADR	ETF	51.36	51.36	51.36	51.36	300.0
2022-08-24	AAPB	ETF	25.34	25.67	25.34	25.5471	1727.0
2022-08-24	AAPD	ETF	24.6	24.7559	24.5	24.59	42949.0
2022-08-24	AAPU	ETF	25.48	25.64	25.25	25.59	14351.0
2022-08-24	AAXJ	ETF	66.34	67.33	66.32	66.98	1412200.0
2022-08-24	ABEQ	ETF	27.32	27.401	27.27	27.389	40600.0
2022-08-24	ACES	ETF	62.04	64.34	62.04	63.85	27800.0
2022-08-24	ACIO	ETF	30.695	30.79	30.689	30.735	15600.0
2022-08-24	ACSI	ETF	46.9582	46.9582	46.9582	46.9582	55.0
2022-08-24	ACT	ETF	26.07	26.42	26.07	26.11	91361.0
2022-08-24	ACTV	ETF	31.26	31.39	31.12	31.25	22170.0
2022-08-24	ACTX	ETF	0.63	0.63	0.63	0.63	4259.0
2022-08-24	ACVF	ETF	31.04	31.188	31.04	31.097	6200.0
2022-08-24	ACWF	ETF	32.93	33.125	32.93	33.0749	13763.0
2022-08-24	ACWI	ETF	88.83	89.6	88.75	89.28	2083000.0
2022-08-24	ACWV	ETF	97.58	97.93	97.42	97.65	71000.0
2022-08-24	ACWX	ETF	45.18	45.65	45.16	45.46	1290470.0
2022-08-24	ADFI	ETF	8.58	8.6	8.54	8.567	13800.0
2022-08-24	ADIV	ETF	13.483	13.483	13.48	13.48	100.0
2022-08-24	ADME	ETF	36.6	36.64	36.539	36.575	5100.0
2022-08-24	ADRE	ETF	39.3846	40.01	39.3846	39.72	3381.0
2022-08-24	AEMB	ETF	38.47	38.535	38.47	38.535	1300.0
2022-08-24	AESR	ETF	12.06	12.14	12.06	12.13	59100.0
2022-08-24	AFIF	ETF	8.81	8.96	8.81	8.94	49125.0
2022-08-24	AFK	ETF	17.53	17.53	17.09	17.33	8553.0
2022-08-24	AFLG	ETF	24.51	24.51	24.493	24.493	200.0
2022-08-24	AFMC	ETF	23.11	23.11	23.062	23.062	100.0
2022-08-24	AFSM	ETF	24.11	24.144	24.11	24.144	100.0
2022-08-24	AFTY	ETF	16.855	16.855	16.855	16.855	100.0
2022-08-24	AGG	ETF	101.35	101.4	101.15	101.24	6318900.0
2022-08-24	AGGY	ETF	44.8	44.8	44.71	44.77	166500.0
2022-08-24	AGNG	ETF	25.35	25.639	25.31	25.563	2700.0
2022-08-24	AGOV	ETF	82.0	82.0	82.0	82.0	279.0
2022-08-24	AGOX	ETF	21.87	21.98	21.85	21.947	14900.0
2022-08-24	AGQ	ETF	20.8	21.36	20.75	21.15	588100.0
2022-08-24	AGZ	ETF	109.4745	109.4745	109.32	109.37	115024.0
2022-08-24	AGZD	ETF	23.02	23.025	22.93	23.0	59400.0
2022-08-24	AHHX	ETF	8.79	8.79	8.7726	8.7799	3920.0
2022-08-24	AHYB	ETF	44.285	44.285	44.285	44.285	100.0
2022-08-24	AIA	ETF	58.09	59.17	58.09	58.81	1079194.0
2022-08-24	AIEQ	ETF	35.028	35.41	35.028	35.382	5800.0
2022-08-24	AIQ	ETF	22.27	22.43	22.23	22.25	7117.0

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

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