with trades as (

SELECT

TX_HASH,

date_trunc('day', BLOCK_TIMESTAMP) as date,

ORIGIN_FROM_ADDRESS as ua,

CASE

when TOKEN_IN in (

SELECT

DECODED_LOG:floorToken

from

ethereum.core.ez_decoded_event_logs

where

contract_address = '0x3eb879cc9a0ef4c6f1d870a40ae187768c278da2'

and event_name = 'NewCollectionSupported'

) then SYMBOL_IN

else SYMBOL_OUT

end as Floor_token,

CASE

when TOKEN_IN in (

SELECT

DECODED_LOG:floorToken

from

ethereum.core.ez_decoded_event_logs

where

contract_address = '0x3eb879cc9a0ef4c6f1d870a40ae187768c278da2'

and event_name = 'NewCollectionSupported'

) then AMOUNT_IN

else AMOUNT_OUT

end as Floor_token_amount,

CASE

when TOKEN_IN in (

SELECT

DECODED_LOG:floorToken

from

ethereum.core.ez_decoded_event_logs