SELECT DATE_DAY AS time FROM crosschain.core.dim_dates

WHERE CURRENT_DATE() > PRIOR_DATE_DAY AND DATE_DAY > '2023-09-07'

),

token_symbols AS (

SELECT DISTINCT token_symbol

FROM base.defi.ez_lending_borrows

WHERE platform = 'Seamless'

UNION

SELECT DISTINCT token_symbol

FROM base.defi.ez_lending_repayments

WHERE platform = 'Seamless'

),

daily_loans_gaps AS (

SELECT

SUM(amount_usd) AS USD,

DATE_TRUNC('day', block_timestamp) AS time,

token_symbol

FROM (

SELECT amount_usd, block_timestamp, token_symbol

FROM base.defi.ez_lending_borrows

WHERE platform = 'Seamless'

UNION ALL

SELECT -1 * amount_usd AS amount_usd, block_timestamp, token_symbol

FROM base.defi.ez_lending_repayments

WHERE platform = 'Seamless'

)

GROUP BY time, token_symbol

),

daily_loans_all_days AS (

SELECT

ds.time,

ts.token_symbol,