flipside

    TOKEN Staking in Last 24 hrs Bsc
    commanderjoseph-761gwXTOKEN Staking in Last 24 hrs Bsc
    Updated 2024-10-28
    SELECT
    block_timestamp,
    origin_from_address AS staker,
    --'0x'||SUBSTR(topics[1], 27, 64) AS user,
    utils.udf_hex_to_int(SUBSTR(data, 67, 64))/POW(10, 9) AS amount_staked,
    utils.udf_hex_to_int(SUBSTR(data, 3, 64)) AS stake_number,
    tx_hash
    FROM
    bsc.core.fact_event_logs
    WHERE
    origin_to_address = lower('0x1E7866B5A5A4F09EfD235D28d49568c2Fe2F7EcD') --TOKENFI STAKING
    AND
    topics[0] = '0x1449c6dd7851abc30abf37f57715f492010519147cc2652fbc38202c18a6ee90' --STAKED
    AND
    tx_status = 'SUCCESS'
    AND
    block_timestamp > current_timestamp - interval '1 day'
    ORDER
    BY
    block_timestamp
    DESC
    QueryRunArchived: QueryRun has been archived