with tb1 AS (
select
ORIGIN_FROM_ADDRESS AS user,
EVENT_INPUTS:_balance/1e18 AS Airdrop
from ethereum.core.fact_event_logs
where
EVENT_NAME='Claimed' and
CONTRACT_ADDRESS='0xf2d15c0a89428c9251d71a0e29b39ff1e86bce25')
select
Date_trunc('day',BLOCK_TIMESTAMP)::DATE AS date,
label,
sum(A.Amount) AS "transferred Amount"
from ethereum.core.ez_token_transfers A inner join tb1 B on FROM_ADDRESS=User
inner join ethereum.core.dim_labels on address=TO_ADDRESS
where CONTRACT_ADDRESS=lower('0x5283D291DBCF85356A21bA090E6db59121208b44') group by 1,2