from blast.core.ez_native_transfers

where TO_ADDRESS = '0x8eb25033c9e511bdbedf99725d7e3cbfe52d4b9d'

and ORIGIN_FUNCTION_SIGNATURE in ('0xd1e8308b','0xd6febde8')

GROUP by all),

all_u as (SELECT date_trunc('day', block_timestamp) as date, FROM_ADDRESS as user

from blast.core.ez_native_transfers

where --tx_hash = '0x03218c122345b19b94f11a485a61797096d6f2091fbc65eb0b6c8b0cb24c2bbf'

ORIGIN_FUNCTION_SIGNATURE = '0x5f242ef1' and

TO_ADDRESS = '0x2b43329616218d57afd2cf6a7b67e2a02955554f'

GROUP by all

union

SELECT date_trunc('day', block_timestamp) as date, TO_ADDRESS as user

from blast.core.ez_native_transfers

where --tx_hash = '0xa8cda63cb86f1a3be2ecc3cc20ee95762d2c2f8554ae5eb0bbb12d3b1dd3c7dd'

ORIGIN_FUNCTION_SIGNATURE = '0x4dd020da' and

FROM_ADDRESS = '0x2b43329616218d57afd2cf6a7b67e2a02955554f'

GROUP by all

union

SELECT

date_trunc('day', block_timestamp) as date,

ORIGIN_FROM_ADDRESS as user

from blast.core.ez_native_transfers

where --tx_hash = '0xd6c4c2b6df8ee655ed14c396a132b0acdaa3db34bb4c5160be95f3d5c34be3f0' and

tx_hash in (SELECT DISTINCT tx_hash from all_txs) and

ORIGIN_FUNCTION_SIGNATURE in ('0xd6febde8','0xd1e8308b')),