with transfers AS (
select
date_trunc('day', block_timestamp) AS date,
tx_id,
tx_to,
amount
from solana.core.fact_transfers
where block_timestamp >= current_date - interval '60 days'
and mint in (
'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',
'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',
'2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo',
'A1KLoBrKBde8Ty9qtNQUtq3C2ortoC3u7twggz7sEto6',
'Ea5SjE2Y6yvCeW5dYTn7PYMuW5ikXkvbGdcmSnXeaLjS',
'DEkqHyPN7GMRJ5cArtQFAWefqbZb33Hyf6s5iCwjEonT',
'EjmyN6qEC1Tf1JxiG1ae7UTJhUxSwk1TCWNWqxWV4J6o'
)
)
select
date,
address_name,
sum(amount) AS volume,
sum(sum(amount)) over (partition by address_name order by date) as cumulative_volume
from transfers
join solana.core.dim_labels
on tx_to = address
group by date,address_name
order by date desc;