select * from

( values

('8', 'USDT', 'binance', '/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/871jbn9unTavWsAe83f2Ma9GJWSv6BKsyWYLiQ6z3Pva'),

('6', 'USDC', 'solana', '/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/9fELvUhFo6yWL34ZaLgPbCPzdk9MD1tAzMycgH45qShH'),

('6', 'USDC', 'optimism', '/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/3VKKYtbQ9iq8f9CaZfgR6Cr3TUj6ypXPAn6kco6wjcAu'),

('6', 'USDC', 'polygon','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/DUVFMY2neJdL8aE4d3stcpttDDm5aoyfGyVvm29iA9Yp'),

('6', 'USDC', 'arbitrum','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7edDfnf4mku8So3t4Do215GNHwASEwCWrdhM5GqD51xZ'),

('8', 'WBTC', 'ethereum','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/7omXa4gryZ5NiBmLep7JsTtTtANCVKXwT9vbN91aS1br'),

('6', 'USDC', 'ethereum','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/Hq4tuDzhRBnxw3tFA5n6M52NVMVcC19XggbyDiJKCD6H'),

('8', 'ETH', 'ethereum','/sei189adguawugk3e55zn63z8r9ll29xrjwca636ra7v7gxuzn98sxyqwzt47l/4tLQqCLaoKKfNFuPjA9o39YbKUwhR1F8N29Tz3hEbfP2')

) as a (decimal, token_name, chain, token_address))

,

airdrop_claimers as (

SELECT

tx_id

, block_timestamp

, receiver as user

, 'SEI' as symbol

, 'usei' as symbol_address

, amount/pow(10,6) as amount

, 'drop' as cat

, 'drop' as bridge

, 'sei' as chain

FROM sei.core.fact_transfers

WHERE

sender IN (

'sei1agd6xc09ydnrucxpjy9c47thunrzzhe5sc75gphjnh4nqkdup8wsexh044',

'sei1mm640rda0zmkfwyprmchk2gg54wj7mn8maqzycgzpul0pml448yswjxvy2'

)

and tx_succeeded = 'true'

and currency = 'usei'

AND block_timestamp >= '2023-08-15'