SELECT

block_timestamp,

BLOCK_ID,

tx_hash,

ifnull(tx:actions[0]:Delegate:delegate_action:receiver_id::string, TX_RECEIVER)::string as receiver,

ifnull(tx:actions[0]:Delegate:delegate_action:sender_id::string, TX_SIGNER)::string AS user

FROM near.core.fact_transactions

where block_timestamp::Date >= '2024-10-01' and block_timestamp < '2024-11-01'

UNION

SELECT

block_timestamp,

BLOCK_ID,

tx_hash,

to_address::string as receiver,

from_address::string AS user

FROM near.core.ez_token_transfers

where block_timestamp::Date >= '2024-10-01' and block_timestamp < '2024-11-01'

UNION

SELECT

block_timestamp,

BLOCK_ID,

tx_hash,

receiver_id::string as receiver,

SIGNER_ID::string AS user

FROM near.core.fact_actions_events_function_call

where block_timestamp::Date >= '2024-10-01' and block_timestamp < '2024-11-01'

UNION

SELECT

block_timestamp,

BLOCK_ID,