PREVIEW / etf_daily / 2023-06-29

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-29.parquet
  size:    110 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-06-29	SPY	ETF	435.96	438.28	435.54	438.11	67882300.0
2023-06-29	QQQ	ETF	364.24	364.89	362.14	363.81	46150967.0
2023-06-29	IWM	ETF	184.72	187.08	184.43	186.38	32084100.0
2023-06-29	DIA	ETF	338.41	341.39	338.11	341.16	2902700.0
2023-06-29	GLD	ETF	175.83	177.63	175.79	177.09	6862500.0
2023-06-29	TLT	ETF	102.17	102.34	101.45	101.74	41091600.0
2023-06-29	AAA	ETF	24.66	24.66	24.66	24.66	50.0
2023-06-29	AAAU	ETF	18.77	18.96	18.77	18.92	772000.0
2023-06-29	AADR	ETF	49.01	49.09	48.92	49.09	2100.0
2023-06-29	AAPB	ETF	28.15	28.329	28.14	28.22	18060.0
2023-06-29	AAPD	ETF	20.56	20.57	20.47	20.52	445329.0
2023-06-29	AAPU	ETF	28.12	28.26	28.04	28.14	86110.0
2023-06-29	AAXJ	ETF	65.83	65.99	65.8	65.91	317500.0
2023-06-29	ABEQ	ETF	27.75	27.912	27.75	27.88	11100.0
2023-06-29	ACES	ETF	43.49	44.3	43.49	44.125	52100.0
2023-06-29	ACIO	ETF	30.66	30.85	30.63	30.81	16800.0
2023-06-29	ACSI	ETF	46.5047	46.5047	46.5047	46.5047	48.0
2023-06-29	ACT	ETF	24.74	25.2	24.64	24.92	291179.0
2023-06-29	ACTV	ETF	31.46	31.565	31.4599	31.4972	3746.0
2023-06-29	ACTX	ETF	0.21	0.21	0.21	0.21	254.0
2023-06-29	ACVF	ETF	33.34	33.45	33.281	33.45	3400.0
2023-06-29	ACWF	ETF	34.79	34.9459	34.79	34.9432	4520.0
2023-06-29	ACWI	ETF	94.52	94.89	94.43	94.89	1937300.0
2023-06-29	ACWV	ETF	96.99	97.41	96.73	97.34	374600.0
2023-06-29	ACWX	ETF	48.57	48.73	48.54	48.73	2008811.0
2023-06-29	ADFI	ETF	8.42	8.44	8.42	8.435	12900.0
2023-06-29	ADIV	ETF	13.56	13.56	13.56	13.56	100.0
2023-06-29	ADME	ETF	35.7	35.959	35.7	35.959	5100.0
2023-06-29	ADPV	ETF	24.48	24.4801	24.47	24.4779	1865.0
2023-06-29	AESR	ETF	12.65	12.69	12.64	12.69	30000.0
2023-06-29	AFIF	ETF	9.25	9.37	8.78	8.795	15551.0
2023-06-29	AFK	ETF	14.68	14.75	14.57	14.7	8289.0
2023-06-29	AFLG	ETF	25.176	25.176	25.176	25.176	100.0
2023-06-29	AFMC	ETF	24.718	24.718	24.718	24.718	100.0
2023-06-29	AFSM	ETF	24.63	24.686	24.63	24.686	200.0
2023-06-29	AFTY	ETF	14.602	14.602	14.602	14.602	100.0
2023-06-29	AGG	ETF	97.8	97.87	97.61	97.72	8877500.0
2023-06-29	AGGH	ETF	22.425	22.4699	22.42	22.4457	3034.0
2023-06-29	AGGY	ETF	42.99	43.02	42.9	42.98	134300.0
2023-06-29	AGNG	ETF	27.37	27.46	27.37	27.44	2200.0
2023-06-29	AGOV	ETF	77.5	77.5	75.04	75.04	292.0
2023-06-29	AGOX	ETF	23.15	23.224	23.12	23.2	25100.0
2023-06-29	AGQ	ETF	26.05	26.73	25.79	26.51	644800.0
2023-06-29	AGZ	ETF	107.1	107.1	106.73	106.8945	13106.0
2023-06-29	AGZD	ETF	22.065	22.115	22.0	22.095	176800.0
2023-06-29	AHYB	ETF	43.76	43.809	43.756	43.809	600.0
2023-06-29	AIA	ETF	59.35	59.45	59.2901	59.42	19150.0
2023-06-29	AIEQ	ETF	31.01	31.35	31.01	31.3	8400.0
2023-06-29	AIQ	ETF	27.64	27.68	27.4501	27.59	449883.0
2023-06-29	AIRR	ETF	52.86	53.9	52.86	53.88	289800.0

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

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