PREVIEW / etf_daily / 2023-04-04

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-04.parquet
  size:    110 KB
  rows:    2,973

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-04	SPY	ETF	411.62	411.92	407.24	408.67	66601500.0
2023-04-04	QQQ	ETF	320.6	321.63	317.8251	319.07	45875384.0
2023-04-04	IWM	ETF	178.92	179.1	174.32	175.35	33487200.0
2023-04-04	DIA	ETF	335.91	336.26	332.63	333.94	2449900.0
2023-04-04	GLD	ETF	184.72	188.23	184.66	187.98	13765400.0
2023-04-04	TLT	ETF	105.78	107.8	105.75	107.13	18052400.0
2023-04-04	AAA	ETF	24.46	24.46	24.46	24.46	98.0
2023-04-04	AAAU	ETF	19.72	20.09	19.7	20.06	2776700.0
2023-04-04	AADR	ETF	47.9	48.01	47.9	48.01	1800.0
2023-04-04	AAPB	ETF	23.01	23.01	22.83	22.89	3005.0
2023-04-04	AAPD	ETF	23.39	23.6101	23.3889	23.56	152423.0
2023-04-04	AAPU	ETF	23.67	23.7	23.36	23.48	51083.0
2023-04-04	AAXJ	ETF	68.0	68.03	67.69	68.01	325200.0
2023-04-04	ABEQ	ETF	28.15	28.21	28.125	28.21	8600.0
2023-04-04	ACES	ETF	45.67	45.73	44.61	45.06	71400.0
2023-04-04	ACIO	ETF	30.26	30.37	30.18	30.25	52400.0
2023-04-04	ACSI	ETF	44.3455	44.3455	44.3455	44.3455	42.0
2023-04-04	ACT	ETF	23.05	23.05	22.66	22.75	94660.0
2023-04-04	ACTV	ETF	29.88	29.88	29.08	29.2969	11101.0
2023-04-04	ACTX	ETF	0.3	0.3	0.3	0.3	440.0
2023-04-04	ACVF	ETF	31.601	31.66	31.353	31.353	2700.0
2023-04-04	ACWF	ETF	33.88	33.88	33.601	33.6807	18738.0
2023-04-04	ACWI	ETF	91.75	91.89	91.03	91.37	2146600.0
2023-04-04	ACWV	ETF	97.44	97.57	97.14	97.41	106400.0
2023-04-04	ACWX	ETF	49.12	49.25	48.94	49.11	799457.0
2023-04-04	ADFI	ETF	8.59	8.62	8.58	8.59	19600.0
2023-04-04	ADIV	ETF	13.753	13.753	13.753	13.753	100.0
2023-04-04	ADME	ETF	34.75	34.922	34.63	34.69	10300.0
2023-04-04	ADPV	ETF	23.3	23.3	22.91	22.95	12076.0
2023-04-04	AESR	ETF	12.04	12.05	11.97	12.03	40400.0
2023-04-04	AFIF	ETF	8.78	8.84	8.78	8.83	34323.0
2023-04-04	AFK	ETF	16.29	16.29	16.06	16.1392	8098.0
2023-04-04	AFLG	ETF	23.87	23.87	23.87	23.87	100.0
2023-04-04	AFMC	ETF	22.73	22.733	22.73	22.733	100.0
2023-04-04	AFSM	ETF	23.19	23.19	22.68	22.787	700.0
2023-04-04	AFTY	ETF	16.331	16.353	16.33	16.353	2000.0
2023-04-04	AGG	ETF	99.55	100.3	99.5	100.19	8925200.0
2023-04-04	AGGH	ETF	22.85	22.95	22.81	22.81	805.0
2023-04-04	AGGY	ETF	43.75	44.06	43.75	44.03	264500.0
2023-04-04	AGIH	ETF	24.95	24.95	24.91	24.91	200.0
2023-04-04	AGNG	ETF	26.89	26.93	26.79	26.88	7000.0
2023-04-04	AGOV	ETF	76.77	76.77	76.77	76.77	2.0
2023-04-04	AGOX	ETF	21.85	21.85	21.52	21.64	25200.0
2023-04-04	AGQ	ETF	31.24	33.75	31.17	33.7	1130800.0
2023-04-04	AGZ	ETF	108.26	108.57	108.26	108.57	13026.0
2023-04-04	AGZD	ETF	21.995	21.995	21.72	21.725	77400.0
2023-04-04	AHYB	ETF	44.16	44.16	43.997	43.997	900.0
2023-04-04	AIA	ETF	61.35	61.59	61.2115	61.52	20068.0
2023-04-04	AIEQ	ETF	29.32	29.32	28.655	28.75	19500.0
2023-04-04	AIQ	ETF	24.5	24.6199	24.32	24.385	17235.0

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

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