BLOCK_TIMESTAMP,

tx_hash

from ethereum.core.fact_traces a

where TO_ADDRESS = lower('0x04bDa42de3bc32Abb00df46004204424d4Cf8287')

--and TX_STATUS = 'success'

and BLOCK_TIMESTAMP > '2022-07-01 15:58:20.000'

limit 10

union

--All native eth transfers from fee wallet

select

BLOCK_TIMESTAMP,

'Sent, ETH' as direction,

case when FROM_ADDRESS = lower('0x04bDa42de3bc32Abb00df46004204424d4Cf8287') then 'Fee Wallet Action'

else FROM_ADDRESS::text end as from_,

TO_ADDRESS::text,

-eth_value as ETH_amount,

18 as decimals,

'ETH' as symbol,

'ETH' as contract_address,

tx_hash

from ethereum.core.fact_traces a

where FROM_ADDRESS = lower('0x04bDa42de3bc32Abb00df46004204424d4Cf8287')

and TX_STATUS = 'success'

select *

from ethereum.core.fact_transactions

where TO_ADDRESS = lower('0x04bDa42de3bc32Abb00df46004204424d4Cf8287')

limit 10