select

TIMESTAMP as date_and_time,

PARAMETERS[0]:value::string as sender,

len(PARAMETERS[0]:value)::number as sender_len,

PARAMETERS[1]:value::string as receiver,

len(PARAMETERS[1]:value)::number as receiver_len,

PARAMETERS[2]:value[0]:value/pow(10,18) as low_value,

PARAMETERS[2]:value[0]:value/pow(10,18) as high_value,

tx_hash,

EVENT_ORDER

from external.tokenflow_starknet.decoded_events

where contract = '0x049d36570d4e46f48e99674bd3fcc84644ddd6b96f7c741b1562b82f9e004dc7'

and name = 'Transfer'),

base2 as (

select

date_and_time,

case

when sender_len = 65 then '0x0' || substr(sender,3,63)

when sender_len = 64 then '0x00' || substr(sender,3,62)

when sender_len = 63 then '0x000' || substr(sender,3,61)

when sender_len = 62 then '0x0000' || substr(sender,3,60)

when sender_len = 61 then '0x00000' || substr(sender,3,59)

when sender_len = 60 then '0x000000' || substr(sender,3,58)

when sender_len = 59 then '0x0000000' || substr(sender,3,57)

when sender_len = 58 then '0x00000000' || substr(sender,3,56)

when sender_len = 57 then '0x000000000' || substr(sender,3,55)

when sender_len = 1 then '0x0000000000000000000000000000000000000000000000000000000000000000'

end as sender_address,

case

when receiver_len = 65 then '0x0' || substr(receiver,3,63)

when receiver_len = 64 then '0x00' || substr(receiver,3,62)

when receiver_len = 63 then '0x000' || substr(receiver,3,61)

when receiver_len = 62 then '0x0000' || substr(receiver,3,60)