address AS (

SELECT day, a.OP_SOURCE_ACCOUNT, balance

FROM (

SELECT

closed_at AS day,

OP_SOURCE_ACCOUNT,

MAX(closed_at) AS latest_time

FROM stellar.core.ez_operations

WHERE asset_issuer = 'GBHNGLLIE3KWGKCHIKMHJ5HVZHYIK7WTBE4QF5PLAKL4CJGSEU7HZIW5'

AND asset_code = 'BENJI'

AND type_string = 'change_trust'

GROUP BY 1,2

) a

LEFT JOIN stellar.core.fact_accounts b

ON a.OP_SOURCE_ACCOUNT = b.ACCOUNT_ID

AND a.latest_time = b.closed_at

AND a.asset_issuer = 'GBHNGLLIE3KWGKCHIKMHJ5HVZHYIK7WTBE4QF5PLAKL4CJGSEU7HZIW5'

AND a.asset_code = 'BENJI'

AND a.type_string = 'change_trust'

),

days AS (

SELECT

DATEADD(DAY, ROW_NUMBER() OVER (), '2008-01-01') AS day

FROM TABLE(GENERATOR(ROWCOUNT => 20000)) -- Generate 20,000 rows for enough days

),

raw AS (

SELECT day, address

FROM (

SELECT DISTINCT OP_SOURCE_ACCOUNT AS address FROM address

), days