Skip to content

Instantly share code, notes, and snippets.

View viniabussafi's full-sized avatar

viniabussafi viniabussafi

View GitHub Profile
@viniabussafi
viniabussafi / fct_hydration_lending_fees.sql
Created October 2, 2025 12:47
Hydration Lending Fees
-- Fetch all token transfers to the lending fee collector address.
with token_transfers as (
select
timestamp_trunc(transfers.block_timestamp, day) as timestamp,
transfers.token_address,
tokens.underlying_token_id,
tokens.decimals,
transfers.value as transfer_amount,
from {{ source('hydration', 'token_transfers_by_to') }} as transfers
left join {{ ref('dim_hydradx_atokens') }} as tokens