PREVIEW / etf_daily / 2022-08-12

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-12.parquet
  size:    103 KB
  rows:    2,769

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-12	SPY	ETF	422.03	427.21	421.03	427.1	61694500.0
2022-08-12	QQQ	ETF	326.175	330.585	325.1001	330.39	40928379.0
2022-08-12	IWM	ETF	197.35	200.43	196.58	200.36	21726600.0
2022-08-12	DIA	ETF	334.8	337.92	334.19	337.83	2606900.0
2022-08-12	GLD	ETF	167.17	167.94	166.83	167.87	5151700.0
2022-08-12	TLT	ETF	115.1	115.57	114.43	115.55	12178400.0
2022-08-12	AAA	ETF	24.36	24.36	24.36	24.36	12.0
2022-08-12	AAAU	ETF	17.8	17.89	17.78	17.89	1034100.0
2022-08-12	AADR	ETF	52.74	52.74	52.74	52.74	100.0
2022-08-12	AAPB	ETF	26.66	26.8654	26.65	26.8654	2984.0
2022-08-12	AAPD	ETF	24.29	24.35	23.9602	23.9602	30432.0
2022-08-12	AAPU	ETF	26.12	26.68	26.0	26.68	20916.0
2022-08-12	AAXJ	ETF	68.57	69.25	68.52	69.22	1484200.0
2022-08-12	ABEQ	ETF	27.22	27.785	27.22	27.785	10100.0
2022-08-12	ACES	ETF	65.82	67.38	65.1	67.34	99700.0
2022-08-12	ACIO	ETF	30.975	31.27	30.975	31.27	42400.0
2022-08-12	ACSI	ETF	48.3	48.4822	48.3	48.4822	1159.0
2022-08-12	ACT	ETF	26.93	26.99	26.63	26.96	87498.0
2022-08-12	ACTV	ETF	32.57	32.91	32.56	32.8904	2377.0
2022-08-12	ACTX	ETF	0.5215	0.5951	0.5215	0.5951	1486.0
2022-08-12	ACVF	ETF	31.79	32.031	31.698	32.031	7900.0
2022-08-12	ACWF	ETF	33.9445	34.1134	33.9445	34.1134	4031.0
2022-08-12	ACWI	ETF	91.76	92.66	91.5	92.65	1186400.0
2022-08-12	ACWV	ETF	98.59	99.76	98.59	99.5	131200.0
2022-08-12	ACWX	ETF	47.0	47.36	46.91	47.36	1600767.0
2022-08-12	ADFI	ETF	8.71	8.74	8.71	8.74	8000.0
2022-08-12	ADIV	ETF	14.061	14.061	14.061	14.061	100.0
2022-08-12	ADME	ETF	37.183	37.61	37.183	37.61	13000.0
2022-08-12	ADRE	ETF	40.22	40.88	40.22	40.88	1695.0
2022-08-12	AEMB	ETF	39.42	39.6	39.42	39.6	2600.0
2022-08-12	AESR	ETF	12.17	12.32	12.17	12.312	9100.0
2022-08-12	AFIF	ETF	9.0	9.02	9.0	9.015	4095.0
2022-08-12	AFK	ETF	18.17	18.2	17.98	18.2	7212.0
2022-08-12	AFLG	ETF	24.85	25.143	24.85	25.143	100.0
2022-08-12	AFMC	ETF	23.37	23.643	23.37	23.643	100.0
2022-08-12	AFSM	ETF	24.5	24.77	24.5	24.755	300.0
2022-08-12	AFTY	ETF	17.53	17.53	17.53	17.53	100.0
2022-08-12	AGG	ETF	102.97	103.12	102.72	103.12	3643400.0
2022-08-12	AGGH	ETF	23.71	23.7224	23.7	23.7	526.0
2022-08-12	AGGY	ETF	45.58	45.67	45.52	45.67	77100.0
2022-08-12	AGIH	ETF	25.66	25.7299	25.64	25.7089	315.0
2022-08-12	AGNG	ETF	26.632	26.699	26.632	26.699	200.0
2022-08-12	AGOV	ETF	82.9645	82.9645	82.9645	82.9645	12.0
2022-08-12	AGOX	ETF	22.39	22.7	22.39	22.684	30200.0
2022-08-12	AGQ	ETF	24.48	25.56	24.48	25.51	510000.0
2022-08-12	AGZ	ETF	110.15	110.2	110.04	110.14	25712.0
2022-08-12	AGZD	ETF	23.025	23.065	23.02	23.03	45000.0
2022-08-12	AHHX	ETF	8.87	8.91	8.87	8.91	2057.0
2022-08-12	AHYB	ETF	45.523	45.59	45.523	45.59	300.0
2022-08-12	AIA	ETF	60.2	60.94	60.2	60.9	22454.0

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

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