select

origin_from_address as holder_address,

-- origin_to_address,

-- contract_address,

-- concat ('0x', substr(topics[1], 27, 40)) :: string as from_address,

-- concat ('0x', substr(topics[2], 27, 40)) :: string as to_address,

sum(livequery.utils.udf_hex_to_int(SUBSTR(data, 3, 64)) / power (10, 18)) as redeem_amt

from blast.core.fact_event_logs

where topics[0]::string = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- signifies token transfers

and contract_address = '0x129ed667bf8c065fe5f66c9b44b7cb0126d85cc3'

-- redeem $WAI from contract function

and origin_function_signature = '0xbe040fb0'

and origin_to_address = '0xd78b925cde1a4ff99da2e14a9aa03b36a97d8563'

group by 1

, all_waifu_txns as (

select

block_timestamp,

tx_hash,

-- origin_from_address,

-- origin_to_address,

contract_address,

concat ('0x', substr(topics[1], 27, 40)) :: string as from_address,

concat ('0x', substr(topics[2], 27, 40)) :: string as to_address,

livequery.utils.udf_hex_to_int(SUBSTR(data, 3, 64)) as amt

from blast.core.fact_event_logs

where topics[0]::string = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- signifies token transfers

and contract_address = '0x129ed667bf8c065fe5f66c9b44b7cb0126d85cc3'

and data != '0x'

),

waifu_bal as (