logs as (

select

logs.block_number,

logs.block_timestamp,

logs.tx_hash,

logs.origin_from_address,

logs.origin_to_address,

logs.origin_function_signature,

'0x' || right(logs.topics[1], 40) as from_address,

'0x' || right(logs.topics[2], 40) as to_address,

livequery.utils.udf_hex_to_int(logs.topics[3]) as token_id,

transactions.value as price

from

core.core.fact_event_logs logs

join core.core.fact_transactions transactions on logs.tx_hash = transactions.tx_hash

where

transactions.tx_succeeded

and transactions.block_timestamp::date >= '2024-12-12'

and logs.contract_address = '0xe48696582061011beadcdb1eb132ff2261ced5cf'

and logs.topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- ERC-20 & ERC-721

and logs.topics[1] is not null

and logs.topics[2] is not null

),

mints as (

select

block_timestamp,

tx_hash,

to_address as minter,

token_id,

price

from

logs

where

from_address = '0x0000000000000000000000000000000000000000'

)