PREVIEW / etf_daily / 2022-10-12

all etf daily files

  file:    by_date/etf_daily/2022/2022-10-12.parquet
  size:    104 KB
  rows:    2,807

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-10-12	SPY	ETF	358.17	359.82	356.3	356.56	76991800.0
2022-10-12	QQQ	ETF	263.4	265.36	261.95	262.66	50580179.0
2022-10-12	IWM	ETF	167.9	168.46	165.48	167.26	26796700.0
2022-10-12	DIA	ETF	292.46	294.57	291.37	292.16	4378700.0
2022-10-12	GLD	ETF	155.51	156.29	155.26	155.99	3998500.0
2022-10-12	TLT	ETF	99.28	100.54	99.19	100.35	21447600.0
2022-10-12	AAA	ETF	24.1	24.1112	24.1	24.11	3343.0
2022-10-12	AAAU	ETF	16.58	16.65	16.55	16.63	118900.0
2022-10-12	AADR	ETF	44.08	44.15	44.07	44.07	300.0
2022-10-12	AAPB	ETF	17.96	17.96	17.9463	17.9463	645.0
2022-10-12	AAPD	ETF	29.2	29.36	28.9398	29.36	91822.0
2022-10-12	AAPU	ETF	18.95	19.219	18.86	18.88	24573.0
2022-10-12	AAXJ	ETF	57.47	57.88	57.33	57.58	1016100.0
2022-10-12	ABEQ	ETF	25.22	25.28	25.197	25.197	127100.0
2022-10-12	ACES	ETF	52.17	52.17	50.385	50.47	40500.0
2022-10-12	ACIO	ETF	28.13	28.3	28.13	28.191	31200.0
2022-10-12	ACSI	ETF	40.75	40.8088	40.75	40.8088	2818.0
2022-10-12	ACT	ETF	23.2	23.36	22.9	22.95	106210.0
2022-10-12	ACTV	ETF	26.99	27.03	26.8901	26.91	5133.0
2022-10-12	ACTX	ETF	0.5	0.5	0.5	0.5	263.0
2022-10-12	ACVF	ETF	27.09	27.09	26.895	26.895	1800.0
2022-10-12	ACWF	ETF	29.55	29.55	29.41	29.4131	10707.0
2022-10-12	ACWI	ETF	77.78	78.06	77.38	77.52	2764200.0
2022-10-12	ACWV	ETF	88.31	88.69	88.0	88.0	134500.0
2022-10-12	ACWX	ETF	39.76	39.9	39.59	39.69	2749399.0
2022-10-12	ADFI	ETF	8.175	8.18	8.14	8.155	6000.0
2022-10-12	ADIV	ETF	11.548	11.548	11.518	11.518	300.0
2022-10-12	ADME	ETF	33.13	33.22	33.08	33.14	25800.0
2022-10-12	ADRE	ETF	33.56	33.6883	33.52	33.605	2454.0
2022-10-12	AEMB	ETF	35.295	35.295	35.295	35.295	100.0
2022-10-12	AESR	ETF	10.72	10.73	10.659	10.66	29800.0
2022-10-12	AFIF	ETF	8.59	8.67	8.59	8.6551	30866.0
2022-10-12	AFK	ETF	14.92	14.92	14.76	14.9	10732.0
2022-10-12	AFLG	ETF	21.701	21.701	21.701	21.701	100.0
2022-10-12	AFSM	ETF	21.28	21.37	21.28	21.288	1200.0
2022-10-12	AFTY	ETF	15.1	15.14	15.1	15.117	1700.0
2022-10-12	AGG	ETF	95.25	95.61	95.23	95.48	5651200.0
2022-10-12	AGGY	ETF	41.81	41.93	41.76	41.895	348100.0
2022-10-12	AGNG	ETF	23.49	23.566	23.41	23.45	2900.0
2022-10-12	AGOV	ETF	76.88	76.88	76.12	76.12	100.0
2022-10-12	AGOX	ETF	19.16	19.32	19.13	19.29	44700.0
2022-10-12	AGQ	ETF	20.61	20.95	20.22	20.67	1145000.0
2022-10-12	AGZ	ETF	105.94	106.08	105.935	106.03	16904.0
2022-10-12	AGZD	ETF	22.785	22.82	22.635	22.725	346000.0
2022-10-12	AHHX	ETF	8.13	8.19	8.07	8.15	18732.0
2022-10-12	AHYB	ETF	41.702	41.777	41.67	41.731	1700.0
2022-10-12	AIA	ETF	49.18	49.51	49.015	49.1	91720.0
2022-10-12	AIEQ	ETF	29.7	29.7	29.42	29.518	3600.0
2022-10-12	AIQ	ETF	18.64	18.75	18.556	18.61	14704.0
2022-10-12	AIRR	ETF	39.76	39.76	39.25	39.25	11100.0

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

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