flipside

    Analyse DAO
    10BlockchainAnalyse DAO
    Updated 2025-02-25
    WITH
    --------------------------------------------------------------------------------
    -- (A) L1: "DelegateChanged"
    --------------------------------------------------------------------------------
    l1_delegate_changed AS (
    SELECT
    'L1' AS chain,
    block_timestamp,
    block_number,
    tx_hash,
    'DelegateChanged' AS event_name,
    (decoded_log:delegator)::string AS delegator,
    (decoded_log:toDelegate)::string AS delegatee,
    CAST(NULL AS NUMERIC) AS old_votes,
    CAST(NULL AS NUMERIC) AS new_votes,
    contract_address AS contract
    FROM ethereum.core.ez_decoded_event_logs
    WHERE contract_address = LOWER('0x3c3a81e81dc49a522a592e7622a7e711c06bf354')
    AND event_name = 'DelegateChanged'
    ),

    --------------------------------------------------------------------------------
    -- (B) L1: "DelegateVotesChanged"
    --------------------------------------------------------------------------------
    l1_delegate_votes AS (
    SELECT
    'L1' AS chain,
    block_timestamp,
    block_number,
    tx_hash,
    'DelegateVotesChanged' AS event_name,
    CAST(NULL AS STRING) AS delegator, -- pas dans l'event
    (decoded_log:delegate)::string AS delegatee,
    CAST((decoded_log:previousBalance)::string AS NUMERIC) AS old_votes,
    CAST((decoded_log:newBalance)::string AS NUMERIC) AS new_votes,
    contract_address AS contract
    Last run: about 2 months ago
    CHAIN
    BLOCK_TIMESTAMP
    BLOCK_NUMBER
    TX_HASH
    EVENT_NAME
    DELEGATOR
    DELEGATEE
    OLD_VOTES
    NEW_VOTES
    CONTRACT
    1
    		L12025-02-24 16:24:11.000219173540xd25d6a4d76d6bfc06cd874de309690974cc9d9bcb3639b31f695378830cad574DelegateVotesChanged0x7875923047c6043f98bdeb17f237f941c6e9fdef9876710591286831000009871729869635803000000x3c3a81e81dc49a522a592e7622a7e711c06bf354
    2
    		L12025-02-23 17:40:59.000219105770x18eb4a06e2d8a2ce3acb05f5cde078ae073792267b8b7408a06f00af4e536277DelegateVotesChanged0xab127edd7db0f739785b0d85e78c04b4d5d006b2060000000000000000000x3c3a81e81dc49a522a592e7622a7e711c06bf354
    3
    		L12025-02-23 17:24:59.000219104980xae2cc83daf84390686cbf991038b0e93b9c0b2d565528b3e48a852ac3bf37937DelegateVotesChanged0x3ccdb6e8a4622eeae0fb65dcf4eb29bed3023243020000000000000000000x3c3a81e81dc49a522a592e7622a7e711c06bf354
    4
    		L12025-02-22 21:34:47.000219045890xd750ddab64b45ed85b4ca4316e6b5b8066a020a6f7bdd49031e0845ed619e5cdDelegateVotesChanged0x42d586b34d567705f8fd8bedc174a6e0da6c5af4800000000000000000000x3c3a81e81dc49a522a592e7622a7e711c06bf354
    5
    		L22025-02-22 19:55:22.000760619050x3793e56164e2279bd856506704b744f0073418a43ccc5726a3fdf723459d3974delegate_call0x78fe9cb131cc63f02e47a9c00bb793ffd72e74600x7705d8798a8f2069c966c85ede7588c4c93403490xed459209796d741f5b609131abd927586fccacc5
    6
    		L12025-02-22 14:20:23.000219024260x2f97ac74adf3e4e4e6dbaa54be4d56ff685cd9ef3cfb8240a1ff032fb223810eDelegateVotesChanged0xa99582d7e81a86bbe912d3cf765278a23d4700db1000000000000000000000x3c3a81e81dc49a522a592e7622a7e711c06bf354
    7
    		L12025-02-22 04:50:35.000218996000xb19f79b10355e65f89ae91b01f9de369faf15e41a81be2fc14d79fdb6e9b0781DelegateVotesChanged0x09da12f0977ed3534124a4f593d9c1a243bea5982.500112567140005e+252.500112459140005e+250x3c3a81e81dc49a522a592e7622a7e711c06bf354
    8
    		L12025-02-22 04:03:59.000218993690x5d28f6b1433a42df5ee4df923527f53a354172b2e8788cd08b4991ce5fc09308DelegateVotesChanged0x2452e136265e4b2ce559534e9eb18e9907f459736188346138016192000000x3c3a81e81dc49a522a592e7622a7e711c06bf354
    9
    		L12025-02-22 04:02:47.000218993630x597223cfe6531988957cbb84ee105ac3bd3707bf8a4bdb8341e4d40716448da6DelegateVotesChanged0x2452e136265e4b2ce559534e9eb18e9907f459731621082116775913700618834613801619200000x3c3a81e81dc49a522a592e7622a7e711c06bf354
    10
    		L12025-02-21 21:14:35.000218973330x127ab589902f0301a1414d6e2be293afa82e3b7b8a325371e2bf310cd45d572dDelegateVotesChanged0x09da12f0977ed3534124a4f593d9c1a243bea5982.500113580325005e+252.500112567140005e+250x3c3a81e81dc49a522a592e7622a7e711c06bf354
    11
    		L22025-02-21 21:00:00.000760206440xf06130145b372cd55b9123134d42eb839731192e14475b44f11a618021a9017ddelegate_call0x6f549c9d9956d4ade66b3956f969075adae4942a0x09da12f0977ed3534124a4f593d9c1a243bea5980xed459209796d741f5b609131abd927586fccacc5
    12
    		L12025-02-21 20:57:11.000218972460x9402b659451368fe8bf5613b1c6edb4668b12a8e46d6033bf89c929549461bc4DelegateVotesChanged0x11b89f44cdb4733ea082c7100d47d1e8014e72e11354300000000000000030000000000000000x3c3a81e81dc49a522a592e7622a7e711c06bf354
    13
    		L22025-02-21 16:31:24.000760125860x43d12dcf65fcad42c374e00a5f4f148a3e84abd762a94c781f18e275551b61f4delegate_call0xdcb7c03c06fde7976de5d179b44e8367942fb8d50x09da12f0977ed3534124a4f593d9c1a243bea5980xed459209796d741f5b609131abd927586fccacc5
    14
    		L12025-02-21 12:47:11.000218948070xd3be04dd30ba3f9b93445f93e699c1903e9733e57de68ae9951f8c9254fd5353DelegateVotesChanged0x718805874028b3ac25f622013d3273dab05747a61000000000000000000000x3c3a81e81dc49a522a592e7622a7e711c06bf354
    15
    		L12025-02-21 11:37:47.000218944610x85dbce30f13757941de00ddb05e07dbe8b3f121a863117c445d5371db72db5ecDelegateVotesChanged0xf26cbd1913c69803bdf35d7fb8b8163aa17544261000000000000000000000x3c3a81e81dc49a522a592e7622a7e711c06bf354
    16
    		L22025-02-21 07:44:10.000759967690xca27d37287a6587a0980a2cb73461547503cbcdf913431910996e29a8dfc63ebdelegate_call0x7f7189181f3571420db3e665a2131a573a4ce0a80x09da12f0977ed3534124a4f593d9c1a243bea5980xed459209796d741f5b609131abd927586fccacc5
    17
    		L12025-02-21 04:46:23.000218924170x85cae997c3d314a827beaf5503ab8cdb7b187732829db658e03ecd353a518d16DelegateVotesChanged0x09da12f0977ed3534124a4f593d9c1a243bea5982.500113880325005e+252.500113580325005e+250x3c3a81e81dc49a522a592e7622a7e711c06bf354
    18
    		L22025-02-20 20:36:56.000759767520x65d9c1dbcf86ad102bfc7af0cd0ad0fe0b1f614fa80c5cbc444b7f586a33acdfdelegate_call0xab40c645c6db5b9112442f0dfa0747eac086ee310xdc026e9f31239c30ee58c29ab98b36259e33832e0xed459209796d741f5b609131abd927586fccacc5
    19
    		L22025-02-20 06:19:14.000759510210x1f965686a419b7ac0f9d9cfb15340c756dd033b261e2362231a02929571f4000delegate_call0x191dec150219666450138d7394877bc3bcea29580x191dec150219666450138d7394877bc3bcea29580xed459209796d741f5b609131abd927586fccacc5
    20
    		L22025-02-19 18:56:04.000759305260xbc6eae80d421c68fd1273fcfad58fe1ceaaec39b919eb28f7328c827298f9186delegate_call0x456bee4dbfd4d4188c4bdf6b230dd1280b58d9050x456bee4dbfd4d4188c4bdf6b230dd1280b58d9050xed459209796d741f5b609131abd927586fccacc5
    ...
    300
    78KB
    71s