PREVIEW / etf_daily / 2023-03-16

all etf daily files

  file:    by_date/etf_daily/2023/2023-03-16.parquet
  size:    108 KB
  rows:    2,896

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-03-16	SPY	ETF	386.82	396.47	386.29	396.11	143254200.0
2023-03-16	QQQ	ETF	298.0	307.18	297.19	306.81	98556824.0
2023-03-16	IWM	ETF	171.47	177.38	170.5	175.98	52392300.0
2023-03-16	DIA	ETF	317.66	323.57	316.43	323.25	6569900.0
2023-03-16	GLD	ETF	179.51	179.65	177.87	178.57	10762200.0
2023-03-16	TLT	ETF	107.38	108.03	105.04	105.27	43089300.0
2023-03-16	AAA	ETF	24.53	24.53	24.53	24.53	17.0
2023-03-16	AAAU	ETF	19.15	19.17	18.98	19.05	2466400.0
2023-03-16	AADR	ETF	45.08	45.84	45.05	45.84	1300.0
2023-03-16	AAPB	ETF	19.94	20.78	19.94	20.66	12196.0
2023-03-16	AAPD	ETF	25.74	25.85	25.07	25.16	104563.0
2023-03-16	AAPU	ETF	20.83	21.67	20.7888	21.56	253544.0
2023-03-16	AAXJ	ETF	63.83	65.04	63.83	65.01	653100.0
2023-03-16	ABEQ	ETF	26.815	27.199	26.815	27.175	26900.0
2023-03-16	ACES	ETF	43.71	44.12	42.8	44.04	82500.0
2023-03-16	ACIO	ETF	29.36	29.58	29.36	29.58	77000.0
2023-03-16	ACSI	ETF	43.1026	43.1026	43.1026	43.1026	1.0
2023-03-16	ACT	ETF	21.73	22.62	21.37	22.34	118788.0
2023-03-16	ACTV	ETF	28.18	28.82	28.1	28.7069	7398.0
2023-03-16	ACTX	ETF	0.321	0.321	0.321	0.321	5024.0
2023-03-16	ACVF	ETF	29.86	30.44	29.74	30.361	2300.0
2023-03-16	ACWF	ETF	31.74	32.417	31.74	32.417	14040.0
2023-03-16	ACWI	ETF	85.68	87.55	85.5	87.52	4573200.0
2023-03-16	ACWV	ETF	92.81	93.86	92.81	93.79	343900.0
2023-03-16	ACWX	ETF	45.59	46.5	45.56	46.49	2445007.0
2023-03-16	ADFI	ETF	8.44	8.44	8.425	8.425	13500.0
2023-03-16	ADIV	ETF	13.32	13.532	13.32	13.532	200.0
2023-03-16	ADME	ETF	33.81	33.93	33.76	33.83	42000.0
2023-03-16	ADPV	ETF	22.66	23.35	22.66	23.2886	17209.0
2023-03-16	ADRE	ETF	37.45	38.31	37.38	38.28	9687.0
2023-03-16	AESR	ETF	11.37	11.62	11.37	11.58	30000.0
2023-03-16	AFIF	ETF	8.71	8.76	8.68	8.76	13456.0
2023-03-16	AFK	ETF	15.04	15.1	14.97	15.1	7304.0
2023-03-16	AFMC	ETF	22.022	22.474	21.994	22.474	52000.0
2023-03-16	AGG	ETF	99.53	99.72	98.68	98.88	15217800.0
2023-03-16	AGGY	ETF	43.71	43.8	43.4	43.44	286700.0
2023-03-16	AGIH	ETF	24.65	24.65	24.4504	24.4504	673.0
2023-03-16	AGNG	ETF	25.81	26.12	25.41	26.12	8200.0
2023-03-16	AGOV	ETF	75.1097	75.1097	75.1097	75.1097	1.0
2023-03-16	AGOX	ETF	20.38	21.13	20.38	21.057	36500.0
2023-03-16	AGQ	ETF	25.99	26.02	24.88	25.43	658800.0
2023-03-16	AGZ	ETF	108.49	108.5	107.635	107.78	33531.0
2023-03-16	AGZD	ETF	21.615	21.855	21.595	21.76	50000.0
2023-03-16	AHHX	ETF	8.47	8.47	8.33	8.4074	528.0
2023-03-16	AHYB	ETF	42.991	43.234	42.991	43.234	800.0
2023-03-16	AIA	ETF	56.75	58.0	56.75	57.9	29078.0
2023-03-16	AIEQ	ETF	27.89	28.779	27.89	28.69	8900.0
2023-03-16	AIQ	ETF	22.24	22.9343	22.24	22.85	15664.0
2023-03-16	AIRR	ETF	45.62	47.026	45.02	46.78	73900.0
2023-03-16	AIVI	ETF	37.06	37.62	36.99	37.62	4300.0

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

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