SELECT

el.tx_hash,

el.block_timestamp,

data,

el.origin_from_address,

el.origin_to_address,

LOWER('0x' || SUBSTR(data, 3 + 64 * 0 + 24, 40)) AS to_address,

LOWER('0x' || SUBSTR(data, 3 + 64 * 2 + 24, 40)) AS token_in,

LOWER('0x' || SUBSTR(data, 3 + 64 * 1 + 24, 40)) AS token_out,

utils.udf_hex_to_int('0x' || SUBSTRING(data, 3 + 64 * 3, 64)) / POWER(10, 18) AS amount_out,

utils.udf_hex_to_int('0x' || SUBSTRING(data, 3 + 64 * 4, 64)) / POWER(10, 18) AS amount_in,

ft.tx_fee AS fee,

ft.cumulative_gas_used AS gas

FROM monad.testnet.fact_event_logs el

inner join monad.testnet.fact_transactions ft

on el.tx_hash = ft.tx_hash

WHERE contract_address = lower('0x45A62B090DF48243F12A21897e7ed91863E2c86b')

and el.block_timestamp::date >= CURRENT_DATE() - interval '30 days'

and topic_0 = '0xd9a8cfa901e597f6bbb7ea94478cf9ad6f38d0dc3fd24d493e99cb40692e39f1'

AND el.tx_succeeded = 'TRUE'

and el.event_removed = 'FALSE'

,users_lfj AS (

select distinct origin_from_address as daily_users_lfj,

block_timestamp::date as day

from lfj_base

group by 1,2

order by day desc

,aggregated_lfj AS (

SELECT

tx_hash,

block_timestamp,