flipside

    Fee Test
    hbd1994Fee Test
    Updated 2025-03-08
    with base as (
    select
    BLOCK_TIMESTAMP,
    TX_HASH,
    topic_1,
    event_name
    from base.core.ez_decoded_event_logs
    where TOPICS[0] = '0x6eb224fb001ed210e379b335e35efe88672a8ce935d981a6896b27ffdf52a3b2'
    and TX_STATUS = 'SUCCESS'
    and CONTRACT_ADDRESS = '0xbebdb6c8ddc678ffa9f8748f85c815c556dd8ac6'
    and length(DATA) = 834
    and tx_hash not in (select distinct tx_hash from base.core.fact_event_logs where contract_address = '0x1682ae6375c4e4a97e4b583bc394c861a46d8962' and topics[0] = '0x2fa9ca894982930190727e75500a97d8dc500233a5065e0f3126c48fbe0343c0')
    and BLOCK_TIMESTAMP >= current_date - 30
    --and tx_hash not in (select distinct tx_hash from base.core.fact_event_logs where contract_address = lower('0x3C5C5436BCa59042cBC835276E51428781366d85') and topics[0] = '0x1b7379b49b96ce33cfd9daf95718231650c40a2c92da579412e5886011867727')
    ),

    transfers as (
    select distinct
    tx_hash, block_timestamp, ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, FROM_ADDRESS, TO_ADDRESS,
    ORIGIN_FUNCTION_SIGNATURE, SYMBOL, AMOUNT, AMOUNT_USD, CONTRACT_ADDRESS, RAW_AMOUNT, EVENT_INDEX as index
    from base.core.ez_token_transfers
    where ORIGIN_FROM_ADDRESS = FROM_ADDRESS
    and BLOCK_TIMESTAMP >= current_date - 30

    union all

    select distinct
    tx_hash, block_timestamp, ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, FROM_ADDRESS, TO_ADDRESS,
    ORIGIN_FUNCTION_SIGNATURE, 'ETH' as SYMBOL, AMOUNT, AMOUNT_USD, '0x0000000000000000000000000000000000000000' as CONTRACT_ADDRESS, AMOUNT_PRECISE_RAW, TRACE_INDEX
    from base.core.ez_native_transfers
    where ORIGIN_FROM_ADDRESS = FROM_ADDRESS
    and BLOCK_TIMESTAMP >= current_date - 30
    )

    select event_name, b.*,topic_1
    from base a
    Last run: 3 months ago
    EVENT_NAME
    TX_HASH
    BLOCK_TIMESTAMP
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    FROM_ADDRESS
    TO_ADDRESS
    ORIGIN_FUNCTION_SIGNATURE
    SYMBOL
    AMOUNT
    AMOUNT_USD
    CONTRACT_ADDRESS
    RAW_AMOUNT
    INDEX
    TOPIC_1
    1
    		LogMessagePublished0x0099e29943084f47cd5ba0081d7c1f9211d24cbd89ecbafb39fa5c48dc1cfdbf2025-02-27 21:29:55.0000x2feca9dbae4beee9c40ab2fabc5fbbff52cc13b60xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x2feca9dbae4beee9c40ab2fabc5fbbff52cc13b60xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654SUI10.363057330x36c6fbf7b49bf65f5f82b674af219c05b2a4add1103630573301910x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    2
    		LogMessagePublished0x044fc6b23238819447cba01155ef01427280995c4f14cdaed888ad89ddebce182025-02-21 22:15:15.0000x3cc869d5dd245545194d481c8c51cee0254387150xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x3cc869d5dd245545194d481c8c51cee0254387150xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654SOL32.987606345498.3742247510x1c61629598e4a901136a81bc138e5828dc150d6732987606340760x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    3
    		LogMessagePublished0x0618f99f3cc389918761f5d439899efcae252a5652ea9c8218162e91c8b62e722025-02-22 09:03:39.0000x016917328756b5fad46e8d54b17c229d2f85bd010xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x016917328756b5fad46e8d54b17c229d2f85bd010xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654SUI1.863057330x36c6fbf7b49bf65f5f82b674af219c05b2a4add118630573302270x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    4
    		LogMessagePublished0x06da61251b766e64b5d9d99c530e842a40e3123bc8bb0074a49b7b2a1b721e582025-03-03 01:51:25.0000x4226cab421ef7419a71f16f7816d67289c02ca6d0xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x4226cab421ef7419a71f16f7816d67289c02ca6d0xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654USDC97.1554880xe8ce40ebbb844142400d21558a2f1c9683d69139971554881510x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    5
    		LogMessagePublished0x082e37de08f5ee5d2bc879c0574d2ae3c666549eef40f3234bba49e1e7891dd92025-02-14 13:54:17.0000x67a56f90d14c016c19f82c89d0ecb79d9de8a4250xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x67a56f90d14c016c19f82c89d0ecb79d9de8a4250xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654WETH0.0012.686560x420000000000000000000000000000000000000610000000000000002200x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    6
    		LogMessagePublished0x0c224d22385ae23d1c8e5a190e68ecafee16d4a1c4d1dd7e3e355c66599d1db32025-02-11 16:03:33.0000x457c711437e730bf9ab95a2aaa907b679f9844480xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x457c711437e730bf9ab95a2aaa907b679f9844480xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654SUI20x36c6fbf7b49bf65f5f82b674af219c05b2a4add120000000004590x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    7
    		LogMessagePublished0x0cbd32261209955f0a92af795183bd24fbfc2f6fba907e9802dbfd6aeda4dcab2025-03-02 08:02:15.0000x6e874b85468d33eee94ebc9297d20e7111c54bef0xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x6e874b85468d33eee94ebc9297d20e7111c54bef0xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654WBTC0.003116710xe6396f780b543df16ee3b784d789c75b68319db03116712250x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    8
    		LogMessagePublished0x0ef71ea5474334ad89e8ec7970275da0f70eabf6f177a101b099465dcb01effe2025-03-04 15:05:25.0000xabe98fac1bea325e8742fe79b854f044309231ff0x0654874eb7f59c6f5b39931fc45dc45337c967c30xabe98fac1bea325e8742fe79b854f044309231ff0x0654874eb7f59c6f5b39931fc45dc45337c967c30xe4269fc4SPX16263.661918857111.4162833130x50da645f148798f68ef2d7db7c1cb22a6819bb2c16263661918853040x00000000000000000000000011aa521c888d84f374b63823d9b873caa3591f55
    9
    		LogMessagePublished0x13a828c31289602c6e6bde2568a0f69f7b088aa28de9a10b8bd2aefdc58b55112025-02-16 04:54:27.0000xa651b9c25ce2359c159846740796c61c5ae0edce0xae8dc4a7438801ec4edc0b035eccccf3807f4cc10xa651b9c25ce2359c159846740796c61c5ae0edce0xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654WBTC0.006681470xe6396f780b543df16ee3b784d789c75b68319db0668147890x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    10
    		LogMessagePublished0x13e8f6421c486e0ae32a51d6c6c1c0fcecdd4fb81184f3fc73fb88feb107ad6e2025-02-17 05:07:31.0000xc8de58be5af630ff42365c3f38d41c3faa97900b0xae8dc4a7438801ec4edc0b035eccccf3807f4cc10xc8de58be5af630ff42365c3f38d41c3faa97900b0xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654USDC999.950xe8ce40ebbb844142400d21558a2f1c9683d691399999500001930x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    11
    		LogMessagePublished0x167dab9e78e969e629424330039ff8e0f5c0a5c7361257221ae8b8e39c9103782025-02-27 16:30:59.0000x0cc93b25f86549e5a938bfa6894df755da52b3900xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x0cc93b25f86549e5a938bfa6894df755da52b3900xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654SOL0.0010.13810x1c61629598e4a901136a81bc138e5828dc150d671000000970x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    12
    		LogMessagePublished0x179c255069b593d0e358526caf7d3e40c6b9e63d7562167488663f3063149b142025-02-16 09:08:43.0000x5e1b2f58beb79c35704055228f5e89cecaceae280xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x5e1b2f58beb79c35704055228f5e89cecaceae280xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654SOL5.02993208976.0583201240x1c61629598e4a901136a81bc138e5828dc150d6750299320801950x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    13
    		LogMessagePublished0x19f8af75de8c311a54924a2896a289e1215a05c74042eff335cafe356bd97e832025-02-24 00:28:49.0000xdbb04b67b5f7d2828db0321f594515321ab1b9c50xae8dc4a7438801ec4edc0b035eccccf3807f4cc10xdbb04b67b5f7d2828db0321f594515321ab1b9c50xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654USDC229.1441290xe8ce40ebbb844142400d21558a2f1c9683d691392291441291570x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    14
    		LogMessagePublished0x1c01f6f59f67a0c72b58734e7907436cf50951f4c4f00256f8814ce402dccde92025-02-08 19:29:25.0000x3cc869d5dd245545194d481c8c51cee0254387150xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x3cc869d5dd245545194d481c8c51cee0254387150xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654SOL173336.760x1c61629598e4a901136a81bc138e5828dc150d67170000000001620x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    15
    		LogMessagePublished0x209a476957372401155fe9ac4a3dbee465585370ab64cb0483a1f5231409d0992025-02-18 23:26:07.0000xeb5204b26c0e78f4f05ff2cc04fdde17022b6b8c0x706f82e9bb5b0813501714ab5974216704980e310xeb5204b26c0e78f4f05ff2cc04fdde17022b6b8c0x706f82e9bb5b0813501714ab5974216704980e310x8b0301b1ETH0.0000097349495050.030x0000000000000000000000000000000000000000973494950527100x000000000000000000000000706f82e9bb5b0813501714ab5974216704980e31
    16
    		LogMessagePublished0x241c7028446a81381aa53548d6442d21c013d8f97f7a80441d278822d3b532282025-02-27 02:43:01.0000x92deacc4210a95fb258bfd2c1454aabae1e701670x0654874eb7f59c6f5b39931fc45dc45337c967c30x92deacc4210a95fb258bfd2c1454aabae1e701670x0654874eb7f59c6f5b39931fc45dc45337c967c30xe4269fc4SPX2453.545614571506.1310574140x50da645f148798f68ef2d7db7c1cb22a6819bb2c2453545614577200x00000000000000000000000011aa521c888d84f374b63823d9b873caa3591f55
    17
    		LogMessagePublished0x259efcddaf3755faf5b0270ab9cc3d21ee6ca4a0488d9d45d222af5b0fd725b52025-02-17 09:22:59.0000x955fde3414bff8b0838a307e97fa551a1a1b32c50xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x955fde3414bff8b0838a307e97fa551a1a1b32c50xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654WETH0.13869498371.8010198360x42000000000000000000000000000000000000061386949800000000001680x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    18
    		LogMessagePublished0x277d1f057290925b25317f13698b6552f4b202b71fdfed3603f25fb30046f4cd2025-02-06 17:15:15.0000x15dddf7c741bb7283e3df3bcca0060c1c21180590xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x15dddf7c741bb7283e3df3bcca0060c1c21180590xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654WBTC0.103934860xe6396f780b543df16ee3b784d789c75b68319db0103934863630x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    19
    		LogMessagePublished0x29ab4146ed061f67af0ed2023e7dff241c4ef53ecb622daf674b829b053465a22025-02-21 18:04:31.0000x26ad5eaf8e39140da40d2d22a9e036fb568edcf80xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x26ad5eaf8e39140da40d2d22a9e036fb568edcf80xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654SOL177.5571215330974.8398509080x1c61629598e4a901136a81bc138e5828dc150d671775571215304780x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    20
    		LogMessagePublished0x29d905e922f5d88df9df046cad8f82a9d33de7dce53b3adf5c1097c23cd108ff2025-02-28 04:32:03.0000x4c77173c87caaeaafa1089b99f3483c82278279a0xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x4c77173c87caaeaafa1089b99f3483c82278279a0xae8dc4a7438801ec4edc0b035eccccf3807f4cc10x1019d654USDT501.570710xff0c62a4979400841efaa6faadb07ac7d5c98b275015707102150x0000000000000000000000008d2de8d2f73f1f4cab472ac9a881c9b123c79627
    ...
    146
    67KB
    42s