RayyykVultisig 1inch (Swapper)
    Updated 1 day ago
    with table_1 as (select block_timestamp,
    'Ethereum' as chain,
    tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_token_transfers
    where from_address in (lower('0xE37e799D5077682FA0a244D46E5649F71457BD09'),
    lower('0x3451B6b219478037a1AC572706627FC2BDa1e812'),
    lower('0x5141B82f5fFDa4c6fE1E372978F1C5427640a190'))
    and to_address = '0xa4a4f610e89488eb4ecc6c63069f241a54485269' --Vultisig
    and block_timestamp >= '2024-04-01'
    union
    select block_timestamp,
    'Ethereum' as chain,
    tx_hash,
    origin_from_address,
    amount_usd
    from ethereum.core.ez_native_transfers
    where from_address in (lower('0xE37e799D5077682FA0a244D46E5649F71457BD09'),
    lower('0x3451B6b219478037a1AC572706627FC2BDa1e812'),
    lower('0x5141B82f5fFDa4c6fE1E372978F1C5427640a190'))
    and to_address = '0xa4a4f610e89488eb4ecc6c63069f241a54485269'
    and block_timestamp >= '2024-04-01'

    union

    select block_timestamp,
    'Optimism' as chain,
    tx_hash,
    origin_from_address,
    amount_usd
    from optimism.core.ez_token_transfers
    where from_address = lower('0xB63AaE6C353636d66Df13b89Ba4425cfE13d10bA')
    and to_address = '0xa4a4f610e89488eb4ecc6c63069f241a54485269'
    and block_timestamp >= '2024-10-01'
    union
    Last run: 1 day ago
    DATE
    CHAIN
    USD_VOLUME
    USD_FEE
    SWAPPER_COUNT
    TX_COUNT
    START_DATE
    END_DATE
    1
    2025-04-01 00:00:00.000Ethereum40165.294044831200.8338202247901/01/20242025-04-25 00:00:00.000
    2
    2025-03-01 00:00:00.000Arbitrum9394.1546.972301/01/20242025-04-25 00:00:00.000
    3
    2025-03-01 00:00:00.000BSC1023.625.11811101/01/20242025-04-25 00:00:00.000
    4
    2025-03-01 00:00:00.000Ethereum26746.528136217133.7387406815901/01/20242025-04-25 00:00:00.000
    5
    2025-02-01 00:00:00.000Arbitrum7769.193076838.8443653842501/01/20242025-04-25 00:00:00.000
    6
    2025-02-01 00:00:00.000Avalanche4156.0420.78021301/01/20242025-04-25 00:00:00.000
    7
    2025-02-01 00:00:00.000BSC376.041.8762201/01/20242025-04-25 00:00:00.000
    8
    2025-02-01 00:00:00.000Base1120.345.62301/01/20242025-04-25 00:00:00.000
    9
    2025-02-01 00:00:00.000Ethereum191434.22582482957.17172912471001/01/20242025-04-25 00:00:00.000
    10
    2025-01-01 00:00:00.000Avalanche1604.3226308728.0216131541101/01/20242025-04-25 00:00:00.000
    11
    2025-01-01 00:00:00.000BSC2720.69526526713.6034763261101/01/20242025-04-25 00:00:00.000
    12
    2025-01-01 00:00:00.000Base1225.556.124401/01/20242025-04-25 00:00:00.000
    13
    2025-01-01 00:00:00.000Ethereum130701.11983144653.5090991578901/01/20242025-04-25 00:00:00.000
    14
    2024-12-01 00:00:00.000BSC32201.824330617161.01697165322901/01/20242025-04-25 00:00:00.000
    15
    2024-12-01 00:00:00.000Ethereum10020.78784733450.1020891123501/01/20242025-04-25 00:00:00.000
    16
    2024-11-01 00:00:00.000BSC76961.37842371384.81084211924301/01/20242025-04-25 00:00:00.000
    17
    2024-11-01 00:00:00.000Ethereum43691.444845218.45072422561201/01/20242025-04-25 00:00:00.000
    18
    2024-11-01 00:00:00.000Optimism10022.4664379350.1074583311201/01/20242025-04-25 00:00:00.000
    19
    2024-10-01 00:00:00.000BSC10605.50809853.027540492201/01/20242025-04-25 00:00:00.000
    20
    2024-10-01 00:00:00.000Ethereum11606.52127387458.0283563694701/01/20242025-04-25 00:00:00.000
    25
    3KB
    414s