SEI transfers Modded

Updated 2023-11-16

-- forked from SEI transfers in-out @ https://flipsidecrypto.xyz/edit/queries/66e0e60c-5cbb-4a9c-8bd0-e027cf7063f3

-- Hard_coded Tokens Based on SEI document

with token_bank as (

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 claimer

-- , amount/pow(10,6) as volume

-- FROM sei.core.fact_transfers

-- WHERE

-- sender IN (

-- 'sei1agd6xc09ydnrucxpjy9c47thunrzzhe5sc75gphjnh4nqkdup8wsexh044',

-- 'sei1mm640rda0zmkfwyprmchk2gg54wj7mn8maqzycgzpul0pml448yswjxvy2'

-- )

-- and tx_succeeded = 'true'

-- and currency = 'usei'

-- AND block_timestamp >= '2023-08-15'

-- )

-- ,

-----------------WORM TXNS START-----------------------------

Run a query to Download Data