-- forked from Pika airdrop - Total Redeem @ https://flipsidecrypto.xyz/edit/queries/945b016a-9efa-4e80-92e1-8ffbf8083766

select

sum(amount) as Total_PIKA_Redeemed,

date_trunc('hour', block_timestamp) as time

from optimism.core.ez_token_transfers

where from_address = '0x21a4a5c00ab2fd749ebec8282456d93351459f2a'

and contract_address = '0x9a601c5bb360811d96a23689066af316a30c3027'

and origin_function_signature = '0x379607f5'

and to_address = '0x4a1a4458e808842fe68099f73529fa20ac9b9eba'

group by time