date_trunc('day', block_timestamp) AS date,

COUNT(DISTINCT CASE WHEN mint = 'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux' THEN tx_id END) AS HNT_transfers,

SUM(CASE WHEN mint = 'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux' THEN amount ELSE 0 END) AS HNT_total_volume,

COUNT(DISTINCT CASE WHEN mint = 'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns' THEN tx_id END) AS IOT_transfers,

SUM(CASE WHEN mint = 'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns' THEN amount ELSE 0 END) AS IOT_total_volume,

COUNT(DISTINCT CASE WHEN mint = 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6' THEN tx_id END) AS MOBILE_transfers,

SUM(CASE WHEN mint = 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6' THEN amount ELSE 0 END) AS MOBILE_total_volume,

COUNT(DISTINCT CASE WHEN mint = 'rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof' THEN tx_id END) AS RENDER_transfers,

SUM(CASE WHEN mint = 'rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof' THEN amount ELSE 0 END) AS RENDER_total_volume,

COUNT(DISTINCT CASE WHEN mint = 'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y' THEN tx_id END) AS SHDW_transfers,

SUM(CASE WHEN mint = 'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y' THEN amount ELSE 0 END) AS SHDW_total_volume,

COUNT(DISTINCT CASE WHEN mint = 'MMAPdo5j2weUCQLs536p3Y6kB4CBcxdddNb8aobiPTc' THEN tx_id END) AS MMAPS_transfers,

SUM(CASE WHEN mint = 'MMAPdo5j2weUCQLs536p3Y6kB4CBcxdddNb8aobiPTc' THEN amount ELSE 0 END) AS MMAPS_total_volume,

COUNT(DISTINCT CASE WHEN mint = 'ETAtLmCmsoiEEKfNrHKJ2kYy3MoABhU6NQvpSfij5tDs' THEN tx_id END) AS MEDIA_transfers,

SUM(CASE WHEN mint = 'ETAtLmCmsoiEEKfNrHKJ2kYy3MoABhU6NQvpSfij5tDs' THEN amount ELSE 0 END) AS MEDIA_total_volume,

COUNT(DISTINCT CASE WHEN mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy' THEN tx_id END) AS HONEY_transfers,

SUM(CASE WHEN mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy' THEN amount ELSE 0 END) AS HONEY_total_volume,

COUNT(DISTINCT CASE WHEN mint = 'wxmJYe17a2oGJZJ1wDe6ZyRKUKmrLj2pJsavEdTVhPP' THEN tx_id END) AS WXM_transfers,

SUM(CASE WHEN mint = 'wxmJYe17a2oGJZJ1wDe6ZyRKUKmrLj2pJsavEdTVhPP' THEN amount ELSE 0 END) AS WXM_total_volume,

COUNT(DISTINCT CASE WHEN mint = 'xNETbUB7cRb3AAu2pNG2pUwQcJ2BHcktfvSB8x1Pq6L' THEN tx_id END) AS XNET_transfers,

SUM(CASE WHEN mint = 'xNETbUB7cRb3AAu2pNG2pUwQcJ2BHcktfvSB8x1Pq6L' THEN amount ELSE 0 END) AS XNET_total_volume,

COUNT(DISTINCT CASE WHEN mint = 'FRySi8LPkuByB7VPSCCggxpewFUeeJiwEGRKKuhwpKcX' THEN tx_id END) AS NATIX_transfers,

SUM(CASE WHEN mint = 'FRySi8LPkuByB7VPSCCggxpewFUeeJiwEGRKKuhwpKcX' THEN amount ELSE 0 END) AS NATIX_total_volume,

COUNT(DISTINCT CASE WHEN mint = 'BZLbGTNCSFfoth2GYDtwr7e4imWzpR5jqcUuGEwr646K' THEN tx_id END) AS IO_transfers,

SUM(CASE WHEN mint = 'BZLbGTNCSFfoth2GYDtwr7e4imWzpR5jqcUuGEwr646K' THEN amount ELSE 0 END) AS IO_total_volume,

FROM solana.core.fact_transfers

WHERE mint IN (

'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux', --HNT

'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns', --IOT

'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6', --MOBILE

'rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof', --RENDER

'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y', --SHDW

'MMAPdo5j2weUCQLs536p3Y6kB4CBcxdddNb8aobiPTc', --MMAPSv2

'ETAtLmCmsoiEEKfNrHKJ2kYy3MoABhU6NQvpSfij5tDs', --MEDIA

'4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy', --HONEY