select

block_timestamp,

block_id,

tx_id,

event_inputs:account::string as user,

event_inputs:userClaim::string/pow(10,18) as tokens_claimed

from ethereum.events_emitted

where --tx_id = '0x81e53958ca674ab6e10fe39bbb4b55e2bc9dfd67afc3321826217a537730d5d7'

-- contract_address = '0xa5f2211b9b8170f694421f2046281775e8468044'

-- and

tx_to_address='0x8526cec1d97a68c0e69420488d04dec5f101b46e'

and event_name='Claimed'

and event_removed = FALSE

select * from airdrops