flipside

    Xswap BSC
    HerotatXswap BSC
    Updated 2022-08-15
    select block_timestamp::date, tx_hash, event_index, contract_address, 'Bsc' as blockchain,
    regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,
    ETHEREUM.PUBLIC.udf_hex_to_int(segmented_data[0]::string)::integer as chain_id,
    ETHEREUM.PUBLIC.udf_hex_to_int(segmented_data[1]::string)::integer as dstPoolId,
    CONCAT('0x', SUBSTR(segmented_data[2]::string, 27, 40)) as from_address,
    ETHEREUM.PUBLIC.udf_hex_to_int(segmented_data[3]::string)::integer/pow(10,6) as amount_SD,
    ETHEREUM.PUBLIC.udf_hex_to_int(segmented_data[4]::string)::integer as eq_Reward,
    ETHEREUM.PUBLIC.udf_hex_to_int(segmented_data[5]::string)::integer as eq_fee,
    ETHEREUM.PUBLIC.udf_hex_to_int(segmented_data[6]::string)::integer as protocol_fee,
    ETHEREUM.PUBLIC.udf_hex_to_int(segmented_data[7]::string)::integer as lp_fee
    from BSC.CORE.FACT_EVENT_LOGS a
    where topics[0]::string = '0x34660fc8af304464529f48a778e03d03e4d34bcd5f9b6f0cfbf3cd238c642f7f' and origin_to_address = '0x7a4af156379f512de147ed3b96393047226d923f' and
    block_timestamp::date > '2022-07-15' and event_name is null

    Run a query to Download Data