flipside

    sandbox
    tomingsandbox
    Updated 6 days ago
    -- SELECT
    -- *
    -- from
    -- ethereum.core.ez_token_transfers
    -- WHERE
    -- block_timestamp BETWEEN (CURRENT_DATE - 2) AND CURRENT_DATE
    -- AND
    -- contract_address=lower('0x1121acc14c63f3c872bfca497d10926a6098aac5')
    -- TO_ADDRESS = lower('0x4A422B7739ba007c2C58F7a1f5C1fF1EF82F44Bf')
    -- AND
    -- block_number > 20566704
    -- LIMIT 100


    -- SELECT
    -- count(tx_hash) as tx_num,
    -- contract_address,
    -- SYMBOL_IN,
    -- SYMBOL_OUT,
    -- TOKEN_IN,
    -- TOKEN_OUT
    -- FROM
    -- ethereum.defi.ez_dex_swaps
    -- WHERE
    -- block_timestamp > '2024-09-11'
    -- GROUP BY
    -- 2,3,4,5,6
    -- ORDER BY
    -- 1 DESC


    -- select
    -- *
    -- from
    -- ethereum.core.ez_token_transfers
    -- where
    Last run: 6 days ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    ORIGIN_FUNCTION_SIGNATURE
    TX_HASH
    EVENT_INDEX
    BRIDGE_ADDRESS
    EVENT_NAME
    PLATFORM
    SENDER
    RECEIVER
    DESTINATION_CHAIN_RECEIVER
    DESTINATION_CHAIN
    DESTINATION_CHAIN_ID
    TOKEN_ADDRESS
    TOKEN_SYMBOL
    AMOUNT_UNADJ
    AMOUNT
    AMOUNT_USD
    TOKEN_IS_VERIFIED
    EZ_BRIDGE_ACTIVITY_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		3517306772025-06-27 11:33:47.0000x7054fdc6308c3ad134f722d1a566790fc96d883f0x7054fdc6308c3ad134f722d1a566790fc96d883f0xe9ae5c530xec2733db156226b11908b404d0fec41640ce362bf6815c443fb2ee08509c6bef220xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x7054fdc6308c3ad134f722d1a566790fc96d883f0x7054fdc6308c3ad134f722d1a566790fc96d883f0x7054fdc6308c3ad134f722d1a566790fc96d883fbase84530x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH505664751791746000.05056647518124.28TRUE4a012c7edd1f0d9e7741703968ecdde22025-06-27 12:24:21.9992025-06-27 12:24:21.999
    2
    		3517306592025-06-27 11:33:42.0000x848e6cf692c25f128ea28b55d5bd79626f4f1f220xe35e9842fceaca96570b734083f4a58e8f7c5f2a0x7b9392320x14d3d43f8ffd46f0cbf9e4a353e371d921a736f5648689503333a705420f9a9b10xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x848e6cf692c25f128ea28b55d5bd79626f4f1f220x848e6cf692c25f128ea28b55d5bd79626f4f1f220x848e6cf692c25f128ea28b55d5bd79626f4f1f22optimism100x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH234332006400000000.0234332006457.59TRUEff0f17b2bf500bfe1550c781d8c14dab2025-06-27 12:24:21.9992025-06-27 12:24:21.999
    3
    		3517306312025-06-27 11:33:35.0000xfa8714498531364f0ce21299c8540643883e1ee50xe35e9842fceaca96570b734083f4a58e8f7c5f2a0x7b9392320x63ee9f94f15412ba58e1dd42c24a1ee6004db830948fbdfc56e5dba93a91ee5b310xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30xfa8714498531364f0ce21299c8540643883e1ee50xfa8714498531364f0ce21299c8540643883e1ee50xfa8714498531364f0ce21299c8540643883e1ee5base84530xaf88d065e77c8cc2239327c5edb3a432268e5831USDC1447055170714470.55170714468.93TRUEa530345ba09b2dbeec2fdc8d53c932ee2025-06-27 12:24:21.9992025-06-27 12:24:21.999
    4
    		3517306242025-06-27 11:33:33.0000x9bf19a5149631a2bc8c95efe49bdb7464fdba5100x1231deb6f5749ef6ce6943a275a1d3e7486f4eae0x28cc43160xc64a9439339330297e9abef6e82be1260568179c7aae9e32d0ceefa0ca395c6120xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x9bf19a5149631a2bc8c95efe49bdb7464fdba5100x9bf19a5149631a2bc8c95efe49bdb7464fdba5100x9bf19a5149631a2bc8c95efe49bdb7464fdba510linea591440x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH206000000000000000.020650.63TRUEbdd3a98fc2d3c94b0420aac03300cfc22025-06-27 12:24:21.9992025-06-27 12:24:21.999
    5
    		3517306202025-06-27 11:33:32.0000x8d391948dc81d695822a24e7360943da6d9dfa0b0x5813877cdda5f0f56eeab9326a42804a09e2cd8c0x9be111d10x6b54f86195435eca4b1f77c0f9a13f77bb7855c680488abc2ec3fcf6b7217fc7260xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x8d391948dc81d695822a24e7360943da6d9dfa0b0x8d391948dc81d695822a24e7360943da6d9dfa0b0x8d391948dc81d695822a24e7360943da6d9dfa0boptimism100x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH200000000000000000.0249.16TRUE98957edc7c4db0ad74ec0eab6730432c2025-06-27 12:24:21.9992025-06-27 12:24:21.999
    6
    		3517302392025-06-27 11:31:58.0000x925074b8eaf9ad076b3de110f8bf8b3ee87589270x5813877cdda5f0f56eeab9326a42804a09e2cd8c0x9be111d10x0ae19c1d4083dd9348e64042069d4edc2390ef764d90b1ae085066675fcc0dd5100xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x925074b8eaf9ad076b3de110f8bf8b3ee87589270x925074b8eaf9ad076b3de110f8bf8b3ee87589270x925074b8eaf9ad076b3de110f8bf8b3ee8758927zksync_era3240x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH4100000000000000.000411.01TRUEdf2f8a493c6ccba06a67d388cf58a6bf2025-06-27 12:24:21.9992025-06-27 12:24:21.999
    7
    		3517301712025-06-27 11:31:41.0000x30e4b7d4570c4793ee31166523200f87d98ac48e0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae0x28832cbd0xe61a2045f033714181d7c0f50dcb6295571f271f09c98d518e7040498b24308b60xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x30e4b7d4570c4793ee31166523200f87d98ac48e0x30e4b7d4570c4793ee31166523200f87d98ac48e0x30e4b7d4570c4793ee31166523200f87d98ac48epolygon1370xaf88d065e77c8cc2239327c5edb3a432268e5831USDC142642500142.6425142.63TRUE2f2e0302341d9c50f7262e5fba2d8bae2025-06-27 12:24:21.9992025-06-27 12:24:21.999
    8
    		3517301322025-06-27 11:31:31.0000xb03b5a9a14b66eccd4c44c31e41ebb67d6c30b7c0xe35e9842fceaca96570b734083f4a58e8f7c5f2a0x7b9392320x044f986d8f67bf133eecf4fdc7aee591307a4ec357c3d805a88a1d7627cd769c50xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30xb03b5a9a14b66eccd4c44c31e41ebb67d6c30b7c0xb03b5a9a14b66eccd4c44c31e41ebb67d6c30b7c0xb03b5a9a14b66eccd4c44c31e41ebb67d6c30b7cunichain1300xaf88d065e77c8cc2239327c5edb3a432268e5831USDC400000000040003999.55TRUEd0b982f8360e61b849cd368cf123fab62025-06-27 12:24:21.9992025-06-27 12:24:21.999
    9
    		3517300832025-06-27 11:31:19.0000x26759c2fc067a59ae77205450ac7bc7f410cc50a0x0b2402144bb366a632d14b83f244d2e0e21bd39c0x0f5287b00x6f2126180f9007c6a50e55627096de897605ff300d159a1a9f875f1c89d0b7c910x0b2402144bb366a632d14b83f244d2e0e21bd39cTransferwormhole0x26759c2fc067a59ae77205450ac7bc7f410cc50a0x0b2402144bb366a632d14b83f244d2e0e21bd39c0x26759c2fc067a59ae77205450ac7bc7f410cc50aethereum20xc3abc47863524ced8daf3ef98d74dd881e131c38LUA514410000000000000000514.411229.44FALSE3ca10d5678537add9282b5f68587c6d52025-06-27 12:24:21.9992025-06-27 12:24:21.999
    10
    		3517300462025-06-27 11:31:09.0000xca8fd3cf830d528e8aa4b29ac7a380482189eb9f0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae0x28cc43160x657f4e44b1a457df57d35809c4d8ac7e6d71d9a57ab0610a0407c30da610047b450xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30xca8fd3cf830d528e8aa4b29ac7a380482189eb9f0xe2868d398a48fa3a03d8df94442dc602332fe4d40xe2868d398a48fa3a03d8df94442dc602332fe4d4lens2320x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH2100000000000000.000210.52TRUE1c4fa5e46a098635bfe021773f7bd7702025-06-27 12:24:21.9992025-06-27 12:24:21.999
    11
    		3517299962025-06-27 11:30:57.0000x4f0591ad9662ccd4281f038f1e426d4b56de90040x3335733c454805df6a77f825f266e136fb4a33330xe1fcde8e0xb55a4cfc286262949475c0a930c58b4e84861d4222b516b4e9b51a47f84968ad0x25ab3efd52e6470681ce037cd546dc60726948d3meson0x6aa981bff95edfea36bdae98c26b274ffcafe8d30x25ab3efd52e6470681ce037cd546dc60726948d30x4f0591ad9662ccd4281f038f1e426d4b56de9004base21050x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH80000000000000000.00819.66TRUE42a1b01da5e026b5abbb992cf6adc9ab2025-06-27 12:24:21.9992025-06-27 12:24:21.999
    12
    		3517299852025-06-27 11:30:54.0000xc4e7263dd870a29f1cfe438d1a7db48547b168880x0000000071727de22e5e9d8baf0edac6f37da0320x765e827f0xc35789c5df082a08da030223dca9f87123aa14c9ca5b58b37ae641146a984e6a20xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x91d2310771e1a0da07a4a2b967d1daefd72c44140x28c7ef3789cf91c918cf86e5ef4b40febe24dad30x28c7ef3789cf91c918cf86e5ef4b40febe24dad3optimism100x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH1100589273239060000.1100589273270.51TRUE758d4071f7fa6770b82cd8e8a60ea4cc2025-06-27 12:24:21.9992025-06-27 12:24:21.999
    13
    		3517299282025-06-27 11:30:40.0000x8b611a0747f714f657c0a8575f877ec5ad9189d00xe35e9842fceaca96570b734083f4a58e8f7c5f2a0x7b9392320x9810ff804ebe4877231126d797e077a025461cb5c917910b812d0e2897e13ae340xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x8b611a0747f714f657c0a8575f877ec5ad9189d00x8b611a0747f714f657c0a8575f877ec5ad9189d00x8b611a0747f714f657c0a8575f877ec5ad9189d0ethereum10x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH928518356492850000.09285183565228.21TRUEddcc4f11447d077421c105cf1737445d2025-06-27 12:24:21.9992025-06-27 12:24:21.999
    14
    		3517299272025-06-27 11:30:40.0000x15652636f3898f550b257b89926d5566821c32e10x0000000000afc904ae9860d9c4b96d7c529c58b80xa13a95ff0x1de8c9d545d6fa5b4edae8db04a8b53a314b67e317a8bedfec6eb3ab86631cda100xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x7f8b4198ae91bf997a16eed610941618039254fe0x000000000060f6e853447881951574cdd06635300x000000000060f6e853447881951574cdd0663530base84530xaf88d065e77c8cc2239327c5edb3a432268e5831USDC63250.0063250.01TRUE3440b7ad4a3eb3ed236f85a6ce5b1eda2025-06-27 12:24:21.9992025-06-27 12:24:21.999
    15
    		3517299272025-06-27 11:30:40.0000x15652636f3898f550b257b89926d5566821c32e10x0000000000afc904ae9860d9c4b96d7c529c58b80xa13a95ff0x1de8c9d545d6fa5b4edae8db04a8b53a314b67e317a8bedfec6eb3ab86631cda70xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x7f8b4198ae91bf997a16eed610941618039254fe0x7f8b4198ae91bf997a16eed610941618039254fe0x7f8b4198ae91bf997a16eed610941618039254febase84530xaf88d065e77c8cc2239327c5edb3a432268e5831USDC50161865.0161865.02TRUEbe052ccfa17d25c46aa50d380296060f2025-06-27 12:24:21.9992025-06-27 12:24:21.999
    16
    		3517298672025-06-27 11:30:25.0000xe7488e7f5c60bfa81d38965c02b4cc5aa6249a110x0000000000afc904ae9860d9c4b96d7c529c58b80xa13a95ff0x5f489d06f38bfee694c11331245181cb468bcb9d01c0fccd2492e42f12a88cb0370xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x7f8b4198ae91bf997a16eed610941618039254fe0x7f8b4198ae91bf997a16eed610941618039254fe0x7f8b4198ae91bf997a16eed610941618039254febase84530xaf88d065e77c8cc2239327c5edb3a432268e5831USDC346920.0346920.03TRUEca8745d593d8412d396b0510667b15a42025-06-27 12:24:21.9992025-06-27 12:24:21.999
    17
    		3517298672025-06-27 11:30:25.0000xe7488e7f5c60bfa81d38965c02b4cc5aa6249a110x0000000000afc904ae9860d9c4b96d7c529c58b80xa13a95ff0x5f489d06f38bfee694c11331245181cb468bcb9d01c0fccd2492e42f12a88cb0400xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x7f8b4198ae91bf997a16eed610941618039254fe0x000000000060f6e853447881951574cdd06635300x000000000060f6e853447881951574cdd0663530base84530xaf88d065e77c8cc2239327c5edb3a432268e5831USDC40200.004020TRUE8450bfbd96a587b6663f8db7822d01c42025-06-27 12:24:21.9992025-06-27 12:24:21.999
    18
    		3517298232025-06-27 11:30:14.0000x38b72280893b5acc08b5f1ca600923865fdfb3470xe35e9842fceaca96570b734083f4a58e8f7c5f2a0x1186ec330xc7c6e8207c235cd239e2518707110fbe01d71450b5f048cb26652feec6b7604210xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x38b72280893b5acc08b5f1ca600923865fdfb3470x38b72280893b5acc08b5f1ca600923865fdfb3470x38b72280893b5acc08b5f1ca600923865fdfb347optimism100x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH66148163184696800.00661481631816.26TRUE8b6aeaf9bf1c62599115f05da0f33e682025-06-27 12:24:21.9992025-06-27 12:24:21.999
    19
    		3517296472025-06-27 11:29:30.0000xe9b80208b993c076b8e0c3ceebbffd40f0270a9f0x69460570c93f9de5e2edbc3052bf10125f0ca22d0xe6c806ff0x8d91ceb95da555059d18ce8e35ee50c8bf02d71e3a5b686c02a9bcdd40d9e0d8300xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30xe9b80208b993c076b8e0c3ceebbffd40f0270a9f0xe9b80208b993c076b8e0c3ceebbffd40f0270a9f0xe9b80208b993c076b8e0c3ceebbffd40f0270a9fethereum10x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH20297057329267900.0020297057334.99TRUE2f2bcfc8588b27e3f7dddc7c452369c62025-06-27 12:24:21.9992025-06-27 12:24:21.999
    20
    		3517296332025-06-27 11:29:26.0000x800e4be7b2bc057724761e1fb9dfa7a865088c360x23981fc34e69eedfe2bd9a0a9fcb0719fe09dbfc0x3ce33bff0xd41b6329ba54f7a690cdb46514415f53bf932ea4400992bcf053d87cd372e3eb150xe35e9842fceaca96570b734083f4a58e8f7c5f2aFundsDepositedacross-v30x800e4be7b2bc057724761e1fb9dfa7a865088c360x800e4be7b2bc057724761e1fb9dfa7a865088c360x800e4be7b2bc057724761e1fb9dfa7a865088c36linea591440x82af49447d8a07e3bd95bd0d56f35241523fbab1WETH2076119731775650.00020761197320.51TRUE7a7a113c5872316df5a6bdc15f2524802025-06-27 12:24:21.9992025-06-27 12:24:21.999
    100
    60KB
    2s