PREVIEW / etf_daily / 2022-08-18

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-18.parquet
  size:    100 KB
  rows:    2,703

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-18	SPY	ETF	426.86	428.61	425.5	427.89	49023200.0
2022-08-18	QQQ	ETF	328.44	330.49	326.79	329.28	41937172.0
2022-08-18	IWM	ETF	197.88	199.25	196.9	198.92	18368100.0
2022-08-18	DIA	ETF	340.2	341.0	338.97	340.58	1850900.0
2022-08-18	GLD	ETF	164.6	164.91	163.54	163.92	3646100.0
2022-08-18	TLT	ETF	114.97	115.64	114.59	114.89	10738200.0
2022-08-18	AAA	ETF	24.41	24.41	24.41	24.41	2.0
2022-08-18	AAAU	ETF	17.54	17.57	17.43	17.47	1221500.0
2022-08-18	AADR	ETF	51.81	51.89	51.7	51.87	800.0
2022-08-18	AAPB	ETF	27.22	27.57	27.22	27.48	2325.0
2022-08-18	AAPD	ETF	23.75	23.7801	23.565	23.68	75429.0
2022-08-18	AAPU	ETF	27.03	27.26	26.88	27.12	27086.0
2022-08-18	AAXJ	ETF	68.28	68.28	67.87	68.08	661400.0
2022-08-18	ABEQ	ETF	27.83	27.87	27.78	27.855	11300.0
2022-08-18	ACES	ETF	65.77	66.19	65.28	65.79	112400.0
2022-08-18	ACIO	ETF	31.44	31.44	31.24	31.33	119900.0
2022-08-18	ACSI	ETF	48.6216	48.6216	48.6216	48.6216	12.0
2022-08-18	ACT	ETF	26.49	26.75	26.16	26.5	262259.0
2022-08-18	ACTV	ETF	32.37	32.61	32.28	32.4885	15013.0
2022-08-18	ACTX	ETF	0.65	0.65	0.65	0.65	300.0
2022-08-18	ACVF	ETF	32.13	32.16	32.03	32.133	4700.0
2022-08-18	ACWF	ETF	33.91	33.99	33.89	33.99	2889.0
2022-08-18	ACWI	ETF	92.04	92.18	91.68	92.0	2668600.0
2022-08-18	ACWV	ETF	99.59	99.97	99.51	99.84	92400.0
2022-08-18	ACWX	ETF	46.68	46.7	46.43	46.59	940016.0
2022-08-18	ADFI	ETF	8.69	8.69	8.68	8.685	6400.0
2022-08-18	ADME	ETF	37.439	37.61	37.425	37.496	16900.0
2022-08-18	ADRE	ETF	39.8698	40.07	39.8386	40.07	4012.0
2022-08-18	AEMB	ETF	39.09	39.125	39.06	39.125	500.0
2022-08-18	AESR	ETF	12.33	12.41	12.32	12.4	71100.0
2022-08-18	AFIF	ETF	8.9901	9.01	8.99	9.0	28387.0
2022-08-18	AFK	ETF	17.99	17.99	17.63	17.68	4995.0
2022-08-18	AGG	ETF	102.7	102.93	102.64	102.71	4260600.0
2022-08-18	AGGH	ETF	23.73	23.78	23.7153	23.7153	2503.0
2022-08-18	AGGY	ETF	45.51	45.6	45.481	45.524	60900.0
2022-08-18	AGNG	ETF	25.84	25.93	25.83	25.93	1600.0
2022-08-18	AGOV	ETF	82.9673	82.9673	82.9673	82.9673	90.0
2022-08-18	AGOX	ETF	22.5	22.55	22.43	22.478	32800.0
2022-08-18	AGQ	ETF	23.03	23.16	22.14	22.32	639200.0
2022-08-18	AGZ	ETF	110.26	110.26	109.98	110.01	19778.0
2022-08-18	AGZD	ETF	23.085	23.085	23.015	23.035	86000.0
2022-08-18	AHHX	ETF	8.85	8.91	8.85	8.895	14690.0
2022-08-18	AHYB	ETF	45.064	45.105	45.064	45.067	400.0
2022-08-18	AIA	ETF	59.85	59.87	59.45	59.67	17612.0
2022-08-18	AIEQ	ETF	35.82	36.45	35.82	36.36	5900.0
2022-08-18	AIQ	ETF	23.4	23.52	23.23	23.38	19686.0
2022-08-18	AIRR	ETF	45.053	45.36	45.02	45.302	6000.0
2022-08-18	AIVI	ETF	36.51	36.57	36.39	36.42	3600.0
2022-08-18	AIVL	ETF	97.61	97.88	97.33	97.73	7700.0
2022-08-18	ALTL	ETF	44.3	44.62	44.134	44.52	89957.0

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

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