flipside

    Summary of actions on MemeBase (Base)
    Flipside TeamSummary of actions on MemeBase (Base)
    Updated 8 days ago
    with tb1 as (select
    'Base' as blockchain,
    'Memebase' as PROGRAM_NAME,
    'ServiceStaked' as Action,
    BLOCK_TIMESTAMP,
    tx_hash,
    contract_address,
    concat('0x',substring(topics[3], 26+1, 40)) AS multisig,
    concat('0x',substring(topics[2], 26+1, 40)) AS owner,
    ethereum.public.udf_hex_to_int(TOPICS[1])::float as serviceId
    from base.core.fact_event_logs
    where (CONTRACT_ADDRESS = lower('0xc653622fd75026a020995a1d8c8651316cbbc4da')
    OR contract_address = lower('0x6011e09e7c095e76980b22498d69df18eb62bed8')
    OR contract_address = lower('0xfb7669c3adf673b3a545fa5acd987dbfda805e22')
    OR contract_address = lower('0xca61633b03c54f64b6a7f1f9a9c0a6feb231cc4d')
    )
    and TOPICS[0] = '0xaa6b005b4958114a0c90492461c24af6525ae0178db7fbf44125ae9217c69ccb'
    ),

    tb2 as (select
    'Base' as blockchain,
    'Memebase' as PROGRAM_NAME,
    'ServiceUnstaked' as Action,
    BLOCK_TIMESTAMP,
    tx_hash,
    contract_address,
    concat('0x',substring(topics[3], 26+1, 40)) AS multisig,
    concat('0x',substring(topics[2], 26+1, 40)) AS owner,
    ethereum.public.udf_hex_to_int(TOPICS[1])::float as serviceId
    from base.core.fact_event_logs
    where (CONTRACT_ADDRESS = lower('0xc653622fd75026a020995a1d8c8651316cbbc4da')
    OR contract_address = lower('0x6011e09e7c095e76980b22498d69df18eb62bed8')
    OR contract_address = lower('0xfb7669c3adf673b3a545fa5acd987dbfda805e22')
    OR contract_address = lower('0xca61633b03c54f64b6a7f1f9a9c0a6feb231cc4d')
    )
    and TOPICS[0] = '0x6d789d063e079a4c156e77a20008529fc448dca2cd7e5e7a20abf969fffb9226'
    Last run: 8 days ago
    BLOCKCHAIN
    PROGRAM_NAME
    ACTION
    BLOCK_TIMESTAMP
    TX_HASH
    CONTRACT_ADDRESS
    MULTISIG
    OWNER
    SERVICEID
    1
    		BaseMemebaseServiceStaked2025-03-07 15:54:57.0000x93e53462f9c0c0a122df1e1ba5f72c7962e88f063f3c38d544b19de7a07c1f7a0x6011e09e7c095e76980b22498d69df18eb62bed80x13fa4b947877c4b67b91aecddcf10d6e24b33ee10x251ff968787f3867afa0b0a3322b398cf472ea7a59
    2
    		BaseMemebaseServiceStaked2024-12-27 11:36:39.0000x5d1ba6c1bdc5d995a8f21afb8a5fdbefa9f625d5b2c09b0d6989d14fba04192c0xc653622fd75026a020995a1d8c8651316cbbc4da0x97e0294db6a3199b56e2db0fa8fff61b38278eb70xa9576978ec0039633ce3574b82e68b735f37450176
    3
    		BaseMemebaseServiceUnstaked2025-01-18 19:10:39.0000x312f3836dfe47394e05d6effe02e17c2ad9fe921676d180ee4abe4f4c3ae43260xc653622fd75026a020995a1d8c8651316cbbc4da0x9dc804f62b48228102a9032e3336c683d113c74f0xc8e112ebb32827e97708289794b1c494bf8ee7d057
    4
    		BaseMemebaseServiceStaked2025-01-23 13:44:45.0000x301a544d83c1b377ca81961777f7afbe8d3f153f3b913599fd17373eb4e4f9600xc653622fd75026a020995a1d8c8651316cbbc4da0xc415967c9f7b7424e9f1dd9b36f1c868e20e68310xcdc2fabedf36aed3b98a6a92ca50149fb67627d385
    5
    		BaseMemebaseServiceStaked2025-03-14 20:14:57.0000x70441465be7e0381abeea38ac1ae8e035fdc06bae27a9bbd6507925c3e0a7ef90xc653622fd75026a020995a1d8c8651316cbbc4da0xfd9d742ff0c4800250221adfca825974373bdb810x59c9a73d1e2b537e3d3b54a2b817dc1b9648b68b108
    6
    		BaseMemebaseServiceUnstaked2025-02-27 23:18:53.0000x73847d6813e6ef155895728a1ce56442c6a0e71d834730e756409decde3176050x6011e09e7c095e76980b22498d69df18eb62bed80x13fa4b947877c4b67b91aecddcf10d6e24b33ee10x251ff968787f3867afa0b0a3322b398cf472ea7a59
    7
    		BaseMemebaseServiceUnstaked2024-12-29 16:25:49.0000xc20651ee0d46d1f93be70f3ffa9cd04a8f9fa003b803920426c2e06dc60225400xc653622fd75026a020995a1d8c8651316cbbc4da0x5931f47bb4e2376df7fb4a24a9141ee52737ce910xa122f63e7145444c8a8b24ce524ad1a26c7d3ad069
    8
    		BaseMemebaseServiceUnstaked2025-02-06 08:01:07.0000xd705c7f47024fcd6afbb33e9ff90903cc205c90c2aeebd24b9848de8e75b164c0xc653622fd75026a020995a1d8c8651316cbbc4da0xcbd7506d33a01abdd03e1c4ef1cdc943c75741b80xb8662544af37f9b7f7c16527d848b0149a81dabd78
    9
    		BaseMemebaseServiceStaked2025-03-27 01:56:19.0000x62bd1d1602709d8d4e53ee69042273490e0c616857282bb0c83486546833085a0xc653622fd75026a020995a1d8c8651316cbbc4da0xe3bf2921fd32f23e04d44ca45b2fa934c33a59180x53a34b5df6d064b4334a036da4f80dc632c41a12113
    10
    		BaseMemebaseServiceUnstaked2025-01-17 08:34:31.0000x75415b707282e6300568e1c44c5eb3199f053c51928e26328d5674ff2c56a4400xc653622fd75026a020995a1d8c8651316cbbc4da0x0c9f27dd5a3871510e403e5de29a4eb1979352230x977b549eaec85280d0b2cb77a215f568b185121e84
    11
    		BaseMemebaseServiceUnstaked2025-02-04 15:39:45.0000xa752289a756c1b21e4104f8de84686282288099b90bf88de53dac98d0fe5c40c0xc653622fd75026a020995a1d8c8651316cbbc4da0x13fa4b947877c4b67b91aecddcf10d6e24b33ee10x251ff968787f3867afa0b0a3322b398cf472ea7a59
    12
    		BaseMemebaseServiceUnstaked2025-01-12 03:55:23.0000x1ecb807518d091c2270b7c73963c37156d6b625a8d2d3d2909d4bcfc7087711b0xc653622fd75026a020995a1d8c8651316cbbc4da0x62033e40382fd018350142996ed2a186484ca4ec0xd5b559ea68d8ee33be42c64cdd410876a4468e3167
    13
    		BaseMemebaseServiceUnstaked2025-01-31 09:26:35.0000xbc717798e4739abb20e8507cb254fa6925523ad4224b1401f56c1c073d1f9b760xc653622fd75026a020995a1d8c8651316cbbc4da0x97e0294db6a3199b56e2db0fa8fff61b38278eb70xa9576978ec0039633ce3574b82e68b735f37450176
    14
    		BaseMemebaseServiceUnstaked2025-03-13 18:24:35.0000x87980b3a4a7865ca8653c62509aa00255ff644bf33236f461c74e41bd71697540xc653622fd75026a020995a1d8c8651316cbbc4da0xcbd7506d33a01abdd03e1c4ef1cdc943c75741b80xb8662544af37f9b7f7c16527d848b0149a81dabd78
    15
    		BaseMemebaseServiceUnstaked2025-01-28 08:30:09.0000x0468943b3febd72ab86a0e40e832d52681f09420fbd406bcfa4458464abcf4010xc653622fd75026a020995a1d8c8651316cbbc4da0xe77bff67100e9838c5ef46ba485d0352a5248e570xf0c897edfb6cc81f8999e2ef7916e86269f5ca8570
    16
    		BaseMemebaseServiceStaked2025-03-07 15:56:57.0000x9d9fc316645aee74097596d3a7e647c98112dcf764931850390a3e1ec9a30a7c0xc653622fd75026a020995a1d8c8651316cbbc4da0x50df2903320951a741920d1ba490d13539df64f00xb3ea7e389a7d217ef303329fb5f8ea97d0e2a0bc102
    17
    		BaseMemebaseServiceUnstaked2025-03-23 15:28:21.0000x9de82bddcbe4cc8f0fa03f9418ef37b33969b1e8f77c1c25d65e63c4327d43580xc653622fd75026a020995a1d8c8651316cbbc4da0xcbd7506d33a01abdd03e1c4ef1cdc943c75741b80xb8662544af37f9b7f7c16527d848b0149a81dabd78
    18
    		BaseMemebaseServiceUnstaked2025-01-06 12:40:27.0000x37bf73fe08dadbe44c3639ea5b09cda05e7a65a09f20965ca893dcf63fb796f50xc653622fd75026a020995a1d8c8651316cbbc4da0xe77bff67100e9838c5ef46ba485d0352a5248e570xf0c897edfb6cc81f8999e2ef7916e86269f5ca8570
    19
    		BaseMemebaseServiceUnstaked2025-01-25 03:46:33.0000xbebe8bd4b5546a4de2654c399b13464bea8fb85463bb7d56ee62aa81385a2aa40xc653622fd75026a020995a1d8c8651316cbbc4da0xd7e2d0f29c28b55165f533554eb6bc00e1ba2b810x680f75cbfa7751b18558d227786dbe246d03e95971
    20
    		BaseMemebaseServiceUnstaked2025-02-13 23:27:29.0000x0f0467f63a1cc0d67784e49528c98910be2c82a1965c486355f7b775285c987d0xc653622fd75026a020995a1d8c8651316cbbc4da0xd7e2d0f29c28b55165f533554eb6bc00e1ba2b810x680f75cbfa7751b18558d227786dbe246d03e95971
    ...
    406
    107KB
    95s