Sbhn_NPtender-tomato
    Updated 2025-01-22
    WITH price as (
    select hour::date as datee,
    avg(price) as usdprice
    from crosschain.price.ez_prices_hourly
    where symbol = 'OLAS'
    group by 1)

    select count(DISTINCT from_address) as stakers,
    count(DISTINCT concat('0x', right(topics[1],40))) as multisigs,
    sum(amount) as staked_olas,
    sum(amount*usdprice) as staked_usd,
    from base.core.fact_event_logs
    join base.core.ez_token_transfers b using(tx_hash)
    left join price on block_timestamp::date = datee
    where topics[0] = '0xec97633905b1dbe9773a7536e9a986dcf89803e1193934b7b6d76587c68beb40'
    and to_address = '0xaea9ef993d8a1a164397642648df43f053d43d85'



    Last run: 24 days ago
    STAKERS
    MULTISIGS
    STAKED_OLAS
    STAKED_USD
    1
    37371330023403.40666
    1
    27B
    231s