date_trunc('week', block_timestamp) as Date,

count(distinct tx_id) as Swaps,

count(distinct swapper) as Swappers,

Sum(case when swap_to_mint in (

'So11111111111111111111111111111111111111112',

'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm',

'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3',

'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN',

'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL',

'4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R',

'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey',

'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263',

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',

'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn',

'27G8MtK7VtTcCHkpASjSDdkWWYfoqT6ggEuKidVJidD4'

) then SWAP_TO_AMOUNT_USD

when swap_from_mint in (

'So11111111111111111111111111111111111111112',

'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm',

'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3',

'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN',

'jtojtomepa8beP8AuQc6eXt5FriJwfFMwQx2v2f9mCL',

'4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R',

'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey',

'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263',

'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v',

'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB',

'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn',

'27G8MtK7VtTcCHkpASjSDdkWWYfoqT6ggEuKidVJidD4'

) then SWAP_FROM_AMOUNT_USD end) as Swap_Volume_USD

from solana.defi.ez_dex_swaps