Sbhn_NPadded-yellow
    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 from_address as stakers,
    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'
    group by 1
    order by 2 desc


    -- select DISTINCT tx_hash, concat('0x', right(topics[1],40)) as multisig,
    -- amount
    -- from base.core.fact_event_logs
    -- join base.core.ez_token_transfers b using(tx_hash)
    -- where topics[0] = '0xec97633905b1dbe9773a7536e9a986dcf89803e1193934b7b6d76587c68beb40'
    -- and to_address = '0xaea9ef993d8a1a164397642648df43f053d43d85'
    Last run: 24 days ago
    STAKERS
    STAKED_OLAS
    STAKED_USD
    1
    0xf4a697253285a02c70de95c9cba5a645061c9e265001068.75
    2
    0xf6e76bd170097e7f305d9ecd098632ab69b69c07500855.625
    3
    0xa0d03601ec64fd3b9ddc9975d1f1d436355fae735001140.625
    4
    0x6bd9f43a4402a5910c8e1065a45cbb198253b4545001075.416666667
    5
    0xc362756d13e9dcb2c59ddfc8dc260f100bceb9f4500901.458333333
    6
    0x23268a34d4ca89b02a6e40414c9c4b3c3c99993c500854.583333333
    7
    0xb136da9aa24707fd6a49f0bb29d3f1fae09f13f7500903.75
    8
    0x5c118887d2d339aa9e6aa37661e426e5f31e3c775001068.75
    9
    0x864c4721c0d1550286c0dd77ce16e415a36e343a500996.458333333
    10
    0xfe8fd3a9c48e1c92f1db2b98e8682c1c38c10651500860.833333333
    11
    0xe42f3cdd29d45260b9ae68d32751251c55772bc6500898.125
    12
    0xb77337bc71122bb62999d9dc5724852f9cbca192500854.583333333
    13
    0x1ce8801af828837e726b7d5415d6674b4217e1d6500806.875
    14
    0x3500ecbdedb4887e45e45a79de5a98581097e736500822.083333333
    15
    0xe43d22c424a7d3727403f0348c9a8534499cacbb500641.458333333
    16
    0xe8dd43c90244ad0fcfd46b0fa329e2f0cb940fed500641.458333333
    17
    0x2236b805cc6aa7a9f692fd20d470f08919813d3f500773.125
    18
    0x5ff1bdc2d47d10560ce951415d2afdff646d96fd500792.083333333
    19
    0xc81124c0b73a727926ff383a896ff5ec9879fe985001201.458333333
    20
    0x93416f9986a1dc086d6649eddcf246d6830edfe2500623.541666667
    37
    2KB
    231s