flipside

    equivalent-teal
    0xHaM-dequivalent-teal
    Updated 2025-03-07
    with priceTb as (
    select
    hour,
    avg(price) as price
    from
    crosschain.price.ez_prices_hourly
    where
    blockchain = 'ethereum'
    and token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
    group by 1
    )
    -- ,
    -- stakeEvent as (
    select
    tx_hash,
    block_timestamp,
    origin_from_address as staker,
    regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,
    ethereum.public.udf_hex_to_int(segmented_data[1])::bigint / 1e18 as amount,
    (ethereum.public.udf_hex_to_int(segmented_data[1])::bigint / 1e18)*price as amount_usd,
    from ink.core.fact_event_logs
    left join priceTb on trunc(block_timestamp,'hour') = hour
    where topics[0] = '0x4c209b5fc8ad50758f13e2e1088ba56a560dff690a1c6fef26394f4c03821c4f'
    and origin_to_address = '0xcab283e4bb527aa9b157bae7180fef19e2aaa71a'
    and tx_succeeded = TRUE
    limit 10
    /*
    )
    -- ,
    -- UnstakeEvent as (
    select*
    -- tx_hash,
    -- block_timestamp,
    -- origin_from_address as staker,
    -- regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,
    -- ethereum.public.udf_hex_to_int(segmented_data[0])::bigint / 1e18 as amount,
    Last run: about 2 months ago
    TX_HASH
    BLOCK_TIMESTAMP
    STAKER
    SEGMENTED_DATA
    AMOUNT
    AMOUNT_USD
    1
    		0x2074c2c50a5a8226fefb126abc455efd51bf1fe410eeabebdbb2756cfa9a40492025-02-10 10:07:35.0000x24077ff88027cc94ed08451e6542fd4d5ca8ee93
    [ "00000000000000000000000000000000000000000000000000005a9d76068421", "00000000000000000000000000000000000000000000000000005af3107a4000" ]
    		0.00010.26447
    2
    		0x8ad529cda563ab42327cbe323d427e140f4d0dd9368bdf1d3cc827dae4ed84712025-02-10 10:00:02.0000x7b1513f0a52abcb1ceada8bed59f4762d99bd278
    [ "00000000000000000000000000000000000000000000000000005a9d7945a5ca", "00000000000000000000000000000000000000000000000000005af3107a4000" ]
    		0.00010.26447
    3
    		0xec38914d95c54b90a0dc4ae4cea371579b8e8089099797a2f3ca17b342a93e122025-02-10 10:47:03.0000xfd595895e9e668c713a2df1ac08165cf904ac701
    [ "00000000000000000000000000000000000000000000000000002d4eb947eaf5", "00000000000000000000000000000000000000000000000000002d79883d2000" ]
    		0.000050.132235
    4
    		0x694a6fb5ca43ad75447e538fd3c1b1a144e6fd50b8c11a1d0af864af2c2a88572025-02-10 10:15:15.0000x72430cfc6cbead96b2ef218ce6791a394fb50bbe
    [ "00000000000000000000000000000000000000000000000000038a269c41294e", "00000000000000000000000000000000000000000000000000038d7ea4c68000" ]
    		0.0012.6447
    5
    		0x217ca4aa923041d72a480e3f207041fe0dd054459371dae179065412abd684522025-02-10 10:28:20.0000x084195e5d0dd05fb2301bedd2ed010d8da48d495
    [ "000000000000000000000000000000000000000000000000000098b5bd84712e", "00000000000000000000000000000000000000000000000000009946010e00e5" ]
    		0.0001690.4469543
    6
    		0xdaf4cd8b869e63b971d2c97ca6f55d11f29bf2a17e079a1d7882d888ac7591a22025-02-10 10:52:39.0000x4f459dc2a1dac3cfb64dc5dceba6ab02d8e1fc1c
    [ "00000000000000000000000000000000000000000000000000038a266b1d1714", "00000000000000000000000000000000000000000000000000038d7ea4c68000" ]
    		0.0012.6447
    7
    		0x746ca380c0b3a997b17fce7bec08ad23ff580cbd99e304bbe4813e89f23e41c22025-02-10 10:15:18.0000x60b7ccb99d797b3dde9f96cf7c38e976f05d5a27
    [ "0000000000000000000000000000000000000000000000000000121f7e014da0", "000000000000000000000000000000000000000000000000000012309ce54000" ]
    		0.000020.052894
    8
    		0x93d7de5b78dd75e38bca17301ab5e689ee9ddb97f950811c6d3c17955d60e39c2025-02-10 10:57:39.0000x629cbeb3cd328e386951d43905d2ed97dbd89c84
    [ "000000000000000000000000000000000000000000000000000001165e839958", "000000000000000000000000000000000000000000000000000001176592e000" ]
    		0.0000010.0026447
    9
    		0x0e949aaf335ebb791200221dffdb180fa54773cdc426c2a8b1c8ac576f830d282025-02-10 10:11:36.0000x233d45936362cda56cc3772de90ce58372a56e8d
    [ "0000000000000000000000000000000000000000000000000001c5134e2094a7", "0000000000000000000000000000000000000000000000000001c6bf52634000" ]
    		0.00051.32235
    10
    		0x956bca7f77eab3eefd2d93efae61f52ac9422d7d0e228f819b2592b92cf4d0362025-02-10 10:22:18.0000x0389349dc1b811f0b3551df9de18bd5c5808f482
    [ "000000000000000000000000000000000000000000000000002365821a8b9d0c", "000000000000000000000000000000000000000000000000002386f26fc10000" ]
    		0.0126.447
    10
    3KB
    6s