date_trunc('day', block_timestamp) AS date,

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

COUNT(DISTINCT CASE WHEN mint = 'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux' THEN tx_from END) AS HNT_senders,

COUNT(DISTINCT CASE WHEN mint = 'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux' THEN tx_to END) AS HNT_receivers,

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

AVG(CASE WHEN mint = 'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux' THEN amount ELSE 0 END) AS HNT_avg_volume,

MEDIAN(CASE WHEN mint = 'hntyVP6YFm1Hg25TN9WGLqM12b8TQmcknKrdu1oxWux' THEN amount ELSE 0 END) AS HNT_median_volume,

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

COUNT(DISTINCT CASE WHEN mint = 'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns' THEN tx_from END) AS IOT_senders,

COUNT(DISTINCT CASE WHEN mint = 'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns' THEN tx_to END) AS IOT_receivers,

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

AVG(CASE WHEN mint = 'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns' THEN amount ELSE 0 END) AS IOT_avg_volume,

MEDIAN(CASE WHEN mint = 'iotEVVZLEywoTn1QdwNPddxPWszn3zFhEot3MfL9fns' THEN amount ELSE 0 END) AS IOT_median_volume,

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

COUNT(DISTINCT CASE WHEN mint = 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6' THEN tx_from END) AS MOBILE_senders,

COUNT(DISTINCT CASE WHEN mint = 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6' THEN tx_to END) AS MOBILE_receivers,

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

AVG(CASE WHEN mint = 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6' THEN amount ELSE 0 END) AS MOBILE_avg_volume,

MEDIAN(CASE WHEN mint = 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6' THEN amount ELSE 0 END) AS MOBILE_median_volume,

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

COUNT(DISTINCT CASE WHEN mint = 'rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof' THEN tx_from END) AS RENDER_senders,

COUNT(DISTINCT CASE WHEN mint = 'rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof' THEN tx_to END) AS RENDER_receivers,

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

AVG(CASE WHEN mint = 'rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof' THEN amount ELSE 0 END) AS RENDER_avg_volume,

MEDIAN(CASE WHEN mint = 'rndrizKT3MK1iimdxRdWabcF7Zg7AR5T4nud4EkHBof' THEN amount ELSE 0 END) AS RENDER_median_volume,

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

COUNT(DISTINCT CASE WHEN mint = 'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y' THEN tx_from END) AS SHDW_senders,

COUNT(DISTINCT CASE WHEN mint = 'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y' THEN tx_to END) AS SHDW_receivers,

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

AVG(CASE WHEN mint = 'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y' THEN amount ELSE 0 END) AS SHDW_avg_volume,

MEDIAN(CASE WHEN mint = 'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y' THEN amount ELSE 0 END) AS SHDW_median_volume,