PREVIEW / etf_daily / 2022-09-27

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-27.parquet
  size:    105 KB
  rows:    2,811

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-09-27	SPY	ETF	368.02	370.4	360.87	363.38	108294100.0
2022-09-27	QQQ	ETF	277.81	280.21	272.11	274.48	69780115.0
2022-09-27	IWM	ETF	166.31	167.63	163.28	164.73	42406600.0
2022-09-27	DIA	ETF	294.78	296.53	289.5	291.3	3681000.0
2022-09-27	GLD	ETF	152.25	152.73	151.5	151.54	7151300.0
2022-09-27	TLT	ETF	102.71	102.98	100.9	100.95	34609500.0
2022-09-27	AAA	ETF	24.26	24.26	24.26	24.26	2.0
2022-09-27	AAAU	ETF	16.23	16.28	16.14	16.15	2775300.0
2022-09-27	AADR	ETF	44.15	44.15	43.9	43.92	2000.0
2022-09-27	AAPB	ETF	21.47	21.47	21.2034	21.2034	910.0
2022-09-27	AAPD	ETF	26.69	27.1599	26.37	26.8963	126312.0
2022-09-27	AAPU	ETF	22.04	22.4189	21.42	21.81	112430.0
2022-09-27	AAXJ	ETF	60.51	60.95	59.8	60.02	1128400.0
2022-09-27	ABEQ	ETF	25.18	25.18	24.86	24.94	11000.0
2022-09-27	ACES	ETF	57.76	58.399	56.76	57.19	44500.0
2022-09-27	ACIO	ETF	28.59	28.59	28.372	28.45	36300.0
2022-09-27	ACSI	ETF	42.0689	42.0689	42.0689	42.0689	3.0
2022-09-27	ACT	ETF	22.42	22.56	21.67	21.94	208451.0
2022-09-27	ACTV	ETF	27.42	27.44	26.8	26.98	13378.0
2022-09-27	ACTX	ETF	0.6	0.6	0.451	0.451	2075.0
2022-09-27	ACVF	ETF	27.67	27.67	27.12	27.235	1200.0
2022-09-27	ACWF	ETF	29.5216	29.5216	29.06	29.2319	7656.0
2022-09-27	ACWI	ETF	79.55	80.0	78.11	78.6	4203500.0
2022-09-27	ACWV	ETF	89.56	90.52	89.01	89.3	813500.0
2022-09-27	ACWX	ETF	40.38	40.57	39.735	39.97	3215086.0
2022-09-27	ADFI	ETF	8.161	8.17	8.13	8.155	6300.0
2022-09-27	ADIV	ETF	12.32	12.32	12.23	12.23	400.0
2022-09-27	ADME	ETF	33.51	33.51	33.27	33.34	25800.0
2022-09-27	ADRE	ETF	35.4026	35.4026	34.8068	34.91	4548.0
2022-09-27	AEMB	ETF	35.45	35.46	35.316	35.319	3600.0
2022-09-27	AESR	ETF	10.815	10.87	10.65	10.703	25500.0
2022-09-27	AFIF	ETF	8.7199	8.73	8.7	8.705	184555.0
2022-09-27	AFK	ETF	15.24	15.36	15.07	15.07	4874.0
2022-09-27	AFLG	ETF	21.61	21.7	21.61	21.687	1000.0
2022-09-27	AFMC	ETF	20.022	20.022	20.022	20.022	100.0
2022-09-27	AFSM	ETF	20.603	20.603	20.603	20.603	100.0
2022-09-27	AFTY	ETF	15.647	15.647	15.647	15.647	100.0
2022-09-27	AGG	ETF	95.97	96.08	95.38	95.54	11440200.0
2022-09-27	AGGH	ETF	22.67	22.67	22.6596	22.6596	492.0
2022-09-27	AGGY	ETF	42.04	42.1	41.79	41.906	120900.0
2022-09-27	AGNG	ETF	23.38	23.39	22.94	22.98	4600.0
2022-09-27	AGOV	ETF	78.82	78.82	77.68	78.1154	3364.0
2022-09-27	AGOX	ETF	19.67	19.67	19.13	19.37	294300.0
2022-09-27	AGQ	ETF	20.0	20.29	19.28	19.33	640700.0
2022-09-27	AGZ	ETF	106.31	106.32	105.99	105.99	24748.0
2022-09-27	AGZD	ETF	22.815	22.905	22.735	22.84	135200.0
2022-09-27	AHHX	ETF	8.12	8.12	7.9901	8.09	50890.0
2022-09-27	AHYB	ETF	41.751	41.751	41.533	41.533	400.0
2022-09-27	AIA	ETF	52.08	52.36	51.38	51.56	83827.0
2022-09-27	AIEQ	ETF	28.92	29.31	28.598	28.884	11000.0

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

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