flipside

    2024-02-15 05:49 AM
    mamad-5XN3k32024-02-15 05:49 AM
    Updated 2024-02-15
    SELECT
    TIMESTAMP as dates,
    TX_HASH,
    SUM((PARAMETERS[2]:value[0]:value/POW(10,p.decimals)) * p.price) AS volume,
    *
    FROM external.tokenflow_starknet.decoded_events
    where TX_HASH = '0x05425f8fa1ff9295356570cb5c6af9aac661977f8bff7138d2e82a05c31ec5f1'
    Last run: about 1 year ago
    LOAD_ID
    CHAIN_ID
    BLOCK_NUMBER
    TIMESTAMP
    EVENT_ID
    TX_HASH
    TRACE_ID
    CONTRACT
    CLASS_HASH
    NAME
    KEYS
    PARAMETERS
    EVENT_ORDER
    1
    		2023-11-04 20:36:29.000mainnet3767972023-11-04 20:35:06.000376797_54_30x05425f8fa1ff9295356570cb5c6af9aac661977f8bff7138d2e82a05c31ec5f1376797_54_1_0_5_00x04d0390b777b424e43839cd1e744799f3de6c176c7e32c1812a41dbd9c19db6a0x02b39bc3f4c1fd5bef8b7d21504c44e0da59cf27b350551b13d913da52e40d3bSync
    []
    [ { "name": "reserve0", "value": [ { "name": "low", "value": 1.3883601340744136e+21 }, { "name": "high", "value": 0 } ] }, { "name": "reserve1", "value": [ { "name": "low", "value": 2548504675991 }, { "name": "high", "value": 0 } ] } ]
    		3
    2
    		2023-11-04 20:36:29.000mainnet3767972023-11-04 20:35:06.000376797_54_10x05425f8fa1ff9295356570cb5c6af9aac661977f8bff7138d2e82a05c31ec5f1376797_54_1_0_3_00x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a80x02760f25d5a4fb2bdde5f561fd0b44a3dee78c28903577d37d669939d97036a0Transfer
    []
    [ { "name": "from_", "value": "0x122b7257e0636fee95970f8caf5fc7b6ac3aebd5e6886ee96864772d26e3b0a" }, { "name": "to", "value": "0x4d0390b777b424e43839cd1e744799f3de6c176c7e32c1812a41dbd9c19db6a" }, { "name": "value", "value": [ { "name": "low", "value": 3496668 }, { "name": "high", "value": 0 } ] } ]
    		1
    3
    		2023-11-04 20:36:29.000mainnet3767972023-11-04 20:35:06.000376797_54_00x05425f8fa1ff9295356570cb5c6af9aac661977f8bff7138d2e82a05c31ec5f1376797_54_0_00x053c91253bc9682c04929ca02ed00b3e423f6710d2ee7e0d5ebb06f3ecf368a80x02760f25d5a4fb2bdde5f561fd0b44a3dee78c28903577d37d669939d97036a0Approval
    []
    [ { "name": "owner", "value": "0x122b7257e0636fee95970f8caf5fc7b6ac3aebd5e6886ee96864772d26e3b0a" }, { "name": "spender", "value": "0x41fd22b238fa21cfcf5dd45a8548974d8263b3a531a60388411c5e230f97023" }, { "name": "value", "value": [ { "name": "low", "value": 3496668 }, { "name": "high", "value": 0 } ] } ]
    		0
    4
    		2023-11-04 20:36:29.000mainnet3767972023-11-04 20:35:06.000376797_54_50x05425f8fa1ff9295356570cb5c6af9aac661977f8bff7138d2e82a05c31ec5f1376797_540x0122b7257e0636fee95970f8caf5fc7b6ac3aebd5e6886ee96864772d26e3b0a0x01a736d6ed154502257f02b1ccdf4d9d1089f80811cd6acad48e6b6a9d1f2003TransactionExecuted
    [ { "name": "hash", "value": "0x5425f8fa1ff9295356570cb5c6af9aac661977f8bff7138d2e82a05c31ec5f1" } ]
    [ { "name": "response", "value": [ { "name": "snapshot", "value": "0x2" } ] } ]
    		5
    5
    		2023-11-04 20:36:29.000mainnet3767972023-11-04 20:35:06.000376797_54_40x05425f8fa1ff9295356570cb5c6af9aac661977f8bff7138d2e82a05c31ec5f1376797_54_1_0_5_00x04d0390b777b424e43839cd1e744799f3de6c176c7e32c1812a41dbd9c19db6a0x02b39bc3f4c1fd5bef8b7d21504c44e0da59cf27b350551b13d913da52e40d3bSwap
    []
    [ { "name": "sender", "value": "0x41fd22b238fa21cfcf5dd45a8548974d8263b3a531a60388411c5e230f97023" }, { "name": "amount0In", "value": [ { "name": "low", "value": 0 }, { "name": "high", "value": 0 } ] }, { "name": "amount1In", "value": [ { "name": "low", "value": 3496668 }, { "name": "high", "value": 0 } ] }, { "name": "amount0Out", "value": [ { "name": "low", "value": 1899183170564424 }, { "name": "high", "value": 0 } ] }, { "name": "amount1Out", "value": [ { "name": "low", "value": 0 }, { "name": "high", "value": 0 } ] }, { "name": "to", "value": "0x122b7257e0636fee95970f8caf5fc7b6ac3aebd5e6886ee96864772d26e3b0a" } ]
    		4
    6
    		2023-11-04 20:36:29.000mainnet3767972023-11-04 20:35:06.000376797_54_00x05425f8fa1ff9295356570cb5c6af9aac661977f8bff7138d2e82a05c31ec5f1376797_54_f_00x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc70x02760f25d5a4fb2bdde5f561fd0b44a3dee78c28903577d37d669939d97036a0Transfer
    []
    [ { "name": "from_", "value": "0x122b7257e0636fee95970f8caf5fc7b6ac3aebd5e6886ee96864772d26e3b0a" }, { "name": "to", "value": "0x1176a1bd84444c89232ec27754698e5d2e7e1a7f1539f12027f28b23ec9f3d8" }, { "name": "value", "value": [ { "name": "low", "value": 206605614905592 }, { "name": "high", "value": 0 } ] } ]
    		0
    7
    		2023-11-04 20:36:29.000mainnet3767972023-11-04 20:35:06.000376797_54_20x05425f8fa1ff9295356570cb5c6af9aac661977f8bff7138d2e82a05c31ec5f1376797_54_1_0_5_0_0_00x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc70x02760f25d5a4fb2bdde5f561fd0b44a3dee78c28903577d37d669939d97036a0Transfer
    []
    [ { "name": "from_", "value": "0x4d0390b777b424e43839cd1e744799f3de6c176c7e32c1812a41dbd9c19db6a" }, { "name": "to", "value": "0x122b7257e0636fee95970f8caf5fc7b6ac3aebd5e6886ee96864772d26e3b0a" }, { "name": "value", "value": [ { "name": "low", "value": 1899183170564424 }, { "name": "high", "value": 0 } ] } ]
    		2
    7
    4KB
    7s