PREVIEW / etf_daily / 2023-04-10

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-10.parquet
  size:    109 KB
  rows:    2,969

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
2023-04-10	SPY	ETF	406.61	409.69	405.97	409.61	63681000.0
2023-04-10	QQQ	ETF	315.07	317.92	313.25	317.87	45134736.0
2023-04-10	IWM	ETF	173.07	175.88	173.03	175.75	22237800.0
2023-04-10	DIA	ETF	334.0	335.96	333.43	335.96	2834200.0
2023-04-10	GLD	ETF	185.18	185.36	184.19	185.11	6408100.0
2023-04-10	TLT	ETF	107.64	107.76	106.56	106.78	19134400.0
2023-04-10	AAA	ETF	24.47	24.47	24.47	24.47	20.0
2023-04-10	AAAU	ETF	19.76	19.78	19.66	19.75	1993100.0
2023-04-10	AADR	ETF	48.01	48.01	47.81	47.83	700.0
2023-04-10	AAPB	ETF	21.68	21.91	21.53	21.9004	10348.0
2023-04-10	AAPD	ETF	24.16	24.37	24.1	24.1	211553.0
2023-04-10	AAPU	ETF	22.61	22.66	22.27	22.66	190559.0
2023-04-10	AAXJ	ETF	67.72	67.91	67.49	67.9	815400.0
2023-04-10	ABEQ	ETF	28.25	28.38	28.25	28.35	9700.0
2023-04-10	ACES	ETF	43.38	44.42	43.38	44.42	52500.0
2023-04-10	ACIO	ETF	29.94	30.26	29.94	30.26	37200.0
2023-04-10	ACSI	ETF	44.3193	44.3193	44.3193	44.3193	26.0
2023-04-10	ACT	ETF	22.99	23.3	22.99	23.28	64432.0
2023-04-10	ACTV	ETF	28.86	29.36	28.86	29.356	11309.0
2023-04-10	ACTX	ETF	0.318	0.318	0.1885	0.3	550.0
2023-04-10	ACVF	ETF	31.32	31.359	31.157	31.359	5800.0
2023-04-10	ACWF	ETF	33.48	33.6322	33.48	33.6322	2892.0
2023-04-10	ACWI	ETF	90.74	91.32	90.57	91.32	1310600.0
2023-04-10	ACWV	ETF	97.56	98.05	97.44	98.05	98700.0
2023-04-10	ACWX	ETF	48.62	49.02	48.62	49.01	2003773.0
2023-04-10	ADFI	ETF	8.55	8.58	8.53	8.57	23500.0
2023-04-10	ADIV	ETF	13.69	13.706	13.67	13.706	4600.0
2023-04-10	ADME	ETF	34.511	34.78	34.511	34.78	9600.0
2023-04-10	ADPV	ETF	22.71	22.93	22.66	22.9	18798.0
2023-04-10	AEMB	ETF	37.84	37.84	37.68	37.72	200.0
2023-04-10	AESR	ETF	11.97	12.045	11.97	12.045	34600.0
2023-04-10	AFIF	ETF	8.81	8.84	8.78	8.835	43451.0
2023-04-10	AFK	ETF	16.12	16.142	15.8	15.99	5814.0
2023-04-10	AFLG	ETF	23.92	23.939	23.92	23.939	500.0
2023-04-10	AFMC	ETF	22.794	22.824	22.794	22.824	3100.0
2023-04-10	AFSM	ETF	22.87	22.884	22.87	22.884	300.0
2023-04-10	AFTY	ETF	16.28	16.28	16.19	16.225	300.0
2023-04-10	AGG	ETF	99.89	99.91	99.6	99.75	4478000.0
2023-04-10	AGGH	ETF	22.88	22.9287	22.88	22.9287	241.0
2023-04-10	AGGY	ETF	43.93	43.95	43.795	43.89	93100.0
2023-04-10	AGNG	ETF	27.2	27.29	27.2	27.29	2400.0
2023-04-10	AGOV	ETF	76.27	76.54	76.23	76.54	247.0
2023-04-10	AGOX	ETF	21.34	21.66	21.34	21.648	21700.0
2023-04-10	AGQ	ETF	33.22	33.37	32.91	33.35	400000.0
2023-04-10	AGRH	ETF	25.45	25.45	25.375	25.375	940.0
2023-04-10	AGZ	ETF	108.34	108.4415	108.33	108.33	57539.0
2023-04-10	AGZD	ETF	21.715	21.81	21.705	21.81	55200.0
2023-04-10	AHYB	ETF	43.85	43.907	43.85	43.907	500.0
2023-04-10	AIA	ETF	61.1	61.52	61.07	61.52	17172.0
2023-04-10	AIEQ	ETF	28.15	28.58	28.06	28.58	23200.0

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

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