PREVIEW / etf_daily / 2022-07-07

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-07.parquet
  size:    101 KB
  rows:    2,732

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-07	SPY	ETF	385.12	389.83	383.27	388.99	64525900.0
2022-07-07	QQQ	ETF	289.63	295.7	289.63	294.98	56620114.0
2022-07-07	IWM	ETF	172.86	175.98	172.85	175.61	24822500.0
2022-07-07	DIA	ETF	312.54	314.27	311.61	313.95	2267500.0
2022-07-07	GLD	ETF	162.43	163.04	162.06	162.23	4588400.0
2022-07-07	TLT	ETF	115.1	115.17	113.51	113.76	13088000.0
2022-07-07	AAA	ETF	24.24	24.255	24.24	24.255	117.0
2022-07-07	AAAU	ETF	17.3	17.36	17.27	17.29	525800.0
2022-07-07	AADR	ETF	47.63	48.15	47.5	48.15	8800.0
2022-07-07	AAXJ	ETF	68.86	69.5	68.72	69.28	959400.0
2022-07-07	ABEQ	ETF	26.98	27.0	26.96	26.978	2900.0
2022-07-07	ACES	ETF	49.61	51.895	49.61	51.59	30700.0
2022-07-07	ACIO	ETF	29.303	29.49	29.27	29.4	14700.0
2022-07-07	ACSI	ETF	43.68	43.731	43.68	43.731	141.0
2022-07-07	ACT	ETF	21.33	21.95	21.33	21.66	231910.0
2022-07-07	ACTV	ETF	31.17	31.4409	31.17	31.4409	6354.0
2022-07-07	ACTX	ETF	0.8	0.8	0.8	0.8	100.0
2022-07-07	ACVF	ETF	29.123	29.292	29.12	29.292	800.0
2022-07-07	ACWF	ETF	31.44	31.58	31.37	31.58	3056.0
2022-07-07	ACWI	ETF	84.7	85.65	84.7	85.51	3197700.0
2022-07-07	ACWV	ETF	95.91	96.11	95.73	95.91	418900.0
2022-07-07	ACWX	ETF	44.55	44.89	44.54	44.88	1620300.0
2022-07-07	ADFI	ETF	8.51	8.53	8.49	8.51	8300.0
2022-07-07	ADIV	ETF	14.01	14.01	13.972	13.972	1700.0
2022-07-07	ADME	ETF	35.12	35.31	35.001	35.28	16000.0
2022-07-07	ADRE	ETF	39.41	39.55	39.4	39.55	1246.0
2022-07-07	AEMB	ETF	37.42	37.42	37.42	37.42	100.0
2022-07-07	AESR	ETF	11.3	11.31	11.27	11.3	15700.0
2022-07-07	AFIF	ETF	8.8501	8.87	8.85	8.85	12569.0
2022-07-07	AFK	ETF	16.78	17.18	16.78	17.12	8141.0
2022-07-07	AFLG	ETF	23.16	23.162	23.16	23.162	100.0
2022-07-07	AFMC	ETF	21.41	21.41	21.41	21.41	100.0
2022-07-07	AFSM	ETF	22.185	22.185	22.185	22.185	100.0
2022-07-07	AFTY	ETF	18.825	18.92	18.825	18.92	3500.0
2022-07-07	AGG	ETF	101.94	101.98	101.52	101.61	8226500.0
2022-07-07	AGGY	ETF	44.94	44.98	44.75	44.84	149400.0
2022-07-07	AGNG	ETF	25.945	25.98	25.945	25.97	800.0
2022-07-07	AGOV	ETF	79.26	80.6	79.0774	79.0774	1866.0
2022-07-07	AGOX	ETF	20.38	20.66	20.38	20.62	28700.0
2022-07-07	AGQ	ETF	22.17	22.57	21.88	22.01	619100.0
2022-07-07	AGZ	ETF	110.12	110.12	109.8785	110.0	65954.0
2022-07-07	AGZD	ETF	22.84	22.985	22.755	22.985	111000.0
2022-07-07	AHHX	ETF	8.5	8.609	8.5	8.609	6148.0
2022-07-07	AHYB	ETF	42.93	43.198	42.93	43.198	400.0
2022-07-07	AIA	ETF	62.29	63.1199	62.29	62.83	118664.0
2022-07-07	AIEQ	ETF	31.77	32.68	31.77	32.64	6000.0
2022-07-07	AIQ	ETF	21.38	21.79	21.38	21.76	6239.0
2022-07-07	AIRR	ETF	37.93	38.2	37.81	38.103	11100.0
2022-07-07	AIVI	ETF	34.85	34.94	34.85	34.93	1500.0
2022-07-07	AIVL	ETF	89.76	90.5	89.76	90.39	22200.0

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

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