RayyykShapeShift CowSwap Rev
    Updated 16 hours ago
    with table_1 as (select block_timestamp,
    'Ethereum' as chain,
    amount_usd
    from ethereum.core.ez_token_transfers
    where from_address = lower('0xA03be496e67Ec29bC62F01a428683D7F9c204930') --CowSwap
    and to_address = lower('0x90A48D5CF7343B08dA12E067680B4C6dbfE551Be') --ShapeShift
    and block_timestamp >= '2024-04-01'
    union
    select block_timestamp,
    'Ethereum' as chain,
    amount_usd
    from ethereum.core.ez_native_transfers
    where from_address = lower('0xA03be496e67Ec29bC62F01a428683D7F9c204930') --CowSwap
    and to_address = lower('0x90A48D5CF7343B08dA12E067680B4C6dbfE551Be') --ShapeShift
    and block_timestamp >= '2024-04-01'

    union

    select block_timestamp,
    'Arbitrum' as chain,
    amount_usd
    from arbitrum.core.ez_token_transfers
    where from_address = lower('0x66331f0b9cb30d38779c786Bda5a3d57d12fbA50') --CowSwap
    and to_address = lower('0x38276553F8fbf2A027D901F8be45f00373d8Dd48') --ShapeShift
    and block_timestamp >= '2024-12-01'
    union
    select block_timestamp,
    'Arbitrum' as chain,
    amount_usd
    from arbitrum.core.ez_native_transfers
    where from_address = lower('0x66331f0b9cb30d38779c786Bda5a3d57d12fbA50') --CowSwap
    and to_address = lower('0x38276553F8fbf2A027D901F8be45f00373d8Dd48') --ShapeShift
    and block_timestamp >= '2024-12-01'

    union

    Last run: about 16 hours agoAuto-refreshes every 24 hours
    DATE
    CHAIN
    Total
    START_DATE
    END_DATE
    1
    2025-03-01 00:00:00.000Arbitrum94.9201/01/20232025-04-25 00:00:00.000
    2
    2024-12-01 00:00:00.000Arbitrum203.9301/01/20232025-04-25 00:00:00.000
    3
    2024-04-01 00:00:00.000Ethereum454.7601/01/20232025-04-25 00:00:00.000
    4
    2024-09-01 00:00:00.000Ethereum352.7901/01/20232025-04-25 00:00:00.000
    5
    2024-12-01 00:00:00.000Ethereum4552.0501/01/20232025-04-25 00:00:00.000
    6
    2024-06-01 00:00:00.000Ethereum1600.0601/01/20232025-04-25 00:00:00.000
    7
    2024-12-01 00:00:00.000Base7.9301/01/20232025-04-25 00:00:00.000
    8
    2025-02-01 00:00:00.000Ethereum999.6101/01/20232025-04-25 00:00:00.000
    9
    2024-07-01 00:00:00.000Ethereum2015.2501/01/20232025-04-25 00:00:00.000
    10
    2024-08-01 00:00:00.000Ethereum773.3501/01/20232025-04-25 00:00:00.000
    11
    2024-05-01 00:00:00.000Ethereum946.3701/01/20232025-04-25 00:00:00.000
    12
    2025-03-01 00:00:00.000Ethereum3530.5501/01/20232025-04-25 00:00:00.000
    13
    2025-01-01 00:00:00.000Ethereum1857.5301/01/20232025-04-25 00:00:00.000
    14
    2024-11-01 00:00:00.000Base9.5401/01/20232025-04-25 00:00:00.000
    15
    2025-01-01 00:00:00.000Base01/01/20232025-04-25 00:00:00.000
    16
    2025-04-01 00:00:00.000Ethereum1683.1901/01/20232025-04-25 00:00:00.000
    17
    2024-11-01 00:00:00.000Ethereum6195.5101/01/20232025-04-25 00:00:00.000
    18
    2025-02-01 00:00:00.000Arbitrum127.2901/01/20232025-04-25 00:00:00.000
    19
    2024-10-01 00:00:00.000Ethereum1984.3301/01/20232025-04-25 00:00:00.000
    20
    2025-01-01 00:00:00.000Arbitrum75.7301/01/20232025-04-25 00:00:00.000
    20
    2KB
    13s