BlockTrackerlending / total supply
    Updated 9 hours ago
    with all_data as
    (
    select
    event_name,
    block_timestamp,
    tx_hash,
    origin_from_address,
    '0x4300000000000000000000000000000000000003' as token_address,
    'USDB' as token_symbol,
    DECODED_LOG : amount :: int /pow(10, 18) as amount
    from blast.core.ez_decoded_event_logs
    where contract_address = '0x4a1d9220e11a47d8ab22ccd82da616740cf0920a'
    and event_name IN ('Deposit', 'Withdraw', 'Borrow', 'Repay')
    and block_timestamp::date >= '2024-02-29'
    union all
    select
    event_name,
    block_timestamp,
    tx_hash,
    origin_from_address,
    '0x4300000000000000000000000000000000000004' as token_address,
    'WETH' as token_symbol,
    DECODED_LOG : amount :: int / pow(10, 18) as amount
    from blast.core.ez_decoded_event_logs
    where contract_address = '0x44f33bc796f7d3df55040cd3c631628b560715c2'
    and event_name IN ('Deposit', 'Withdraw', 'Borrow', 'Repay')
    and block_timestamp::date >= '2024-02-29'
    )
    ,
    prices as (
    select
    symbol,
    price
    from blast.price.ez_prices_hourly
    where symbol IN ('WETH', 'USDB')
    qualify row_number() over (partition by symbol order by hour desc) = 1
    Last run: about 9 hours ago
    TOKEN_SYMBOL
    Total Supplied
    Total Supplied [USD]
    1
    WETH-773.296496648-2475035.96606565
    2
    USDB-1355913.15528637-1355273.16427708
    2
    88B
    24s