P as( select hour, price from base.price.ez_prices_hourly where token_address = '0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938' order by 1 desc limit 1 ),

L as ( select * from (values

('Ethereum' , '0xa469b7ee9ee773642b3e93e842e5d9b5baa10067'),

('Arbitrum' , '0x5018609ab477cc502e170a5accf5312b86a4b94f'),

('Base' , '0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938'),

('Blast' , '0x52056ed29fe015f4ba2e3b079d10c0b87f46e8c6'),

('Manta' , '0x73d23f3778a90be8846e172354a115543df2a7e4')

) as l1 (chain,contract_address) ),

X as(

select 'Ethereum' as chain, block_timestamp, 0+amount as balance, from_address as contract, contract_address from ethereum.core.ez_token_transfers union all

select 'Ethereum' as chain, block_timestamp, 0-amount as balance, to_address as contract, contract_address from ethereum.core.ez_token_transfers union all

select 'Base' as chain, block_timestamp, 0+amount as balance, from_address as contract, contract_address from base.core.ez_token_transfers union all

select 'Base' as chain, block_timestamp, 0-amount as balance, to_address as contract, contract_address from base.core.ez_token_transfers union all

select 'Arbitrum' as chain, block_timestamp, 0+amount as balance, from_address as contract, contract_address from arbitrum.core.ez_token_transfers union all

select 'Arbitrum' as chain, block_timestamp, 0-amount as balance, to_address as contract, contract_address from arbitrum.core.ez_token_transfers union all

select 'Blast' as chain, block_timestamp, 0+amount as balance, from_address as contract, contract_address from blast.core.ez_token_transfers union all

select 'Blast' as chain, block_timestamp, 0-amount as balance, to_address as contract, contract_address from blast.core.ez_token_transfers ),

A as(

select '2024-08-14' as time, 'Manta' as chain, '650000' as balance from P union all

select date_trunc('day',block_timestamp) as time, a.chain, sum(case when balance is null then 0 else balance end) as balance

from X as a

join L as b on a.chain = b.chain and a.contract_address = b.contract_address

where lower(contract) = '0x0000000000000000000000000000000000000000'

group by 1,2),

B as(

select date_trunc('month',time) as time, chain,

sum(balance) as balance,

sum(case when balance >0 then balance else 0 end) as mint,