PREVIEW / etf_daily / 2022-07-08

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-08.parquet
  size:    102 KB
  rows:    2,750

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-07-08	SPY	ETF	387.27	390.64	385.66	388.67	72397800.0
2022-07-08	QQQ	ETF	292.08	296.75	291.12	295.35	59895478.0
2022-07-08	IWM	ETF	175.07	176.99	173.65	175.59	20547000.0
2022-07-08	DIA	ETF	313.5	315.14	312.17	313.46	2094300.0
2022-07-08	GLD	ETF	162.35	163.38	161.84	162.3	4584100.0
2022-07-08	TLT	ETF	113.5	113.5	112.05	112.5	15320000.0
2022-07-08	AAA	ETF	24.275	24.275	24.275	24.275	115.0
2022-07-08	AAAU	ETF	17.29	17.4	17.25	17.29	1664700.0
2022-07-08	AADR	ETF	47.78	48.08	47.78	48.08	4100.0
2022-07-08	AAXJ	ETF	68.96	69.49	68.72	69.21	774500.0
2022-07-08	ABEQ	ETF	27.03	27.03	26.914	26.914	7000.0
2022-07-08	ACES	ETF	51.29	52.962	51.0	52.4	177200.0
2022-07-08	ACIO	ETF	29.31	29.47	29.31	29.34	24700.0
2022-07-08	ACSI	ETF	43.7775	43.7775	43.7775	43.7775	94.0
2022-07-08	ACT	ETF	21.71	21.94	21.49	21.69	86568.0
2022-07-08	ACTV	ETF	31.29	31.538	31.06	31.1849	8096.0
2022-07-08	ACTX	ETF	0.641	0.8	0.641	0.8	550.0
2022-07-08	ACVF	ETF	29.36	29.42	29.28	29.31	1900.0
2022-07-08	ACWF	ETF	31.541	31.6599	31.39	31.5399	21119.0
2022-07-08	ACWI	ETF	85.13	85.9	84.82	85.45	2727300.0
2022-07-08	ACWV	ETF	95.89	96.02	95.48	95.69	588700.0
2022-07-08	ACWX	ETF	44.77	45.05	44.55	44.91	2264767.0
2022-07-08	ADFI	ETF	8.52	8.53	8.49	8.509	175500.0
2022-07-08	ADIV	ETF	14.017	14.017	14.017	14.017	100.0
2022-07-08	ADME	ETF	35.28	35.335	35.22	35.22	9800.0
2022-07-08	ADRE	ETF	39.755	39.755	39.44	39.53	1963.0
2022-07-08	AEMB	ETF	37.32	37.32	37.21	37.236	13700.0
2022-07-08	AESR	ETF	11.29	11.37	11.28	11.3	35400.0
2022-07-08	AFIF	ETF	8.86	8.87	8.85	8.86	419246.0
2022-07-08	AFK	ETF	17.25	17.25	17.01	17.12	4578.0
2022-07-08	AFLG	ETF	23.21	23.21	23.159	23.159	100.0
2022-07-08	AFMC	ETF	21.45	21.45	21.37	21.37	200.0
2022-07-08	AFSM	ETF	22.29	22.29	22.22	22.22	100.0
2022-07-08	AFTY	ETF	18.86	18.88	18.844	18.844	1600.0
2022-07-08	AGG	ETF	101.35	101.45	101.16	101.23	5270100.0
2022-07-08	AGGY	ETF	44.69	44.72	44.56	44.67	96600.0
2022-07-08	AGNG	ETF	25.92	26.16	25.79	26.021	2400.0
2022-07-08	AGOV	ETF	79.34	80.96	79.14	80.1497	5124.0
2022-07-08	AGOX	ETF	20.32	20.69	20.32	20.67	117200.0
2022-07-08	AGQ	ETF	22.12	22.47	21.69	22.1	567300.0
2022-07-08	AGZ	ETF	109.85	109.85	109.5801	109.69	44277.0
2022-07-08	AGZD	ETF	22.85	22.89	22.825	22.88	135200.0
2022-07-08	AHHX	ETF	8.49	8.55	8.49	8.5139	316830.0
2022-07-08	AHYB	ETF	43.08	43.269	43.08	43.269	500.0
2022-07-08	AIA	ETF	62.43	63.0472	62.32	62.66	44784.0
2022-07-08	AIEQ	ETF	32.47	32.864	32.47	32.797	5400.0
2022-07-08	AIQ	ETF	21.52	21.79	21.4503	21.69	7645.0
2022-07-08	AIRR	ETF	37.93	38.16	37.69	37.948	5500.0
2022-07-08	AIVI	ETF	34.94	35.24	34.94	35.16	3800.0
2022-07-08	AIVL	ETF	89.87	90.5	89.67	90.07	8400.0

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

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