select
block_timestamp::date as day,
sum(amount) / 1000000 as revenue_sei,
sum(amount) / 1000000 / 0.02 as volume_sei
from
sei.core.fact_transfers
where
tx_succeeded = 't' and
receiver = 'sei1kdns9z8qm3euk0hnmgltqxlnldkqq3wza4eqwd'
group by day
order by day desc
limit 60