flipside

    5
    datavortex5
    Updated 2025-02-06
    SELECT * from ethereum.core.ez_decoded_event_logs
    where tx_hash = '0x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db'
    and origin_to_address = '0x3a23f943181408eac424116af7b7790c94cb97a5'
    limit 300












    /*
    SELECT
    -- Extract user-related data from topics
    '0x' || SUBSTR(topics[1], 27) AS caller, -- User who initiated the transaction (address)
    '0x' || SUBSTR(topics[2], 27) AS owner, -- Owner involved in the transaction (address)
    '0x' || SUBSTR(topics[3], 27) AS asset, -- Asset being involved (address)

    -- Amount and shares from the data field (as integers)
    ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 3, 64)) AS amount, -- Amount field (first 32 bytes)
    ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 67, 64)) AS shares, -- Shares field (second 32 bytes)

    -- Other relevant data points
    l.block_timestamp AS block_timestamp, -- Transaction timestamp
    l.tx_hash AS tx_hash, -- Transaction hash
    l.origin_function_signature AS origin_function_signature, -- Origin function signature
    l.origin_from_address AS origin_from_address, -- Originating address for the transaction
    l.origin_to_address AS origin_to_address, -- Destination address for the transaction
    -- Event details and additional metadata
    l.event_index AS event_index, -- Event index within the transaction
    Last run: 3 months ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    TX_HASH
    EVENT_INDEX
    CONTRACT_ADDRESS
    CONTRACT_NAME
    EVENT_NAME
    DECODED_LOG
    FULL_DECODED_LOG
    ORIGIN_FUNCTION_SIGNATURE
    ORIGIN_FROM_ADDRESS
    ORIGIN_TO_ADDRESS
    TOPICS
    DATA
    EVENT_REMOVED
    TX_STATUS
    EZ_DECODED_EVENT_LOGS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2830x28e4f3a7f651294b9564800b2d01f35189a5bfbeStateSynced
    {"contractAddress":"0xa6fa4fb5f76172d178d61b04b0ecd319c5d1c0aa","data":"...
    {"address":"0x28e4F3a7f651294B9564800b2D01f35189A5bFbE","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0x103fed9db65eac19c4d870f49ab7520fe03b99f1838e5996caf47e9e43308392","0...
    0x0000000000000000000000000000000000000000000000000000000000000020000000...
    		falseSUCCESSe6daeb6cb28ae4aba28e8073618fe8382025-01-08 07:15:32.8812025-01-08 09:16:04.355
    2
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2750xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48USD CoinTransfer
    {"from":"0x2e8135be71230c6b1b4045696d41c09db0414226","to":"0x70bf6634ee8...
    {"address":"0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0x00000000000000000000000000000000000000000000000000000000036c4fa8falseSUCCESS619341a73b1589fb551386c04783118c2025-01-08 07:15:32.8812025-01-08 09:16:04.355
    3
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2780xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48USD CoinTransfer
    {"from":"0x70bf6634ee8cb27d04478f184b9b8bb13e5f4710","to":"0xad01c20d588...
    {"address":"0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0x0000000000000000000000000000000000000000000000000000000000015080falseSUCCESS311be427a3857b8c1803788fe866ad622025-01-08 07:15:32.8812025-01-08 09:16:04.355
    4
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2790xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48USD CoinTransfer
    {"from":"0x70bf6634ee8cb27d04478f184b9b8bb13e5f4710","to":"0x3a23f943181...
    {"address":"0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0x00000000000000000000000000000000000000000000000000000000036aff28falseSUCCESS599a329222776af1c39016cc35c8c3c02025-01-08 07:15:32.8812025-01-08 09:16:04.355
    5
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2820xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48USD CoinTransfer
    {"from":"0x3a23f943181408eac424116af7b7790c94cb97a5","to":"0x40ec5b33f54...
    {"address":"0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0x00000000000000000000000000000000000000000000000000000000036aff28falseSUCCESS45779ca15016a18aaf9a4ea785f3f71a2025-01-08 07:15:32.8812025-01-08 09:16:04.355
    6
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2810x40ec5b33f54e0e8a33a975908c5ba1c14e5bbbdfLockedERC20
    {"amount":57343784,"depositReceiver":"0x1881ad6e231a14a8be0f9ae6f9efd8f3...
    {"address":"0x40ec5B33f54e0E8A33A975908C5BA1c14e5BbbDf","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0x9b217a401a5ddf7c4d474074aff9958a18d48690d77cc2151c4706aa7348b401","0...
    		0x00000000000000000000000000000000000000000000000000000000036aff28falseSUCCESSd427ce8f11131098f47476ed02f473d62025-01-08 07:15:32.8812025-01-08 09:16:04.355
    7
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2800x3a23f943181408eac424116af7b7790c94cb97a5SocketSwapTokens
    {"buyAmount":57343784,"fromToken":"0xc02aaa39b223fe8d0a0e5c4f27ead9083c7...
    {"address":"0x3a23F943181408EAC424116Af7b7790c94Cb97a5","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0xb346a959ba6c0f1c7ba5426b10fd84fe4064e392a0dfcf6609e9640a0dd260d3"]
    0x000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000...
    		falseSUCCESS642419028c7cfb3012d5f342c2d948182025-01-08 07:15:32.8812025-01-08 09:16:04.355
    8
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2730xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2Wrapped EtherApproval
    {"guy":"0x0000000000001ff3684f28c67538d4d072c22734","src":"0x3a23f943181...
    {"address":"0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925","0...
    		0x000000000000000000000000000000000000000000000000003d1938c47be229falseSUCCESSc36aa7460f2fdaa7ca60dd4c64b3a5ca2025-01-08 07:15:32.8812025-01-08 09:16:04.355
    9
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2720xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2Wrapped EtherTransfer
    {"dst":"0x3a23f943181408eac424116af7b7790c94cb97a5","src":"0xeeb17adefd0...
    {"address":"0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0x000000000000000000000000000000000000000000000000003d1938c47be229falseSUCCESSc50cc133c850ccc356819de4f1fe0b942025-01-08 07:15:32.8812025-01-08 09:16:04.355
    10
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2740xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2Wrapped EtherTransfer
    {"dst":"0x2e8135be71230c6b1b4045696d41c09db0414226","src":"0x3a23f943181...
    {"address":"0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef","0...
    		0x000000000000000000000000000000000000000000000000003d1938c47be229falseSUCCESSec730b9f60da1cf97b378bea43b744952025-01-08 07:15:32.8812025-01-08 09:16:04.355
    11
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2760x2e8135be71230c6b1b4045696d41c09db0414226Pancake LPsSync
    {"reserve0":159985410355,"reserve1":"47805929951093222494"}
    {"address":"0x2E8135bE71230c6B1B4045696d41C09Db0414226","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0x1c411e9a96e071241c2f21f7726b17ae89e3cab4c78be50e062b03a9fffbbad1"]
    0x000000000000000000000000000000000000000000000000000000253fdfa133000000...
    		falseSUCCESS3c7e169d9d26db5914fbdb2afd2389762025-01-08 07:15:32.8812025-01-08 09:16:04.355
    12
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2770x2e8135be71230c6b1b4045696d41c09db0414226Pancake LPsSwap
    {"amount0In":0,"amount0Out":57429928,"amount1In":"17197705184666153","am...
    {"address":"0x2E8135bE71230c6B1B4045696d41C09Db0414226","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822","0...
    0x0000000000000000000000000000000000000000000000000000000000000000000000...
    		falseSUCCESS93d9bb5ea9bcb844b226d779883f3d322025-01-08 07:15:32.8812025-01-08 09:16:04.355
    13
    		215779412025-01-08 06:23:59.0000x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db2840x3a23f943181408eac424116af7b7790c94cb97a5SocketBridge
    {"amount":57343784,"bridgeName":"0xf1c09a354cd800a13f6f260a3a96a0e33db28...
    {"address":"0x3a23F943181408EAC424116Af7b7790c94Cb97a5","data":[{"decode...
    		0x000001a00xeeb17adefd06a3c67abd4adf7e42978b1f018c8e0x3a23f943181408eac424116af7b7790c94cb97a5
    ["0x74594da9e31ee4068e17809037db37db496702bf7d8d63afe6f97949277d1609"]
    0x00000000000000000000000000000000000000000000000000000000036aff28000000...
    		falseSUCCESSecb5cb956f06af3684e22050290f0aa62025-01-08 07:15:32.8812025-01-08 09:16:04.355
    13
    18KB
    4s