select date_trunc('day',block_timestamp) as date,TX_HASH,FROM_ADDRESS,TO_ADDRESS,BLOCK_NUMBER,
status,eth_value, TX_JSON:receipt:logs[0]:decoded:eventName as event_type,gas_price
from ethereum.core.fact_transactions
where tx_hash = lower('{{TransactionId}}')
or to_address = lower('{{Address}}')
or from_address = lower('{{Address}}')
limit 5