cypherAvalanche Flash Bounty - Swaps vs Transfers
    Updated 2022-06-24
    select *
    -- tokenflow_eth.hextoint(substr(input,3,64)) as background,
    -- tokenflow_eth.hextoint(substr(data,67,64)) as body,
    -- tokenflow_eth.hextoint(substr(data,131,64)) as accessory,
    -- tokenflow_eth.hextoint(substr(data,195,64)) as head,
    from avalanche.core.fact_transactions
    -- where block_timestamp >= '2022-6-20'
    -- and contract_address = lower('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e')
    -- and event_name = 'Transfer'
    where block_number = 16420246
    and tx_hash = '0xa5a602e8a9624ab7487c0c89b3cd5446958e9b2e677eb5a776914a2e5bed898a'

    limit 100
    Run a query to Download Data