SELECT * FROM VALUES

-- symbol | issuer | price manual

('BENJI', 'GBHNGLLIE3KWGKCHIKMHJ5HVZHYIK7WTBE4QF5PLAKL4CJGSEU7HZIW5', 1.00),

('FLTT', 'GBTZKH3RNKW46XEZNCGZEBAGJISKDZKQXKSQ2N5G5SFX36TLWKKR6QJ6', 2.32),

('WTGX', 'GDMBNMFJ3TRFLASJ6UGETFME3PJPNKPU24C7KFDBEBPQFG2CI6UC3JG6', 1.00),

('GOLD', 'GCK75CK3VX5L4ZLSD7HHNVA4L3LKGIAYWLCZO2IBNGOFTBV3HJBE2MPJ', 12000),

('WTSY', 'GB3ZUC7FGDEEBXY3BDEJWMPNGBFA66YRI4QQT6PBO3ZT6F33S7RL36VF', 158.7),

('WTTS', 'GBBV5CF7UPA2PYRPA632URLB55BWML7X4H33ZRCDWMTULOXDGPHJR5VI', 4750),

('TIPS', 'GAJ4KSYLVBJKQ4UBPKJJXPYWVIRZWVTIYRMHBXTHGCDS4XJXXYEUALVD', 5500.62),

('WTST', 'GDEBI5X7J4IDXCSVV3KPFZIHQRCBVF3DAZMS5H7KYOBK45T6XYGDE77P', 15000),

('WTLG', 'GAK7PE7DD4ZRJQN3VBCQFBKFV53JGUM2SQATQAKLFK6MVONPGNYK34XH', 10500)

AS t(symbol, issuer, price)),

filtered_trustlines AS (

SELECT closed_at,

DATE_TRUNC('day', closed_at) AS day,

account_id,

asset_code,

asset_issuer,

balance

FROM stellar.core.fact_trust_lines

WHERE deleted = FALSE

AND (asset_code, asset_issuer) IN (

SELECT symbol, issuer FROM tokens

)

),

latest_balance_per_day AS (

SELECT

day,

account_id,

asset_code,

asset_issuer,

MAX(closed_at) AS latest_time

FROM filtered_trustlines