Sbhn_NPfun-purple
    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 "Staker",
    concat('0x',substr(data,27,40)) as "Multisig",
    concat('0x', right(data,40)) as "StakingInstance",
    ethereum.public.udf_hex_to_int(substr(topics[2],3,len(topics[2]))) as "Social ID",
    ethereum.public.udf_hex_to_int(substr(topics[3],3,len(topics[3]))) as "Service ID",
    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] = '0x2c50df9a1dea57a91edc18dc7b7d135675e66bca942cb9ab6009bc7647f09c64'
    and to_address = '0xaea9ef993d8a1a164397642648df43f053d43d85'
    group by 1,2,3,4,5



    -- select
    -- topics
    -- from base.core.fact_event_logs
    -- join base.core.ez_token_transfers b using(tx_hash)
    -- where topics[0] = '0x2c50df9a1dea57a91edc18dc7b7d135675e66bca942cb9ab6009bc7647f09c64'
    -- and to_address = '0xaea9ef993d8a1a164397642648df43f053d43d85'
    -- and tx_hash = '0xdc219ef6ec9040da865574428b32034fa189a485d7c5c5681048fd6289c79c40'


    Last run: 24 days ago
    Staker
    Multisig
    StakingInstance
    Social ID
    Service ID
    Staked $OLAS
    Staked USD
    1
    0x5c118887d2d339aa9e6aa37661e426e5f31e3c770x729a9db7813b5187fdfd7166e1b310e28acef6880x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e81259899393643143169215001068.75
    2
    0xf6e76bd170097e7f305d9ecd098632ab69b69c070x47ac6cd1d7303c5358f0c2a0404cb54b619fe69f0x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e8183602207416010752037500855.625
    3
    0x9188bb9a35d3c0048ef5266f68d0c66d4487fcd30xf54087a6c009391163905e43dac06bd160848e920x95146adf659f455f300d7521b3b62a3b6c4aba1f43537715099310094.760826667
    4
    0xc81124c0b73a727926ff383a896ff5ec9879fe980x4deb97bf6bcb8362bf1144d53fa97772ffdf25d40x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e8265754557655001201.458333333
    5
    0x23a45d03029b847a02bf19f3caa42cbee6ddf94a0x30076db9b2eabb65ed6cac329b3d9069d83540e50x95146adf659f455f300d7521b3b62a3b6c4aba1f185679560698518323350100211.291666667
    6
    0x3500ecbdedb4887e45e45a79de5a98581097e7360x07fcc6a71c78ea33ad67b835b4d796db7a393fe20x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e8342385166230500822.083333333
    7
    0xa9da9cac1fbeb057fa9c88071b3d74638313d71c0x61ddae7515828de9a5b04b4032043cc97920ad030x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e8137708769275677082524500854.583333333
    8
    0x6427328b8096ae606252aaf5ae8b1dc4cbf4b01d0xeb5ec50dc819a6bed61e9a9bdb4f0eb603581ce30x2c8a5ac7b431ce04a037747519ba475884bce2fb135875518581687091719100213.75
    9
    0x6bd9f43a4402a5910c8e1065a45cbb198253b4540x4c169251dac381d1d3f20cfa0c706887e3224a770x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e81781344356802371584665001075.416666667
    10
    0x79247a47a038b02177ba29da8436064f4c8155270x1558b65550a0cec450450b0f1f76c149e11db8080x2c8a5ac7b431ce04a037747519ba475884bce2fb176905917419607654472100180.75
    11
    0x0ab2814fd454519f395a95e7311391b9199f4bee0xd2dd597f0e616b12cd369dcea373b0bd4d6883420x95146adf659f455f300d7521b3b62a3b6c4aba1f292969503679100164.291666667
    12
    0xd1de95707094333bdf0599ff2d1f939d8af1e5130xde3cd4a309fd9a7626bfd3e253c62a7f1985f2590x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e870648164978602803443500833.333333333
    13
    0xb77337bc71122bb62999d9dc5724852f9cbca1920x8ff588876de4dda80fc783dd9e1a8c176eda46290x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e8135725719973563187726500854.583333333
    14
    0x23268a34d4ca89b02a6e40414c9c4b3c3c99993c0x73dff3714544a1a857772a34a6e5e8097c3316eb0x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e894645924781805977623500854.583333333
    15
    0xe43d22c424a7d3727403f0348c9a8534499cacbb0xa564466a144c139eb5f536cb5203d2adcd56bb480x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e815199870988500641.458333333
    16
    0xc362756d13e9dcb2c59ddfc8dc260f100bceb9f40xdfa75824b4fd70cb018c8e94f84b4ddeea5583100x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e8174487343022095155252500901.458333333
    17
    0xfd7f2cfe541b3789059a78f1de1fc87b637c34a30xb98fedc1fdf84eb73a4b1f8bcac799533fa817dd0x2c8a5ac7b431ce04a037747519ba475884bce2fb169523220983226777654100191.083333333
    18
    0x1ce8801af828837e726b7d5415d6674b4217e1d60xe5e314787a3c9c7ededf2b9da07fdc626238b6230x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e8131809416225677721627500806.875
    19
    0xb136da9aa24707fd6a49f0bb29d3f1fae09f13f70x4d01c742a3a3a4deb55b071b0f22a24520c5da630x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e8187007549521334682073500903.75
    20
    0x63fcf3ed2a17b9b60c8b7c494e74bfda8b13364f0x67c7235473c54c21814002ad2dfc69861aff024f0x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e813567842725500854.583333333
    37
    6KB
    232s