block_timestamp::date as date,

sum (amount) as Volume,

sum (Volume) over (order by date) as Cumulative_Volume

from solana.core.fact_transfers t1 join solana.core.dim_labels t2 on t1.tx_to = t2.address

where label != 'solana'

and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

and label_type not in ('nft','token')

and block_timestamp >= CURRENT_DATE - 93

group by 1,2

UNION ALL

select 'USDT' as Symbol,

block_timestamp::date as date,

sum (amount) as Volume,

sum (Volume) over (order by date) as Cumulative_Volume

from solana.core.fact_transfers t1 join solana.core.dim_labels t2 on t1.tx_to = t2.address

where label != 'solana'

and mint = 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'

and label_type not in ('nft','token')

and block_timestamp >= CURRENT_DATE - 93

group by 1,2