PREVIEW / etf_daily / 2023-01-18

all etf daily files

  file:    by_date/etf_daily/2023/2023-01-18.parquet
  size:    109 KB
  rows:    2,916

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-01-18	SPY	ETF	399.01	400.12	391.28	391.49	99632300.0
2023-01-18	QQQ	ETF	283.11	284.69	277.67	277.88	47754549.0
2023-01-18	IWM	ETF	187.45	188.96	183.7	183.8	23507800.0
2023-01-18	DIA	ETF	339.57	340.2	332.7	332.97	5164300.0
2023-01-18	GLD	ETF	178.92	179.18	176.9	177.08	5384700.0
2023-01-18	TLT	ETF	108.46	108.77	107.12	108.63	35497200.0
2023-01-18	AAA	ETF	24.47	24.47	24.47	24.47	1.0
2023-01-18	AAAU	ETF	19.08	19.1	18.87	18.89	733900.0
2023-01-18	AADR	ETF	50.22	50.42	49.14	49.47	104700.0
2023-01-18	AAPB	ETF	16.8604	16.96	16.39	16.44	2746.0
2023-01-18	AAPD	ETF	28.64	29.06	28.33	29.02	208728.0
2023-01-18	AAPU	ETF	18.0	18.25	17.6	17.6	102286.0
2023-01-18	AAXJ	ETF	70.88	71.07	69.89	69.91	917400.0
2023-01-18	ABEQ	ETF	28.755	28.755	28.38	28.38	6800.0
2023-01-18	ACES	ETF	51.76	52.605	50.835	51.01	54600.0
2023-01-18	ACIO	ETF	29.4	29.42	29.13	29.13	60100.0
2023-01-18	ACSI	ETF	43.1877	43.1877	43.1877	43.1877	5.0
2023-01-18	ACT	ETF	24.27	24.32	23.91	23.99	206406.0
2023-01-18	ACTV	ETF	31.13	31.33	31.0811	31.0811	27889.0
2023-01-18	ACTX	ETF	0.4	0.44	0.4	0.44	2236.0
2023-01-18	ACVF	ETF	30.584	30.63	30.349	30.349	4400.0
2023-01-18	ACWF	ETF	33.56	33.58	32.97	32.9707	13344.0
2023-01-18	ACWI	ETF	90.18	90.31	88.61	88.65	3426900.0
2023-01-18	ACWV	ETF	97.56	97.98	96.01	96.04	190400.0
2023-01-18	ACWX	ETF	48.9	48.977	48.81	48.82	2417170.0
2023-01-18	ADFI	ETF	8.64	8.67	8.63	8.67	8200.0
2023-01-18	ADIV	ETF	14.325	14.325	14.2	14.2	400.0
2023-01-18	ADME	ETF	33.9	34.085	33.68	33.69	61100.0
2023-01-18	ADPV	ETF	25.15	25.16	25.09	25.12	55228.0
2023-01-18	ADRE	ETF	42.21	42.36	41.97	41.97	24017.0
2023-01-18	AESR	ETF	11.78	11.78	11.51	11.51	20400.0
2023-01-18	AFIF	ETF	8.9	8.9	8.86	8.87	22749.0
2023-01-18	AFK	ETF	17.44	17.44	16.965	17.06	14010.0
2023-01-18	AFLG	ETF	23.68	23.68	23.538	23.538	200.0
2023-01-18	AFSM	ETF	23.58	23.58	23.51	23.51	500.0
2023-01-18	AFTY	ETF	17.41	17.41	17.31	17.31	2400.0
2023-01-18	AGG	ETF	100.76	100.88	100.37	100.73	7779300.0
2023-01-18	AGGY	ETF	44.33	44.44	44.21	44.37	140100.0
2023-01-18	AGNG	ETF	27.2	27.2	26.84	26.84	1100.0
2023-01-18	AGOV	ETF	81.265	81.265	81.265	81.265	10.0
2023-01-18	AGOX	ETF	21.56	21.66	21.17	21.17	76600.0
2023-01-18	AGQ	ETF	32.63	32.91	30.43	30.51	675900.0
2023-01-18	AGZ	ETF	108.53	108.6	108.49	108.51	63216.0
2023-01-18	AGZD	ETF	21.9	21.905	21.815	21.84	241200.0
2023-01-18	AHHX	ETF	8.74	8.74	8.6687	8.68	2293.0
2023-01-18	AHYB	ETF	44.849	44.849	44.526	44.53	700.0
2023-01-18	AIA	ETF	64.32	64.48	63.26	63.26	102337.0
2023-01-18	AIEQ	ETF	31.5	31.68	30.81	30.864	5800.0
2023-01-18	AIQ	ETF	21.76	21.87	21.72	21.72	7396.0
2023-01-18	AIRR	ETF	47.3	47.5	46.37	46.42	34100.0

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

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