flipside

    Calcul fin
    10BlockchainCalcul fin
    Updated 2025-02-22
    WITH base_events AS (
    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    DATA
    FROM ethereum.core.fact_event_logs
    WHERE CONTRACT_ADDRESS = LOWER('0x31d543e7BE1dA6eFDc2206Ef7822879045B9f481')
    AND TOPIC_0 = '0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2'
    -- Filtre sur l'event signature si besoin
    ORDER BY BLOCK_TIMESTAMP DESC
    LIMIT 20
    )
    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    DATA,
    -- 1) On enlève '0x'
    REPLACE(DATA, '0x', '') AS data_no_prefix,
    -- 2) On convertit la string hex en binaire
    TO_BINARY(REPLACE(DATA, '0x', ''), 'HEX') AS data_binary,
    -- 3) On cast ce binaire en nombre (uint256)
    CAST(
    TO_BINARY(REPLACE(DATA, '0x', ''), 'HEX')
    AS NUMBER(38, 0)
    ) AS l2_block_number_decimal
    FROM base_events;

    Last run: 2 months ago
    BLOCK_TIMESTAMP
    TX_HASH
    CONTRACT_ADDRESS
    TOPIC_0
    TOPICS
    DATA
    ORIGIN_FUNCTION_SIGNATURE
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    1
    		2025-02-22 05:16:23.0000xefbc34afbb306b9c1d02bb4b758f53a0a8c3f058227c15cf72281c45f7320fac0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b95da70x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    2
    		2025-02-22 04:12:23.0000xd46640b96ecb7452fe60fa244d6da07877c03ba403f29ea3342d15eb0bc4c18f0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b94ea70x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    3
    		2025-02-22 03:21:11.0000x2e072f6e6a647dbbf0a6992d65d438382248db6b06d053981ac41ee3f688b7290x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b942a70x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    4
    		2025-02-22 02:17:11.0000xbd1ca12399b5144cef605bdf83b274f89e53ab5159ecfcccec0cd375aed1ef890x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b933a70x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    5
    		2025-02-22 01:13:11.0000x684f046d941c1270cb6e6fa35533965ede3b51e6833c32316b64035964a6bc7b0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b924a70x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    6
    		2025-02-22 00:09:11.0000x0e81f1b3c494fae2a94bb2d9c6f6083a965add3cdc00d4d8023b0401ea01084a0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b915a70x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    7
    		2025-02-21 23:17:47.0000xdb957284c88ebe2262527c650f8a868b9bd6456d240a40a27ba58942fbdb2e320x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b9099b0x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    8
    		2025-02-21 22:13:35.0000xf6bfa9e080ed3dc8e58ffb62c5e8bfb3ad226a75299c6943bea6ed5010b35d450x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b8fa8f0x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    9
    		2025-02-21 21:09:35.0000x3979219395351ac31435caa03d48a0461d92d220f3aa1ada1e7ee10153bd691c0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b8eb8f0x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    10
    		2025-02-21 20:05:35.0000x938404e4c5313f8f4e6ddbc4bf0c45fa717ec8beb5451c7a818679ff871128de0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b8dc8f0x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    11
    		2025-02-21 19:21:11.0000x2ae9aeb6190660464331caa170eae897457a278867c1c5c9197e53f0877790bd0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b8d2270x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    12
    		2025-02-21 18:17:11.0000x16e32d21ec5c171c22c975cd3eecb7718e23b8b18272e26e0d8a26473482a8050x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b8c3270x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    13
    		2025-02-21 17:06:35.0000x4cfd1412cf5ca47fa7486bb9e64a28f2bead65b2c19fa94be0a9f31361932d1d0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b8b29b0x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    14
    		2025-02-21 16:21:35.0000x5ec419a8325cd71466e5db9a90c35f8197cf8052a4721f7f7128fce134576c050x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b8a80f0x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    15
    		2025-02-21 15:11:47.0000x6f4414533d56673c67cbc5bfb7aa8a74fac13bf668dd5b7366127e2d8599f0400x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b897b30x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    16
    		2025-02-21 14:20:11.0000xaa6823ac217f4639bce8c79024d5fd4308e401d506546448c41ab199cb3e9a4f0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b88b9b0x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    17
    		2025-02-21 13:16:11.0000x06b3797115f7d9553fdf9c932a1e31354cbaf1074090543df1eb5f0ed1297cee0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b87c9b0x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    18
    		2025-02-21 12:12:11.0000xcbdd21521e132be7cb62070c0b5f4dfa8f77c8c302e621e3eea7ec91639fa5aa0x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b86d9b0x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    19
    		2025-02-21 11:08:11.0000x332893b489d3cba99d93cd971a5992ad038c088528da72bcb9280063c48b1ff80x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b85e9b0x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    20
    		2025-02-21 10:17:23.0000x82cfcc67995cbb737ef5798683d4903c6e3eafbc0d5ef97382c4578c295761340x31d543e7be1da6efdc2206ef7822879045b9f4810xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2
    ["0xa7aaf2512769da4e444e3de247be2564225c2e7a8f74cfe528e46e17d24868e2","0...
    		0x0000000000000000000000000000000000000000000000000000000067b852b30x9aaab6480x6667961f5e9c98a76a48767522150889703ed77d0x31d543e7be1da6efdc2206ef7822879045b9f481
    100
    65KB
    11s