PREVIEW / etf_daily / 2023-06-12

all etf daily files

  file:    by_date/etf_daily/2023/2023-06-12.parquet
  size:    110 KB
  rows:    2,953

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-12	SPY	ETF	430.92	433.88	430.17	433.8	76104300.0
2023-06-12	QQQ	ETF	356.19	360.59	355.2	360.49	44817646.0
2023-06-12	IWM	ETF	185.23	186.68	184.22	185.8	26580500.0
2023-06-12	DIA	ETF	339.74	341.3	339.23	341.17	2035500.0
2023-06-12	GLD	ETF	181.8	181.94	181.04	181.88	4873600.0
2023-06-12	TLT	ETF	102.24	102.3	101.12	102.22	19010300.0
2023-06-12	AAA	ETF	24.57	24.57	24.535	24.535	436.0
2023-06-12	AAAU	ETF	19.4	19.42	19.32	19.41	1373300.0
2023-06-12	AADR	ETF	49.03	49.03	48.81	49.0	1100.0
2023-06-12	AAPB	ETF	26.2099	26.88	26.2099	26.8472	8812.0
2023-06-12	AAPD	ETF	21.59	21.6693	21.33	21.34	73125.0
2023-06-12	AAPU	ETF	26.6	27.12	26.5	27.1	82192.0
2023-06-12	AAXJ	ETF	67.24	67.55	67.24	67.47	402500.0
2023-06-12	ABEQ	ETF	28.16	28.21	28.103	28.2	33300.0
2023-06-12	ACES	ETF	44.65	45.39	44.13	45.35	40700.0
2023-06-12	ACIO	ETF	30.51	30.68	30.49	30.68	42800.0
2023-06-12	ACSI	ETF	45.77	46.0279	45.77	46.0279	4530.0
2023-06-12	ACT	ETF	25.95	26.01	25.58	25.71	203269.0
2023-06-12	ACTV	ETF	30.96	31.27	30.96	31.1604	6541.0
2023-06-12	ACTX	ETF	0.285	0.285	0.0201	0.0201	800.0
2023-06-12	ACVF	ETF	32.86	33.03	32.78	32.99	8400.0
2023-06-12	ACWF	ETF	34.55	34.7255	34.55	34.7255	1147.0
2023-06-12	ACWI	ETF	93.88	94.33	93.71	94.32	3086600.0
2023-06-12	ACWV	ETF	97.19	97.19	96.81	97.05	191700.0
2023-06-12	ACWX	ETF	48.97	49.025	48.85	49.0	859083.0
2023-06-12	ADFI	ETF	8.445	8.46	8.43	8.455	29000.0
2023-06-12	ADIV	ETF	13.81	13.81	13.81	13.81	100.0
2023-06-12	ADME	ETF	35.43	35.66	35.41	35.66	17900.0
2023-06-12	ADPV	ETF	23.925	23.9744	23.925	23.9744	1093.0
2023-06-12	AEMB	ETF	37.485	37.485	37.485	37.485	100.0
2023-06-12	AESR	ETF	12.441	12.55	12.44	12.55	23700.0
2023-06-12	AFIF	ETF	8.875	8.89	8.84	8.875	21813.0
2023-06-12	AFK	ETF	15.6	15.655	15.6	15.61	4808.0
2023-06-12	AFLG	ETF	24.71	24.8	24.71	24.766	600.0
2023-06-12	AFMC	ETF	24.03	24.09	24.01	24.055	1000.0
2023-06-12	AFSM	ETF	24.326	24.326	24.326	24.326	100.0
2023-06-12	AFTY	ETF	14.92	14.97	14.92	14.92	1300.0
2023-06-12	AGG	ETF	98.09	98.16	97.73	98.14	5436300.0
2023-06-12	AGGH	ETF	22.62	22.75	22.62	22.6923	15490.0
2023-06-12	AGGY	ETF	43.14	43.16	43.0	43.14	96100.0
2023-06-12	AGNG	ETF	27.78	27.86	27.78	27.86	1200.0
2023-06-12	AGOV	ETF	76.65	77.2	76.0	76.845	322.0
2023-06-12	AGOX	ETF	22.85	23.01	22.82	22.99	42900.0
2023-06-12	AGQ	ETF	30.21	30.38	29.87	30.33	432700.0
2023-06-12	AGZ	ETF	107.24	107.24	107.065	107.22	23820.0
2023-06-12	AGZD	ETF	21.95	21.995	21.925	21.975	68400.0
2023-06-12	AHOY	ETF	19.93	19.9759	19.9117	19.9759	327.0
2023-06-12	AHYB	ETF	43.806	43.806	43.767	43.767	300.0
2023-06-12	AIA	ETF	61.01	61.3	60.99	61.3	13572.0
2023-06-12	AIEQ	ETF	30.8	31.15	30.73	31.07	26400.0

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

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