adriaparcerisasPunchswap swaps by asset
    Updated 4 days ago
    with
    swaps as (
    select x.tx_hash, x.origin_from_address, x.contract_address, y.tx_fee, x.block_timestamp
    from flow.core_evm.fact_event_logs x
    join flow.core_evm.fact_transactions y
    on x.tx_hash=y.tx_hash
    where --(lower(y.to_address)=lower('0xf45AFe28fd5519d5f8C1d4787a4D5f724C0eFa4d') or x.origin_function_signature='0x7ff36ab5')
    x.origin_function_signature in ('0x7ff36ab5','0x38ed1739','0x18cbafe5','0x79a3cf08','0xecae08fc')
    and x.tx_succeeded='TRUE'
    AND LOWER(x.contract_address) IN (
    '0x1b97100ea1d7126c4d60027e231ea4cb25314bdb',
    '0x7f27352d5f83db87a5a3e00f4b07cc2138d8ee52',
    '0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e',
    '0x5598c0652b899eb40f169dd5949bdbe0bf36ffde',
    '0x9c7efd8ecd7c5e8b51a3833f6fb67c6e2f4f4a9b',
    '0x68eb683a393c8a1c816255b4fc4b89d73c52ad4b',
    '0xd8ad8ae8375aa31bff541e17dc4b4917014ebdaa',
    '0x995258cea49c25595cd94407fad9e99b81406a84',
    '0xec0f7e75128781c2924ad907a379909ae531d050',
    '0x6a2cd141d75864944318acf272443febc54855a9',
    '0x4dcd1b9a5103fa5f13cc4c3b758e05ffaccb4dd',
    '0x169bb04590fbf18b09739f951274aa5650dfccde',
    '0xd59d7c7f4d063a707a021c7c49c5cfb4faf94cb0',
    '0x40b0f603fd1165db32af769771428be100f8434e',
    '0x8b2f3a6e7ad5f971ff5d4e597a4ebc58b2d2758e',
    '0xd3378b419feae4e3a4bb4f3349dba43a1b511760',
    '0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed',
    '0xf1815bd50389c46847f0bda824ec8da914045d14',
    '0x3a33c904c132822ce01948ce318c15988727d1db',
    '0x7296ebca325e835eb6c1b690484cf6fb4c396d2c',
    '0x6a64e027e3f6a94acbdcf39cf0cbb4bead5f5ecb', --0x6A64E027E3F6A94AcBDCf39CF0cBb4BeaD5f5ecb
    '0xe8b7423b80f9af33480d365171c7ceda3586aa35',
    '0xf45cbe30bd953590c9917799142edb05be3f293f',
    '0x8bd75008361517df04aa3ea033f03ba33c0c0a66',
    '0x9b565507858812e8b5ffbfbde9b200a3bc2e8f76',
    '0x10448481630fb6d20b597e5b3d7e42dcb1247c8a',
    Last run: 4 days ago
    DATE
    ASSET
    ACTIVE_SWAPPERS
    NEW_SWAPPERS
    TOTAL_SWAPPERS
    SWAPS
    TOTAL_SWAPS
    FLOW_FEES
    AVG_TX_FLOW_FEE
    1
    2025-05-19 00:00:00.000TRUMP2015112133890.000076083480980.000006340290081
    2
    2025-05-19 00:00:00.000BETA10330125951.17172e-131.17172e-13
    3
    2025-05-19 00:00:00.000USDF110513172420660.0018994259280.000009497129639
    4
    2025-05-19 00:00:00.000USDC.e41115826545884.798123e-121.654525172e-13
    5
    2025-05-19 00:00:00.000Purrzival1153617729.67536e-133.22512e-13
    6
    2025-05-19 00:00:00.000Pawderick1155718199.67488e-133.22496e-13
    7
    2025-05-19 00:00:00.000HotCocoa1048511952850.000084207245575.134588144e-7
    8
    2025-05-19 00:00:00.000Bartholomeow2154328211.95267e-123.25445e-13
    9
    2025-05-19 00:00:00.000Gwendolion1152818039.67536e-133.22512e-13
    10
    2025-05-19 00:00:00.000GangGang5323353568.177934e-123.028864444e-13
    11
    2025-05-19 00:00:00.000wFLOW42434012811216760.012782167220.000006110022574
    12
    2025-05-19 00:00:00.000Catseye1154718159.67509e-133.22503e-13
    13
    2025-05-18 00:00:00.000Pawderick3355638188.734707e-123.235076667e-13
    14
    2025-05-18 00:00:00.000USDF131513427418940.0047917471220.000009602699643
    15
    2025-05-18 00:00:00.000wFLOW61633977701213950.048413527340.000005615115674
    16
    2025-05-18 00:00:00.000HotCocoa1358473652660.00036819092458.872070471e-7
    17
    2025-05-18 00:00:00.000Purrzival2253527713.879402e-123.232835e-13
    18
    2025-05-18 00:00:00.000TRUMP3115170133770.0013973130610.00001204580225
    19
    2025-05-18 00:00:00.000PEPE115013535.21214e-131.73738e-13
    20
    2025-05-18 00:00:00.000TSR1111213305.21166e-131.73722e-13
    ...
    1965
    145KB
    4s