Rayyyk0x Trader CRM
    Updated 9 days ago
    with table_1 as (select block_timestamp::date as date,
    tx_hash,
    origin_from_address,
    'Ethereum' as chain,
    contract_address,
    amount,
    amount_usd
    from ethereum.core.ez_token_transfers
    where from_address in (lower('0x22F9dCF4647084d6C31b2765F6910cd85C178C18'),
    lower('0x70bf6634eE8Cb27D04478f184b9b8BB13E5f4710'),
    lower('0x0d0E364aa7852291883C162B22D6D81f6355428F'),
    lower('0x5418226aF9C8d5D287A78FbBbCD337b86ec07D61'))
    and to_address = lower('0x90A48D5CF7343B08dA12E067680B4C6dbfE551Be') --ShapeShift
    and block_timestamp >= '2023-05-01'
    union
    select block_timestamp::date as date,
    tx_hash,
    origin_from_address,
    'Ethereum' as chain,
    '0x0000000000000000000000000000000000000000',
    amount,
    amount_usd
    from ethereum.core.ez_native_transfers
    where from_address in (lower('0x22F9dCF4647084d6C31b2765F6910cd85C178C18'),
    lower('0x70bf6634eE8Cb27D04478f184b9b8BB13E5f4710'),
    lower('0x0d0E364aa7852291883C162B22D6D81f6355428F'),
    lower('0x5418226aF9C8d5D287A78FbBbCD337b86ec07D61'))
    and to_address = lower('0x90A48D5CF7343B08dA12E067680B4C6dbfE551Be') --ShapeShift
    and block_timestamp >= '2023-05-01'

    union

    select block_timestamp::date as date,
    tx_hash,
    origin_from_address,
    'Polygon' as chain,
    Last run: 9 days ago
    Address
    First Swap
    Last Swap
    Total TX
    Total Rev Generated
    Average Fee USD
    Lowest Fee
    Highest Fee
    COUNT
    TOTAL_NEW_WALLETS
    1
    0x6dbfbdf0d484b9e4df61034f1feb9a3e17adb85a2025-05-18 00:00:00.0002025-05-18 00:00:00.000312.254.0833333330.069.9129
    2
    0x73434e57edc600fb07efa683a87be4888e795cf82025-01-02 00:00:00.0002025-01-13 00:00:00.000396.0332.0066666675.2671.2129
    3
    0xd3fa0201fae12c6bfb89d7de47423da852db39872025-02-06 00:00:00.0002025-02-23 00:00:00.0003114.6338.20666666723.5466.49129
    4
    0xbbfefb09727136a6c3ddd28bd4abdf259b9351c12025-05-17 00:00:00.0002025-06-16 00:00:00.0002293.37146.68100.4192.96129
    5
    0xf3e774bed2f95305a7de31acfbef532beb211c9f2025-05-20 00:00:00.0002025-06-15 00:00:00.00024.242.1152.052.18129
    6
    0x79e0ce242b15b42e89244184b81f986388b0e2c82025-01-03 00:00:00.0002025-03-09 00:00:00.000211.575.7854.816.76129
    7
    0xd54f6558e6def83e4383fa7981bc3a110797204e2025-05-29 00:00:00.0002025-05-29 00:00:00.00020.030.010.010.01129
    8
    0xaf491cbf1f12d4b25658e0480abded2952c39c172025-01-30 00:00:00.0002025-01-30 00:00:00.00019.639.639.639.63129
    9
    0xca5e9b660665846c1aed199170461783e3a6826a2025-03-05 00:00:00.0002025-03-05 00:00:00.000178.2378.2378.2378.23129
    10
    0xf7a8462b057424809a95e3013b1dc2bb0a8238312025-04-02 00:00:00.0002025-04-02 00:00:00.0001123.88123.88123.88123.88129
    11
    0xe52dd18c276892c1f74c7de8a6489dc54636c9ba2025-06-18 00:00:00.0002025-06-18 00:00:00.00010.060.060.060.06129
    12
    0xb60835fdfd7b7f8e5c7cdd4b74fd9559f2bfd93c2025-02-28 00:00:00.0002025-02-28 00:00:00.0001227.61227.61227.61227.61129
    13
    0xf8e2e1f3b8497ccf11e17b0f3fc0612dd3fb893d2025-02-05 00:00:00.0002025-02-05 00:00:00.00016.636.636.636.63129
    14
    0x3967241200f90cd11a9f6afa88dfda6f903b0fa22025-01-06 00:00:00.0002025-01-06 00:00:00.0001561.3561.3561.3561.3129
    15
    0x2e97513ae6175ae06f971151f823ee4142691de32025-01-24 00:00:00.0002025-01-24 00:00:00.000196.1696.1696.1696.16129
    16
    0x20ec33f4da885d0c1175665cb9c047ba0762c6982025-01-21 00:00:00.0002025-01-21 00:00:00.00016.896.896.896.89129
    17
    0xdb7e172f4b5ffb04fa5e9fecc4b8dae0833403612025-04-17 00:00:00.0002025-04-17 00:00:00.000116.8716.8716.8716.87129
    18
    0xdb722be97564040da72c5f2f0e4d7aac6534dd132025-01-24 00:00:00.0002025-01-24 00:00:00.0001313.22313.22313.22313.22129
    19
    0x394521a5809170ee794741c3cf16527376ae34b02025-01-31 00:00:00.0002025-01-31 00:00:00.000197.8597.8597.8597.85129
    20
    0xc3528a632473aab90256f8d77e8bcfdaadd631642025-02-26 00:00:00.0002025-02-26 00:00:00.000127.4127.4127.4127.41129
    29
    4KB
    89s