select block_timestamp::date as block_timestamp_date,

tx_hash,

tx_json:receipt:logs as log

from ethereum.core.fact_transactions

where block_timestamp::date = '2022-02-15'

and tx_hash = '0x11b24caa0f0f0c7369cfebdc2d7eb2cbd3935264f3483004042cdf63b9a14115'

select block_timestamp_date,

tx_hash,

t.value:address::string as contract_address,

t.value:decoded:eventName::string as event_name,

ethereum.public.udf_hex_to_int(t.value:logIndex) as log_index

from txs,

lateral flatten(input => log)t