select * from ( values

('USDC', 'USD Coin', 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'),

('SOL', 'Solana', 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL'),

('WIF', 'DogWifHat', '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH'),

('ETH', 'Turbo ETH', 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn'),

('ORCA', 'Orca', '2tGbYEm4nuPFyS6zjDTELzEhvVKizgKewi6xT7AaSKzn'),

('USDT', 'Tether USD', 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm'),

('TIA', 'Celestia', '9RryNMhAVJpAwAGjCAMKbbTFwgjapqPkzpGMfTQhEjf8'),

('STTIA', 'Stride Staked TIA', 'V5m1Cc9VK61mKL8xVYrjR7bjD2BC5VpADLa6ws3G8KM'),

('WEETHS', 'Super Symbiotic LRT', 'F72PqK74jc28zjC7kWDk6ykJ2ZAbjNzn2jaAY9v9M6om'),

('WBTC', 'Wrapped BTC', '7UTjr1VC6Z9DPsWD6mh5wPzNtufN17VnzpKS3ASpfAji'),

('ETH', 'Ethereum', 'So11111111111111111111111111111111111111112')

) as t(symbol, name, mint)

, base as (

select 'mint' as type, block_timestamp, mint_amount / pow(10, decimal) as amount, mint, symbol

from eclipse.defi.fact_token_mint_actions

join tokens using (mint)

where mint in ('AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE', 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm')

UNION ALL

select 'burn' as type, block_timestamp, burn_amount / pow(10, decimal) as amount, mint, symbol

from eclipse.defi.fact_token_burn_actions

join tokens using (mint)

where mint in ('AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE', 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm')

, base_agg as (

select 'Eclipse' as chain,

block_timestamp::date as date,

'stablecoin' as token_type,

symbol,

mint as token_contract,

zeroifnull(sum(iff(type = 'mint', amount, 0))) as total_mint,

zeroifnull(sum(iff(type = 'burn', amount, 0))) as total_burn,

total_mint - total_burn as net_token,