PREVIEW / etf_daily / 2022-09-22

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-22.parquet
  size:    104 KB
  rows:    2,821

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-09-22	SPY	ETF	376.58	378.3	373.44	374.22	89472600.0
2022-09-22	QQQ	ETF	282.0	283.03	278.815	280.07	62757073.0
2022-09-22	IWM	ETF	175.0	175.58	170.74	171.39	33468600.0
2022-09-22	DIA	ETF	301.56	302.97	299.89	300.52	3492500.0
2022-09-22	GLD	ETF	156.26	156.48	155.31	155.7	5975200.0
2022-09-22	TLT	ETF	105.79	105.96	104.73	105.27	29030600.0
2022-09-22	AAA	ETF	24.27	24.27	24.27	24.27	45.0
2022-09-22	AAAU	ETF	16.65	16.67	16.56	16.59	977700.0
2022-09-22	AADR	ETF	47.13	47.13	47.13	47.13	200.0
2022-09-22	AAPB	ETF	21.3641	21.52	21.09	21.52	3947.0
2022-09-22	AAPD	ETF	26.81	27.029	26.421	26.6596	97316.0
2022-09-22	AAPU	ETF	21.92	22.22	21.65	22.04	27605.0
2022-09-22	AAXJ	ETF	62.5	62.55	61.98	62.04	1129600.0
2022-09-22	ABEQ	ETF	25.87	25.91	25.8	25.897	14700.0
2022-09-22	ACES	ETF	62.15	62.18	58.9	59.38	65800.0
2022-09-22	ACIO	ETF	28.81	28.81	28.63	28.7	72800.0
2022-09-22	ACSI	ETF	43.2256	43.2256	43.2256	43.2256	10.0
2022-09-22	ACT	ETF	23.22	23.22	22.78	22.9	264874.0
2022-09-22	ACTV	ETF	28.5	28.5	27.87	28.0237	7524.0
2022-09-22	ACTX	ETF	0.6	0.6	0.45	0.45	1184.0
2022-09-22	ACVF	ETF	28.24	28.29	28.14	28.161	3000.0
2022-09-22	ACWF	ETF	30.64	30.64	30.4301	30.452	90967.0
2022-09-22	ACWI	ETF	82.18	82.26	81.3	81.52	2728200.0
2022-09-22	ACWV	ETF	92.04	92.21	91.57	91.84	115500.0
2022-09-22	ACWX	ETF	42.26	42.28	41.7946	41.96	2803336.0
2022-09-22	ADFI	ETF	8.3	8.31	8.3	8.305	11000.0
2022-09-22	ADIV	ETF	12.62	12.62	12.62	12.62	400.0
2022-09-22	ADME	ETF	33.59	33.7	33.47	33.47	49200.0
2022-09-22	ADRE	ETF	36.75	36.7907	36.3577	36.56	10189.0
2022-09-22	AESR	ETF	11.09	11.15	11.05	11.05	21400.0
2022-09-22	AFIF	ETF	8.8	8.8	8.75	8.765	25432.0
2022-09-22	AFK	ETF	16.0	16.13	15.73	15.9	10462.0
2022-09-22	AFLG	ETF	22.436	22.436	22.436	22.436	100.0
2022-09-22	AFSM	ETF	21.398	21.398	21.398	21.398	100.0
2022-09-22	AFTY	ETF	15.676	15.676	15.676	15.676	200.0
2022-09-22	AGG	ETF	97.9	97.92	97.4	97.5	7092400.0
2022-09-22	AGGY	ETF	43.17	43.17	42.92	42.95	209300.0
2022-09-22	AGNG	ETF	23.6	23.64	23.58	23.64	900.0
2022-09-22	AGOV	ETF	80.25	80.25	79.5	80.2058	1904.0
2022-09-22	AGOX	ETF	20.102	20.15	20.02	20.053	14800.0
2022-09-22	AGQ	ETF	22.4	22.52	21.83	22.31	1336000.0
2022-09-22	AGZ	ETF	107.08	107.17	106.78	106.88	38991.0
2022-09-22	AGZD	ETF	23.025	23.035	22.955	22.995	120400.0
2022-09-22	AHHX	ETF	8.27	8.34	8.27	8.34	288.0
2022-09-22	AHYB	ETF	42.608	42.608	42.608	42.608	300.0
2022-09-22	AIA	ETF	53.45	53.56	53.03	53.11	25952.0
2022-09-22	AIEQ	ETF	31.22	31.22	30.411	30.411	3100.0
2022-09-22	AIQ	ETF	20.1	20.125	19.8	19.8	22498.0
2022-09-22	AIRR	ETF	40.12	40.12	39.65	39.747	92700.0
2022-09-22	AIVI	ETF	32.87	32.87	32.69	32.77	2500.0

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

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