with multi as ( select tx_hash, count(*) as counts

from sei.core_evm.fact_traces

where from_address = '0x1aed60a97192157fda7fb26267a439d523d09c5e'

group by 1

having counts > 1)

,

final as (select block_timestamp,

tx_hash,

regexp_substr_all(SUBSTR(input, 11), '.{64}') AS segmented,

'0x' || substr(segmented[11]::string , 25) as seller,

'0x' || substr(segmented[3]::string , 25) as buyer,

'0x' || substr(segmented[36]::string , 25) as currency,

livequery.utils.udf_hex_to_int(segmented[38]::string)/pow(10,18) as price,

'0x' || substr(segmented[30]::string , 25) as collection

from sei.core_evm.fact_traces

where from_address = '0x1aed60a97192157fda7fb26267a439d523d09c5e'

and tx_hash in (select tx_hash from multi)

and block_timestamp::date >= '2024-12-03'

union all

select block_timestamp,

tx_hash,

regexp_substr_all(SUBSTR(input, 19), '.{64}') AS segmented,

'0x' || substr(segmented[9]::string , 25) as seller,

'0x' || substr(segmented[18]::string , 25) as buyer,

'0x' || substr(segmented[31]::string , 25) as currency,

livequery.utils.udf_hex_to_int(segmented[33]::string)/pow(10,18) as price,

'0x' || substr(segmented[37]::string , 25) as collection

from sei.core_evm.fact_traces

where to_address = '0x1aed60a97192157fda7fb26267a439d523d09c5e'

and tx_hash not in (select tx_hash from multi)

and block_timestamp::date >= '2024-12-03'

having price != 0 and price is not null and price not ilike '%e%'

UNION all

select block_timestamp,