--Question: display the active wallets by day, month, and Year-To-Date in 2022.
SELECT block_timestamp::date as block_day,
count(distinct tx_from) as TERRA_wallets
FROM terra.transactions
WHERE block_day >= '2022-01-01' AND
tx_status = 'SUCCEEDED'
GROUP BY block_day