select

block_number,

block_timestamp,

tx_hash,

origin_from_address as from_address,

origin_to_address as to_address,

event_index,

contract_address,

event_name,

event_inputs,

event_inputs['tokenAddress'] as token_address,

event_inputs['deposit']/pow(10,18) as deposit,

event_inputs['startTime'] as stream_start_date,

event_inputs['stopTime'] as stream_end_date,

event_inputs['amount'] as amount,

event_inputs['recipient'] as recipient,

event_inputs['recipientBalance']/pow(10,18) as recipient_bal,

event_inputs['sender'] as sender,

event_inputs['senderBalance']/pow(10,18) as sender_bal,

event_inputs['streamId'] as stream_ID

from ethereum.core.fact_event_logs

where contract_address = '0xcd18eaa163733da39c232722cbc4e8940b1d8888'

),

labels as (

select

from ethereum.core.dim_labels

),

combined as (

select

a.*,

l.*

from all_pay a