WITH TXNS_VOLUME AS (

SELECT DISTINCT

block_timestamp,

tx_id

FROM solana.transactions

Where block_timestamp::date >= '2021-12-06'

And Succeeded = TRUE

AND pre_mint::string='r8nuuzXCchjtqsmQZVZDPXXq928tuk7KVH479GsKVpy'

And post_mint::string='r8nuuzXCchjtqsmQZVZDPXXq928tuk7KVH479GsKVpy'

block_timestamp::date as date,

COUNT(tx_id) AS TRANSACTIONS_VOLUME

FROM TXNS_VOLUME

Group by 1

ORDER BY 1 ASC