datasovrunknown-ivory
    Updated 2024-10-01
    select
    block_timestamp,
    tx_hash,
    'ethereum' as chain,
    event_index,
    contract_address,
    from_address,
    to_address,
    amount_precise,
    amount_usd,
    symbol,
    token_price,
    origin_function_signature,
    case
    origin_function_signature
    when '0xa9059cbb' then 'transfer'
    when '0x6a761202' then 'transfer'
    when '0x00aeef8a' then 'deposit'
    when '0xf104489f' then 'deposit'
    when '0xd0e30db0' then 'deposit'
    when '0x1e83409a' then 'claim'
    when '0x427a0a17' then 'withdraw'
    when '0x2e1a7d4d' then 'withdraw'
    when '0x3593564c' then 'swap'
    when '0x78e111f6' then 'swap'
    when '0xbc4a02e4' then 'swap'
    when '0x5ae401dc' then 'swap'
    when '0x9db4f7aa' then 'swap'
    when '0x06bb5402' then 'swap'
    when '0x13d79a0b' then 'swap'
    when '0x0965d04b' then 'swap'
    when '0x03020316' then 'swap'
    when '0xa8b82ac1' then 'swap'
    when '0x59bdf46f' then 'swap'
    when '0x62e238bb' then 'swap'
    when '0xd0f2d8ac' then 'swap'
    QueryRunArchived: QueryRun has been archived