jp12Crypto-Unicorns RBW Usage
    Updated 2023-04-28
    WITH raw as (
    SELECT block_timestamp, tx_hash, 'Breeding' as activity, contract_address,
    IFF(contract_address = '0x431cd3c9ac9fc73644bf68bf5691f4b83f9e104f', 'RBW', 'UNIM') as token,
    RAW_AMOUNT / 1e18 as amount
    FROM polygon.core.fact_token_transfers
    WHERE 1=1
    AND ORIGIN_FUNCTION_SIGNATURE = '0xd2df3a9e'
    and TO_ADDRESS = '0x94f557dddb245b11d031f57ba7f2c4f28c4a203e'
    UNION
    SELECT block_timestamp, tx_hash, 'Evolution' as activity, contract_address,
    IFF(contract_address = '0x431cd3c9ac9fc73644bf68bf5691f4b83f9e104f', 'RBW', 'UNIM') as token,
    RAW_AMOUNT / 1e18 as amount
    FROM polygon.core.fact_token_transfers
    WHERE 1=1
    AND ORIGIN_FUNCTION_SIGNATURE = '0x65b4613f'
    and TO_ADDRESS = '0x94f557dddb245b11d031f57ba7f2c4f28c4a203e'

    UNION
    SELECT block_timestamp, tx_hash, 'Transfer To Game' as activity, contract_address,
    IFF(contract_address = '0x431cd3c9ac9fc73644bf68bf5691f4b83f9e104f', 'RBW', 'UNIM') as token,
    RAW_AMOUNT / 1e18 as amount
    FROM polygon.core.fact_token_transfers
    WHERE 1=1
    AND ORIGIN_FUNCTION_SIGNATURE = '0x51782474'
    and TO_ADDRESS = '0x94f557dddb245b11d031f57ba7f2c4f28c4a203e'

    UNION

    SELECT block_timestamp, tx_hash, 'Transfer From Game' as activity, contract_address,
    IFF(contract_address = '0x431cd3c9ac9fc73644bf68bf5691f4b83f9e104f', 'RBW', 'UNIM') as token,
    RAW_AMOUNT / 1e18 as amount
    FROM polygon.core.fact_token_transfers
    WHERE 1=1
    AND ORIGIN_FUNCTION_SIGNATURE = '0xdd7944f5'
    Run a query to Download Data