PREVIEW / etf_daily / 2022-04-19

all etf daily files

  file:    by_date/etf_daily/2022/2022-04-19.parquet
  size:    100 KB
  rows:    2,694

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-19	SPY	ETF	437.86	445.8	437.68	445.04	77821000.0
2022-04-19	QQQ	ETF	338.03	346.85	336.98	346.26	56515684.0
2022-04-19	IWM	ETF	197.86	202.24	197.69	201.56	22786700.0
2022-04-19	DIA	ETF	344.29	349.74	344.25	349.12	4261200.0
2022-04-19	GLD	ETF	183.19	183.65	181.33	181.82	12585600.0
2022-04-19	TLT	ETF	119.15	119.72	118.67	119.25	26012300.0
2022-04-19	AAA	ETF	24.72	24.88	24.72	24.88	321.0
2022-04-19	AAAU	ETF	19.51	19.56	19.31	19.35	572800.0
2022-04-19	AADR	ETF	58.73	58.82	58.59	58.8	3800.0
2022-04-19	AAXJ	ETF	72.12	72.75	71.84	72.69	1134800.0
2022-04-19	ABEQ	ETF	30.02	30.09	30.0	30.05	92300.0
2022-04-19	ACES	ETF	56.62	57.98	56.15	57.82	32800.0
2022-04-19	ACIO	ETF	31.065	31.36	31.065	31.34	18900.0
2022-04-19	ACSI	ETF	50.1437	50.1437	50.1437	50.1437	28.0
2022-04-19	ACT	ETF	23.24	23.83	23.24	23.8	129289.0
2022-04-19	ACTV	ETF	35.23	35.73	35.2288	35.59	5278.0
2022-04-19	ACTX	ETF	0.99	0.99	0.99	0.99	254.0
2022-04-19	ACVF	ETF	33.22	33.379	33.22	33.379	4000.0
2022-04-19	ACWF	ETF	35.96	36.488	35.96	36.488	6439.0
2022-04-19	ACWI	ETF	96.64	98.12	96.62	97.98	5598500.0
2022-04-19	ACWV	ETF	104.19	105.09	104.04	105.0	152100.0
2022-04-19	ACWX	ETF	50.65	51.03	50.56	51.02	3895976.0
2022-04-19	ADFI	ETF	8.8	8.8	8.78	8.781	12100.0
2022-04-19	ADIV	ETF	15.26	15.26	15.26	15.26	100.0
2022-04-19	ADME	ETF	39.913	40.23	39.913	40.18	24100.0
2022-04-19	ADRE	ETF	41.39	41.7383	41.16	41.67	4117.0
2022-04-19	AEMB	ETF	41.82	41.82	41.742	41.742	200.0
2022-04-19	AESR	ETF	13.03	13.28	13.03	13.27	38800.0
2022-04-19	AFIF	ETF	9.205	9.205	9.18	9.19	33209.0
2022-04-19	AFK	ETF	21.32	21.32	20.97	21.14	9730.0
2022-04-19	AFLG	ETF	26.19	26.66	26.19	26.624	8300.0
2022-04-19	AFMC	ETF	24.695	24.695	24.695	24.695	100.0
2022-04-19	AFSM	ETF	25.6	25.603	25.6	25.603	600.0
2022-04-19	AFTY	ETF	17.99	17.999	17.99	17.999	100.0
2022-04-19	AGG	ETF	103.26	103.43	102.97	103.02	7847500.0
2022-04-19	AGGY	ETF	45.82	45.939	45.71	45.71	97700.0
2022-04-19	AGNG	ETF	28.37	28.81	28.37	28.754	12100.0
2022-04-19	AGOV	ETF	81.8	82.99	81.592	81.592	1055.0
2022-04-19	AGOX	ETF	23.23	23.45	23.23	23.4	36300.0
2022-04-19	AGQ	ETF	40.71	40.89	39.04	39.41	1066300.0
2022-04-19	AGZ	ETF	110.86	110.86	110.6	110.6	61448.0
2022-04-19	AGZD	ETF	23.125	23.125	23.075	23.11	65600.0
2022-04-19	AHHX	ETF	9.19	9.225	9.19	9.225	2405.0
2022-04-19	AHYB	ETF	46.375	46.375	46.375	46.375	300.0
2022-04-19	AIA	ETF	65.0	65.54	64.64	65.54	90090.0
2022-04-19	AIEQ	ETF	35.85	36.508	35.85	36.508	11600.0
2022-04-19	AIQ	ETF	24.74	25.41	24.74	25.35	12862.0
2022-04-19	AIRR	ETF	40.77	41.604	40.77	41.453	55600.0
2022-04-19	AIVI	ETF	39.47	39.65	39.47	39.62	16100.0
2022-04-19	AIVL	ETF	99.44	100.01	99.4	99.87	5100.0

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

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