SELECT

*

FROM

external.tokenflow_starknet.decoded_events

WHERE

CONTRACT ILIKE '0x00000005dd3D2F4429AF886cD1a3b08289DBcEa99A294197E9eB43b0e0325b4b'

AND NAME ILIKE 'ProtocolFeesPaid'

),

ExtractedFees AS (

SELECT

PARAMETERS[0]:value[0]:value::STRING AS token0,

PARAMETERS[0]:value[1]:value::STRING AS token1,

-- Extraction of mag for amount0 and amount1

PARAMETERS[2]:value[0].value[0].value::FLOAT AS fee_amount0,

PARAMETERS[2]:value[1]external.tokenflow_starknet.decoded_events.value[0].value::FLOAT AS fee_amount1

FROM

ProtocolFeesPaidEvents

),

CombinedFees AS (

SELECT token0 AS token_address, fee_amount0 AS total_fees FROM ExtractedFees

UNION ALL

SELECT token1 AS token_address, fee_amount1 AS total_fees FROM ExtractedFees

token_address,

SUM(total_fees) AS total_fees

CombinedFees

GROUP BY

token_address;