--b.TO_ADDRESS

--,CURRENT_BAL

--,sum(b.RAW_AMOUNT_PRECISE/power(10,18)) over(partition by b.to_address) as individual_total

'Tree' as asset

, date_trunc('minute',b.BLOCK_TIMESTAMP) as date

,sum(b.RAW_AMOUNT_PRECISE/power(10,18)) over(order by date_trunc('minute',b.BLOCK_TIMESTAMP))/ 100000000 as Percent_claimed

,sum(b.RAW_AMOUNT_PRECISE/power(10,18)) over(order by date_trunc('minute',b.BLOCK_TIMESTAMP)) as Claimed_amount

from ethereum.core.fact_transactions a

inner join ethereum.core.fact_token_transfers b on a.tx_hash = b.tx_hash

where a.TO_ADDRESS = lower('0x01f3bCc12155908Af91D53a782A0211edba9179b')

and a.ORIGIN_FUNCTION_SIGNATURE = '0x4e71d92d'